SPEC_ARCHIVE_ORDER

Description:

Contains information about orders that were archived as part of deceased patient archiving.

Primary Key

Column Name	Ordinal Position
SPECIMEN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SPECIMEN_ID	VARCHAR	No
	The unique identifier for the specimen 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	ARCH_ORDER_ID	NUMERIC	No
	The identifier of an order that has been archived as part of deceased patient archiving. Once the order is archived, all of the data from the order record is deleted and will not be available. This related group of items in the specimen record will be populated at the time of archiving by copying the most important pieces of information from the order record.
4	ARCH_ORD_PROC_NAME	VARCHAR	No
	Name of an order that has been archived as part of deceased patient archiving. Once the order is archived, all of the data from the order record is deleted and will not be available. This related group of items in the specimen record will be populated at the time of archiving by copying the most important pieces of information from the order record.
5	ARCH_ORD_PANEL_NAME	VARCHAR	No
	Name of an order panel that has been archived as part of deceased patient archiving. Once the order is archived, all of the data from the order record is deleted and will not be available. This related group of items in the specimen record will be populated at the time of archiving by copying the most important pieces of information from the order record.
6	ARCH_ORD_USER_ID	VARCHAR	No
	The unique identifier of the ordering user for an order that has been archived as part of deceased patient archiving. Once the order is archived, all of the data from the order record is deleted and will not be available. This related group of items in the specimen record will be populated at the time of archiving by copying the most important pieces of information from the order record.
7	ARCH_ORD_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	ARCH_ORD_DEP_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
9	ARCH_ORD_DTTM	DATETIME (Local)	No
	Prioritized instant for an order that has been archived as part of deceased patient archiving. Once the order is archived, all of the data from the order record is deleted and will not be available. This related group of items in the specimen record will be populated at the time of archiving by copying the most important pieces of information from the order record.
10	ARCH_CSN_ID	NUMERIC	No
	Encounter contact serial number for an order that has been archived as part of deceased patient archiving. Once the order is archived, all of the data from the order record is deleted and will not be available. This related group of items in the specimen record will be populated at the time of archiving by copying the most important pieces of information from the order record.
11	ARCH_AUTH_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.