PS Query Classification Tool

As the manager of HR Shared Services one of the major initiatives Anand took up was to streamline the auditing processes of each business activity. This was needed as the organisation was growing bigger leading to larger HR transaction volumes, higher employee churning leading to the need to have documented processes to enable business continuity and the need for data accuracy. The biggest factor playing in Anand's mind was Payroll accuracy - given that his company was using Peoplesoft Global Payroll which had multiple feeder systems like Peoplesoft Absence Management, Time and Labor and Benefits - it was a nightmare for his team to ensure data consistency across the various modules. Anand worked closely with Praveen from the IT team to build audits at every stage of the payroll process and overtime the sheer number of audit queries became too large for the team to handle manually. With no tools at his disposal, Anand was forced to maintain the list of audit queries in an excel sheet which again had to be updated everytime a new query was added or retired. Praveen came to realise this constaint while working with Anand's team and thought why he could not develop a simple tool that will help Anand map a PS Query to the appropriate business process and also provide another page which would list all the PS Queries corresponding to a business process and let the users execute the query directly. He immediately got working on the idea and came up with the PS Query Classification Framework which he christened - QBox.
Anand just loved the tool as it helped him manage his audit process much better, his team mates could just access the QBox page and view all the up-to-date queries for a business process, now there was no way anyone would miss running a query and maintaining the query list was as easy as clicking a button!

Query Classification Tool

View more presentations from jijucvengal.

Absence Leakage Decision Chart

Praveen was visibly frustrated, well not without reason, as the lead Absence Management consultant he was bombarded with multiple calls from the business team - most of them talking about the same issue of users having reported absences but the same not getting paid out in payroll. These issues were serious because it affected the pay of the employees and had to be investigated on priority and it took a good half day to investigate, document and communicate the fix to the users (even though he was an expert in the module!). Couple of months into this routine, Praveen realised that better user training and tools could help HR users to troubleshoot this issue at the first level itself and he decided to prepare a decision chart for the same.
Praveen had long realised that Peoplesoft absence management was a complex module for business users to comprehend and better tools and charts were required to simplify navigation through the module. He conceptualised a simple seven step process to help users identify where the booked absence went missing. The below presentation details the decision chart prepared by Praveen:

Peoplesoft Absence Leakage Decision Chart

View more presentations from jijucvengal.

As a matter of fact, not even a single call came to the IT team regarding missing absences after introducing this tool and Praveen has been smiling since then!!
Well, even today most customers and users are trying hard to wade through the issues and complexities presented by Peoplesoft Absence Management and does not have any tool or dashboard to see what is actually being paid out and whether any payroll over or underpayments are being made. If you feel you fall under this category of customers and would want better auditing and dashboards to track your Peoplesoft Time and Attendance and Payroll systems, it is time to get in touch with us!