ED_PAT_STATUS

Description: |
The ED_PAT_STATUS table contains information about ED patients' "patient" status. One row in this table corresponds to one ED "patient" status change. If a patient's ED "patient" status is changed five times in a single encounter, this table will contain five rows for that encounter.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
INPATIENT_DATA_ID | 1 |
LINE | 2 |

Column Information

| 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 for the information associated with this patient status. Multiple pieces of information can be associated with this record.
3 | ED_PAT_STATUS_C_NAME | VARCHAR | No |
The category number of the ED patient status for the ED encounter.
May contain organization-specific values: Yes
Category Entries:
Expected
Waiting Room
Waiting for Nurse
Waiting for Physician
Test Results
Ready for Discharge
Observation
Physician In
Nurse In
Ready for Admit
In Process
Ready for Re-Eval
Waiting for Triage
Ready for Transfer
Ready for Transport
In Transport
Waiting for AVS
Bed Requested
In Triage
Waiting
Waiting for Provider
With Nurse
With Provider
Ready for Disposition
Waiting for Transport
Waiting for Room
At Kiosk
Kiosk Completed
Kiosk Timed Out
Kiosk Redirected
Checked Out
Scheduled
Arrived
Rooming in Progress
Visit in Progress
Visit Complete
Signed
Not Seen
Patient Left
Present
Open Addendum
Canceled
Rescheduled
Resident/Fellow In
At Diagnostic Testing
Dilating in Exam Room
Dilating in Waiting Room
Exam Complete
Orthoptist In
Technician In
Testing Complete
Waiting for Orthoptist
Waiting for Resident/Fellow
4 | PAT_STATUS_TIME | DATETIME (Local) | No |
The date and time when the ED patient status was set.
5 | PAT_STATUS_USER_ID | VARCHAR | No |
The unique ID of the user who is associated with this status change. This column is frequently used to link to the CLARITY_EMP table.
6 | PAT_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.