INDICATOR_REL_ORD_DOC

Description:

This table extracts the media related to the orders in INDICATOR_REL_ORD_TBL.

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 patient 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	DOCUMENT_ID	VARCHAR	No
	The unique ID of a document linked to an order linked to a patient genomic indicator. Which order can be found by joining to INDICATOR_REL_ORD_TBL ON INDICATOR_REL_ORD_DOC.PAT_INDICATOR_ID = INDICATOR_REL_ORD_TBL.PAT_INDICATOR_ID and INDICATOR_REL_ORD_DOC.GROUP_LINE = INDICATOR_REL_ORD_TBL.LINE