Search

EEO1 Reports

EEO-1 Reporting

Component 1

Agencies are required to report to the government a count of the number of active employees that are employed at their agency by EEOC job category, race, and sex.

The “Employe Care EEO-1 Component 1” report returns those counts for the date range entered based on the employee's active status, which is calculated based on the employee's hire date, rehire dates 1-3 and termination dates 1-3.

You can run the Employee Active/Employment Status Discrepancies report, which will show employees that are marked Active and have a termination date and Employees that are marked inactive, but do not have a termination date. If any employees appear in this report, you need to update the employee's hire/rehire/termination dates so that the EE01 report returns an accurate count.

To run the “Employe Care EEO-1 Component 1” report, select Reports from menu pane and enter "eeo" in the Search box.

The EEO1 advanced report contains special properties that are described below.

Special Property Description
Job Category This is based on the EEOC Job Category assigned to the Job Title setup list item associated with the employee’s job title that is marked primary on the Employment Information tab on the Job Titles card.
Race Category This is defined by the EEOC category assigned to the Race setup list item associated with the employee on the Demographics tab on the EEO1 Information card.
Sex This count is based on the sex selected for the employee on on the Demographics tab on the EEO1 Information card.
Count The number of active employees that have that EEOC, race and sex based on the employee’s primary, active job title

For information on running reports or creating your own employee reports, refer to Reporting.

Component 2

Employers had to submit and certify Component 2 compensation data for the years 2017 and 2018 only. Component 2 data includes hours-worked data, annual compensation, job category, race and sex information for the full-time and part-time employees who were on your payroll during the workforce snapshot period (any pay period between October 1 and December 31).

Note: In order to run the EEO-1 report with Component 2 data that includes hours and compensation information, you must license BOTH Payroll and Employee Care

While the Component 2 report is no longer required, it is still available to run in the event it becomes required again.

The number of hours worked is calculated based total hours paid through Payroll for the entire year excluding weighted overtime hours (because those hours are already included in the non-overtime hours). If employees are paid with a dollar amount-only wage type (in which case there will not be any hours in Payroll), those hours are computed via the follow formula: Hours Per Week (40 if full-time, 20 otherwise) multiplied by the Number of Pay Periods they received a check in the year multiplied by the Payroll Frequency (52=Weekly, 26=Biweekly, 24=Bimonthly, 12=Monthly).

The specifications designate 12 compensation bands:

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

The compensation band that the employee falls under is based on the employee’s earnings as reported in W-2 Box 1 Wages for the entire year.

The employee’s job category, race and sex are determined based on the employee’s setup as is in the Component 1 EE0-1 report.

Check for Issues

Run the PR with Employee Care - Component 2 EEO-1 Check for Issues report to find employees that are missing information required for the report

  1. Select Reports from the menu pane and enter "eeo" in the Search box.

  2. Select PR with Employee Care - Component 2 EEO-1 Check for Issues .

  3. In the Settings area leave Check for Issues setting set to True and select the Workforce Snapshot Period.

    Important: Make sure you select a pay period in October, November or December (and use the same pay period when you run the actual/report file.

    Note: The remaining settings are only used when you are creating the electronic file.

  4. Select Run Report.
  5. Correct any issues as needed.

Running the EEO-1 Report or Downloading the File

You can run the PR with Employee Care - Component 2 EEO-1 Report to review your data. or select the PR with Employee Care - Component 2 EEO-1 File to create a CSV text file that could be uploaded should the government require this data again in the future.

To run the Component 2 EEO-1 report/file:

  1. Select Reports from the menu pane and enter "eeo" in the Search box.

  2. Select PR with Employee Care - Component 2 EEO-1 Report or PR with Employee Care - Component 2 EEO-1 File.

  3. Leave the Check for Issues setting set to False and select the Workforce Snapshot Period.

    Important: Make sure you select a pay period in October, November or December

  4. If you selected PR with Employee Care - Component 2 EEO-1 Report, go ahead and select Run Report.

    Otherwise if you selected PR with Employee Care - Component 2 EEO-1 File, complete the remaining settings as required:

    User ID Unique 8-digit identifier for entire company provided by NORC
    Status Code 1 = Single-Estab Employer Multi-Estab
    Unit Number Optional
    Unit Name Agency name
    Unit Address Agency address
    Unit Address 2 Extended agency address to include suite no., PO box, etc.
    City City name
    State State abbreviation
    Zip Code U.S. Postal Service zip code
    County Name County name
    FEIN 9-digit Federal EIN (Tax ID)
    NAICS CODE NAICS Code
    Question B2C Was an EEO-1 report filed for this agency last year? True (1) or False (2)
    Question D2 Is this agency: (1) not exempt as provider 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,000or more; or serve as a depository of government fund in any amount; or is a financial institution which is an issuing and paying agent for U.S. savings bonds and/or savings notes? True (1) or False (2)

    Note: The employee counts and labor hours for non-binary gender employees by job category, pay band and racial group were reported in the Comment box on the Certification Page. Prefaced with the phrase “Additional Employee Data:” For example, “Additional Employee Data: 1 non-binary gender employee working 2,040 hours in Job Category 4, Salary Pay Band 5, Race/ethnicity non-Hispanic White. 3 non-binary gender employees; combined work hours 5,775; in Job Category 5, Salary Pay Band 8; Race/ethnicity: Employee 1 – Non-Hispanic Black, Employee 2 – Hispanic, Employee 3 – Two or more races.”

  5. Do not change the Employee.Sex filter.

  6. Select Download to save it to your device.

    The format of the file name should be UploadFileyyyyCCCCCCCC, where 'yyyy' is the survey year and "CCCCCCC" is the 8-digit User ID provided by NORC.

Comments

0 comments

Please sign in to leave a comment.