The Alberta Teachers 1/200 Calculation is used to calculate the adjustment to salary for Teachers who did not work a full year either through working a reduced FTE or not completing a full year. This 1/200 calculation process pulls in the information for the employee for those months already worked and projects the remaining months to the end of June. By default, the Deduct 1/200 is calculated and displayed, although you can set your initial preference through the Alberta Pension Profile. You can switch the calculation between Deduct and Pay 1/200 as needed. From the pre-calculated amounts, you can adjust the employees' values as needed. The total of the days, Days Worked plus Not Worked is forced to equal the number of Working Days defined in the payroll calendar. This process along with the TRF process uses the number of Days in the employees Days bank to determine the employees FTE per period. The employees Days bank must have a value for any school term month where the employee was paid.
Note: this process and all TRF processing will use the main payroll calendar Working Days as the default although the payroll calendar Alternate Days override is applicable. You cannot use the Alberta profile Alternate Days and the calendar Alternate Days at the same time, the profile option is being phased out.
This process requires the Payout prompts on the second page of the Alberta Pension Profile be completed ahead of time. The Payout profile values define the earnings to be regarded as Annual Salary, the critical pay periods for the current school year, the pay code and the batch type code required for timesheet generation. It is recommended that a new batch type code be created and reserved for this purpose.
Enter Employee #
-
Enter the number or name of the employee to be adjusted.
Days Worked = taken from the Days storage bank for the employee.
FTE = calculated from the Days storage bank and the payroll calendar Working Days.
Not Worked = Calendar Working Days less Days Worked.
Daily Rate = Salary at 100% divided by 200.
Salary AT 100% = Salary Per FTE bumped up to 100%.
Salary PER FTE = Earnings paid based on the Payout Salary Pay Codes, as defined under the Teacher profile, plus any retro distributed to that month. Days and salary based on the Payout Docking Pay Codes will be included as Salary Per FTE for the specific month.
Deduct 1/200 = The days Not Worked multiplied by the Daily Rate.
Pay 1/200 = The Days Worked multiplied by the Daily Rate.
** = Projected months Days Worked and Salary Per FTE are carried forward to unprocessed months.
Deduct 1/200 results = Salary At 100% less Salary Per FTE less Deduct 1/200 equals totaling owing for July and August.
Pay 1/200 results = Pay 1/200 total less Salary Per FTE equals totaling owing for July and August.
JUL/AUG = Salary Per FTE (function line earnings) plus or minus TIMESHEET amount equals ½ of the calculation for a combined total equal to the total Deduct or Pay 1/200. The highlighted amounts under the TIMESHEET heading is the amount(s) to be used when a timesheet entry is generated.
Edit mode allows you to adjust the values for the current vertical line. You can move from field to field using the up and down arrow keys or the enter key on your keyboard or by using the arrows indicated. You can also use the page up and page down to move from one line to another while remaining in Edit mode on a specific field. For example, you can move from one deduction frequency field to another using the page up or page down without going to the end of the line or leaving Edit mode.
|
Next |
Select Next to return to the employee number prompt to access a new employee or exit this option. No timesheets will have been done. |
|
Modify |
Select Modify to modify the employee's displayed values. |
|
Jul-Aug |
Select July-August to edit the July and August Salary Per FTE amounts. |
|
Pay |
Select Pay to convert the current calculation to a Pay 1/200. |
|
Deduct |
Select Deduct to convert the current calculation to a Deduct 1/200. |
|
No Projection |
Select No Projection to remove the projected Days Worked and Salary Per FTE. This will switch all calendar days for those months to fully unpaid. |
|
Timesheet |
Select Timesheet to create a timesheet entry based on the current adjustment values. The Payout Pay code and Payout Batch code values are as defined under the Teacher profile. Once a timesheet is created you will be returned to the Employee Number prompt to access a new employee or exit the option. |
Timesheet Generation
Using the up and down arrow keys, select the month or July and August where the timesheet entry should be created. Select Cancel to return to the previous screen without creating a timesheet. Details will be displayed for each timesheet entry generated, showing the batch and pay code used.
July/August Two timesheets one in July and one in August will be created using the Timesheet amount shown.
August One timesheet with the combined Timesheet amounts will be created under the August pay period.
July One timesheet with both the combined Timesheet amount as well as the August payment will be created under the July pay period.
Selecting June to September will generate a timesheet entry using the full recalculation amount.