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