|
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 |
HSP_ACCOUNT_ID |
NUMERIC |
No |
|
|
|
The hospital account ID for a Hospital at Home linked visit |
|
|
7 |
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. |
|
|
8 |
START_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
The start instant for a Hospital at Home linked visit |
|
|
9 |
END_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
The end instant for a Hospital at Home linked visit |
|
|
10 |
VISIT_TYPE_ID_PRC_NAME |
VARCHAR |
No |
|
|
|
The name of the visit type. |
|
|