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