|
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. |
|
|