RIS_REVISE_RSLTS

Description: |
This table provides an audit trail of dates, times, and user IDs of revisions to finalized study results through the Revise Results activity.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique ID of the order record associated with this procedure order.
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 | REVISING_USER_ID | VARCHAR | No |
The user ID who revised the finalized result.
4 | REVISING_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | REVISED_DATETIME | DATETIME (Local) | No |
The date and time that the finalized result was revised. If the date is null, the default value is 01/01/1900; If the time is null, the default value is 00:00.