DiaryEventCode
Field Name Type Nullable? Comment

Event Code (PK)

CHAR(4)

    

Event Type (PK/FK)

CHAR(4)

    
AccountNumber Allowed? CHAR(1)    
AgreementNumber Allowed? CHAR(1)    
SubscriptionNo Allowed? CHAR(1)    
ProspectNumber Allowed? CHAR(1)    
Group Code Allowed? CHAR(1)    
EventStatus CHAR(1)    
Corporate Code Allowed? CHAR(1)    
Interactively Selectable? CHAR(1)    

Date Created (FK)

Numeric(7,0)

    

Time Created (FK)

Numeric(6,0)

    

Created by DISE User ID (FK)

 DateTime    

Created by Program (FK)

 DateTime    

Date Changed (FK)

 DateTime    

Time Changed (FK)

 DateTime    

Changed by DISE User Id (FK)

CHAR(10)

    

Changed by Program (FK)

CHAR(10)

    
Security Level (FK) Numeric(1)    
Active? (FK) Boolean Non Null  
Explanation Text1 (FK) CHAR    
Explanation Text2 (FK) CHAR    
Explanation Text3 (FK) CHAR    
Explanation Text4 (FK) CHAR    
RC Reason Code (FK) CHAR (4)    

Letter Name (FK)

CHAR

    
Created by User (FK) CHAR(10)    
ShortMessage Code (FK) CHAR    
Start Procedure Code (FK) CHAR    
Letter Status      
End ProcedureCode CHAR    
Ev Sts After Auto Confirm Numeric (1)    
Contact Name Rule      
Std Letter Replay Requird? CHAR(1)    
Std Letter Replay Days? Numeric    
Event Description CHAR    
Reason Code Rule      

Resolution Req Date Rule

 

    

Resolution Req by Days

 DateTime    

Default Resolution Time

 DateTime    

Send Letter?

CHAR(1)

    

Send Multiple Messages?

CHAR(1)

    

Existing Inc/Ecl?

CHAR(1)

    

Use CC Address?

CHAR(1)

    

CQBSD