cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

PCR for OT calculations

rehanhashimi
Discoverer
0 Likes
838

Dear Experts,

Can someone help me writing a time PCR based on the below logic.

weekly schedule 3 working days and 4 day offs.

If the EE works any hours on day offs their hours should be calculated as 1,5x or 2.0x based on union agreement as below

If EE works upto 8 hours it should be 1.5x overtime

If EE works from 9 hours to 16 hours it should be 2.0x overtime

if EE works from 17 or more it should be 1.5x overtime,

Accepted Solutions (0)

Answers (2)

Answers (2)

corriveau_remi
Contributor
0 Likes

Create a "Counter" Time Type to count the Overtime hours worked in the week.  On the first day of the week, that counter is set back to 0.00 at the beginning of the Time Evaluation Schema.

On Scheduled Work Days, Overtime hours can be established using the Hours Worked and the Work Schedule Hours.  On Days OFF, all hours are Overtime.

Each day (except on the first day of the week), look at Yesterday's value of t"Counter" and establish if Today's Overtime Hours fall in the 1,5x or 2.0x category, and in what proportion.

clumbert
Contributor
0 Likes

I don't think you need separate time types which puts the burden back on the employee or end user recording the time. Try using VARSTDAYTY to determine if it is a scheduled or unscheduled day. Then you can use FILLP to change the valuation type.

I hope this helps. 

Cindy