PAT_ENC_CALL_CMTS

Description:

This table stores information regarding the free-text comments entered in Protocols during clinical calls.

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	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	CM_CT_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6	SEC_PROTOCOL_ID	NUMERIC	No
	ID of the Protocol Section within which a triager has left a comment.
7	SEC_PROTOCOL_ID_PROTOCOL_NAME	VARCHAR	No
	The display name of the protocol.
8	SEC_PROTOCOL_CNCT	NUMERIC	No
	DTE of the protocol section LPT record that the comment was left on. Note that the source item is a DAT value - Clarity does not support DAT columns, so we have to transform it into a DTE.
9	SEC_PROTOCOL_ROW	INTEGER	No
	Number corresponding to the Protocol Section row (I LPT 230 line) on which a triager has left a comment. Special case: All Negative rows do not have a corresponding I LPT 230 line, and are stored as special value "-1".
10	CMT_USER_ID	VARCHAR	No
	User ID of the triager who left a comment on a Nurse Triage protocol.
11	CMT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
12	CMT_INST_UTC_DTTM	DATETIME (UTC)	No
	Instant (in UTC) of the last edit to this protocol comment.