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
Batch Error
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
Not Listed
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