In the Establishments tab of Illinois pay data templates, you can generate the Illinois Employee Data report to see if employees from the payroll filing period are missing any of the following data:
- Pay
- Hours
- Gender
- Ethnicity
- Job category
This report is for review purposes and not for submitting to the Illinois Department of Labor (IDOL). This report can also provide insight into how Dayforce aggregates the numbers in the pay data report.
Role feature access: HR Admin > HR Admin > Compliance Reporting > EEO > Illinois Pay Data Reporting > Illinois Employee Data Reporting
Important: Only certain roles should be assigned access to this report. The file generated gives access to employee-level data. It’s different from the Illinois pay data report, which doesn't identify specific employees.
This report is generated in the CSV format and includes all of the employees who are counted in the IL Employee Count column of the Establishments tab of a template. These are Illinois employees who are on the employer's payroll for the filing year defined for the template. If an employee is missing gender, ethnicity, or job category data, they aren't counted in the IL Employee Count column, but they’re included in this report.
You need to resolve these issues in the area of Dayforce where corresponding data is managed. See the following sections:
To generate the Illinois Employee Data Report, click Export > Illinois Employee Data Report.
This file contains the following columns:
- Missing Info?
- Employee Name
- Employee Number
- Establishment
- JobClassification (Job Category)
- SSN
- Gender
- Race
- Ethnicity
- W-2 Box 5 (Annual Salary)
- Hours worked
- Hire Date
- Job Title
- County
- PaidHS
- BaseHourlyRate
- CBAYN