INDICATOR_REL_ORD_RSLT

Description: |
This table extracts the result components for the order stored in INDICATOR_REL_ORD_TBL. The corresponding value for this result component can be found in INDICATOR_REL_ORD_VAL for matching values of PAT_INDICATOR_ID, GROUP_LINE, and VALUE_LINE.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_INDICATOR_ID | NUMERIC | No |
The unique identifier (.1 item) for the pt indicators record.
2 | GROUP_LINE | INTEGER | No |
The line number for the information associated with this record.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of data within this record.
4 | COMPONENT_ID | NUMERIC | No |
If a lab result triggered this patient genomic indicator to be added, the result components causing this PGI to be added are stored in this item, grouped by the order which contains the result.
5 | COMPONENT_ID_NAME | VARCHAR | No |
The name of the component.