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_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
4 | LST_UPDATE_UTC_DTTM | DATETIME (UTC) | No |
The instant the newest message in the conversation was sent.
5 | PAT_ID | VARCHAR | No |
The ID of the patient linked to the conversation.
6 | RECORD_CREATION_DATE | DATETIME | No |
Stores the date the record was created
7 | INSTANT_OF_UPDATE_DTTM | DATETIME (Local) | No |
Stores the instant the record was last locked/unlocked
8 | 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
Solo Conversation
9 | 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.
10 | PAT_CONVERSATION_THREAD_ID | NUMERIC | No |
The ID of the MyChart conversation linked to this Secure Chat conversation.
11 | CHAT_CONTEXT_TYPE_C_NAME | VARCHAR | No |
Stores the Secure Chat conversation context.
May contain organization-specific values: No
Category Entries:
Alert
12 | LINKED_PUSH_NOTIF_ID | NUMERIC | No |
Linked PNN (push notification) record ID to the TLK record that provides additional context about the conversation.
13 | ORIGINAL_GROUP_ID_RECORD_NAME | VARCHAR | No |
Record name
14 | ACTIVE_ESCALATION_ID | NUMERIC | No |
The active Chat Request for the conversation, if applicable.
15 | CREATED_BY_USER_ID | VARCHAR | No |
Stores the ID of the user that created this conversation.
16 | CREATED_BY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
17 | INST_CREATED_UTC_DTTM | DATETIME (UTC) | No |
The UTC instant at which this record was created.
18 | INST_CREATED_LOCAL_DTTM | DATETIME (Local) | No |
The local instant at which this record was created.