RSLT_ORDERS

Description: |
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.