DEPT_PAT_CARE_SELECTION

Description:

Table containing Department of Patient Care, and Department of Patient Care selection information for orders.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier (.1 item) for the order record.
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	DPCAR_DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
4	DPCAR_PAT_ENC_CSN_ID	NUMERIC	No
	Stores the contact serial number (CSN) of the encounter from which the department of patient care (I ORD 77910) was chosen. The last line contains the CSN corresponding to the current department of care, while previous lines contain historical values.
5	DPCAR_SEL_LOGIC_C_NAME	VARCHAR	No
	Stores the selection logic used to determine the department of patient care (I ORD 77910) chosen for the order. The last line contains the selection logic that corresponds to the current department of care, while previous lines contain historical values. May contain organization-specific values: No Category Entries: Set by end user Encounter where the order was signed Most recent eligible encounter with authorizing provider Most recent eligible encounter with ordering provider Most recent eligible encounter with the same encounter provider Most recent eligible encounter in the same encounter department Most recent eligible encounter where an order in the reorder chain was signed Patient contact department at the time of signing the order
6	DPCARE_SEL_INST_UTC_DTTM	DATETIME (UTC)	No
	Stores the instant in which the department of patient care (I ORD 77910) was saved for the order. The last line contains the instant in which the current department of care was saved, while previous lines contain historical values.
7	DPCARE_UPDT_USER_ID	VARCHAR	No
	Stores the user ID of the user who caused the department of patient care (I ORD 77910) to be saved for the order. Saving of the department of patient care occurs when initially signing an order, when updating the order's authorizing or ordering provider, or when changing the encounter department for the encounter in which the order was signed. The last line contains user ID of the user who triggered the saving of the current department, while previous lines contain historical values.
8	DPCARE_UPDT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.