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