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