Define Hourly Rates

Objective

The Define Hourly Rates option is used to configure the hourly rates needed to prepare the payroll by employee, trade, union, sector, region, shift, annex and the number of years or level.

You can download the changes to CCQ hourly rates by clicking the Update Hourly Rates icon. For the procedure, refer to the Appendix.

 

PREREQUISITEs

• Employee Management
• Define Trades

 

Icons

Icons of the Define Hourly Rates option:

Icon	Title	Used to
	Enter New Filter Parameters	Erase all entered data in the fields of the Filters / Default Values section.
	Filter Data According to Specified Parameters	Apply and filter the the data according to the information entered in the fields of the Filters / Default Values section.
	Import Rates from Excel	Import multiple rates using an Excel file.
	Hourly Rate Analysis	Analyze the different hourly rates according to the applied filters, as well as by employee and work category type.
	Update Hourly Rates	Transmit and apply hourly rates.
	Deselect All	Deselect all boxes checked in the Transmit column of the grid. NOTE : Available when clicking on the Update Hourly Rates icon.
	Select All	Check every box in the Transmit column of the grid. NOTE : Available when clicking on the Update Hourly Rates icon.

 

Steps

1. Enter the required information in the Default Filters / Values tab:

This section can be used in two different ways. It can be used as a filter to display only transactions that have already been entered by clicking the Filter data according to the settings entered icon, or as a default value to facilitate data entry in the Hourly Rates Detail section. You can import multiple rates from an Excel file by clicking the Import rates from Excel icon.

 

Field	Description
Employee	Employee for whom the hourly rate applies. NOTE: Employees must first be created in Employee Management.
Sector	Sector for which the hourly rate is entered or applicable. The choices are: All, 0 - Not Applicable, 1 - Civil Engineering and Road Networks, 2 - Industrial, 3 - Institutional and Commercial, 4 - Residential and 5 Heavy Residential. NOTE: The ALL value lets you display transactions for all sectors. You cannot create new transactions for ALL sectors.
Trade Code	Trade code to be displayed or to be applied to newly created transactions.
CCQ Trade Code	Displays the value entered in the CCQ Trade Code field of the Define Trade option if the Use to update social benefits box is checked.
Years or Level	Years or Level to be displayed or applied to newly created transactions.
Annex	Annex to be displayed or applied to newly created transactions.
Region	Region to be displayed or applied to newly created transactions.
Union Code	Union code to be displayed or applied to newly created transactions.

2. Enter the required information in the Hourly Rates Detail tab:

If the filter mode is used in the Default Filters / Values section, the grid only displays the transactions found. If there are new transactions, the default values entered are displayed in the grid so that the user can complete the missing information. You can determine the number of lines required in the breakdown grid by clicking the Configuration icon. You must enter at least one Employee or Trade Code (or both) on each line. Fields followed by the * character are mandatory fields.

 

Field	Description
Description	Description of the hourly rate. The description can be entered in both languages.
Description on Stub	Description to be displayed on the stub in the employee's language.
Employee	Employee for whom the hourly rate applies.
Employee's name	Name of the employee selected in the Employee column.
Sector	Sector for which the hourly rate applies. The choices are: 0 - Not Applicable, 1 - Civil Engineering and Road Networks, 2 - Industrial, 3 - Institutional and Commercial, 4 - Residential and 5 Heavy Residential.
Trade Code	Trade code for which the hourly rate applies. NOTE: If the field is empty or with the value 0, this tells maestro* that the rate must be applied for all trade code. NOTE: This code is from the Define Trades option.
Years or Level	Years or Level for which the hourly rate applies. NOTE: If the field is empty or with the value 0, this tells maestro* that the rate must be applied for all years or level. NOTE: This code is from the Define Years or Level option.
Annex	Annex for which the hourly rate applies. Note: This code is from the Define Annex option.
Region	Region for which the hourly rate applies. NOTE: This code is from the Define Regions option.
Union Code	Union code for which the hourly rate applies. NOTE: This code is from the Union Management option.
Shift	Shift for which the hourly rate applies.
Hourly Rate*	Hourly rate to be applied.

