CommsRequestTargetDistribution |
|||
|---|---|---|---|
| Field Name | Type | Nullable? | Comment |
| CommsRequestID (PK/FK) | Autogenerated | ||
| DistributionStatus | CHAR(1) | No Null |
Non Null If Email or Letter set to S initially; all others set to D initially |
| FileLocation | VARCHAR(200) | Nullable | Will be populated by the Comms Email Monitor or Comms Letter Monitor job |
| DistributionReference | VARCHAR(50) | Nullable | If zipped and sent will contain the zip file name etc. If an SMS could be the unique reference number supplied by the SMSC etc. |
| ExcludedUntilDateTime | TIMESTAMP | Nullable | |
| TargetRequestStatus | Enumeration CHAR(1) | Non Null |
|
| Message | VARCHAR(50) | Nullable | The message that was distributed to the target. Only applies to PUSH, SMS or Online |
| RetryDateTime | DateTime | Nullable | If the distribution daemon (the particular daemon will depend on the delivery method) cannot send the comms for some reason, they can record the time that a retry should be attempted at here. |
| AliasValue | VARCHAR(70) | This field is populated with the AliasValue from the Comms Alias. | |
| ActualDistributionMethodDTC | CHAR(20) | Nullable | This code indicates how a comms that had a delivey method of External actually got sent by the external system. This is set via an API that is invoked by the external system on CMP. |
| ActualDistributionMethodDTC | CHAR(20) | Nullable | Set to ACTUALDISTMETHOD |
| SentDateTime | |||
| ReadDateTime | DateTime | The setting of this is triggered by an external system when it detects that the customer has read the comms. | |
| AuditTimeStamp | DateTime | ||
| AuditProcess | |||
| AuditUser | |||
| ActualDateTimeSent | TIMESTAMP | Nullable | Date and time that a comms that was sent by an external system was sent. This is only update by a call by the external system to a CMP API. |
| ActualDistributionTarget | Nullable | When a comms is sent by an external system, this field can be populated by the external system when they invoke a CMP API that allows that external system to indicate excactly where the comms was sent, e.g. a mobile number, email address etc. | |
| EmailSubject | CHAR | ||
| IsStored | Boolean | ||
| PublishedDateTime | DateTime | ||
| RetryCount | Numeric | ||
| UndeliverablleEventNumber (FK) | Numeric (9,0) | Nullable | |
Search Tips
Search is based on keyword.
Ex: "Procedures"
Do not search with natural language
Ex: "How do I write a new procedure?"
To search for specific phrases, enclose search term in double quotes.
Ex: "Online Analytics"
If the search phrase is a common word and all lowercase e.g "he" or "you" or "when", try changing the case of the letters if you get no results.
Contact Documentation
Classification: Customer Confidential
© MDS Global 2026 Terms of Use