CommsDeliveryMethod

Field Name Type Nullable? Comment
CommsDeliveryMethodCode (PK) Enumeration VARCHAR(10)  
  • LETTER
  • EMAIL
  • PUSH
  • SMS
  • EXTERNAL
  • ONLINE

 

Description VARCHAR(30) Non Null

For example:

  • Letter
  • Email
  • Push Notification
  • SMS
  • Push to External System
  • Online
isUndeliverableSupported Boolean Non Null  
Priority Integer Non Null
  • 1 - High
  • 2 - Medium
  • 3 - Low
isTimeExcludable CHAR(1) Non Null Indicates whether this delivery method can be excluded based on time. e.g. having a time exclusion has no effect on a LETTER
isActive Boolean Non Null  
AuditTimeStamp DateTime    
AuditUser      
AuditProcess      
isFromAliasRequired Boolean Non Null Indicates whether a From Alias is required or not. Examples of these are Sender Id for an SMS or a From email address. This will likely be true for emails and SMS's.
AliasValueRegex VARCHAR(100) Non Null Contains a regular expression that is to be used in Business Configuration to validate the Alias Value as it is being stored.
AliasValueLabel VARCHAR(100) Non Null The text to appear on the screen in Business Configuration beside the input field that is to contain the Alias Value.
isSelectable Boolean Non Null  
SecurityLevel Numeric(1)