The RegionTrend table
stores the Region level and score data points for policy runs. The
RegionID field associates each RegionTrend record with its
Region.
Table: RegionTrend table
|
Field Name
|
Type
|
Description
|
|
Lvl
|
<number>
|
0 Green, 1 Yellow, 2 Red
|
|
Rating
|
<number>
|
10 times the number of Red messages, plus the number of Yellow
messages
|
|
RegionID
|
<number>
|
Region ID from Regions table
|
|
DatapointDate
|
<date>
|
Date of the level and the score
|
