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.