RQG_DB_MAIN

Description: |
This table contains information about the Requisition Grouper (RQG) Source: ID Number, Name, Sex, Gender Identity, Sex Assigned at Birth, DOB or Age, SSN, Species, Ethnic Group, City, State, Zip Code, County, Country, House Number, District, Status, and Email. This table also contains the gamete donor ID, date of donation, age of donation, donation bank name, and the donor's relationship with the patient for gamete donor RQG records.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RQG_GROUPER_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RQG_GROUPER_ID | NUMERIC | No |
This is the primary key for RQG tables and refers to the ID number of the source Requisition Grouper.
2 | RQG_GROUPER_NAME | VARCHAR | No |
This is the name of the Requisition Grouper source.
3 | RQG_RECORD_STAT_C_NAME | VARCHAR | No |
Stores the record status (hidden, soft-deleted, etc...) of the Requisition Grouper source. This category list is stored in ECT 1000.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
4 | RQG_DOB_DT | DATETIME | No |
This is the Date of Birth of the Requisition Grouper source.
5 | RQG_SEX_C_NAME | VARCHAR | No |
This is the sex of the Requisition Grouper source. This category list is stored in EPT 130.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
6 | RQG_SSN | VARCHAR | No |
This is the SSN of the Requisition Grouper source.
7 | RQG_AGE_UNITS_C_NAME | VARCHAR | No |
Units for the age of the requisition grouper
May contain organization-specific values: No
Category Entries:
Years
Months
Weeks
Days
Hours
8 | RQG_CITY | VARCHAR | No |
The city of the requisition grouper's address.
9 | RQG_STATE_C_NAME | VARCHAR | No |
The state category number of the requisition grouper's address.
May contain organization-specific values: Yes
10 | RQG_ZIP | VARCHAR | No |
The ZIP code of the requisition grouper's address.
11 | RQG_COUNTY_C_NAME | VARCHAR | No |
The county category number of the requisition grouper's address.
May contain organization-specific values: Yes
12 | RQG_COUNTRY_C_NAME | VARCHAR | No |
The country category number of the requisition grouper's address.
May contain organization-specific values: Yes
13 | RQG_HOUSE_NUM | VARCHAR | No |
The house number of the requisition grouper's address.
14 | RQG_DISTRICT_C_NAME | VARCHAR | No |
The district category number of the requisition grouper's address.
May contain organization-specific values: Yes
15 | ETHNIC_GROUP_C_NAME | VARCHAR | No |
This item stores the ethnic group a patient belongs to.
May contain organization-specific values: Yes
16 | RQG_BIRTH_TM | DATETIME (Local) | No |
The date and time of birth of the Requisition Grouper source.
17 | GENDER_IDENTITY_C_NAME | VARCHAR | No |
The gender identity category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Not Listed
Choose not to disclose
Nonbinary
Genderqueer
18 | SEX_ASGN_AT_BIRTH_C_NAME | VARCHAR | No |
The sex assigned at birth category ID for the patient.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Not recorded on birth certificate
Choose not to disclose
Uncertain
19 | EMAIL_ADDRESS | VARCHAR | No |
The email address of the record.
20 | RQG_AGE_NUM | NUMERIC | No |
The age of the requisition grouper, including decimal values when applicable.