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.