ED_RAD_STATUS
Description:
The ED_RAD_STATUS table contains information about ED patients' "radiology" status. One row in this table corresponds to one ED "radiology" status change. If a patient's ED "radiology" 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 record. Multiple pieces of information can be associated with this record.
3 ED_RAD_STATUS_C_NAME VARCHAR No
The ED radiology status category number for the ED encounter.
May contain organization-specific values: Yes
Category Entries:
Rad Ordered
Rad Sent
Rad Returned
Rad Reported
Rad Resulted
Pt Ready for X-Ray
Pt at X-Ray
Pt Returned from X-Ray
Image Exam Started
Image Available
Image Ordered
Image Sent
Image Returned
Image Reported
Image Resulted
Procedure Ordered
Procedure Resulted
Procedure Completed
4 RAD_STATUS_TIME DATETIME (Local) No
The date and time when the ED radiology status was set.
5 RAD_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 RAD_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.