HSC_TESTS
Description:
This table stores information about the tests that are run for Specimens.

Primary Key
Column Name Ordinal Position
RECORD_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique ID of the Specimen Collection (HSC) 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 TESTS_ID NUMERIC No
This column contains the procedure that needs to be performed in the lab.