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