Understanding the Point-in-Time Employee Master
After you verify the integrity of your employee record data, and before you review your data selection, use the Build/Delete Point-In-Time Employee Master program (R060116D) to create a new Point-in-Time Employee Master table (F0601161) that the system uses to generate point-in-time reports. This table is a mirror image of the Employee Master Information table (F060116) with two additional fields: the Effective Date field and the Version field. These additions enable you to generate multiple employee records for multiple points in time.
When selected employee records are not available for the specified date, the system selects data for the next earlier date. If no earlier data is available, the system automatically generates an exception report that includes the employee records with missing data, the date, and values from the next earlier date. This might occur if:
Historical records have been archived and no longer exist in the HR History table (F08042).
Data was not tracked in history before a specified date.
The HR History table has been purged or initialized.
By resetting a processing option for the Build/Delete Point-in-Time Employee Master program, you can delete data from the R060116D table. Do this to remove point-in-time versions that are no longer useful and to reduce the size of the R060116D table.