|
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 |
FIRST_CALL_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. |
|
|
7 |
FIRST_CALL_USER_ID |
VARCHAR |
No |
|
|
|
This item identifies the user who was designated as the patient's first call following a change in coverage for the encounter treatment team. The item is only populated for assignments from the On-Call schedule. |
|
|
8 |
FIRST_CALL_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
9 |
FIRST_CALL_TRTMNT_TEAM_REL_C_NAME |
VARCHAR |
No |
|
|
|
This item identifies the role of the provider who was designated as the patient's first call following a change in coverage for the encounter treatment team. |
May contain organization-specific values: Yes |
|
|
10 |
FIRST_CALL_UPDATE_DTTM |
DATETIME (UTC) |
No |
|
|
|
This item identifies the update time of the provider who was designated as the patient's first call following a change in coverage for the encounter treatment team. This corresponds to the time the first call was referenced for use (by the system or display to an end user) and not necessarily the time at which the patient's first call provider's assignment was updated. |
|
|
11 |
FIRST_CALL_REASON_C_NAME |
VARCHAR |
No |
|
|
|
This item identifies the update reason for the provider who was designated as the patient's first call following a change in coverage for the encounter treatment team. |
May contain organization-specific values: No |
Category Entries: |
Manual |
Automatic - On-Call Covering |
Automatic - Team Role |
Automatic - Primary Team Contact |
Automatic - Scheduled Manual Override Shift Start |
|
|
12 |
FIRST_CALL_CHNG_USER_ID |
VARCHAR |
No |
|
|
|
This item identifies the update user for the provider who was designated as the patient's first call following a change in coverage for the encounter treatment team. |
|
|
13 |
FIRST_CALL_CHNG_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|