ORD_NESTED_OSQS

Description: |
Contains nested panel information where each line represents one level of nesting.

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 number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | NESTED_PANEL_ID_ORDERSET_NAME | VARCHAR | No |
The SmartGroup record name. This is different from the display name, which is stored in CL_OSQ_OT.DISPLAY_NAME.
4 | NESTED_PANEL_CONTACT_DATE_REAL | NUMERIC | No |
Stores a list of grouped orders (OSQ) contact dates (DATs) corresponding to the nested (group within group) OSQ IDs.
5 | NESTED_PANEL_UNIQ_KEY | VARCHAR | No |
Stores a list of "panel info"s corresponding to the OSQ IDs above, which uniquely identify identical nested OSQs placed in the same ordering session.
6 | NESTED_GROUP_ID | NUMERIC | No |
For orders from clinical pathways (a method of placing many orders that are meant to take place over a period of time all at once), stores a list of TRG IDs representing the groups of orders which contain other groups of orders from which the order originated.
7 | NESTED_GROUP_CSN | NUMERIC | No |
Stores a list of Patient Order Groups and Treatment Days (TRG) Contact Serial Numbers (CSN) associated with the above TRG IDs.