ORD_RESEARCH_ASSOC_HX

Description: |
This table contains information about the changes that have occurred to the association between an order and research studies after an order has been signed. If the research association of an order has not been modified, it will not appear in this table.
Each row is one change event for an order.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier (.1 item) 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 | ASSOCIATING_USER_ID | VARCHAR | No |
User ID responsible for the change on this line of this order.
4 | ASSOCIATING_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | ASSOCIATED_UTC_DTTM | DATETIME (UTC) | No |
The date and time when the order had its research association changed after signing.
6 | RESEARCH_ID_RESEARCH_STUDY_NAME | VARCHAR | No |
The name of the research study record.
7 | PREV_RESEARCH_ID_RESEARCH_STUDY_NAME | VARCHAR | No |
The name of the research study record.
8 | RSH_CODE_FROM_C_NAME | VARCHAR | No |
This column stores the source that was used to modify the research association of this order in this modification event.
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
9 | PREV_RSH_CODE_FROM_C_NAME | VARCHAR | No |
This column stores the source that was used to modify the research association in the previous modification event.
The category values for this column were already listed for column: RSH_CODE_FROM_C_NAME