POLICY_ANALYSIS

The POLICY_ANALYSIS table stores the policy analysis session formation during the policy change and service enforcement change events.

Table 1. POLICY_ANALYSIS table
Column Name Description Data type
ANALYSIS_ID* Unique ID. Primary key. Character (32)
TENANT_NAME Name of the tenant in a multi-tenant setting. Character (64)
STATUS* Contains status:

NOT_STARTED=0

STARTING=1

INITIALIZING=2

PENDING=3

INTERRUPTED=4

ABORTED=5

ERROR=6

COMPLETE=7

INCOMPLETE=8

Numeric
REASON* Reason for the analysis:

POLICY_CHANGE=0

ENFORCEMENT_TYPE_CHANGE=1

Numeric
CONTEXT* Context of the analysis:

SIMULATION=0

ENFORCEMENT=1

Numeric
CHANGE_TYPE* Specific change type:

POL_ADD=0

POL_REMOVE=1

POL_MODIFY=2

ENFORCEMENT_CHANGE_ALERT=3

ENFORCEMENT_CHANGE_ENFORCE=4

ENFORCEMENT_CHANGE_SUSPEND=5

Numeric
LAST_ACCESSED* Last accessed date. Date
WORKERS_STARTED* Counter that is incremented when an analysis messaging thread is started and assigned a unit of analysis work. Default: 0 Numeric
WORKERS_COMPLETED* This counter is incremented when an analysis messaging thread completes its work. Default: 0 Numeric
WORKERS_TOTAL* The number of messaging threads that do the analysis work. Default: 0 Numeric
ACCOUNT_EVALUATED* The number of accounts that were evaluated during policy analysis. Default: 0 Numeric

* Indicates the column is required and not null.