ORD_RESEARCH_CODE

Description:

This table contains information about research studies that an order is associated with. The table includes a column that links to the corresponding Research Study (RSH) record.

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	RESEARCH_CODE_ID	VARCHAR	No
	The ID number of the Research Study record that is associated with the Order. A research study record stores information about a research study. If an Order record is linked to one, it means that the Order is somehow related to the research study.
4	RSH_CODE_COMMENT	VARCHAR	No
	Any comments associated with a linked Research Study record. A Research Study record stores information about research studies. This column is used in combination with the RESEARCH_CODE_ID column and stores any comments a user may have made regarding the link between the Order and the research study.
5	RSH_CODE_FROM_C_NAME	VARCHAR	No
	This item stores where the research association in Research Study record ID came from. This is so that we can track where an association was made, to avoid potentially overwriting data from one valid source with another, such as overwriting Research Association Grid data with Order-Specific question data. May contain organization-specific values: No Category Entries: Research Association Grid Order-Specific Question Response Treatment Plan Interfaced Reflex API SmartSet DBC Association Popup
6	ENROLL_ID	NUMERIC	No
	The unique ID of the research study association that has been linked to this order. Linking an order to a research study association means the order is related to the execution of the research study.