The ManagerTrend table
stores the manager level and the score data points for policy runs.
The ManagerID field associates each ManagerTrend record with its
manager.
Table: ManagerTrend 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
|
|
ManagerID
|
<number>
|
Manager ID from Managers table
|
|
DatapointDate
|
<date>
|
Date of the level and the score
|
