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

Cause

The EEO-1 Report pulls from job history tables; inaccurate or inconsistent data can affect results.

Resolution

  • Verify the job history record shows the correct dates and sequence.
  • Remove any duplicates.
  • If the dates are correct and no duplicates exist.
  • List the history in order and back up the data if needed.
  • Rehire the employee using the correct dates (don’t create duplicate history records).
  • Terminate the employee using the correct dates (don’t create duplicate history records).

Create a Secure Query or Crystal Report using fields from the hrpersnl table to identify missing EE0-1 data.

  • p_company
  • p_empno
  • p_fname
  • p_lname
  • p_eeoclass
  • p_termdate
  • p_active
  • p_jobcode
  • p_sex