PXPASS_RESULT_REVIEW
Description:
This table contains information about users who reviewed results in the system and indicated that their review was relevant to a particular Procedure Pass.

Primary Key
Column Name Ordinal Position
RECORD_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique ID of the Procedure Pass 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 REVIEW_USER_ID VARCHAR No
The unique ID associated with the user record for this row. This column is frequently used to link to the CLARITY_EMP table.
4 REVIEW_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 REVIEW_ORDER_ID NUMERIC No
The unique ID of the order whose result was reviewed by a user who indicated that their review was specific to this Procedure Pass
6 REVIEW_ORD_DAT NUMERIC No
Stores the order contact for a result that was reviewed by a user who indicated that their review was specific to this Procedure Pass
7 PXPASS_REVIEW_RSN_C_NAME VARCHAR No
Stores the reason that a result was reviewed.
May contain organization-specific values: Yes
Category Entries:
Other (See Comments)
8 REVIEW_COMMENT VARCHAR No
Stores the comment associated with a result review.