PAY RECORDS Report (Bill 124 RETRO Reporting)

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 

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 

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. 

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

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. 

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

Choose Run to process the report

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**

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