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_RESEARCH_STUDY_NAME | VARCHAR | No |
The name of the research study record.
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
Post-Sign Research Association Grid
Therapy Plan
Post-Sign Ancillary Orders
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.