CHAT_CONVERSATIONS
Description:
Table containing Secure Chat conversation level items.

Primary Key
Column Name Ordinal Position
CONVERSATION_ID 1

Column Information
Name Type Discontinued?
1 CONVERSATION_ID NUMERIC No
The unique identifier (.1 item) for the secure chat conversation record.
2 CM_PHY_OWNER_ID VARCHAR No
The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
3 RECORD_NAME VARCHAR No
Record name
4 RECORD_STATUS_C_NAME VARCHAR No
Stores the record status (hidden, soft-deleted, etc...)
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
5 LST_UPDATE_UTC_DTTM DATETIME (UTC) No
The instant the newest message in the conversation was sent.
6 PAT_ID VARCHAR No
The ID of the patient linked to the conversation.
7 RECORD_CREATION_DATE DATETIME No
Stores the date the record was created
8 INSTANT_OF_UPDATE_DTTM DATETIME (Local) No
Stores the instant the record was last locked/unlocked
9 CONVERSATION_TYPE_C_NAME VARCHAR No
The type of the conversation record, which indicates the intended audience of the Secure Chat conversation. A null value indicates the conversation is only between staff members.
May contain organization-specific values: No
Category Entries:
Staff-only conversation
Bedside conversation
Staff Broadcast conversation
10 PAT_ENC_CSN_ID NUMERIC No
The contact serial number (CSN) of the patient encounter associated with this conversation. This item will only be populated for Bedside patient-facing conversations. A value here means the conversation may include a patient or their proxies.
11 PAT_CONVERSATION_THREAD_ID NUMERIC No
The ID of the MyChart conversation linked to this Secure Chat conversation.
12 CHAT_CONTEXT_TYPE_C_NAME VARCHAR No
Stores the Secure Chat conversation context.
May contain organization-specific values: No
Category Entries:
Alert
13 LINKED_PUSH_NOTIF_ID NUMERIC No
Linked PNN (push notification) record ID to the TLK record that provides additional context about the conversation.
14 ORIGINAL_GROUP_ID NUMERIC No
Stores TGR ID of the original group that received a Secure Chat. Used for starting and continuing conversations with additional context with this group.