HR and Payroll Case Studies

Large Housing Association (PSe).

Rebuilding a Cognos catalog in the PSe Catalog Wizard

A task undertaken for a client who had been maintaining the catalog through Impromptu. There are arguments for and against the use of the PSe Catalog Wizard, but it does provide a discipline, maintains updates and security for PSe. To speed up the process and increase the accuracy we have a developed an application to read and make more sense of the catalog content overview and compare the differences between two catalogs. This helps in diagnosing problems as well as helping to replicate the build. Any customer bespoke tables or views are identified and their entries made in the PSe Data Dictionary so that they would be available to the Wizard. Finally, all of the reports are rationalised, upgraded to the new catalog and user acceptance testing performed.

An alternative reporting structure to the sole use of Organisation Units

 In this case the client had many locations but with the same departments within them and wanted to report by location or department. To compound the issue they had acquired other businesses over the years and merged them into one payroll system. The application we developed allowed multiple structures of the business and regions using a ‘drag and drop’ tree view which initially organises by partial Organisation Unit and then overrides individual Employees. The new structure reflects changes in PSe such as Organisation Unit changes, New Starters and ‘Lefters’.

One of the Largest County Councils in England (PSe).

Due to the implementation of PSe, a new HR and payroll system, all statutory forms (P11, P45, P60, etc), Payslips and Management Reports required rewriting. Report development requires an analytical mind as inevitably you end up performing “final quality inspection” and validation over and prior data take on.

...cont/
...cont/

This customer had some requests that proved ‘too resource hungry’ for Impromptu and SQL, and integration to Gandlake’s Laserserve. We provided the solution to these problems with some small utility programs written in Borland Delphi in combination with SQL Stored procedures.

With the payslips via Impromptu, on a pay group of 9000 + payslips, was taking in excess of nine hours to run. Our solution reduced this to less than 10 minutes.

High in volumes of audit data prohibited processing via the application and was not to be in a format suitable for reporting on. By using Borland Delphi, Stored procedures and two new tables we normalised the data and were able to process the data very quickly. If auditing is required from the data take on period then high volumes would be expected, this is also a high risk period where an audit trail could prove usefu.

Some work on SQL views to enable easier Impromptu reporting for BVPI (Best Value Performance Indicator) which are used for national statistics.

Undoubtedly our multi skills and understanding of the customer requirements helped in providing acceptable solutions.

A Motoring Organisation (PSe).

One of the large motoring organisations in the UK and following a merge with one of our existing customers. As a part of the merger we assisted in the cleansing of some of their HR and Payroll database tables prior to migrating to a single system. The source and target employee address table were of different formats so the solution was part programming and part keying. We had previously provided applications to assist this company in migrating data following a merger.

Human Interface Limited