|
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 |
PSP_IDENT |
VARCHAR |
No |
|
|
|
The unique identifier for the Patient-Specific Package. |
|
|
7 |
PSP_LINKED_PACKAGE_NDC_ID |
VARCHAR |
No |
|
|
|
The unique identifier (.1 item) for the NDC record of the package linked to this Patient-Specific Package. |
|
|
8 |
PSP_LINKED_PACKAGE_NDC_ID_NDC_CODE |
VARCHAR |
No |
|
|
|
The external code for the National Drug Code (NDC). An NDC represents packages of medications. |
|
|
9 |
LINKING_USER_ID |
VARCHAR |
No |
|
|
|
The unique identifier (.1 item) for the EMP record of the user who linked the Patient-Specific Package to this patient. |
|
|
10 |
LINKING_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
11 |
LINK_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
The instant the Patient-Specific Package was linked to this patient. |
|
|