Description
This Stimulsoft report will allow you to monitor where job order parity rates are the same as pre-parity rates. This would suggest that the parity rates are pending to be received from the client and that it should be followed up so that the correct rate is in place before the job reaches parity.
This report will only output those candidates where monitoring is required and the parity rate is the same as the pre-parity rate.
Report Parameters
The report data can be filtered using the following parameters:
Parameter | Description | Rules |
---|---|---|
Brand | To be able to filter for jobs within a particular brand | Can choose all brands or a particular brand. |
Region | To be able to filter for jobs within a particular region. | Can choose all regions or a particular region. |
Office | To be able to filter for jobs within the offices selected. | Can select multiple offices. Leave blank if all offices are required. Data is restricted to the user’s security data profile when running the report. |
Client Name | To be able to filter for jobs that are for a particular client. | Can be left blank to see all client jobs. Can enter a part client name. A wildcard % is not required to search for the part name. |
Job Ends On or After | To be able to filter on jobs where the job end date is on or after the date entered. This is so jobs that have ended prior to the date are not displayed as they are already ended. | This defaults with today’s date but can be changed. |
Job Active for More Than No. of Weeks | The report is only relevant for those jobs that are greater than the parity weeks. If the job is active for less than the number of weeks entered, these will not appear in the report. As this could be different for a Office or Client, this can be changed where required. | This defaults with 12. An entry must be made to return data. If all jobs are required, enter a value of 0. |
Clock Count From | To be able to filter for those jobs that have a clock count between the range entered. | An entry must be made to return data. A default of 9 is applied but can be changed. If you want all clock counts, enter a value of 0. |
Clock Count To | An entry must be made to return data. A default of 12 is applied but can be changed. If you want all clock counts, enter a value of 13. | |
Supplier Name | To filter for workers who are associated to an umbrella or 3rd tier agency. | Can be left blank to see all jobs for all types of payees. Can enter a part supplier name. A wildcard % is not required to search for the part name. |
Report Content
The report content will output the following data:
Column | Comments |
---|---|
Office | The data is grouped under the office the job is assigned. |
Client No. | |
Client Name | |
Candidate Id | |
First Name | |
Surname | |
Supplier Name | |
Job No. | |
Job Start Date | |
Job End Date | |
Clock Count | This is the latest clock count on the job. |
Enhanced Holiday | If there is an enhanced holiday override value entered, this will be displayed, else it will be blank. |
Rate Type | Identifies if the pay code is from standard rates or agreement rates. If an agreement rate, it will only output those rates that have the Type of Flat Rate. |
Pay Code Name | Will list out all pay codes where the parity rate is the same as the pre-parity rate. |
Pre- Parity Pay Rate | This will display the latest validity pay rate value where the rate type is Pre-Parity. |
Parity Pay Rate | This will display the latest validity pay rate value where the rate type is Parity. |
Benefits
Helps identify where parity pay rates are yet to be supplied so that they can be obtained before the payee reaches parity.
The report can also be run where a payee has already reached parity but the rates are same.
Configuration
If you want the report to be distributed to multiple teams, it will be necessary to configure a report schedule.