How overtime can be calculated based on time and hours both?

[snehasuman]

Hi Experts,

I have to achieve below mentioned scenarios.

Questions:-

Do I require no.PCR separately for different allowance?

How many time types are required for this?

Which Operation to be used for OT so that I will get time as well as hours of OT? How will I know OT time if client enters approved OT from 17.00 to 00.00, because from 17.00 to 20.00 one rate is applicable and from 20.00 to 00.00 other rate is applicable.

My client is having 5 types of incentives related to OT below are the details.

General Shift timings- 8.00-17.00

Night Shift timing- 20.00- 8.00

1. OT calculation and Allowance based on IT2002

Employee Sub Group- Driver

i. calculation for monday to thursday

a. No OT general shift timings are 8.00- 17.00

b. OT rate 1.5 from >17.00- 20.00

c. OT rate 2 from >20.00- 00.00

d. OT rate 1.5 from >00.00- 8.00

ii. calculation for Friday to Saturday

a. No OT general shift timings are 8.00- 17.00

b. OT rate 1.5 from >17.00- 20.00

c. OT rate 2 from >20.00- 00.00

d. OT rate 3 from >00.00- 8.00 (from mid night saturday to saturday 8.00)

iii. calculation for saturday

a. OT rate 1.5 general shift timings are 8.00- 17.00 (excluding break OT only for 8 hrs)

b. OT rate 3 from >20.00- 08.00

iv. calculation for sunday

a. OT rate 1.5 general shift timings are 8.00- 17.00 (excluding break OT only for 8 hrs)

b. OT rate 3 from >20.00- 00.00

c. OT rate 1.5 from >00.00- 8.00 (from mid night sunday to monday 8.00)

2. Shift Allowance based on IT2011

Night shift- Allowance 200

Rate based on 200 as per working hrs

i. >=7.5 Rate 100%

ii. 7.30 <=Wrk hr<7.50 Rate 93.75%

iii. 4.0 <=Wrk hr<7.30 Rate 50%

iv. Wrk hr < 4.0 Rate 0

3. Food Allowance on IT2002

Work overtime for all shifts

Employee Sub Group- Section

Position- All except Driver

i. OT after shift end >= 1.5hrs- Amount 0

ii. >= 2hrs  OT after shift end < 5 hrs Amount 30

iii. OT after shift end >= 5 hrs Amount 60

iv. OT Clock out >=20:00 Amount 0

Position Driver

i. OT after shift end >= 1.5hrs- Amount 0

ii. >= 2hrs  OT after shift end < 5 hrs Amount 0

iii. OT after shift end >= 5 hrs Amount 0

iv. OT Clock out >=20:00 Amount 30

4. Living Allowance on IT2002

Work overtime for only night shift

Employee Sub Group- Section

Position- All except Driver

a. Allowance for working OT normal day

i. OT after shift end >= 2hrs Amount 30

ii. OT after shift end < 3 hrs Amount 0

iii. OT after shift end >= 3 hrs AMount 0

b.Allowance for working OT holiday day

i. OT after shift end >= 2hrs Amount 30

ii. OT after shift end < 3 hrs Amount 0

iii. OT after shift end >= 3 hrs AMount 0

Position Driver

a. Allowance for working OT normal day

i. OT after shift end >= 2hrs Amount 0

ii. OT after shift end < 3 hrs Amount (30 thb/3Hrs)*Actual wrk hrs **

iii. OT after shift end >= 3 hrs AMount 30

b. Allowance for working OT holiday day

i. OT after shift end >= 2hrs Amount 0

ii. OT after shift end < 3 hrs Amount (30 thb/3Hrs)*Actual wrk hrs **

iii. OT after shift end >= 3 hrs Amount 30

5. Transport allowance

Only for Drivers in all shift

Clock in <= 06::00 Amount 100

Clock out >=22:00 Amount 100

Thanks,

Sneha

[vianshu · Accepted solution]

Hi Sneha,

Please go through the below document where the concept of preapproved overtime along with different rates is explained.

I hope this is helpful.

Thanks and regards,

Vivek Barnwal

[snehasuman · Accepted solution]

Hi Vivek,

Thanks the thread shared is very useful, but can I achieve the same result while using IT2002 instead of IT2007 as client will proved approved OT in IT2002. Also in current month payroll the payment of OT will be for previous month, so how to transfer previous month data in the time wage type.

Regards,

Sneha

[vianshu · Accepted solution]

