COMM_TRACE_EMAIL_RECPNTS

Description: |
This table stores information about addresses that an email was sent to as well as the person records associated with that address.

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 | COMM_CONTACT_ID | NUMERIC | No |
The unique identifier for the communication contact record associated with the external email addresses that an email will be sent to.
5 | EMAIL_ADDR_RECPNT_TYP_C_NAME | VARCHAR | No |
The recipient type for a specific email address receiving the email.
May contain organization-specific values: No
Category Entries:
To
Carbon Copy
Blind Carbon Copy
6 | PAT_ID | VARCHAR | No |
The unique identifier for the patient associated with a person receiving an email.
7 | MYPT_ID | VARCHAR | No |
The unique identifier for the MyChart user associated with the person receiving the email.
8 | ACCT_ID | NUMERIC | No |
The unique identifier for the guarantor associated with the person receiving the email.
9 | PAT_RELATIONSHIP_ID | NUMERIC | No |
The unique identifier for the patient relationship associated with the person receiving the email.
10 | USER_ID | VARCHAR | No |
The unique identifier for the user associated with the person receiving the email.
11 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
12 | COMM_ACTION_STATUS_C_NAME | VARCHAR | No |
The status of the email for this recipient.
May contain organization-specific values: No
Category Entries:
Created
Queued
Sidetracked
Session Active
To Interconnect
To Cloud
Pending
Sent
Delivered
Seen
Canceled
Expired
Failed
Replaced
Unknown
Auto-Invite Tank
Auto-Invite Queue
Throttle Queue
Ended
Multiple Statuses
Temporary Failure - Waiting for Resolution
Temporary Failure - No Resolution
Probable Failure
Voice Transient Error
ECS Not In Use
13 | NUM_TEMP_FAILURES | INTEGER | No |
The number of times an email temporarily failed to deliver before reaching a final status.
14 | MARKED_SPAM_YN | VARCHAR | No |
Whether this recipient marked the email as spam.
May contain organization-specific values: No
Category Entries:
No
Yes
15 | STATUS_UTC_DTTM | DATETIME (UTC) | No |
UTC instant the status event (I RCH 85617) occurred for this recipient.
16 | STATUS_LOCAL_DTTM | DATETIME (Local) | No |
Local instant the status event (I RCH 85617) occurred for this recipient.
17 | EMAIL_ADDR_LEGACY_EXT | VARCHAR | No |
This item stores the external email address of the recipient when we bridge to legacy email sending via the SMTP server. This item will not be populated on traces sent via Hello World Email. For email recipient information on Hello World traces, see COMM_TRACE_EMAIL_RECPNTS.COMM_CONTACT_ID (links to CCR record).