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