Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
TriggerName | VARCHAR(64) | NOT NULL | This is the name of the trigger item. |
TriggerDesc | VARCHAR(128) | NOT NULL | This is the description of the trigger item. |
CriteriaRequired1 | SMALLINT | NOT NULL | This is the flag indicating whether the first filtering criterion is required. |
CriteriaRequired2 | SMALLINT | NOT NULL | This is the flag indicating whether the second filtering criterion is required. |
CriteriaRequired3 | SMALLINT | NOT NULL | This is the flag indicating whether the third filtering criterion is required. |
CriteriaDisplayLabel1 | VARCHAR(64) | NULL | This is the label to display on the configuration page for the first criteria field. |
CriteriaDisplayLabel2 | VARCHAR(64) | NULL | This is the label to display on the configuration page for the second criteria field. |
CriteriaDisplayLabel3 | VARCHAR(64) | NULL | This is the label to display on the configuration page for the third criteria field. |
CriteriaType1 | VARCHAR(20) | NULL | This is the type of the first filtering criteria field. For example: 'INDICATORS', 'CODED_TEXTS' or 'SERVICE_TYPES' |
CriteriaType2 | VARCHAR(20) | NULL | This is the type of the second filtering criteria field. For example: 'INDICATORS', 'CODED_TEXTS' or 'SERVICE_TYPES' |
CriteriaType3 | VARCHAR(20) | NULL | This is the type of the third filtering criteria field. For example: 'INDICATORS', 'CODED_TEXTS' or 'SERVICE_TYPES' |
CreateDTimeMins | SMALLDATETIME | NOT NULL | This is the date/time when the event trigger item was created/started. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |