CommsRequestHeader
Field Name	Type	Nullable?	Comment
CommsRequestID (PK)			Autogenerated
Priority	Integer	Non Null	1 - High 2 - Medium 3 - Low
Event Number (FK)	Numeric	Nullable
TriggerNotifiationID (FK)	Big Int	Nullable
CommsCode (FK)	VARCHAR(20)	Nullable
CommsStrategyHeaderCode (FK)	VARCHAR	Nullable
RequestStatus	Enumeration	Non Null	A- Awaiting Processing. This is set when the Comms Request Header is created. R - Awaiting Event Resolution. This is set when the Comms Request Header is created but the associated entry in the Diary Event Comms table is set to R - when resolved. P - Processed - Once all the beans have been executed and the comm is ready for distribution this is set by the Comms Monitor Job. C - Cancelled - This is usually set by the GUI when an agent decides to cancel a comm. This can usually only happen whenn the comm was set to 'R' . N - Not Sent - If the Comms cant be sent for some reason e.g. no valid email address then this will be updated by the Comms Monitor Job to this status. O - Opted Out - If the Comms Monitor Job calculates that the customer has opted out of the comms or are opted out by default, then its sets the status to this. E - Error occurred. This will be set in conjunction with the population of the CommsRequestError table.
AuditProcess
AuditTimeStamp	DateTime
AuditUser
MergeDateTime	DateTime	Nullable
OverrideCommsDeliveryMethodCode (FK)		Nullable
CopyCommsRequestId
IsEligibleToProcess