Understanding the HR History Data Integrity Check

You run the HR History Data Integrity Check program (R08042D) to review all employee records in the HR History table (F08042) to ensure that each record includes an associated effective date. The Point-in-Time Employee Master table (F0601161) that you build in the next task includes only records that include an effective date.

When selected employee records do not contain all the data needed for point-in-time reporting, the HR History Data Integrity Check automatically generates a report that includes the employee records with missing data.

You use the Employee History Maintenance program (P050420) to enter the missing data listed on the error report. Then you rerun the HR History Data Integrity Check program to ensure that no more errors occurred. When you build a new Point-in-Time Employee Master table (F0601161), the system does not include any records with incomplete data. Only employees who have an original hire date that is equal to or earlier than the date that you select are included in the new table.

While optional, verifying the integrity of the data and entering corrections as needed ensures that all applicable data is included in point-in-time reporting.