|
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 |
|
|
|
|
14 |
ACTIVE_ESCALATION_ID |
NUMERIC |
No |
|
|
|
The active Chat Request for the conversation, if applicable. |
|
|