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: Mapping Reports and Advanced Queries
- 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 Craft Workers Operatives |
| 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: 7: Craft Workers 8: Operatives
|
| Race Gender Code |
Race/Ethnicity/Gender Codes are as Follows: A: Hispanic or Latino Males |
| 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; N = Non Binary; X = I do not wish to Answer |
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? |
| Job Category |
Job Categories Are as Follows: 1: Executive/Senior Level Officials and Managers 7: Craft Workers 8: Operatives |
| Race Ethnicity Gender |
Race/Ethnicity/Gender Codes are as Follows: A: Hispanic or Latino Males |
| Annual Salary |
Pay Band Category Codes are as Follows: 1: $19,239 and under |
| 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.
Comments
0 commentsPlease sign in to leave a comment.