CHAT_MESSAGE_CONTENT
Description:
Table for PHI message contents sent in secure chat.

Primary Key
Column Name Ordinal Position
CONVERSATION_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 CONVERSATION_ID NUMERIC No
The unique identifier (.1 item) for the secure chat conversation 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 MSG_TEXT VARCHAR No
Stores the message text for a single secure chat message. Note: It is stored in a super-item, because the super-item global structure is more efficient. No additional items should be added to its super item.
5 MEDIA_DOCUMENT_ID VARCHAR No
This item stores a link to a media record containing information about the media file sent in a Secure Chat message.
6 LINK_CONTENT_TYPE_C_NAME VARCHAR No
The type of content linked to in this message.
May contain organization-specific values: Yes
Category Entries:
SlicerDicer Session
Cogito Dashboard
Signed Order
Remote Dual Signoff
Pended Order Session
Bed Request
Transfer Center
Debug
7 LINK_REPORT_INFO_ID NUMERIC No
The SlicerDicer Session ID linked to in this message.
8 LINK_REPORT_INFO_ID_REPORT_INFO_NAME VARCHAR No
The name of the report.
9 LINK_ORDER_SESSION_EVENT_ID VARCHAR No
Store the pended order session that is linked to this message in the conversation.
10 LINK_ORDER_SESSION_EVENT_LINE INTEGER No
Store the event line for the pended order session that is linked to this message in the conversation.
11 LINK_RDS_PAT_ENC_CSN_ID NUMERIC No
Stores the patient CSN to link the message to the patient in the remote dual sign workflow
12 LINK_PENDING_ADT_EVENT_PEND_ID VARCHAR No
Store the ID for the pending ADT event (PND) that is linked to this message in the conversation.
13 LINK_TRANSFER_CENTER_COMM_ID NUMERIC No
Store the ID for the Transfer Center request (NCS) that is linked to this message in the conversation.
14 ORDER_ID NUMERIC No
Signed Order linked to in this message.
15 CAPTION_SS VARCHAR No
Caption of the order or saved work linked to this message.
16 DESCRIPTION_SS VARCHAR No
Description of the order or saved work linked to this message.
17 ORDER_SNAPSHOT_UTC_DTTM DATETIME (UTC) No
The instant at which order data for this message line was current.