IP_FS_ORD_IX_ID

Description: |
This table stores the orders associated with a flowsheet row in a multiple-response format for easier reporting.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
INPATIENT_DATA_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | INPATIENT_DATA_ID | VARCHAR | No |
The unique ID of the inpatient data record.
2 | GROUP_LINE | INTEGER | No |
The line number of the associated order ID stored in a flowsheet row in this inpatient data record. Together with INPATIENT_DATA_ID, this forms the foreign key to the IP_FLOWSHEET_ROWS table.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple order IDs stored in a flowsheet row that is associated with the inpatient data record and the order ID from the IP_FLOWSHEET_ROWS table.
4 | IX_FLOW_RW_ORD_ID | NUMERIC | No |
The unique IDs of the orders that are added to this patient's flowsheet row. This is a multiple-response item.