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.