|
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 |
|
|