Standard AQ - Federal EEO Component 2 Reporting AQ

Report Description

This report gives Federal reporting of EEO-1 Component 2 information (which includes pay data).

This report was created based on the specifications found on the EEOC.gov website.  The format of the report is found on the EEOC website: Format

NOTE: Please note that pay data information was required in 2017 & 2018, but has not been required on Federal EEO-1 reporting since. Please confirm EEOC requirements for EEO-1 reporting to determine if this report should be utilized. 

Setup Required

• This AQ requires mapping: https://support.avionte.com/hc/en-us/articles/218393358
• This AQ requires a Supplier Property called OSHA NAICS Code.  If this property is missing or has no value, an error will display. 

Special Logic

Report throws following error message as result if EEO Mapping or Job Category Mapping has not been completed: 'Mapping Group "EEO Report Mapping" or Mapping Type "Job Category" is missing'

 If Job Position mapping is missing, then following error message is thrown: 'Missing Mapping in Admin Tools >> Import Export Mapping Section'

Parameters

Parameter Name	Options	Description
Supplier	All Available Suppliers
Branch (Employee)	All Available Branches
Date Type	Accounting Period Date, Week Worked Date, Check Date
Start Date	MM/DD/YYYY
End Date	MM/DD/YYYY
Status Code	Establishment Designation	1 = Single Establishment Employer 2 = Consolidated Report 3 = Headquarters Report 4 = Individual Establishment Report (50+ Employees – Not First Time Reporting) 5 = Special Reporting Procedure 6 = Establishment List Report (Fewer Than 50 Employees) 8 = Individual Establishment Report (Fewer Than 50 Employees) 9 = Individual Establishment Report (50+ Employees – First Time Reporting)
Unit Number		Should Be Reported Except for New Status Code 6, 8 And All Status Code 9 Records
UserID (8 digit identifier)		Unique 8-Digit Identifier for Entire Company Provided by NORC To Employer
QuestionB2C	1 = Yes; 2 = No	Was An EEO-1 Report Filed for This Establishment Last year?
QuestionD2	1 = Yes; 2 = No	Is this Establishment: (1) Not Exempt as Provided for by 41 CFR 60-1.5 (2) A Prime Contractor or First-Tier Subcontractor; And (3) Have A Contract, Subcontract, Or Purchase Order Amounting to $50,000 or More; Or Serve as A Depository of Government Funds In any Amount; Or Is A Financial Institution Which Is an Issuing and Paying Agents for U.S. Savings bonds And or Savings Notes?
Show Employee Info	Yes / No	If Show Employee Info = Yes. Report Will Show Employee’s EEO Details, Along with Listed Parameters & Report Fields. If Show Employee Info = No. Report Will Only Show Listed Parameters & Report Fields.
Transaction Types	All Transaction Types Entered	Ex) Regular, OT, DT, Salary, Bonus, Equipment, etc.
Exclude DH Orders?	Yes / No	If Yes, Excludes Candidates Associated with Direct Hire Orders
Ignore Missing Info Errors?	Yes / No	If No, Report Will Not Generate and List Errors to be Corrected for Missing Data. If Yes, Report Will Generate and Ignore Missing Data as Blank Fields.

Report Fields

Field Name	Description
Following fields are shown in report for Show Employee Info = Yes
Supplier Name Description	Supplier Name Listed from Admin Tools > Employer
Payee ID	Employee’s ID in System
Employee Name	Employee’s Full Name
Job Title	Job Title on which Employee has Worked on for Selected Date Range
EEO Category	EEO Job Categories Are as Follows: Executive/Senior Level Officials and Managers First/Mid-Level Officials and Managers Professionals Technicians Sales Workers Administrative Support Workers Craft Workers Operatives Laborers & Helpers Service Workers
Payee Gross	Employee’s Gross Pay (total gross wages for the year, not the dates passed in the parameters entered)
Pay Band Minimum	Employee’s Minimum Pay Band Amount
Pay Band Max	Employee’s Maximum Pay Band Amount
EEO Category ID	EEO Job Category IDs Are as Follows: 1: Executive/Senior Level Officials and Managers 2: First/Mid-Level Officials and Managers 3: Professionals 4: Technicians 5: Sales Workers 6: Administrative Support Workers 7: Craft Workers 8: Operatives 9: Laborers & Helpers 10: Service Workers
Race Gender Code	Race/Ethnicity/Gender Codes are as Follows: A: Hispanic or Latino Males B: Hispanic or Latino Females C: White Males D: Black or African American Males E: Native Hawaiian or Other Pacific Islander Females F: Asian Males G: Native American or Alaska Native Males H: Two or More Races Males I: White Females J: Black or African American Females K: Native Hawaiian or Alaska Native Females N: Two or More Races Females Z: Not Applicable (Type 6 Report Only)
Pay Band Code	Pay Band Category Codes are as Follows: 1: $19,239 and under 2: $19,240 - $24,439 3: $24,440 - $30,679 4: $30,680 - $38,999 5: $39,000 - $49,919 6: $49,920 - $62,919 7: $62,920 - $80,079 8: $80,080 - $101,919 9: $101,920 - $128,959 10: $128,960 - $163,799 11: $163,800 - $207,999 12: $208,000 and over
Payee Hours	Employee Hours Worked For Year that is indicated in the date parameters
Race	Hispanic or Latino, Black or African American, Asian, White, Two or More Races, Native Hawaiian or Other Pacific Islander, American Indian or Alaska Native or I Do Not Wish to Answer
Gender	M = Males; F = Female; X = Non Binary

