|
Name |
Type |
Discontinued? |
|
1 |
INPATIENT_DATA_ID |
VARCHAR |
No |
|
|
|
The unique ID associated with the Inpatient Data Store record for this row. This column is frequently used to link to PAT_ENC_HSP.INPATIENT_DATA_ID. |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The line number of the status associated with this ED consult. Multiple pieces of information can be associated with this record. |
|
|
3 |
ED_CONS_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
The category number of the ED consult status for the ED encounter. |
May contain organization-specific values: Yes |
Category Entries: |
Consult Called |
Consult Responded |
Consult Completed |
Consult Arrived |
|
|
4 |
CONS_STATUS_TIME |
DATETIME (Local) |
No |
|
|
|
The date and time when the ED consult status was set. |
|
|
5 |
CONS_STATUS_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the user who is associated with this ED consult status change. This column is frequently used to link to the CLARITY_EMP table. |
|
|
6 |
CONS_STATUS_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
7 |
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). This column is frequently used to link to PAT_ENC_HSP.PAT_ENC_CSN_ID. |
|
|