SmartFusion Modules > Payroll > Reports > EEOC-4 Labor Statistics Report 

Recent Change:  
6.251 - Fixed below issues -
* Report failed to pull employee(s) who were rehired after the fiscal year end date but had been active during the fiscal year period the report was run for and was inactivated after the fiscal year end date.
* Report failed to pull inactive employee(s) who were inactivated in payroll after the fiscal year end date, but were active during the fiscal year when include inactives is checked.


6.215 - Fixed the report to pull the function from EEOC code as done when creating the export file and also created a script to create the EEOC codes in the format 'Function-EEO-1 Job Category' if they currently do not exist in the database.

6.214 - Fixed the date filter being used  to pull any employees with a hire date less than or equal to the  Fiscal year end date for Select employees to include NOT being 'Full Time Except New Hire'.

6.209 - the Occupational Employment Report selection was removed from the report type (there is a new menu selection for that functionality)   

6.198 - Added date range filter "Select fiscal year range to report" for report data pull.

6.195 - Added a column to the end of each page of the export to report a count of rows. Each count will have the tab number and the row number formatted as "1_2", "2_2", and "3_3". The first tab of the export will have the count as 1_2, 1_3, and so on. The second tab of the export will have the count as 2_2, 2_3, and so on. The third tab of the export will have the count as 3_2, 3_4, and so on.

- Changed the export to produce all functions and categories even if they were unused on the Full time, other than full time, and new hire tabs.

6.146 - Updated the reports to current specifications to include Pacific Islander, American Indian and Two Or More Races; EEO4 Function was also added as a report sequence  

6.144 Supplemental 
- In Parameters > Job Titles > a new drop-down for EEO-4 Function was added
- In Reports > EEOC-4 Labor Statistics Report > an update to the export was created from the 2021 EEO-4 spec

6.144 - fixed a bug that caused the report to include invalid data if the "Include inactives" option was selected 

6.131 - updated the report to no longer include employees marked as "Deceased" as their employee type on the Salary tab of Enter/Edit Employee Master in the payroll module as active employees  

6.125 - updated the report and file to handle the "Two or more Races" race

6.86 - Added new selection for employees to include and updated report accordingly

Introduction

The Equal Employment Information Report (EEO-4) is a report that is to be filed by state and local government entities. The report sets forth the gender and race/ethnic composition of the work force by job category and annual salary. This report is a bi-annual report that gets reported for the 7/1-6/30 Fiscal Year period.

Selection Criteria

Select report sequence - Category, EEOC Code or Function/EEOC Code
Select output option - Detail, Summary or Totals Only
Select report type - State and Local Government EEOC-4
Select fiscal year range to report
Select employees to include

  • Full Time
  • Full Time New Hire Only
  • Full Time Except New Hire
  • Not Full Time
  • All

Include inactives - Includes employees that are no longer active in Payroll -- inactivated during the fiscal year range of the report-- (PR Status); Does not relate to "Type of employee"
Create EEO-4 file -
https://www.eeocdata.org/eeo4

https://www.eeocdata.org/pdfs/2023_EEO-4_Instruction_Booklet.pdf

Additional Filter Criteria

Locations
Categories
EEOC
Departments
Salary Class