EEO-1 Survey Component 2 (RP_350_1403)

Release Date: 2019-08-23

The Equal Employment Opportunity Commission (EEOC) provided specifications for file uploads for required employers to report compensation data for their employees, categorized by job category code (EEO Code), Race/Ethnicity/Gender code, and pay band code. Report RP_50_1403 was added to the application to report the required information in file format to the EEOC.

Data Validation

As is the case with any reporting, data must be pulled from various areas of the system and it is extremely important that these data points are completed properly. Failure to validate data may cause employees to be left off the report/file.

• Gender: Employees with Gender codes 'F' and 'M' entered are reported using those federally recognized codes. Employees with other entered Gender codes (gender non-binary, refused, or other state-accepted codes) need the new field, EInfo.genderObserved, populated with the observed Gender code 'F' or 'M'.

  note

  Employees without one or both fields completed are left off the report.

• Ethnicity: Employees with the Ethnicity codes below are reported using those federally recognized codes.

  Code	Description
  A	Asian
  B	Black or African American
  H	Hispanic or Latino
  I	Native American or Alaska Native
  P	Native Hawaiian or Other Pacific Islander
  T	Two or More Races
  W	White

  Employees with other entered Ethnicity codes need the new field, EInfo.ethnicityObserved, populated with the observed Ethnicity code from the list above.

  note

  Employees without one or both fields completed are left off the report.

• EEO Class: Employees should be classified by applicable job category (codes 1-10) per EEO-1 Survey Component 1 requirements.

• Pay Bands: The Pay Band Categories of Component 2 are based on W2 Box 1 amounts pulled from the EYtd table for the year the chosen check date is part of.

Additional Setup Requirements

In addition to making sure all employees have the necessary data points completed, several company-level options must be completed.

• The EEOC-provided Company Number should be populated on the Company / Departments & Labor / EEOC tab of RPO, along with the EEO-1 Report Date if an EEO-1 Survey was submitted in the prior year by the employer.

• For multi-location employers, the cost center level associated with identifying the locations should be marked as the Primary Work Location? on the Company / Departments & Labor / Dept Setup page. Then, the address information and EEOC Unit Number must be completed for each cost center code in that level.

• The applicable NAICS Code must be set on the Company / Demographics page.

Considerations When Running the Report

When running the report from the Reporting section, several considerations must be made to ensure the report output contains the correct information.

• Choose Override Dates (one pay period) from the 4th Quarter of the year you are reporting for.

• In the Additional Options section, mark the check box for Question D2 if the answer to the following is 'Yes':

  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 AGENT FOR U.S. SAVINGS BONDS AND OR SAVINGS NOTES?

• Also in Additional Options, choose the Status Code for the type of report being submitted (1-9).

• Also in Additional Options, the NORC-provided 8-digit user ID must be provided for column 1 of the file.

• When running the report, the Output Format needs to be set to Excel.

  warning

  When the resulting file is saved, it must be saved in CSV format or it will not be accepted online when uploaded.

• Consolidated companies (using Multi Co Setup) may be run together from the parent company. Child companies are included that have the same check date (by process number) as the one chosen when running the report. Affiliated companies must be run separately by ID currently.

Questions?

Contact your Payroll Service Provider.