This page (revision-11) was last changed on 26-Nov-2021 10:22 by Karen Parrott

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
11 26-Nov-2021 10:22 10 KB Karen Parrott to previous
10 26-Nov-2021 10:22 8 KB Karen Parrott to previous | to last
9 26-Nov-2021 10:22 8 KB kparrott to previous | to last
8 26-Nov-2021 10:22 8 KB kparrott to previous | to last
7 26-Nov-2021 10:22 8 KB kparrott to previous | to last
6 26-Nov-2021 10:22 7 KB mmcfarland to previous | to last
5 26-Nov-2021 10:22 8 KB khiggs to previous | to last
4 26-Nov-2021 10:22 8 KB khiggs to previous | to last
3 26-Nov-2021 10:22 3 KB rthiruppathy to previous | to last
2 26-Nov-2021 10:22 3 KB JMyers to previous | to last
1 26-Nov-2021 10:22 3 KB JMyers to last

Page References

Incoming links Outgoing links
REEO 1
REEO1

Version management

Difference between version and

At line 13 added one line
__Changes As of 2019__
At line 15 added 20 lines
The Equal Employment Opportunity Commission now requires the EEO-1 Form to collect compensation data.
This change has been documented by the EEOC as 'Collection of 2017 and 2018 EEO-1 Component 2
Compensation Data'.
The REEO1 function has been updated to now create a data file in a CSV file format with the new required data.
In the ‘Component 2 EEO-1’ upload file layout (CSV File), job category, demographic group (defined by race,
ethnicity, and gender) and annual salary as reported by pay band are columns in the file along with number of
employees and hours worked. Each record in the upload file represents a unique combination of “job category
by demographic group by pay band” for each establishment.
New UDFs required for Users to setup:
These fields will be created the first time REEO1 is launched. Therefore, users should run the REEO1 first prior
to completing the additional required set up.
||User field Name||Prompt||Table||Field Value Type||Lexicon
|EEO1_USER_ID|EEO1 Comp 2 User ID|[P2K_CM_ENTITY_DETAILS]|Char|
|EEO1_Q_D_2|EEO1 Question D.2|[P2K_CM_LOCATIONS]|Char|X_YES_NO|
At line 105 changed 3 lines
|EEO1 Component|MandatoryWhen set to YES, an errors file will be generated. Users can select from the LOV.
|*Salary Pay Element|When set to YES, an errors file will be generated. Users can select from the LOV.
|*Hours Worked Pay Element|When set to YES, an errors file will be generated. Users can select from the LOV.
|EEO1 Component|Mandatory. Must contain 'Component 2 EEO-1'
|*Salary Pay Element|This is the pay element for capturing Annual Salary
|*Hours Worked Pay Element|This is the pay element for capturing Hours worked
At line 149 added 13 lines
!!Processing
EEO1 File Name
- If "EEO1 File Name" is not provided, program will use UploadFileyyyyCCCCCCCC_mex.csv as file name (where 'yyyy' is the survey year, 2017 or 2018, and "CCCCCCC" is the 8-digit User ID
provided by NORC.
Date Range From/To
- Defines the date range to report on. Employees who are Active within this date range will be included in the report.
Employers will select a pay period between October 1 and December 31 of the reporting year, known as the workforce snapshot period.
The workforce snapshot period for the 2017 EEO-1 report would be an employer-selected pay period between October 1, 2017 and December 31, 2017.The
workforce snapshot period for the 2018 EEO-1 report would be an employer-selected pay period between October 1, 2018 and December 31, 2018.
This page (revision-11) was last changed on 26-Nov-2021 10:22 by Karen ParrottTop