LAB_TEST
Description:
This table stores general information about instances of lab tests. It contains one row per test, including both anatomic and clinical pathology tests.

Primary Key
Column Name Ordinal Position
TEST_INSTANCE_ID 1

Column Information
Name Type Discontinued?
1 TEST_INSTANCE_ID NUMERIC No
The unique identifier (.1 item) for the test record.
2 ENTERED_DATE DATETIME No
The date the instance of the test was created.
3 CASE_CAPABLE_YN VARCHAR No
Indicates whether the test supports anatomic pathology case functionality. 'Y' indicates that the test supports case functionality. 'N' or NULL indicate that the test does not support case functionality.
May contain organization-specific values: No
Category Entries:
No
Yes
4 MULTI_SPEC_PER_TEST_CAPABLE_YN VARCHAR No
Indicates whether the test supports multiple specimens per test. 'Y' indicates that the test supports multiple specimens per test. 'N' or NULL indicate that the test does not support multiple specimens per test.
The category values for this column were already listed for column: CASE_CAPABLE_YN
5 MULTI_TEST_PER_SPEC_CAPABLE_YN VARCHAR No
Indicates whether the test supports multiple tests per specimen. 'Y' indicates that the test supports multiple tests per specimen. 'N' or NULL indicate that the test does not support multiple tests per specimen.
The category values for this column were already listed for column: CASE_CAPABLE_YN
6 NO_SPECIMENS_CAPABLE_YN VARCHAR No
Indicates whether the test is allowed to have no specimens. 'Y' indicates that the test is allowed to have no specimens. 'N' or NULL indicate that the test must have a specimen.
The category values for this column were already listed for column: CASE_CAPABLE_YN
7 PRODUCT_ASSIGN_CAPABLE_YN VARCHAR No
Indicates whether the test supports product assignment. 'Y' indicates that the test supports product assignment. 'N' or NULL indicate that the test does not support product assignment.
The category values for this column were already listed for column: CASE_CAPABLE_YN
8 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
9 GROUPER_ID NUMERIC No
The unique ID of the requisition grouper record for this row.
10 LAB_ID_LAB_NAME VARCHAR No
The name of the lab record.
11 CONTAINER_ID VARCHAR No
The unique ID of the tracking container for this test.
12 SUBSPECIALTY_C_NAME VARCHAR No
The case flag category ID for the case's subspecialty.
May contain organization-specific values: Yes
13 PAT_ASSOC_UTC_DTTM DATETIME (UTC) No
The date and time when the patient was associated with the test in UTC.
14 CASE_ACCESSION_LOCAL_DTTM DATETIME (Local) No
The date and time that the case was first accepted in Case Builder in the time zone of the lab.
15 CASE_ACCESSION_UTC_DTTM DATETIME (UTC) No
The date and time that the case was first accepted in Case Builder in UTC.
16 EARLIEST_COLL_LOCAL_DTTM DATETIME (Local) No
The earliest date and time any specimen on the test was collected in the time zone of the submitter or accessioning department.
17 CASE_RECEIVED_LOCAL_DTTM DATETIME (Local) No
The date and time that the case was received in the time zone of the lab. This is initially set when the first specimen on the case is received, and it is updated any time all case containers are received into a new lab.
18 CASE_SIGNOUT_LOCAL_DTTM DATETIME (Local) No
The date and time when the entire case was signed out in the time zone of the lab.
19 CASE_OVERDUE_LOCAL_DTTM DATETIME (Local) No
The date and time the case is considered overdue in the time zone of the lab. This is equal to the Case Received date and time plus the Case Expected Length.
20 LAST_TASK_ADDED_LOCAL_DTTM DATETIME (Local) No
The latest date and time when a task was added to this case in the time zone of the lab.
21 LAST_TASK_ADDED_UTC_DTTM DATETIME (UTC) No
The latest date and time when a task was added to this case in UTC.
22 PRIMARY_SPECIMEN_ID VARCHAR No
The unique ID of the specimen which is most representative of the anatomic pathology case as a whole.
23 SERVICE_LINE_PROVIDERTEAM_ID NUMERIC No
The unique ID of the provider team who should work on the case.
24 SERVICE_LINE_PROVIDERTEAM_ID_RECORD_NAME VARCHAR No
The name of the record.
25 PRIM_SPEC_OVRIDE_USER_ID VARCHAR No
The unique ID of the user who manually overrode the primary specimen value.
26 PRIM_SPEC_OVRIDE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
27 PRIM_SPEC_OVRIDE_UTC_DTTM DATETIME (UTC) No
The date and time when the primary specimen was overridden by the user in UTC.
28 CTZN_OVRIDE_USER_ID VARCHAR No
The unique ID of the user who manually overrode either the subspecialty or service categorization of the case.
29 CTZN_OVRIDE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
30 CTZN_OVRIDE_UTC_DTTM DATETIME (UTC) No
The date and time when either the subspecialty or service categorization of the case were overridden in UTC.
31 CASE_TYPE_ID_LAB_NAME VARCHAR No
The name of the lab record.
32 ACCESSION_NUM VARCHAR No
The accession number for this test instance.
33 AP_CASE_STATUS_C_NAME VARCHAR No
The anatomic pathology case status category ID for the test instance.
May contain organization-specific values: Yes
Category Entries:
New
Accessioned
Gross Description Done
Microscopic Description Done
Interpretation Done
Final Diagnosis Done
Signed Out
Cytology Screen
Cytology Rescreen
Cytopathologist Review
Amendment
Addendum
Canceled
34 EARLIEST_COLL_UTC_DTTM DATETIME (UTC) No
The earliest collection instant across all specimens in UTC.
35 EFF_INSTANT_UTC_DTTM DATETIME (UTC) No
The relevant instant for clinical reporting of this test in UTC.
36 EFF_INSTANT_LOCAL_DTTM DATETIME (Local) No
The relevant instant for clinical reporting of this test in local time.