|
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. |
|
|