RES_VLD_AUDIT

Description:

Result audit information for verification and unverification (result correction).

Primary Key

Column Name	Ordinal Position
RESULT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RESULT_ID	VARCHAR	No
	The unique ID of the result 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	RES_SPECIMEN_ID	VARCHAR	No
	Internal specimen identifier associated with result
4	RES_VLD_STATUS_C_NAME	VARCHAR	No
	The result validation status category number for the audit trail validation status. May contain organization-specific values: No Category Entries: Preliminary Final Prelim Pend Final Pend Unverified Cosign Prelim Wait Final Wait Workflow Step Completed
5	RES_UNVLD_RSN_C_NAME	VARCHAR	No
	The result correction reason category number for the result correction. May contain organization-specific values: Yes
6	RES_VLD_USER	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.
7	RES_VLD_USER_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	RES_VLD_INSTANT	DATETIME (Local)	No
	The instant when the result is validated.
9	RES_UNVLD_RSN_COM	VARCHAR	No
	Unvalidation reason comment The category values for this column were already listed for column: RES_UNVLD_RSN_C_NAME
10	RES_UNVLD_RESULT_ID	VARCHAR	No
	The unique identifier of the validation audit result record that is associated with this result record.