PCR for Overtime

[Former Member]

Hi Friends,

I am trying to create the PCR for the below mentioned condition.

DWS=8 hrs

If employee is working > 8 <10 hrs then OT is paid as 150%

If employee is working >10 < 12 hrs then OT is paid as 200%

Finally is employee is working more than 12 hrs so OT should not be paid.

As i am naive in designing the Schema/PCR section so please suggest me how to configure in the simplest form.

Thank you

Amit

[Sanky · Accepted solution]

Hi Amit,

You can design your pcr like below.

ZTST

*

****

      HRS=PEND

      HRS-PBEG

      ADDDB1001

      HRS=D 1001

      HRS?8

              >

                 HRS?10

                        >

                           HRS?12

                               *

                                 ADDZL 9001

                               >

                                  LEAVE

                        *

                           ADDZL 9001

              *

                 ADDZL 9000

This two wage type 9000 & 9001 will move to payroll then in the payroll write the rate. Suppose WT9000 amount would 150% of one day basic.

Then in the payroll you will write the below pcr like below.

ZPYR

*

  9000

          AMT=  1000

          AMT/TKDIVI

          AMT*1.5

          NUM=  9000

         MULTI ANA

         ADDWT 9000

   9001

         AMT=  1000

         AMT/TKDIVI

         AMT*2

         NUM=  9001

         MULTI ANA
         ADDWT 9001

   ****

       ADDWT *

Insert the pcr with function PIT after ZLIT function in XT00.

Check and tell me.

Regards,

Sankarsan

[BGibbons · Accepted solution]

Hi,

you can of course create your OT with a PCR as described above, however the neater way to do it would be to configure up Wage Type Sections rules on table T510S.

Wage Type select rules allow great flexability in generating wage Types from your TIP entries without the need to code up in a PCR.

If you do a search on SCN there is at least one WIKI explaing how to use this functionality.

Regards

bg

[Former Member · Accepted solution]

Hi Sankarsan,

After mentioning the requirement of calculation in time pcr , instead of writing PCR in Payroll again can we go by v_512w_b table to mention how the wage type to be valuated ie 150% or 200% whatever it may be.

[Sanky · Accepted solution]

Yes you can through table T512W_B.

Regards,

Sankarsan

[Former Member · Accepted solution]

Hi Sankarsan,

I want to re-initiate the discussion based on my requirement as mentioned below .

"If employee is working > 8 <10 hrs then OT is paid as 150%

If employee is working >10 < 12 hrs then OT is paid as 200%

Finally is employee is working more than 12 hrs, OT should not be paid."

This time process with the help of table V_T510S. Since there are 3 conditions in OT.

so as per my understanding we need to create two WTs thru OH11 and these 2 WTs will be defined in table T510S.

for first WT the below mentioned confi is required

for 2nd WT please refer below

Please let me know here do we also need to define 3rd WT to meet the condition >12 hrs?

Another point is how end user will select the relevant WTs to book OT hrs.

Kindly assist me.

regards,

Amit

[BGibbons · Accepted solution]

Amit,

Can you clarify your requiremement please ? If below statements are incorrect then elaborate with examples.

Assumption employee planned time (Processing type 'S') is 8 hours

Rules required only for Unplanned time (Processing type 'M')

If employee works 9 hours - pay 1 hour @ 150% ?

if employee works 11 hours - pay 2 hours @150% + 1 hour @200% ?

If employee works 13 hours -  pay 2 hours @150% + 2 hours @200% ?

Regards

bg

[Former Member · Accepted solution]

Hi Brendan,

Please refer my requirement as below.

If employee works 9 hours - pay 1 hour @ 150% ?

if employee works 11 hours - pay 1 hour @150% + 2 hours @200% ?

If employee works 12 hours -  pay 1 hour @150% + 3 hours @200% ?

If employee works more than 12 hours then there is no overtime.

regards,

Amit

[BGibbons · Accepted solution]

Amit,

Out of curiosity if employee works a 13 hour day what do they get paid ?

bg

[Sanky · Accepted solution]

Hi,

have tried with my mentioned PCR?

Regards,

Sankarsan

[Former Member · Accepted solution]

Brendan,

It may also be one condition of 13 hrs or more but due to legal obligation my requirement is confined upto 12 hrs only.

regards,

Amit

[Former Member · Accepted solution]

No Sankarsan,

I didn't try with your PCR.

regards,

Amit

[BGibbons · Accepted solution]

Amit,

So what does he get if he works 13 hours ?

Are they treated as if they worked only 12 hours or treated as if only worked the planned 8 hours ?

bg

[Sanky · Accepted solution]

Would like to go with T510S.

Sankarsan

[Former Member · Accepted solution]

Hi Brendan,

Appreciate your logic and your concept is also right but there is no OT after 12 hrs as per the client policy.

Max. after 12 hours they are not required to stay back in the office.

regards,

[Former Member · Accepted solution]

Better if i get to know thru T510S. but as per Venkatesh's response, there must be some idea to opt T510S and PCR both.

regards,

[BGibbons · Accepted solution]

Amit,

Then you can use the MIN and MAX functionality on T510S to generate your wage types

Rule 1 to generate OT @150%

set MIN = 0 MAX = 1 this wil generate a maximum of 1 hour at the appropriate WT (the wt you use to pay @150%)

Rule 2 to generate OT @200%

Set MIN = 1 MAX = 2  this wil generate a maximum of 2 hours at the appropriate WT (the wt you use to pay @200%). Because we set the MIN = 1 this rule will only kick in when 1 hour has already been generated by a previous rule (for the same processing type 'M' in your case)

This should generate your OT time wage types.

How you subsequently value this in Payroll is a seperate issue

Regards

bg

[Former Member · Accepted solution]

Hey Brendan,

It would be highly appreciable if you can elaborate the below mentioned scenario, it may give idea to solve this thread.

Assumption employee planned time (Processing type 'S') is 8 hours

Rules required only for Unplanned time (Processing type 'M')

If employee works 9 hours - pay 1 hour @ 150% ?

if employee works 11 hours - pay 2 hours @150% + 1 hour @200% ?

If employee works 13 hours -  pay 2 hours @150% + 2 hours @200% ?

regards,

[Former Member · Accepted solution]

Hi Sankarsan,

I have taken idea from you first PCR and wrote my own but it's not working kindly refer below and let me know where i am mistaken.

As i am using TM04 without clock so used TT 0900/0904

rgds,

Amit

[Former Member · Accepted solution]

Hi Brendan,

This case is working fine with the help of table now but still looking for PCR method so that ZL entries get automatically updated thru PCR and it will pass those updated entries in PY driver.

regards,

[Former Member]

Hi,

I would also opt for V_T510S and configuration of the wage type  to generate the 150%/200% etc.

It is easier to maintain as any future/additonal changes required mean exisitng ones can easily be delimited.

Regards,

Will

[Former Member]

Hi Will,

May i ask the entire process to solve this perplexity?

Thank you

[venkateshorusu]

Once you generate OT wage type with number of hours by using V_T510S accordingly you can write a rule to pay the employee accordingly.

Regards

Venkatesh

[Former Member]

Hi venkatesh,

I think you gave me idea, but there is challenge for me to call WT in PCR.

I try to do that.

regards,