|
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. |
|
|