This page (revision-21) was last changed on 18-Jul-2022 18:17 by Kevin Higgs

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
21 18-Jul-2022 18:17 8 KB Kevin Higgs to previous

Page References

Incoming links Outgoing links
REEO 4
REEO4

Version management

Difference between version and

At line 1 changed one line
!!!PRODUCE EEO-4 REPORT
!!!PRODUCE EEO-4 REPORT (State and Local Government Information Report)
At line 5 changed one line
![IEID] – Maintain Identity Information
!Version 1
The EEO-4 data upload file specifications for 2021 reporting uses an Excel XLSX format. Each Excel data upload file represents one state or local government filing an EEO-4 Report, including all of their functions. Filers submitting on behalf of multiple state or local governments will need to provide multiple Excel data upload files. To begin, filers must create an account and provide some preliminary information on the state or local government in the EEO-4 Online filing System in order to upload a data file. Uploaded data files must meet all submission requirements to be accepted. Filers must certify their submission to complete the reporting process.
!Instructions for creating an EEO-4 data upload file:
*Filers must provide data using the 2021 Excel EEO-4 data upload file layout specifications.\
*Only valid numeric values between 0 and 9999 are allowed.\
*No decimals are allowed. \
*Letters (a, b, c, etc.) and special characters (!, @, #, etc.) are not allowed.\
*Blank, missing, and 0 values are all treated as cells without data.\
*The EEO-4 instruction booklet provides additional information on who must file, when to file, data to be reported in EEO-4 Report, definitions, descriptions, and legal requirements. The instruction booklet is available online at: https://www.eeocdata.org\
!Instructions for submitting the EEO-4 data upload file:
*Filers must register for an account in the EEO-4 Online Filing System.
*Additional information is collected through the EEO-4 Online Filing System prior to uploading the data upload file.
*Data upload files must be submitted in XLSX formats through the EEO-4 Online Filing System.
*The data upload is processed and used to fill out the data entry form in the EEO-4 Online Filing System. Once the data file is uploaded, the data may be further edited in data entry gird before being submitted.
*Some filers may have to provide additional information when the data is reviewed.
*In order to finalize the data file upload, the EEO-4 Report must be certified within the EEO-4 Online Filing System.
!EEO-4 Online Filing System: https://www.eeocdata.org/EEO4/
!EEO-4 Instruction Booklet: https://www.eeocdata.org/EEO4/howto/instructionbooklet
!The following four Excel worksheets (tabs) comprise this data upload file:
*__Instructions Worksheet (Tab 1)__: No data fields collected.
*__Full-Time Worksheet (Tab 2)__: Full-time employee data should cover the payroll period which includes June 30th of the reporting year (i.e., 2021). Data can be entered only into columns D-Q and rows 2-961.
*__Other Than Full-Time Worksheet (Tab 3)__: Part-time employee data should cover the payroll period which includes June 30th of the reporting year (i.e., 2021). Data can be entered only into columns C-P and rows 2-121.
*__New Hires During Fiscal Year Worksheet (Tab 4)__: Filers must provide a breakout of new permanent full-time hires during the fiscal year (i.e., July 1st, 2020 – June 30th, 2021). Data for such new hires covers the entire fiscal year which ends on June 30th of the reporting year (i.e., 2021). The relevant time period for the 2021 reporting year would be July 1st, 2020 – June 30th, 2021. Data can be entered only into columns C-P and rows 2-121.
!Maintain Identity Information - [IEID]
At line 18 changed one line
|Combine Totals|Optional, Yes or No, LOV available\\If <Yes> then the report with totals of all functions combined will be created. \\ \\If <No> then the report with separate totals for each function will be created.
|Print EEO-4 Tabs Only|Optional, Yes or No, If <Yes> then the report with only include data specific to the EEO-4 Report.
This page (revision-21) was last changed on 18-Jul-2022 18:17 by Kevin HiggsTop