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.