Understanding Point-in-Time Employee Reports

As with currently available employee reports, you can run point-in-time employee reports to review changes that have been made to the employee master record. The primary difference is that in the point-in-time report group, you can produce a view of an employee's record (or any group of employee records) as of a specified date. For example, you might need to produce a report to satisfy a governmental inquiry that includes the top 10 salaried employees for each business unit as of a particular date, including each employee's surname, job, position, and mailing address, and the name of the person to whom each employee reported.

The system provides several point-in-time reports. To create your own custom reports, use the Report Director Templates program (P91400) and select the Point-in-Time EE Reporting template. The Report Director Templates program offers an automated approach for creating user-defined reports using the Point-In-Time Employee Master table (F0601161). The Director assists you with report creation by guiding you step-by-step through the design process.

The Report Director Templates program uses templates that contain default criteria. When you select the Point-in-Time EE Reporting template in the Report Director Templates program, the program presents the default criteria through Director forms. You can modify the JD Edwards EnterpriseOne templates and create your own templates or programs.

The Point-in-Time EE Reporting template provides smart fields that enhance report-writing capabilities and reduce the amount of time required to create a custom report. Smart fields are predesigned components of logic and processing that you can select for a particular field; you do not need to write code to create the desired functions. Available smart fields include:

• Amount Variance.

  Used to include the specific amount between the salary levels of employees that you have selected for a point-in-time version in a new report

• Salary Percent Variance.

  Used to include the specific percentage difference between the salary levels for a selected employee group

• Salary Midpoint.

  Used to include the midpoint salary levels for a selected employee group

  You can use the Salary Midpoint smart field to show the midpoint of a pay grade for a specific effective date. You can also create separate report versions and enter them into processing options for point-in-time reports to calculate the midpoint between two salaries.

You can use these smart fields in conjunction with the processing options of the Report Director Templates program to specify the desired functions.