How to Mass Update Employee Rates
All values in the below examples are fictitious for the following example.
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')
