This table contains information about orders associated with result records.
Primary Key
Column Name
Ordinal Position
RESULT_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
RESULT_ID
VARCHAR
No
The unique identifier (.1 item) for 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
SOURCE_ORDER_ID
NUMERIC
No
The unique ID of the source order for the result. For tests that have been redrawn or moved, this is the removed order. For tests that have not be redrawn or removed, this is an order that the current result for the test will file to. This is the culture order for susceptibility tests. Anatomic pathology results may have multiple source orders.