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.