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
Donor
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