TriggerNotification

Field Name Type Nullable? Comment
TriggerNotificationId (PK) Big Int    
SuppliedTriggerId VARCHAR(100)    
CustomerLevel Enumeration CHAR(1)  
  • A - Account
  • M - Agreeement
  • C - Corporate
  • G - Group
  • S - Subscription
CustomerReference      
TriggerNotificationStatus Enumeration  
  • A - Awaiting Processing
  • P - Processed
  • E - Error
DateTimeTriggerReceived DateTime    
AuditProcess      
AuditTimeStamp DateTime    
AuditUser      
TriggerChannelIDTC (FK)      
TriggerChannelIDTG (FK)      
SuppliedUniqueReference      
DateTimeNotificationTransmitted DateTime