You can use IT2002 also for overtime. But it will work differently.

You can't use the approach mentioned in this document.

Regards,

Vivek

[snehasuman · Accepted solution]

Hi Vivek,

Can you please guide me for IT2002, the main issue I am facing is different rate for different times.

Regards,

Sneha

[vianshu · Accepted solution]

The issue of different rates for different times is addressed in my below document:

You have to define T510S configuration correctly for this and it is explained in my document.

Please read the whole document.

Regards,

Vivek

[snehasuman · Accepted solution]

Sure, accordingly I will try to write PCR as well. If any issues I will contact. Thanks again.

Sneha

[vianshu · Accepted solution]

I think you don't need any PCR for it.

Types function can assign processing type M to time pairs with pair type 3 and time id 01.

And you need to process such time pairs for overtime.

Regards,

Vivek

[snehasuman · Accepted solution]

Hi Vivek,

I cannot use TYPES function as I would be using schema TM00 not TM04. for shift allowance IT2011 will be used. what is the alternate way to process IT2002 and generate time wage type.

Regards,

Sneha

[jagan_gunja · Accepted solution]

Hi Sneha

You can create an attendance type as OT.  The payroll admin will need to enter this in IT 2002.  Or the employee can enter on timesheet, which needs to be converted to IT 2002 with the specific att.type.

In a time eval PCR, check if the pair is from IT 2002 and if the att.type = OT; if so generate OT time w/t;  or change the proc type for the pair to 'M' so that GWT can generate OT w/t.

The OT w/t needs to have suitable val.basis and should have proc cl 10 = 0, so that there is no reduction for partial pay factors.

In payroll subschema XT00

- function ZLIT will import the time w/t's generated in time eval. 

- PCR X015 should valuate time w/t's

Above should be enough

[Shivanii · Accepted solution]

Hi Vivek

[Shivanii · Accepted solution]

Can you share the document with me also as I also have the same requirement and need to configure the OT for different rate

[snehasuman]

Hi,

Can you let me know how to check the begdda of IT2002 entry, eg. if begda of It2002 entry is 20.00 hrs then only I have consider the entry to check hrs worked for one allowance.

can I use HRS=PBEG HRS?20.00

Thanks

[Former Member]

Hi Sneha,

You are going right. But beforehand you have to first identify if the pair is from IT2002. You can choose to check time type or processing type beforehand. Once you identify the pair is from IT2002, then you can query as you said.

My friend Vivek has written a good article on TIMTP function. It will help you to understand how you identify the pair type is from It2002.

Regards

Aj

[snehasuman]

Hi Ajay,

I need to keep increasing the count in timetype at occurrence of every 7 hrs, eg. if an employee works on a certain shift for more than 7 hrs this 7 hrs is counted as 1. so if in a month he works for 10 days like that 10 will be stored in timetype. I am able to get the shift and 7 hrs please help me how to increase the count.

Regards,

Sneha

[Sanky]

Hi,

Certain shift is like suppose taking example night shift wsr(NDWS_WSR) then you can query in the pcr like below.

For this in the time type maintain 1 under period balance and below is the PCR.

ZOTC

*

  ****

      OUTTPORIGS

        *

            COLOP *

        E

            OUTWPSHIFT

             *

             **

             ***

             ****

             *****

             ******

             *******

             NDWS_WSR

                      HRS=PNUM

                      HRS?7

                        *

                           COLOP *

                        >

                           HRS=1

                           ADDDB1000Z

1000 is the time type and for this maintain 1 under period balance.

Check and tell me.

Regards,

Sankarsan

Insert this PCR after

[Former Member]

Hi Sneha,

A long question.

Ans:

Do I require no.PCR separately for different allowance?

- Yes you need to write

How many time types are required for this?

- cannot count Time types like this, but think of what information do you need at end

- like for case 1 - you need time types for 1.5 and 2.0 - 2 time types

- However to calculate these some time types would require to hold some value during processing of evaluation.

- Similarly we need to count time types based on differential payments and other classified informations

Which Operation to be used for OT so that I will get time as well as hours of OT?

- You needs to write many PCRs to do so. most of the operations will be handelled by HRS. However things are not so easy but achievable.

How will I know OT time if client enters approved OT from 17.00 to 00.00, because from 17.00 to 20.00 one rate is applicable and from 20.00 to 00.00 other rate is applicable.

- You can create shifts and work on dynamic shift assignment.

Regards

Aj