LAB_CASE_QA
Description:
This table contains the selected case's quality assurance information.

Primary Key
Column Name Ordinal Position
REQUISITION_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 REQUISITION_ID NUMERIC No
The unique identifier for the case 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 LAB_CASE_QA_EVENT_C_NAME VARCHAR No
This will store the QA (Quality Assurance) event type for the case.
May contain organization-specific values: Yes
4 LAB_CASE_QA_CASE_ID NUMERIC No
The unique identifier of the correlated case record.
5 LAB_CASE_QA_SPEC_ID VARCHAR No
The unique identifier of the correlated specimen record.
6 LAB_AP_REVIEWER_ID VARCHAR No
The unique identifier of the user who is the reviewer of a related QA (Quality Assurance) event.
7 LAB_AP_REVIEWER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 LAB_AP_REVIEW_DATE DATETIME No
Stores the review date of a related QA (Quality Assurance) event.
9 LAB_AP_QA_STATUS_C_NAME VARCHAR No
The status category number for the related QA (Quality Assurance) event.
May contain organization-specific values: No
Category Entries:
In Progress
Completed
10 LAB_CASE_QA_ORD_ID NUMERIC No
The unique identifier of the correlated order record.