Issue/Symptom/Question

How do I set up and generate the EEO-1 Component 2 in PENTA?

Applies To

PENTA for Windows

County Codes Setup: Payroll > Setup > Taxes > County Codes

OU EEO Setup: Finance & Accounting > Setup > Organization Units > Legal Entity Tab > EEO Information

Hiring Location Setup: Payroll > Setup > Legal Entity Information > Hiring Locations

Map Worker Classification codes to EEO Job categories: Payroll > Setup > Pay Groups, Payroll Classes and Workers Compensation > Worker Classifications

Employee EEO Setup: Payroll > Employees > Employee Payroll Information OR Human Resources > Employee Information > Employee HR Information

Update FLSA Hour Worked: Payroll > Setup > PTO, Hours Classification Codes and Overtime Rules > Hours Classification Code

Generate the File: Payroll > Periodic Reporting > EEO-1 Component 2 File Generation

Resolution/Fix/Answer

Prerequisites:

EEO data collected from Employees
Payroll run in the reporting year for employees
Have access to EEO-1 Component 2 File Generation window

Process:

Set Up County Information:
1. Enter the State Code in which the county lies
2. Enter the code by which you identify the county. For example, FIPS 6-4 codes.
3. Enter the Name of the county
4. Repeat steps 1.a through 1.d to add a record for each county in which you have EEO Establishments
5. Close the window
Set Up Legal Entity EEO Information:
1. Execute a query on the Organizational Unit Code of the entity for which you are setting up EEO information. PENTA retrieves the entities record.
2. Navigate to the Legal Entity tab
3. Click the EEO Information button. PENTA opens the EEO Information pop-up window
4. Enter the Company Number assigned by the EEOC to the company
5. Enter the Unit Number assigned by the EEOC to the company
6. Enter the Contractor Type. Possible values are P (Prime Contractor), S (Subcontractor) and B (Both Prime & Subcontractor)
7. Enter the NAICS Number associated with the establishment
8. Enter the DUNS Number associated with the establishment
9. Enter the County in which the establishment is located
10. Enter Y/N for question B2C: Was an EEO-1 report filed for this establishment last year?
11. Enter Y/N for 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?
12. (Opt) Enter Certifying Offical Information (Title, Name, Phone #, E-mail Address)
13. Repeat step 2.a to 2.l for each Legal Entity for which you need to set up EEO
  information
14. Close the pop-up window
Set Up Hiring Locations:
1. Enter/Query the LE OU ID of the entity for which you are setting up hiring locations.
2. Enter a unique Hiring Location ID to identify this physical address.
3. Enter a Hiring Location Name to associate with the Hiring Location ID.
4. Enter the Address, City, State/Prov, Postal Code and County of the establishment.
5. Enter the NAICS Number of the establishment.
6. Enter the DUNS Number of the establishment.
7. Enter Y/N for question B2C: Was an EEO-1 report filed for this establishment last year?
8. Enter Y/N for 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?
9. Repeat steps 3.a to 3.h for each hiring location you need.
10. Close the window.
Map Worker Classification Codes to EEO Job Categories
1. Enter a Worker Classification code, number or abbreviation to identify the worker classification
2. Enter a Description to further identify the Worker Classification
3. Enter the EEO Job Category number applicable to your Worker Classification. PENTA displays the associated Job Category Description in the adjacent field.
4. Repeat steps 4.a to 4.d for each of your worker classifications.
5. Close the window.
Set Up Employee EEO Information - You have two options for performing this sub-step. Entries you complete via the Employee Payroll Information window also populate the Employee HR Information window, and vice versa.
1. To use Employee Payroll Information:
  1. Execute a query on Employee ID. PENTA displays the employee’s record
  2. Click on the Reporting tab
  3. Enter F or M in the Gender field. PENTA displays Female (for F) or Male (for M) in the adjacent field
  4. Enter the Race code appropriate for the employee. PENTA displays the code’s description in the adjacent field
  5. If the employee is not associated with the Headquarters location, enter the employee’s Hiring Location - Note: PENTA counts employees with a null hiring location in the Headquarters file for EEO-1 reporting. PENTA counts employees with a non-null hiring location in the establishment file for that hiring location.
  6. Enter the employee’s Wrkr Classification Cd. PENTA displays the code’s description in the adjacent field - Note: worker classifications available for this field map to EEO Job Categories via the Worker Classifications window
  7. Enter F (for Full Time) or P (for Part Time) in the Full or Part Time field
  8. Enter A (for Actual) or P (for Proxy) in the Actual or Proxy Hours Worked field
  9. Repeat steps 5.a.i through 5.a.viii for each employee
  10. Close the window
2. To use Employee HR Information:
  1. Execute a query on Employee ID. PENTA displays the employee’s record
  2. Click on the General tab
  3. Enter the employee’s Gender
  4. Enter employee’s Race
  5. If the employee is not associated with the Headquarters location, enter the employee’s
    Hiring Location. NOTE: PENTA counts employees with a null hiring location in the Headquarters file for EEO-1 reporting. PENTA counts employees with a non-null hiring location in the establishment file for that hiring location.
  6. Enter the employee's work Classification - NOTE: worker classifications available for this field map to EEO Job Categories via the Worker Classification window
  7. Enter F (for Full Time) or P (for Part Time) in the Full or Part Time field
  8. Enter A (for Actual) or P (for Proxy) in the Actual or Proxy Hours Worked field
  9. Repeat steps 5.b.i through 5.b.viii for each employee
  10. Close the window
Update FLSA Hour Worked:
1. Query all the Hours Classification codes
2. If the Hours Class should be included in FLSA then place a check mark in the column "FLSA Hour Worked"
3. If the Hours Class should NOT be included in FLSA then leave the “FLSA Hour Worked” blank/unchecked
4. Repeat steps 6.a through 6.c for all Hours Class Numbers
5. Close the window
Generate EEO-1 Component 2 .csv File
1. Open the EEO-1 Component 2 File Generation window
2. Enter the User ID provided to you by NORC
3. Enter the LE OU ID for which you want to create the report
4. Enter a snapshot date range between October 1st and December 31st for the reporting year
5. Enter a File Name
  1. Per the EEOC the submitted file should be named 'UploadFileyyyyCCCCCCCC' where 'yyyy' is the survey year and 'CCCCCCCC' is the 8-digit User Id provided by NORC
  2. PENTA will automatically add the .csv extension if the extension is not specific in the file name
6. Click Create File
7. Select save location from the file explorer
8. Window automatically closes
9. Repeat steps 7.a through 7.h for any other snapshot periods and all other LE OU's that require reporting

EEO-1 Component 2 Setup and File Generation

Issue/Symptom/Question

Applies To

Resolution/Fix/Answer