CommsFieldDefinition

Field Name Type Nullable? Comment
CommsFieldCode (PK) VARCHAR(30)    
Description VARCHAR(30) Non Null  
InternalExternal Enumeration CHAR(1)  

Indicates whether the FIeld makes an external call or not. Can be used in deciding a strategy for load balancing:

  • I - Internal
  • E - External
Parameter VARCHAR(200) Nullable This is a parameter to the java bean. It is required when Comms Category.RequiredParameter = true
Explanation VARCHAR(200) Nullable  
isSubscriptionLevel CHAR(1)   Indicates whether this field is relevant at subscription level
isAccountLevel CHAR(1)    
isCorporateLevel CHAR(1)    
isGroupLevel CHAR(1)    
isActive CHAR(1)    
AuditTimeStamp DateTime    
AuditUser      
AuditProcess      
BeanId (FK)      
MaxFieldLength Integer    
CommsFieldCategoryDTC (FK) CHAR(20) Non Null  
CommsFieldCatgegoryDTG (FK) CHAR(20) Non Null