Contact Us
01908 265111

Bulk Data Manipulation Tool Delivering Data Import Opportunities

Bulk Data Manipulation Tool Delivering Data Import Opportunities

Contact Us: 01908 265111


Some of the information recorded within People Inc. is generated automatically by the system using logic defined within the screens. For example, the system takes an employee’s surname and adds it to their first name to provide a format of name that can be used in reports and letters (this calculated version of their name is saved separately in the employee record).

Most screens in the system contain a variety of different calculations. The calculations are done using triggers defined within the screens. The triggers normally generate the calculated data when the user saves a record. If the calculated information is visible on the screen, it is normally displayed in a box that has a yellow background (note that not all calculated information is displayed on the screen).

The Recalculate Data Screen wizard is designed to enable the user to recalculate information within the system globally, screen by screen.

Recalculate Data Screen Wizard

People Inc HR recalculate data screen tool with left handing column of system screens and right hand panel of available record filters

The Daily Run

Time-dependent information needs to be recalculated regularly. For example, an employee’s length of service increases by one-day every day. The People Inc. Daily Run recalculates this kind of data automatically every night. The Daily Run also reconciles absence information and updates any open-ended absence records. If future job or salary information is added to the system, the employees’ current job and salary information is also kept up-to-date in this way.

The People Inc. Daily Run does not however recalculate information held within the system that is normally managed using calculations defined within the system screens.

Recalculating Data

The Recalculate Data Screen wizard can be used to recalculate the records managed by a specific data screen. When this is done, the wizard takes each record one-by-on and runs all of the triggers defined within the screen (and in doing so, it refreshes all of the calculated information). The wizard also enables the user to select a screen filter. This will limit the records that are to be re-calculated in some way. For example, the user may wish to select just current employees (excluding any leavers).

Being able to recalculate data in this way is likely to be of use in a number of situations:

  • If for some reason the overnight re-calculation of information has not completed, the wizard could be used temporarily to update the data screen-by-screen. This would be necessary if the user needed to generate reports and did not have the time to resolve the issue with the Daily Run.
  • If data has been imported into the system, it may be necessary to recalculate the existing information in the system to ensure that the new details are included in the totals generated by the system. For example, the user may have imported absence records, or training records. Both of these categories of information generate some totals that can be used in reports.
  • If a new calculation has been added to the system (by adding or changing a trigger) and the user would like to update all of the records using this trigger. For example, the user may need a new reminder for each employee (based on some new rule or new legislation). It is possible to get the system to generate this reminder automatically, but this is only done when a record is saved.

It is possible to define calculations that are only run when a new record is added (or when a record is deleted). These calculations are ignored by the Recalculate Data Screen wizard.

Using Triggers

Calculated information within People Inc. is updated using triggers. Most People Inc. screens have a significant number of triggers defined within them. The triggers defined within a screen can be reviewed using the Screen Designer. If users need to add further calculations, they can add custom triggers to a screen (once again, using the Screen Designer).

Getting a Copy of the Wizard

The new wizard is available as a download, free of charge to all People Inc. users. Note that to do this, a log-in for the Client Resources area of the website is required.



Receive regular product updates by subscribing to our newsletter.

News Index

Have You Found Your HRM Solution?

Call P&A Software on 01908 265111 for some helpful advice or visit our Solutions page.

Find Your HR Solution