REQ_DB_MAIN
Description:
The main table for requisition entries. It contains mostly patient demographics and items that don't change much over time.

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 record.
2 REQ_GROUPER_ID NUMERIC No
When a requisition is created for a non-participating submitter it is attached to a requisition grouper record rather than a patient record.
3 REQ_PAT_CONTACT VARCHAR No
Stores the patient contact that this requisition is linked to.
4 REQ_LAB_ID_LAB_NAME VARCHAR No
The name of the lab record.
5 REQ_SUBMITTER_ID NUMERIC No
Stores the submitter associated with this requisition.
6 REQ_SUBMITTER_ID_RECORD_NAME VARCHAR No
The name of the submitter record.
7 REQ_COLL_SITE_ID NUMERIC No
Used for toxicology submitters to track where the specimen was collected.
8 REQ_COLL_SITE_ID_COL_SITE_NAME VARCHAR No
The name of the collection site.
9 REQ_SUBM_PT_ID VARCHAR No
Stores the patient's ID at the submitter site.
10 REQ_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.
11 REQ_EMPLOYER_ID VARCHAR No
Stores the patient's employer.
12 REQ_EMPLOYER_ID_EMPLOYER_NAME VARCHAR No
The name of the employer.
13 REQ_EMPLOYER_PAT_ID VARCHAR No
Stores the patient's ID at the employer's site.
14 REQ_STUDY_NUMBER VARCHAR No
Free text study number that can be entered during requisition entry
15 REQ_INTERVAL_NUMBER VARCHAR No
Interval number often used in research studies
16 REQ_ROOM_NUM VARCHAR No
Stores the room number associated with this requisition.
17 REQ_CHART_NUM VARCHAR No
Stores the chart number associated with this requisition.
18 REQ_COUNSELOR VARCHAR No
Stores the counselor associated with this requisition.
19 REQ_COUNSEL_PHN_NUM VARCHAR No
Stores the phone number for the counselor associated with this requisition.
20 REQ_PAT_CITY VARCHAR No
Stores the city of the patient associated with this requisition.
21 REQ_PAT_ZIP VARCHAR No
Stores the ZIP of the patient associated with this requisition.
22 REQ_PAT_COUNTY_C_NAME VARCHAR No
Stores the county of the patient associated with this requisition.
May contain organization-specific values: Yes
23 REQ_PAT_COUNTRY_C_NAME VARCHAR No
Stores the country of the patient associated with this requisition.
May contain organization-specific values: Yes
24 REQ_BILL_TO_C_NAME VARCHAR No
Designates which entity should be primarily responsible for the charges generated by the requisition.
May contain organization-specific values: No
Category Entries:
Client Bill
Patient Bill
25 REQ_ACCOUNT_ID NUMERIC No
The account that should be used for requisition billing.
26 REQ_COVERAGE_ID NUMERIC No
Coverage attached to the requisition for billing.
27 REQ_COMMENT_ID VARCHAR No
Comments associated with the requisition
28 TIME_COLL_TM DATETIME (Local) No
Stores time collected entered in Express Requisition Entry. This item is only used temporarily until an specimen (OVS) record is created for the requisition (REQ) record.
29 REQ_STATUS_C_NAME VARCHAR No
Denotes whether the requisition is active, closed or canceled
May contain organization-specific values: No
Category Entries:
In Progress
Completed
Canceled
Generating
30 EXTERNAL_VISIT_ID VARCHAR No
External visit identifier of the requisition
31 PATIENT_SEX_C_NAME VARCHAR No
Stores patient gender entered during requisition entry.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
32 PATIENT_DOB DATETIME No
Patient date of birth as it was entered during requisition entry.
33 AGE INTEGER No
Age of the requisition's patient
34 AGE_UNITS_C_NAME VARCHAR No
Units for the age of the requisition's patient
May contain organization-specific values: No
Category Entries:
Years
Months
Weeks
Days
Hours
35 PATIENT_SSN VARCHAR No
SSN as it was entered during requisition entry.
36 NON_HUMAN_YN VARCHAR No
Flag to indicate the requisition's patient is non-human
May contain organization-specific values: No
Category Entries:
No
Yes
37 OUT_SPEC_DET_FLG_YN VARCHAR No
This column determines whether Specimen Details have been saved for the Requisition. Note it is only used and set from the Web Outreach system- if Specimen Details are saved in another way, this column will not get updated until the next time the Specimen Details data is accessed from the Web Outreach system.
The category values for this column were already listed for column: NON_HUMAN_YN
38 ACUTE_CONVAL_C_NAME VARCHAR No
Item to store acute/convalescent flag entered in Express Req Entry. This item is only used temporarily until a Specimen (OVS) record is created for the Requisition (REQ) record.
May contain organization-specific values: No
Category Entries:
Acute
Convalescent
39 DATE_ENTR_DT DATETIME No
Stores the date the requisition was created in Requisition Entry. If the requisition was pre-printed, this item stores the date it was pre-printed, and once the requisition is received in the lab, the date it was received.
40 STUDY_NUM_C_NAME VARCHAR No
Stores the study number associated with this requisition.
May contain organization-specific values: Yes
41 INTERNAL_COMMENT_ID VARCHAR No
Stores internal comments related to the requisition. These are not sent on any external reports.
42 REQUISITION_NAME VARCHAR No
This is the name of the Requisition record.
43 REQ_PAT_HOUSE_NUM VARCHAR No
Stores the house number of the patient associated with this requisition.
44 REQ_PAT_DISTRICT_C_NAME VARCHAR No
Stores the district of the patient associated with this requisition.
May contain organization-specific values: Yes
45 ORDERING_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.
46 ORD_PROV_CMT VARCHAR No
The comment associated with the ordering provider for this row.
47 AUTH_PROV_CMT VARCHAR No
The comment associated with the authorizing provider for this row.
48 PAT_BIRTH_TM DATETIME (Local) No
Patient date and time of birth as it was entered during requisition entry.
49 LAB_BILL_ENC_CSN_ID NUMERIC No
The billing encounter to use by default for charges from this requisition's orders.
50 ETHNIC_GROUP_C_NAME VARCHAR No
The ethnic group category number for the requisition's patient.
May contain organization-specific values: Yes
51 SUBM_PAT_ALIAS_ID VARCHAR No
References an alternate form of a patient's name that is sent either by interface or paper requisition form from an outside submitter. This is used in reporting results back to the submitter. The name is stored in the Person Name database.
52 ENTERING_USER_ID VARCHAR No
The unique ID associated with the user record who created this requisition. This column is frequently used to link to the CLARITY_EMP table.
53 ENTERING_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
54 INSTANT_PAT_ASSOC_UTC_DTTM DATETIME (UTC) No
The date and time when the patient was associated with the requisition.
55 GENDER_IDENTITY_C_NAME VARCHAR No
The gender identity category ID for the requisition.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Other
Choose not to disclose
Nonbinary
Genderqueer
56 SEX_ASGN_AT_BIRTH_C_NAME VARCHAR No
The sex assigned at birth category ID for the requisition.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Not recorded on birth certificate
Choose not to disclose
Uncertain
57 AUTOPSY_REC_FROM VARCHAR No
Organization or person that an autopsy was received from on a requisition.
58 AUTOPSY_GEST_AGE_WEEKS VARCHAR No
Gestational Age in Weeks of the deceased patient received on a requisition. This field is a free text field.
59 AUTOPSY_MOMS_CHART VARCHAR No
Mother's Chart Number for still born from the autopsy requisition. This will be a free text string to accommodate any type of chart number (numeric, alphanumeric, etc.) from the sending organization.
60 AUTOPSY_FNRL_HOME VARCHAR No
Stated funeral home for an autopsy that sent the specimens in a requisition.
61 AUTOPSY_DEATH_DTTM DATETIME (Local) No
This column stores the date and time of death of the autopsy patient from a requisition.
62 REQ_ORDER_DATE DATETIME No
The date when the requisition was ordered.
63 PAT_ADDR_HX_TYPE_C_NAME VARCHAR No
Stores the type of address associated with this requisition.
May contain organization-specific values: No
Category Entries:
Permanent
Temporary
Confidential
Correspondence
Next of Kin
Subscriber Home
64 AUTH_PROV_ADDR_IDENT VARCHAR No
The unique ID of the provider address associated with the requisition that is used to route results from the requisition to the Authorizing Provider.
65 ORD_PROV_ADDR_IDENT VARCHAR No
The unique ID of the provider address associated with the requisition that is used to route results from the requisition to the Ordering Provider.
66 ACCT_SERIAL_NUM INTEGER No
The account serial number associated with the requistion.
67 HIDE_FRM_OTH_DEPT_YN VARCHAR No
Specifies if this requisition is viewable only in the department it was created in. Indicates whether this requisition is viewable only in the department it was created in. 'Y' indicates that the requisition is hidden in other departments. 'N' or null indicate that the requisition is visible in other departments.
The category values for this column were already listed for column: NON_HUMAN_YN