REQ_ALL_MAIN

Description:

The REQ_ALL_MAIN table contains basic information about Requisitions, Cases, and External System Patient Demographics.

Primary Key

Column Name	Ordinal Position
REQUISITION_ID	1

Column Information

	Name	Type	Discontinued?
1	REQUISITION_ID	NUMERIC	No
	The unique identifier for the requisition, case, or external system patient demographics record.
2	REQ_TYPE_C_NAME	VARCHAR	No
	The type category ID for the requisition, case, or external system patient demographics record. May contain organization-specific values: No Category Entries: Requisition Case External System Patient Demographics External System Identifier Mapping
3	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4	PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number (CSN) of the patient. If you use IntraConnect, this is the Unique Contact Identifier (UCI). For requisitions, this is the CSN for the Lab Requisition encounter associated with the requisition. For cases, this is the CSN for the encounter linked to the first order on the case.
5	RQG_GROUPER_ID	NUMERIC	No
	The unique ID of the requisition grouper associated with this record.
6	CANCELED_YN	VARCHAR	No
	Indicates whether the record is canceled. 'Y' indicates that the record is a canceled requisition or case. 'N' indicates that the record is not canceled. May contain organization-specific values: No Category Entries: No Yes