COMM_TRACE_EMAIL_HX

Description:

This table contains an audit history of events for an outgoing email.

Primary Key

Column Name	Ordinal Position
OUTREACH_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	OUTREACH_ID	NUMERIC	No
	The unique identifier (.1 item) for the outreach record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	AUDIT_UTC_DTTM	DATETIME (UTC)	No
	The UTC Instant a status update was received for the email.
5	COMM_CONTACT_ID	NUMERIC	No
	The recipient CCR ID associated with the status update.
6	EML_AUD_STATUS_C_NAME	VARCHAR	No
	The status of the email. May contain organization-specific values: No Category Entries: Delivered Permanent Failure Temporary Failure Marked as Spam
7	SMTP_CODE	INTEGER	No
	The SMTP reply code of the email.
8	SMTP_ENHANCED_CODE	VARCHAR	No
	The SMTP enhanced reply code of the email.
9	DESCRIPTION	VARCHAR	No
	A plaintext description about the status of the email.
10	DELIVERY_ATTEMPT_NUM	INTEGER	No
	The number of times this email was attempted to be delivered.
11	RETRY_UTC_DTTM	DATETIME (UTC)	No
	The instant the email will retry delivery after a temporary failure.