Bill 124 RETRO Reporting

Modified on Tue, 11 Jun at 1:07 PM

Bill 124 RETRO Reporting

The following reporting aggregates and displays data for the RETRO Payments By Year. The data is not split by TPP or OMERS, the data is the same. 

NOTE: PAY_RECORDS report is included that can be sliced and diced based on a date range. 

 

Steps to Deploy:

NOTE: Ensure you have a data source created that is pointing to your HRP Database before starting.

 

  1. Expand the Zip file to a temporary location.
  2. Upload all the files ending in .rsd (these are your Dataset files) 
    1. Once they are Uploaded, Click Manage 

image

  1. Select Data Source 

image

  1. Click Browse and select your pre-existing data source 

image

  1. Repeat this for all .rsd files. 
  1. Now upload all the .RDL files , these are your report files 
    1. If they are located in the same folder as the .rsd files, they should like as you uploaded the .rsd first. 
    2. If they are not linked, just click on Manage   then Shared Datasets 

image

  1. Click Browse on each one and locate the uploaded Data Set file 
  2. Repeat this for each .rdl to link it 
    1. NOTE: The ShareData sets are different for each report and must be linked 

 

  1. Provide SSRS access to your HRP team to use the reports online
  2. Advanced tip if using the portal, you can create a custom menu link and provide security to key individuals to the link the Report URL for easy access to the report. 

 

 

 

RETRO Payments Report

The RETRO Payments report defaults to all Employee Groups and All Pay Numbers > Specify from here onwards. 

A screenshot of a computer

Description automatically generated

 

User can now also specify the Year that the Pay Number are to begin with to filter how many Pay Numbers will show. 

A screenshot of a computer

Description automatically generated

 

 

PAY_RECORDS Report

The PAY_RECORDS report is driven by Date, Entity Type, Entity Code and Class. 

Users can specify a specific Data Range and any additional parameters and continue to filter down the results as much as they would like. 

A screenshot of a computer

Description automatically generated

**Note it can take a second to load**

 

Choose Run to process the report

A screenshot of a computer

Description automatically generated

Note: The report can be expanded by Employee Group, Pay Number, Employee ID, All Pay Entities and their appropriate details. 

**Users can filter from EMP_GROUP > PAYNUM > EID and view all associated Pay Records and Details**

 

A screenshot of a computer

Description automatically generated

 

Alternatively, you can filter more specific data before running the report such as TYPE = SALARY & CODE = RETRO to view Retro specific data. 

A screenshot of a computer

Description automatically generated

 

 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article