3. Click Save.
4. Click the Print icon to access the list generator and print the entries, if necessary.

 

See also

• Managing Appendices
• Define Regions
• Union Management
• Work Category Management
• Hours
• Configuration
• Hours Management
• How to: Importing rates from Excel
• How to: Hourly Rates Analysis
• How to: Apply the Highest Hourly Rate Based on the Union Code
• How to: Update CCQ-Related Data
• Maestro*EXPRESS: New "Class 2" for 15 Occupations of the Civil Engineering and Roadwork Sector
• Maestro*EXPRESS: Payroll Modifications Effective January 1, 2020

 

APPENDIX

Order in which hourly rates are read

Many reads are performed to find the hourly rate. They are conducted in the following order, by removing certain settings each time. The search ends as soon as a rate is found.

	Empl. No..	Trade	Union	Sector	Regiion	Shift	Annex	Years or Level
1	x	x	x	x	x	x	x	x
2	x	x	x	x		x	x	x
3	x	x	x	x			x	x
4	x	x	x	x				x
5	x	x	x				x	x
6	x	x	x					x
7	x	x	x
8	x	x
9	x		x	x	x	x	x	x
10	x		x	x		x	x	x
11	x		x	x			x	x
12	x		x	x				x
13	x		x				x	x
14	x		x					x
15	x		x
16	x
17		x	x	x	x	x	x	x
18		x	x	x		x	x	x
19		x	x	x			x	x
20		x	x	x				x
21		x	x				x	x
22		x	x					x
23		x	x
24		x

 

Procedure for Downloading the Updates to Hourly Rates From the CCQ

The Update hourly rates icon allows you to compare the hourly rate entered in maestro* with the rates available on the CCQ site. You can then download the new rates and automatically update them in maestro*.

To use this function, you must ensure that the information entered in Define Hourly Rates (sector, trade code, apprenticeship year and annex) correspond to the information on the CCQ site.

This function does not create new data in maestro*. It only updates the existing rates. Use of the annex is not mandatory in maestro*, but all rates published by the CCQ are linked to a specific annex. If the annex is not mentioned in your data, the import program uses the annex that corresponds with the general conditions applicable in each sector to determine the applicable rates.

 

If a payroll is being prepared, you must complete the payroll procedure before you update the hourly rates.

1. Click the Update Hourly Rates icon.

A table is displayed with information from the Define Hourly Rates option in maestro*.

2. Select the date for which hourly rates should be imported.

This date is used as a filter and the system displays the rates in effect on this date on the CCQ site. For maestro*, as soon as the hourly rates are updated, the new rates apply immediately. It is therefore impossible to import rates for future use.

3. Check or clear the Transmit column if applicable.

Only checked hourly rates will be confirmed with the CCQ's web site.

4. Click the Transmit icon.

An Internet connection is required to check the information with the CCQ.

 

A summary message is displayed indicating the number of files successfully transmitted and the number of files with errors. Click OK to close the dialog box.

5. Confirm the CCQ section of the table and clear the Update column to reject the updating of an hourly rate if necessary.

If the system finds a concordance between maestro* and the CCQ site, the system displays the values found on the CCQ site with the new hourly rate. The Return Code column indicates whether the concordance was successful or not and displays a message if there is an error. The Update column is automatically checked if the return code is successful.

6. Click Apply to accept the update of hourly rates.

A confirmation message is displayed on the screen. If you answer Yes, the update of hourly rates is applied immediately and this cannot be undone.

7. Click Quit to leave the update of hourly rates screen.

If transactions have already been entered and they must be corrected to reflect the newly imported hourly rates, you must reopen and save these transactions. The system will detect that the hourly rates have been changed and will offer to update the new rates in the transactions. This function is only available for transactions that have not been transferred.

 

Last modification: September 20, 2024