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	VARCHAR	No
	Stores the admitting provider.
5	ADT_ATTEND_PROV_ID	VARCHAR	No
	Stores the attending provider.
6	ADM_COND_C_NAME	VARCHAR	No
	Stores the patient condition. May contain organization-specific values: Yes
7	ADT_CONSULT_PROV_ID	VARCHAR	No
	Stores the lead consultant.
8	ADT_DX_ID	NUMERIC	No
	Stores the primary 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	NUMERIC	No
	Stores the hospital area.
14	ADT_INTERN_PROV_ID	VARCHAR	No
	Stores the intern provider.
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	VARCHAR	No
	Stores the resident provider.
19	ADT_RESP_LOC_ID	NUMERIC	No
	Stores the responsible department.
20	ADT_RESP_DEPARTMENT_ID	NUMERIC	No
	Stores the responsible hospital unit.
21	HOSP_SERV_C_NAME	VARCHAR	No
	Stores the service. May contain organization-specific values: Yes
22	ADT_SERV_AREA_ID	NUMERIC	No
	Stores the service area.
23	ADT_DEPARTMENT_ID	NUMERIC	No
	Stores the hospital unit.