This page (revision-32) was last changed on 26-Nov-2021 10:22 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
32 26-Nov-2021 10:22 34 KB Kevin Higgs to previous
31 26-Nov-2021 10:22 34 KB JMyers to previous | to last
30 26-Nov-2021 10:22 34 KB JMyers to previous | to last
29 26-Nov-2021 10:22 34 KB JMyers to previous | to last
28 26-Nov-2021 10:22 34 KB JMyers to previous | to last
27 26-Nov-2021 10:22 34 KB JMyers to previous | to last
26 26-Nov-2021 10:22 34 KB JMyers to previous | to last
25 26-Nov-2021 10:22 34 KB JMyers to previous | to last
24 26-Nov-2021 10:22 34 KB JMyers to previous | to last
23 26-Nov-2021 10:22 34 KB JMyers to previous | to last
22 26-Nov-2021 10:22 34 KB JMyers to previous | to last
21 26-Nov-2021 10:22 34 KB JMyers to previous | to last

Page References

Incoming links Outgoing links
UPTG PROCESSING
UPTG PROCESSING

Version management

Difference between version and

At line 60 changed one line
Mid-Period New Hire\\
__Mid-Period New Hire__\\
The beginning of the pay period is 01-Aug-2010.\\
If the employee had worked the entire pay period, he would have been scheduled to work 8 hours on the following days: 01-Aug to 04-Aug, 07-Aug to 11-Aug and 14-Aug to 15-Aug. This is a total of 88 hours.
At line 64 added 4 lines
RATE METHOD FOR SALARY = Standard Hours\\
The employee works 07-Aug to 15-Aug, 56 hours (using the standard of 8 hours/day x 7 days), their salary should be prorated using a factor of 56/88. No Force-Balancing is needed. The Monthly Salary is $5,166.67, making her semi-monthly salary $2,583.34. The hourly rate for the pay period is $2,583.34/86.667 = $29.81. The amount of her salary for the pay period is 56 x $29.81 = $1,669.23. If this employee had premiums the premium amounts would be prorated the same way and included on the details of the transaction line.\\ \\
RATE METHOD FOR SALARY = Scheduled Hours \\
The employee works from 07-Aug to 15-Aug, 60 hours (using the actual hours per day from the work schedule for 7 days), Her salary should be prorated using a factor of 60/88. No Force-Balancing is needed. The Monthly Salary is $5,166.67, making her semi-monthly salary $2,583.34. The hourly rate for the pay period is $2,583.34/88 = $29.3561. The amount of her salary for the pay period will be 60 x $29.3561 = $1,761.37. If this employee had premiums the premium amounts would be prorated the same way and included on the details of the transaction line.
At line 69 added 2 lines
__Mid-Period Termination__\\
The beginning of the pay period is 01-Jan-2010 and the ending is 15-Jan-2010. The employee’s last day is January 5, 2011. If they had worked the entire pay period the hours would have been as follows:
At line 64 removed 2 lines
The beginning of the pay period is 01-Aug-2006.
If the employee had worked the entire pay period, he would have been scheduled to work 8 hours on the following days: 01-Aug to 04-Aug, 07-Aug to 11-Aug and 14-Aug to 15-Aug. This is a total of 88 hours.
At line 67 removed 8 lines
The employee works 07-Aug to 15-Aug, 56 hours (using the standard of 8 hours/day x 7 days), Her salary should be prorated using a factor of 56/88. No Force-Balancing is needed. The Monthly Salary is $5,166.67, making her semi-monthly salary $2,583.34. The hourly rate for the pay period is $2,583.34  86.667 = $29.81. The amount of her salary for the pay period is 56 x $29.81 = $1,669.23. If this employee had premiums the premium amounts would be prorated the same way and included on the details of the transaction line.
RATE METHOD FOR SALARY = Scheduled Hours
The employee works from 07-Aug to 15-Aug, 60 hours (using the actual hours per day from the work schedule for 7 days), Her salary should be prorated using a factor of 60/88. No Force-Balancing is needed. The Monthly Salary is $5,166.67, making her semi-monthly salary $2,583.34. The hourly rate for the pay period is $2,583.34  88 = $29.3561. The amount of her salary for the pay period will be 60 x $29.3561 = $1,761.37. If this employee had premiums the premium amounts would be prorated the same way and included on the details of the transaction line.
Mid-Period Termination
The beginning of the pay period is 01-Jan-2006 and the ending is 15-Jan-2006. The employee’s last day is January 5, 2007. If she had worked the entire pay period the hours would have been as follows:
RATE METHOD FOR SALARY = Standard Hours
At line 80 changed one line
\\This totals 80 hours. Since her his last day was January 5th, she worked 40 hours. Her monthly salary is $6,250 with a semi-monthly salary of $3,125.00. Her hourly rate for the pay period should be $3,125  86.667 = $36.06. Her salary for this pay period should be 40 x 36.06 = $1,442.31. If this employee had premiums the premiums would be prorated in the same way and included on the details of the transaction.
\\This totals 80 hours. Since their last day was January 5th, they worked 40 hours. Their monthly salary is $6,250 with a semi-monthly salary of $3,125.00. Their hourly rate for the pay period should be $3,125 / 86.667 = $36.06. Their salary for this pay period should be 40 x 36.06 = $1,442.31. If this employee had premiums the premiums would be prorated in the same way and included on the details of the transaction.\\ \\
At line 89 changed one line
\\This totals 84.5 hours. Since her last day was January 5th, she worked 36 hours. Her monthly salary is $6,250 with a semi-monthly salary of $3,125.00. Her hourly rate for the pay period should be $3,125  84.5 = $36.9822. Her salary for this pay period should be 36 x 36.9822 = $1,331.36. If this employee had premiums the premiums would be prorated in the same way and included on the details of the transaction.\\
\\This totals 84.5 hours. Since their last day was January 5th, they worked 36 hours. Their monthly salary is $6,250 with a semi-monthly salary of $3,125.00. Their hourly rate for the pay period should be $3,125 \ 84.5 = $36.9822. Their salary for this pay period should be 36 x 36.9822 = $1,331.36. If this employee had premiums the premiums would be prorated in the same way and included on the details of the transaction.\\
At line 92 changed one line
The employee should receive the same semi-monthly salary and premiums regardless of the number of scheduled days in the pay period. The Salary will be divided into FLSA periods if designated to do so.
The employee should receive the same semi-monthly salary and premiums regardless of the number of scheduled days in the pay period. The salary will be divided into FLSA periods if designated to do so.
At line 97 changed 2 lines
High Line Approach
When an employee has schedule changes that are effective after the pay period start date and before the pay period end date, the salary is determined by using the total number of hours generated by UPTG for the overriding work calendar/work rule and the effective dates on IEAS. For example, during the April 1 – 15 pay period the employee is on a 5/40 schedule until April 9th when the employee changes to a 9/80 A schedule. There is an 09-April effective date record changing the work rule from 5/40 to 9/80 A. This means that the employee schedule should be 8 hours of work April 2 – April 7 and 9 hours of work April 10 – April 13. This is a total of 76 hours for the pay period. The employee’s salary is determined by using the pro-ration of 76/76 and then force balancing to insure that the employee receives 100% of their semi-monthly salary. Similarly, if there is an effective record changing the employee back to a 5/40 effective April 12, the total number of hours generated by UPTG would be 82. The salary is determined by what is on IEAS at the time UPTG salary is processed. The processing of premiums is excluded at this time.\\
Example \\
When an employee has schedule changes that are effective after the pay period start date and before the pay period end date, the salary is determined by using the total number of hours generated by UPTG for the overriding work calendar/work rule and the effective dates on IEAS.\\
At line 100 changed 2 lines
Mid-Period Schedule Changes with No Salary and/or Premium Changes
This employee had a work rule change in the middle of the pay period. There is no change in salary or premium, so there is no need to do any additional calculation. The system will pay the same semi-monthly salary and premium amount. UPTG will generate 4 transactions, two for each of the effective date records, due to work rule changes, with the employee’s salary and premiums on one and the time on the other.\\
For example, during the April 1 – 15 pay period the employee is on a 5/40 schedule until April 9th when the employee changes to a 9/80 A schedule. There is an 09-April effective date record changing the work rule from 5/40 to 9/80 A. This means that the employee schedule should be 8 hours of work April 2 – April 7 and 9 hours of work April 10 – April 13. This is a total of 76 hours for the pay period. The employee’s salary is determined by using the pro-ration of 76/76 and then force balancing to insure that the employee receives 100% of their semi-monthly salary. Similarly, if there is an effective record changing the employee back to a 5/40 effective April 12, the total number of hours generated by UPTG would be 82. The salary is determined by what is on IEAS at the time UPTG salary is processed. The processing of premiums is excluded at this time.\\
__Mid-Period Schedule Changes with No Salary and/or Premium Changes__
This employee had a work rule change in the middle of the pay period. There is no change in salary or premium, so there is no need to do any additional calculation. The system will pay the same semi-monthly salary and premium amount. UPTG will generate 4 transactions, two for each of the effective date records, due to work rule changes, with the employee’s salary and premiums on one and the time on the other.\\ \\
At line 110 changed 3 lines
Mid-Period Salary and Premium Changes
The total salary is determined by using the same pro-ration logic described previously. If there are no work calendar or work rule changes in effect on IEAS and the employee has a salary increase, the total salary for the pay period is determined by a pro-ration of the number of hours the employee is on the old and new salary. For example, for the pay period of Oct 15-31, 2006, an employee is assigned to a 5/40 work rule receives a salary increase effective Oct 23. The old semi-monthly salary is $2,583.34 and the new semi-monthly salary is $3,125.00. The employee’s salary for the pay period is:
($2,583.34 x 40/100) + ($3125.00 x 60/100) = ($1033.34 + $1875.00) = $2908.34
__Mid-Period Salary and Premium Changes__
The total salary is determined by using the same pro-ration logic described previously. If there are no work calendar or work rule changes in effect on IEAS and the employee has a salary increase, the total salary for the pay period is determined by a pro-ration of the number of hours the employee is on the old and new salary.\\
For example, for the pay period of Oct 15-31, an employee is assigned to a 5/40 work rule receives a salary increase effective Oct 23. The old semi-monthly salary is $2,583.34 and the new semi-monthly salary is $3,125.00. The employee’s salary for the pay period is:
($2,583.34 x 40/100) + ($3125.00 x 60/100) = ($1033.34 + $1875.00) = $2908.34
At line 121 changed 14 lines
Start Date A start date must be provided. The start date is the when the leave begins.
End Date An end date must be provided. The end date is the when the leave ends.
Time Code A Time code must be provided. This field contains the code for which the leave line record is being created.
Leave Type A Leave Type must be provided. This field contains the user-defined code to indicate the leave type
Overall Time This field displays the total amount of time that has been requested. This field will be populated according to the setup on the employee’s assignment record.
Basis This field contains the unit of measure for the requested time to be taken.
Description This field contains a user-defined description of the leave type entered.
Status This field indicates the status of the leave line record. It will be updated accordingly when the leave lines are processed by the various functions in the eP system.
• 1st Requested – initial record created on IAAL
• 2nd Processed – picked up and processed by UPTG
• 3rd In Payroll – picked up by a PR process
• 4th Update in Progress
• 5th Unofficial Accr Updated
• 6th Official Accr Updated
|Start Date|A start date must be provided. The start date is the when the leave begins.
|End Date|An end date must be provided. The end date is the when the leave ends.
|Time Code|A Time code must be provided. This field contains the code for which the leave line record is being created.
|Leave Type|A Leave Type must be provided. This field contains the user-defined code to indicate the leave type
|Overall Time|This field displays the total amount of time that has been requested. This field will be populated according to the setup on the employee’s assignment record.
|Basis |This field contains the unit of measure for the requested time to be taken.
|Description|This field contains a user-defined description of the leave type entered.
|Status|This field indicates the status of the leave line record. It will be updated accordingly when the leave lines are processed by the various functions in the system.\\1st Requested – initial record created on IAAL
*2nd Processed – picked up and processed by UPTG
*3rd In Payroll – picked up by a PR process
*4th Update in Progress
*5th Unofficial Accr Updated
*6th Official Accr Updated
This page (revision-32) was last changed on 26-Nov-2021 10:22 by Kevin HiggsTop