ORDER_INSTANTIATED

Description: |
This table contains a list of orders that have been instantiated.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique ID of the order record.
2 | LINE | INTEGER | No |
The line count for this table as determined by the number of instantiated orders.
3 | INSTNTD_ORDER_ID | NUMERIC | No |
The ID for the instantiated order, the child. Note: For the case of the grandparent/parent/child scenario (Outpatient Standing order released into an Inpatient/HOV setting), this column will store the child (i.e. “grandchild”) order and the ORDER_ID column will store the parent order. For the grandparent/parent order relationship, refer to STAND_HOV_INST_ORD.ORDER_ID (“grandparent”) and STAND_HOV_INST_ORD.STAND_INS_IP_ORD_ID (“parent”).