TriggerAction

Field Name Type Nullable? Comment
DescriptiveTitleCode (PK/FK)      
DescriptiveTileGroup (PK/FK)      
TriggerId (PK) VARCHAR(100) Non Null  
Description VARCHAR(30) Non Null  
TriggerLevel Enumeration CHAR(1)  

Indicates the level in CMP hierachary that the trigger is associated with:

  • 1 - Subscription
  • 2 - Account
  • 3 - Agreement
CommsStrategyHeaderCode (FK) VARCHAR(20) Nullable  
AuditTimeStamp DateTime    
AuditUser      
AuditProcess      
TriggerActionOtherDTC (FK) CHAR(6) Nullable  
TriggerActionOtherDTG (FK) CHAR(6) Nullable  
Priority Integer Non Null
  • 1 - High
  • 2 - Medium
  • 3 - Low
EventType (FK) CHAR(6) Nullable  
EventCode (FK) CHAR(6) Nullable