Description
This Stimulsoft report will allow review the AWR clock count and rates applied to a job order.
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. | |
Client Job Position | |
Position | |
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 rates are standard or agreement rates. Where agreement rates, only the flat rate type pay codes will be output. |
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
To be able to have a report to show the details of the AWR status of each job.
Configuration
If you want the report to be distributed to multiple teams, it will be necessary to configure a report schedule.