SLR_AUDIT
Description:
This table contains auditing information for second-level reviews.

Primary Key
Column Name Ordinal Position
REVIEW_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 REVIEW_ID NUMERIC No
The unique identifier for the second-level review.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 REQUEST_LAST_SAVED_UTC_DTTM DATETIME (UTC) No
The UTC instant the second-level review's request information was most recently edited.
4 REQUEST_LAST_SENT_UTC_DTTM DATETIME (UTC) No
The UTC instant the second-level review's request was most recently submitted.
5 REVIEW_LAST_SAVED_UTC_DTTM DATETIME (UTC) No
The UTC instant the second-level review's physician review information was most recently edited.
6 EDITING_USER_ID VARCHAR No
The unique ID associated with the user who last edited the second-level review. This column is frequently used to link to the CLARITY_EMP table.
7 EDITING_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 EDIT_INSTANT_UTC_DTTM DATETIME (UTC) No
The UTC instant the second-level review's contact was most recently edited.
9 REQUEST_LAST_SAVED_USER_ID VARCHAR No
The unique ID associated with the user who last edited the second-level review request. This column is frequently used to link to the CLARITY_EMP table.
10 REQUEST_LAST_SAVED_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 REQUEST_LAST_SENT_USER_ID VARCHAR No
The unique ID associated with the user who last submitted the second-level review request. This column is frequently used to link to the CLARITY_EMP table.
12 REQUEST_LAST_SENT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
13 REVIEW_LAST_SAVED_USER_ID VARCHAR No
The unique ID associated with the user who last edited the second-level review's physician review information. This column is frequently used to link to the CLARITY_EMP table.
14 REVIEW_LAST_SAVED_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.