The PolicyTrend table
stores the Policy level and the score data points for policy runs.
The PolicyID field associates each PolicyTrend record with its
Policy.
Table: PolicyTrend 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
|
|
PolicyID
|
<number>
|
Policy ID from Policies table
|
|
DatapointDate
|
<date>
|
Date of the policy run
|
