PolicyTrend table

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