Skip to content
logo Knowledgebase

Employees are missing on EEO-1 Headcount Detail

Created on  | Last modified on 

Summary

EEO-1 Headcount Detail missing employees Terminated employees missing on EEO-1 Headcount Detail EE0-1 Report has employee with ethnicity value missing

Description

Cause

The EEO-1 Report is pulling from the job history tables in the data. Inaccurate or inconsistent information can throw the report off.

Resolution

  1. Verify that there is a job history record that reflects the correct dates and order of the employees job history changes.
  2. Delete and correct duplicates.
  3. If the dates are correct, and there are no duplicates:
  4. Copy the information down in chronological order for the employee. Make a backup of the data if necessary.
  5. Rehire the employee through the "Rehire Employee" process with the correct dates (do not create a job history record if one already exists for those dates).
  6. Terminate the employee through the "Terminate Employee" process with the correct dates (do not create a job history record if one already exists for those dates).
  7. Creating a simple secure query in Sage HRMS or a crystal Report to pull the EE0-1 values on the following fields : p_company, p_empno, p_fname, p_lname, p_eeoclass, p_termdate, p_active, p_jobcode, p_sex, from hrpersnl table will help identify missing values for any of these fileds not showing on the EE0-1 Report.