PeopleSoft Payroll Reporting Training
Version 1 UK Offices – London and West Midlands | 17th October 2019 – 13th March 2020
Realising the full potential of your Payroll
At Version 1, we have been providing Global Payroll services for many years, originally to support implementation and upgrade projects. Over this time the emphasis on reporting and other analytics has grown with Payroll teams expected to supply meaningful information to both management teams and external agencies on a regular basis.
Version 1 have worked with a wealth of organisations over the years to assist them both with the development of bespoke payroll reports and to also give them the tools to enable them to build their own reporting and analytics suite. With recent advances in the PeopleSoft Query and Analytics applications, Version 1 can help you to develop your reporting provision with the following services:
PeopleSoft Query Training
1 dayDesigned for users with little or no knowledge of the delivered PS Query tool, this course gives the user an excellent introduction to developing queries designed to extract payroll related data for both internal and external use. The course begins with an overview the query framework and a summary of the common tables used for payroll reporting before moving on to showing users how to build complex queries designed to extract payroll information without the need to involve technical resources
The user will become familiar with the techniques required to extract accurate payroll results and will gain knowledge in the following topics:
- Understanding PeopleSoft Query Terms
- Selecting Data Tables
- How to join Data Tables
- Defining Selection Criteria
- Defining Prompts and Expressions
- Report formatting and Field properties
Composite and Connected Query Training
1 dayFollowing on from the basic PeopleSoft Query training course is a complementary course designed to assist users in understanding and developing both Composite and Connected PeopleSoft Queries. The course will cover when and where to use these types of Query and how they can be used to produce complex and powerful reports without the need for developer involvement. Topics covered are:
- Understanding Parent, Child and Sibling Connected Queries
- Public and Private Connected Queries
- Linking Queries
- Publishing in XML format
- Combining Data from existing Queries (Composite)
- Filtering and Aggregating results (Composite)
Course attendees will use the skills learned during the training to build example reports extracting relevant payroll data to showcase how these new skills can be related to the tasks they perform in their organisation.
Pivot Grids and Payroll Analytics Training
1 dayPivot grids can be used to present numerical data summarised by key attributes. Once collected, this data can be presented as a table or as a chart. Using the analytics functionality delivered by PeopleSoft, the results of these tools can be deployed in a variety of ways, including dashboards and WorkCenters.
This course is designed to give users an understanding of how Pivot Grids work and how they can be deployed for analysis by their colleagues within the wider organisation without the requirement for technical development skills.
Attendees will cover the following:
- Understanding Pivot Grid terms
- Defining a data source
- Defining a Pivot Grid
- Creating a Fluid Homepage
- Deploying Pivot Grids to Homepages
- Embedding Pivot Grids on a Fluid Tile
- Administering Pivot Grids
During the course, the users will create payroll-related example Grids and Tiles to demonstrate how these functions can be used in their organisations.
Report and Analytics Development
Version 1offers a range of consulting services designed to help organisations to meet their reporting obligations both internally and externally. From individual query setup, Application Engine report development and through to the creation of a full reporting and analytics solution, we can help you achieve your goals.
Reporting Training Tailored to Your Solution
Should your specific training needs not be met by the standard courses, we would be delighted to discuss your requirements and design a training schedule tailored to your reporting requirements. Please contact us to discuss in detail.
The courses are scheduled to run throughout the remainder of 2019 and beyond, at our office locations in London and the British Midlands. Alternatively, they can be delivered on a client site.
To discuss details of your requirement including pricing and availability please complete the information below
PeopleSoft Global Payroll Services
Learn more about our data protection and privacy policies.