EEO-1 Component 2 reporting

If your company needs to file EEO-1 Component 2 reports for 2017 and 2018, you must provide the required information to the Equal Employment Opportunity Commission using the website created by the non-partisan and objective research organization NORC at the University of Chicago. Although you can enter the information manually into their online form, you can instead upload report files at NORC.org.

You can use this process to create the report files to upload. See the NORC website (https://eeoccomp2.norc.org) for more information about report requirements. To view a video about this process, see Sage Knowledgebase article 100736.

Before creating the report file

Determine whether your company is considered a single or multi-establishment employer. According to the NORC website, an "Establishment" is generally a single physical location where business is conducted or where services or industrial operations are performed.

Several of the columns in the report are based on employee information entered in the Employee Setup window. Verify this information so the report is accurate:

• Gender and Ethnic group on the General tab. The program uses this information to determine the race/ethnicity/gender code for each employee to use for the report.

• Std occ code on the Misc Info tab. Assign a 6-digit standard occupation code to each employee. See the SOC Job Code in the EEO-1 Job Classification Guide spreadsheet on the NORC website. The program uses this information to determine the EEO job category code for each employee to use for the report.

Creating the report file

1. Select Tasks > EEO Reporting (Component 2 Data).

2. Select the transaction file containing the employee and check data for the reporting year, and then click [OK].

3. In the EEO-1 Component 2 Report - Establishment Details window:

   1. Select the Period Start and Period End dates for the workforce snapshot period. It must be between October 1 and December 31 of the reporting year (2017 or 2018). Employees who worked during this time period are pulled for the report.

   2. For NORC User ID, enter the number assigned to your company by NORC. This should be on the letter you received from them informing you that your company needs to file these reports.

   3. For Status Code, select the code for your report. The code to use is based on whether your company is a single-establishment employer or a multi-establishment employer, as well as the number of employees in each establishment. See the status code selections (for column number 2) in the Upload File Specification and the instruction book on the NORC website.

   4. For NAICS Code, enter the NAICS code for the establishment. See the NAICS Codes and Descriptions spreadsheet on the NORC website. If you selected 6 for Status Code, use 999999.

   5. For Establishment #, enter the establishment code (also called Unit #) that was used for your company's EEO Component 1 report. (Not needed for status codes 6, 8, and 9.)

   6. Your company name and address are displayed in the window. If needed, correct this establishment's name and address.

   7. For County, enter the county where the enterprise is located.

   8. If relevant, select one or both check boxes.

   9. Click [Next].

4. The EEO-1 Component 2 Report - Employee Details window lists the employees who were paid for work during the workforce snapshot period that you selected. In this window:

   1. If needed, clear the Include check box in front of each employee who you do not want to include in the file. For example, do not include employees who work at another establishment of your company.

   2. Review the total hours for the year for each employee in the Total Hours column. If this shows an incorrect amount (such as 0), edit the amount.

      Tip: You can sort by this column, by ID, or by Name.

   3. Click the browse button and select the folder where you want to save the generated file. The folder path and name display for Save Report to.

      Note: The report file is automatically named so it is meets the NORC file name requirements.

   4. If a file already exists, choose either:

      • Delete the existing file and create a new one (Use when there was an error)—if the existing report has a mistake and you want to replace the whole report.

      • Append the new values to the existing file (Use only when reporting on employees not included in previous runs)—if you want to append the current information to the existing file. For example, use this choice if you have a multi-establishment company, have already created a headquarters report, and are creating an establishment report.

   5. Click [Create Report].

   Important! If an error message displays, click the [OK] button and review the log file for details. For example, the log file lists employees with missing or invalid standard occupation codes. Although the report file was created, you would want to make the corrections and repeat steps 1-4 to update the report.

5. Review the entries in the CSV file.

6. If your company is a multi-establishment employer, repeat steps 1 - 5 using the same workforce snapshot period (in step 3a) but select another multi-establishment status code (in step 3c) and/or Establishment # (in step 3e), and select to append the existing report (in step 4d).

7. When the file is complete, follow the directions on the NORC website to upload the file.