Following fields are shown in report for Show Employee Info = No
User ID	Unique 8-Digit Identifier for Entire Company Provided by NORC to Employer
Status Code	1 = Single Establishment Employer 2 = Consolidated Report 3 = Headquarters Report 4 = Individual Establishment Report (50+ Employees – Not First Time Reporting) 5 = Special Reporting Procedure 6 = Establishment List Report (Fewer Than 50 Employees) 8 = Individual Establishment Report (Fewer Than 50 Employees) 9 = Individual Establishment Report (50+ Employees – First Time Reporting)
Unit Number	Should Be Reported Except for New Status Code 6, 8 And All Status Code 9 Records
Unit Name	Supplier Short Name
Unit Address	Supplier Address
City	Supplier City Name
State	Supplier State Abbreviation
Zip Code	Supplier U.S. Postal Service Zip Code
County	Please note: Since there is no County Name in Supplier, this data will need to be added to the results when exported to Excel and prior to uploading to the EEOC.
FEIN	Your Federal EIN (Tax ID) 9 Digits
NAICS Code	North American Industry Classification Listed from Admin Tools > Employer > Property > OSHA NAICS Code 6 Digits Type 6 Report Use “999999”
Question B2C	Was An EEO-1 Report Filed for This Establishment Last year? 1 = Yes; 2 = No
Question D2	Is this Establishment: (1) Not Exempt as Provided for by 41 CFR 60-1.5 (2) A Prime Contractor or First-Tier Subcontractor; And (3) Have A Contract, Subcontract, Or Purchase Order Amounting to $50,000 or More; Or Serve as A Depository of Government Funds In any Amount; Or Is A Financial Institution Which Is an Issuing and Paying Agents for U.S. Savings bonds And or Savings Notes? 1 = Yes; 2 = No
Job Category	Job Categories Are as Follows: 1: Executive/Senior Level Officials and Managers 2: First/Mid-Level Officials and Managers 3: Professionals 4: Technicians 5: Sales Workers 6: Administrative Support Workers 7: Craft Workers 8: Operatives 9: Laborers & Helpers 10: Service Workers 99: Not Applicable (Type 6 Report Only)
Race Ethnicity Gender	Race/Ethnicity/Gender Codes are as Follows: A: Hispanic or Latino Males B: Hispanic or Latino Females C: White Males D: Black or African American Males E: Native Hawaiian or Other Pacific Islander Females F: Asian Males G: Native American or Alaska Native Males H: Two or More Races Males I: White Females J: Black or African American Females K: Native Hawaiian or Alaska Native Females N: Two or More Races Females Z: Not Applicable (Type 6 Report Only)
Annual Salary	Pay Band Category Codes are as Follows: 1: $19,239 and under 2: $19,240 - $24,439 3: $24,440 - $30,679 4: $30,680 - $38,999 5: $39,000 - $49,919 6: $49,920 - $62,919 7: $62,920 - $80,079 8: $80,080 - $101,919 9: $101,920 - $128,959 10: $128,960 - $163,799 11: $163,800 - $207,999 12: $208,000 and over 99: Total Employees (Type 6 Report Only)
Total Employees	Total Employees Per Category, No Negatives Note: Filers Should not Report Rows where Number of Employees = 0
Total Hours	Total Hours per Category, No Negatives Exception: Type 6 Report Which Will Report “-3”

3rd party link Disclaimer: These links are being provided as a convenience and for informational purposes only; they do not constitute an endorsement or an approval by [The author] of any of the products, services or opinions of the corporation or organization or individual. [The author] bears no responsibility for the accuracy, legality or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.