Understanding Data Preparation for Point-in-Time Reports

To prepare data for reports, you must verify the integrity of the data in the HR History table (F08042), build a new Point-In-Time Employee Master table (F0601161), and then review the data selection. After these tasks have been completed and any errors have been fixed in employee records, you can run any of the point-in-time reports.

If errors exist in the HR History table, you can run the HR History Data Integrity Check (R08042D) to produce an error report. You must fix errors listed in this report to include the records in a subsequent report. To correct data or add missing data to employee records, you use the Employee History Maintenance program (P050420).

The Build/Delete Point-In-Time Employee Master program (R060116D) creates a new Point-in-Time Employee Master table, based on the existing Employee Master Information table (F060116), that includes two new data fields: the Effective Date field and the Version field. The additional fields allow the table to contain multiple records for employees, covering different points in time. A combination of data from the Employee Master Information table and the HR History table is used to build the point-in-time records.

When employee records for a specific date are not available in the HR History table, the program uses the next earlier date available. If an earlier date is not available, the program provides an exception report that lists the next date available for each record.