CommsCode
Field Name Type Nullable? Comment
CommsCode (PK) VARCHAR(20)    
Description VARCHAR(30) Non Null  
Priority Integer Non Null
  • 1 - High
  • 2 - Medium
  • 3 - Low
InternalExternal Enumeration CHAR(1)  

Indicates whether this comm is intended to be sourced from withing CMP or external to CMP:

  • I - Internal
  • E - External
isSubscriptionLevel CHAR(1) Non Null  
isAccountLevel CHAR(1) Non Null  
isCorporateLevel CHAR(1) Non Null  
isGroupLevel CHAR(1) Non Null  
isActive Boolean Non Null  
AuditTimeStamp DateTime    
AuditUser      
AuditProcess      
CommsPreferenceCode (FK) VARCHAR(20)   This links the comms preference that is associated with the comms code.
SecurityLevel Numeric(1)    
Explanation VARCHAR(80) Nullable  
isSelectable Boolean Non Null  
isUseCreditControlAddress Boolean Non Null