Clarity - How Do I Mass Update Employee Rates?

All values in the below examples are fictive

Update the province and save the below script in a text file.

In the script the province is Manitoba (MB). If province is Alberta replace MB with AB. User must update tax_province, pay category, and rate.

SELECT

  [Master paycards].RATE

FROM

  EMPLOYEES Employees

  INNER JOIN EMPLOYEES_MASTER_PAYCARD [Master paycards] ON (Employees.ID = [Master paycards].ID_EMPLOYEE)

  INNER JOIN PAYROLL_CATEGORIES [Payroll categories] ON ([Master paycards].ID_PAYROLL_CATEGORY = [Payroll categories].ID)

WHERE

  ([Master paycards].[YEAR] = 2017) AND

  (Employees.TAX_PROVINCE = 'MB') AND

  ([Payroll categories].NUMBER = '102') AND

  ([Master paycards].RATE < 13.60) AND

  (Employees.STATUS = 'A')

Start Clarity and login into company you want to update

Steps:

1. Go to Utilities > Mass update.
   
2. Close error message > Next in the Mass update window
   
3. Select the group of records > Next.
   
4. Click Load query to upload the query saved earlier..
   
5. Select the file > click Open > the script is now visible in the right panel > click Next.
   
6. Select the target > click Next.
   
7. Select the field > Next.
   
8. Select the operation, update type and enter the updated amount > click Next.
   
9. Click Next.
   
10. Select year > click Next.
    
11. See the update > click Next.
    
12. Confirm the mass update > click Finish.
    
    
13. Review employee master pay card: Employee > master pay card > locate the pay category.