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_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
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_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.