ORD_ACKNOWLEDGE

Description:

This table is used to extract inpatient order acknowledge information.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier for the order record.
2	LINE	INTEGER	No
	The line count for this table as determined by the number of times the order is acknowledged.
3	ACK_TYPE_C_NAME	VARCHAR	No
	The acknowledge type category number for the order. Only Hospital Outpatient Visit (HOV) appointments have a value populated for this column. May contain organization-specific values: No Category Entries: Acknowledging Order Placing Acknowledging Order Discontinued Acknowledging Order Modified Acknowledging Order Held Acknowledging Order Unheld Acknowledging Order Expired Acknowledging Order Cancel Hold Undoing Order Acknowledging
4	ACK_USER_ID	VARCHAR	No
	The user who marked the order as acknowledged and validated they saw it, and take responsibility for it
5	ACK_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	ACK_TIME	DATETIME (Local)	No
	The date and time at which a user acknowledged they had seen the order and take responsibility for it.
7	ACK_DETAIL_LINE	INTEGER	No
	This column is used only while acknowledging modified orders. Since an order may be modified multiple times, this column saves the line number for acknowledged modifications from group ORD-35100, which stores the username of the user who modified the order.
8	ACK_LINKED_LINE	INTEGER	No
	Stores the line within the Superitem that a given line is linked to.
9	AUTO_ACK_YN	VARCHAR	No
	This column stores whether or not an order automatically had a user acknowledge the order and take responsibility for it. May contain organization-specific values: No Category Entries: No Yes