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.