My Oracle Support Banner

E1:08: 2019 EEO-1 Component 2 - New Reporting Functionality is Available (Doc ID 2576794.1)

Last updated on OCTOBER 22, 2019

Applies to:

JD Edwards EnterpriseOne Human Resources Management - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.

Details

The JD Edwards EnterpriseOne Human Resource product has been enhanced to comply with the 2019 EEO-1 changes. Employers are responsible for filing the new EEO-1 Component 2 Report by September 30, 2019.

The changes includes revised data collection for the EEO-1 report. This revised data collection has two components:

For more details visit, https://www.eeoc.gov/employers/eeo1survey/index.cfm

What's New?

UDC 05U|PT

UDC 05U|PB

R058515A

The employees' W-2 earnings reported in Box 1 of the W-2 form are used as a reference to categorize the employees into the 12 pay bands or salary compensation bands defined for each of the 10 EEO-1 job categories. Enter the Year-End ID from P07810 in Processing Option #10.

R058515A Processing Options

Processing Options #10 and #11 are new for Component 2 Reporting:

#10 pertains to the Year-End ID for the year being reported. Refer to the Year-End Workbench, P07810 to obtain the correct value for this processing option.

#11 pertains to how the report retrieves the hours worked. Actual hours worked will look at the timecard historical file, F0618. If you choose this option, you can also tell the system what pay types to omit by utilizing UDC 05U

Dates in processing options (#1 and #2) for R058515A act as a snapshot of one pay period that the EEOC wants for either Oct., Nov. or Dec. They help determine the employee's eligibility. The hours on the report are for the entire year.

Year-End ID (P07810)
The Year-End ID that is used for W2 and 1099 reporting for payroll is used to report the employee wages.

 

If you do not process payroll using the JD Edwards EnterpriseOne US Payroll product or do not process W2s via this product, you will need to populate the F05850 with the required information in order to create the EEO-1 Component 2 report.

 

EEO-1 Component 2 Reporting Examples

Employee Counts

U.S. Government Employee Count form examples

 

JD Edwards EnterpriseOne Employee Count Report example

 

Hours Worked

U.S. Government Hours Worked Report example

 

JD Edwards EnterpriseOne Hours Worked Report example

 

 

P05850
This application is populated after the R058515A UBE is run. The report populates the table F05850 and also creates the PDF report.

Magnetic Media File

R89058515A creates the magnetic media file as a simple CSV file.

Mag Media File Example

 Refer to the JD Edwards EnterpriseOne Applications Human Resources Implementation Guide (10.1.2 - Components of the EEO-1 Report (Release 9.2 Update)) for more information regarding the new functionality.

 

Steps to process the EEO-1 Component 2 Reports

Before processing the EEO-1 Component 2 report, ensure that you have payroll history and year-end IDs set up for the years being reported.

  1. Access batch versions (BV) for R058515A. Ensure that all of the processing options are setup including #10 (Year-End ID) and #11 (proxy or actual hours).
  2. Review information in P05850 and verify the EEO-1 Component 2 report
  3. Run R8905815A to create the mag media file

 

Actions

Apply the ESU for the release listed below to receive the new functionality.

Release Bug
EEO1 New Reporting Functionality
9.1 29494436
9.2 29487503

Column names are required and should only be reported in the first record of the upload file and not repeated for each establishment. The functionality for the column names is not available via the first ESU (listed above). A new ESU will be required.

EEO-1 Column Names (upload file)
Release Bug
9.1 30154748
9.2 30154712
Notification: Column name bugs will not be available by the September 30th reporting date, please see attached spreadsheet for the headers. As a workaround for the upcoming reporting period, you can copy/paste the column headers into your final CSV file.

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
Actions
Contacts

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.