COMM_TRACE_INFO_2

Description: |
This table contains information about communication traces.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
COMM_TRACE_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | COMM_TRACE_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 | COMM_CHANNEL_C_NAME | VARCHAR | No |
Communication channel used to send this trace.
May contain organization-specific values: No
Category Entries:
SMS
Email
Voice
MMS
Web
Push Notification
Bedside TV
RCS for Business
Text
4 | RELATED_CAL_COMM_ID | VARCHAR | No |
Stores a related CAL record associated with a specific trace.
5 | COMM_AI_STATUS_C_NAME | VARCHAR | No |
Whether the content was generated using AI.
May contain organization-specific values: No
Category Entries:
None
All
Some
6 | SIBLING_GROUP | VARCHAR | No |
Messages sent at the same time, or messages that are fallback to other channels may all share a sibling grouper value. This is likely one RCH CSN from the group.
7 | REPLACED_BY_COMM_TRACE_CSN_ID | NUMERIC | No |
Contains a link to the CSN of the trace contact that this message was replaced by.
8 | ABOUT_MYPT_ID | VARCHAR | No |
If this trace was about a specific MyChart user, this item points to that MyChart user. Note that the MyChart user does not need to be a recipient.
9 | ABOUT_PAT_REL_ID | NUMERIC | No |
If this trace was about a specific relationship, this item points to that relationship. Note that the relationship does not need to be a recipient.
10 | THROTTLING_INIT_UTC_DTTM | DATETIME (UTC) | No |
The UTC instant when the trace began being throttled.
11 | THROTTLING_INIT_LOCAL_DTTM | DATETIME (Local) | No |
The local instant when the trace began being throttled.
12 | ADAPTIVE_SRC_C_NAME | NUMERIC | No |
If the requested time to send was determined via adaptive logic, this item contains the source of the adaptive data used.
May contain organization-specific values: No
Category Entries:
Population
Personal
13 | TRIGGER_ACTOR_PAT_ID | VARCHAR | No |
The patient who manually triggered this trace.
14 | TRIGGER_ACTOR_MYPT_ID | VARCHAR | No |
The MyChart account that manually triggered this trace.
15 | TRIGGER_ACTOR_ACCOUNT_ID | NUMERIC | No |
The guarantor who manually triggered this trace.
16 | TRIGGER_ACTOR_PAT_RELATION_ID | NUMERIC | No |
The patient relationship that manually triggered this trace.
17 | TRIGGER_ACTOR_USER_ID | VARCHAR | No |
The user who manually triggered this trace.
18 | TRIGGER_ACTOR_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
19 | REPLACED_SUM_COMM_TRACE_CSN_ID | NUMERIC | No |
Contains the CSN of the summary trace that this trace replaced.
20 | MCDRN_TRIG_REDETERMINE_DATE | DATETIME | No |
The Redetermination Date (CVG-2710) on the coverage that triggered the Medicaid Redetermination Notification, at the time the notification was triggered.
21 | CALLBACK_NUMBER | VARCHAR | No |
The callback number. Data should be stored in E.164 format.