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.