DiaryEventCodeComms

Field Name Type Nullable? Comment
Sequence (PK) Number (3)   Allows for recurring fields e.g. a list of billable assets

Event Code (PK/FK)

CHAR(4)

   

Event Type (PK/FK)

CHAR(4)

   

CommsCode (FK)

VARCHAR(20)

   

CommsStrategyHeaderCode (FK)

VARCHAR(20)

   
AuditProcess      
AuditTimeStamp DateTime    
AuditUser