ADT_ORDER_INFORMATION
Description:
This table contains information about ADT Orders.

Primary Key
Column Name Ordinal Position
ORDER_ID 1

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier for the order record.
2 ACCOMMODATION_C_NAME VARCHAR No
Stores the accommodation code.
May contain organization-specific values: Yes
3 ACCOM_REASON_C_NAME VARCHAR No
Stores the accommodation code reason.
May contain organization-specific values: Yes
4 ADT_ADMT_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.
5 ADT_ATTEND_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.
6 ADM_COND_C_NAME VARCHAR No
Stores the patient condition.
May contain organization-specific values: Yes
7 ADT_CONSULT_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 ADT_DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.
9 ADT_EXPECT_ADMSN_DATE DATETIME No
Stores the date the patient is expected to be admitted.
10 ADT_EXPECT_DISCHRG_DATE DATETIME No
Stores the date the patient is expected to be discharged.
11 ADT_EXPECT_STAY_LEN INTEGER No
Stores the number of days the patient is expected to stay.
12 PAS_HAR_CHNG_RSN_C_NAME VARCHAR No
Stores the reason why the patient's current hospital account is ending, and a new hospital account is beginning.
May contain organization-specific values: Yes
No Entries Defined
13 ADT_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
14 ADT_INTERN_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.
15 LEVEL_OF_CARE_C_NAME VARCHAR No
Stores the level of care.
May contain organization-specific values: Yes
16 ADT_PAT_CLASS_C_NAME VARCHAR No
Stores the patient class.
May contain organization-specific values: Yes
17 REASON_C_NAME VARCHAR No
Stores the reason for inserting a patient update event.
May contain organization-specific values: Yes
18 ADT_RES_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.
19 ADT_RESP_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
20 ADT_RESP_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
21 HOSP_SERV_C_NAME VARCHAR No
Stores the service.
May contain organization-specific values: Yes
22 ADT_SERV_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
23 ADT_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
24 ADT_ORDER_TYPE_C_NAME VARCHAR No
This item stores the type of ADT order.
May contain organization-specific values: No
Category Entries:
Admission, Transfer, Update
Leave of Absence
Discharge
Telemetry