ORD_SPECIMEN_INFO

Description: |
This table contains information on the associated specimen for the order including active status and the accessioning lab system.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier for the order record.
2 | SPECIMEN_LAB_ID | NUMERIC | No |
The lab (LLB) record ID responsible for filing the specimen information through the interface.
3 | SPECIMEN_LAB_ID_LLB_NAME | VARCHAR | No |
Interface laboratory name.
4 | SPECIMEN_ACTIVE_C_NAME | VARCHAR | No |
A compiled item used to generate an index of which specimens have not been deactivated on the order. (Eg. have no deactivated instant filed)
May contain organization-specific values: No
Category Entries:
Active
5 | SPECIMEN_ACTIVE_UTC_DTTM | DATETIME (UTC) | No |
The instant at which the specimen was first filed from the lab interface system.
6 | SPECIMEN_INACTIVE_UTC_DTTM | DATETIME (UTC) | No |
The instant at which the specimen was rendered inactive in response to a laboratory information system (LIS) message or linked order status change.
7 | SPECIMEN_INACTIVE_C_NAME | VARCHAR | No |
Interface or order status event which resulted in the specimen being marked unavailable for collection.
May contain organization-specific values: No
Category Entries:
Resulted
Cancelled
Complete
Reissued by LIS