PROV_COMM_SENSITIVE
Description:
This table stores information about provider communications. This includes whether the communication is sensitive or not, where the communication originated from, and the communication job ID.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 COMM_INFO_JOB_ID VARCHAR No
This item stores the job ID for the communication info table. Information stored in this table will stay the same for every recipient in one communication.
5 COMM_FROM_USER_ID VARCHAR No
This item stores the communication from user's ID.
6 COMM_FROM_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 COMM_SENSITIVE_C_NAME VARCHAR No
This item stores the sensitive setting of a communication.
May contain organization-specific values: No
Category Entries:
Sensitive
Not Sensitive
Marked Sensitive After Send
Marked Not Sensitive After Send
8 COMM_TYPE_C_NAME VARCHAR No
The type of communication, used to define a specific workflow for the communication.
May contain organization-specific values: Yes
9 COMM_INFO_FROM_DEP NUMERIC No
Communication from department.
10 COMM_INFO_EXT_USR VARCHAR No
Communication from external user, a free text string.
11 COMM_MSG_ID VARCHAR No
Universally unique ID for a communication.
12 COMM_PARENT_ID VARCHAR No
Message ID of the parent communication
13 COMM_CONV_ID VARCHAR No
The unique ID of the conversation, which is used to group related communications.
14 COMM_FROM_PROV_ID VARCHAR No
The unique ID of the provider (SER) record that sent the communication.