Sick quota for Students & Contractors

[Srikanth02]

Hi Friends,

Below is the requirement for the quota accrual.

To check employee has worked more than 30 days after 1stJuly 2015 to start accrual.

          a.      If yes, then check for whether employee has worked 30 hours. If not, wait for 30 hours to complete.

          b.      And accordingly it has to add “1”Hour for every 30 hours worked .

     e.g. if Employee has crossed 30 days as on from 1 st July, system has to check whether emp.  has greater than or equal to 30 hours, then accrual has to happen as per Payroll period (Biweekly). if not wait for 30 hours to complete.

          c. When next time, time evaluation runs it should not check the hours for which accrual has already happened and it should check for next 30 hours, if yes accrual of quota, if not no accrual.

My issue is, it first checks for 30 days and checks whether 30 hours or more for first time accrual. But when next time, it runs again it includes hours from the beginning for quota calculation.

Regards,

Srikanth

Sick leave quota for Students & Contractors

[vianshu · Accepted solution]

Hi Srikanth,

Your requirement isn't clear to me.

What is the basis of taking 01st Jul as the cut off date? What happens before 01-Jul?

What is the definition of day worked? If the employee works for 5 hours in a 8 hours shift, is it considered as day worked? Are you in positive time management or negative time management?

Do you consider attendance in IT2002 towards day worked?

Kindly explain.

Regards,

Vivek

[Srikanth02 · Accepted solution]

Hi Vivek,

1. 1st July is the cut off start date and any hours entered before should not be considered.

2. For Students & Contractors, Planned hours is "0" and there is no fixed time/minimum time to consider as full day. Any hours entered in a day is considered as full day.

3. We use negative time management and we consider from ITT2002 for attendance.

4. Currently, we are using copy of TQTA schema, for Salaried employees for their quota accrual (Vacation & Sick).

Please let me know if you need further information.

Regards,

Srikanth

[vianshu · Accepted solution]

What is the validity and deduction interval for this quota? Is this yearly one?

Regards,

Vivek

[Srikanth02 · Accepted solution]

Hi Vivek,

Yes, this is yearly one and carry forward of 24 hours Max.

Regards,

Srikanth

[vianshu · Accepted solution]

Hi Srikanth,

I am sorry to say that I am lost in your requirements explanation.

To check employee has worked more than 30 days after 1stJuly 2015 to start accrual.

          a.      If yes, then check for whether employee has worked 30 hours. If not, wait for 30 hours to complete.

          b.      And accordingly it has to add “1”Hour for every 30 hours worked .

     e.g. if Employee has crossed 30 days as on from 1 st July, system has to check whether emp.  has greater than or equal to 30 hours, then accrual has to happen as per Payroll period (Biweekly). if not wait for 30 hours to complete.

          c. When next time, time evaluation runs it should not check the hours for which accrual has already happened and it should check for next 30 hours, if yes accrual of quota, if not no accrual.

What do you mean by if the employee has completed 30 days on 01-Jul-2015?

You are also talking about accrual happening by payroll period (biweekly)? How will this logic work next year because the biweekly payroll period won't have end date exactly as 30-Jun-2016?

Also if it is biweekly, then you don't need to consider attendance at all?

Regards,

Vivek

[vianshu · Accepted solution]

Why not explain with scenarios in a spreadsheet with dates and accrual? That may bring more clarity to the requirement and what will happen next year too?

Regards,

Vivek

[Srikanth02 · Accepted solution]

Hi Vivek,

The reason I said is as per US Law it should start from 1st July 2015. For students and contractors till now, there is no quota and its a new bill which has been declared by US and it is mandatory.

1. Thats the reason I said, it should start from 1 st july 2015.

2. It is calendar based. It will start from 1st july 2015 till 31st december 2015. And from next year onwards it is from January 2016 to December 2016.

3. Only first time after 1st July 2015, we need to check whether employee has crossed 30 days or not, after that only based on hours accrual should happen. If employee has been rehired, then again we need to check for 30 days completed for accrual.

4. Sorry, accrual is not on biweekly basis, it is based on weekly basis.

5. We are using Copy of TQTA for quota accrual for Salaried employees.

6. Carry forward of max 24 hours to next year.

Attached a scenario for your reference. Please check and let me know if you need further information.

Regards,

Srikanth

[Sanky · Accepted solution]

Hi Srikanth,

As per my understanding that there few points are there in the requirment.

1. 1st July 2015 onwards.

2. Should check 30 days completion and accumulate the hours simultaneously.

3. Once 30days has been completed then you will be checking next every 7days working and there after have the completion of 30 hours or not.If its not then it will carry forward to next week and adding with the current week work hours. (Having the confusion becuase in the sheet is the uneven work days after 30 days completion)- Clarify.

To design that you should go with TM04 schema and attendance should be captured through IT2002.

1st Point no 1.

For this you please create an constant like ZJULD and maintain like below in the constant table T511K.

ZJULD  01.01.2015  30.06.2015   1

ZJULD  01.07.2015  31.12.9999   2

Now write the below PCR to check the calculation will start once system is on and after 01.07.2015.

ZJUL

  *

    ****

          NUM=CZJULD

          NUM?1

                 *

                    SCOND= F IF

                 2

                     SCOND=T IF

2nd Point.

ZPRN

  *

     ****

           VARSTFREE

                 Y

                      LEAVE

                 N

                      VARSTHOLCL

                          *

                             HRS=1

                             ADDDB1000Z

                          1

                             LEAVE

Here 1000 is the time type where period balance should be ticked for this Ttype1000.

ZACT

  *

    ****

          OUTTPORIGS

                E

                    COLOP *

                P

                    COLOP *

                    HRS=PNUM

                    ADDDB1010Z

Here Ttype 1010 is carrying the actual working hours.

ZWRK

    *

      ****

             HRS=M1000

             HRS?30

                  *

                    LEAVE

                  =

                     HRS=M1010

                     HRS/M1000

                     ADDDB1020Z

                     HRS=0

                     ADDMB1000Z

                     ADDMB1010Z       

Here Time type 1020 is quota type base entitlement time type. Which will be passing to employee's IT2006 against quota type.

Design your schema like this and will add after P2002 function

IF         ZJUL

PTIP    ZACT  GEN

ACTIO ZPRN

ENDIF

ACTIO ZWRK will be add after CUMBT function in the tiem schema.

*** Upto point no 1 & 2 is completed.

Point 3.

Cab only provide once get the cleart picture on the point no 3.

Regards,

Sankarsan

[Srikanth02 · Accepted solution]

Hi Sankarsan,

For Students & Contractors, there is no planned hours and it is "0". They may work in a week either 1 day / 5 days / 7days or they wont work in a week.

That's the reason I mentioned different days in a week as an example.

Once 30 days is completed, then it has to check for hours from July whether 30 hours is completed to start accrual. Once quota is accrued for initial 30 hours, then it should not consider again for next accrual.

Timesheet approval happens every Monday and it has to run after that to check for previous week timesheet for 30 hours.

Week starts from Sunday to Saturday.

Let me know if you need further information.

Regards,

Srikanth

[Srikanth02 · Accepted solution]

Hi Sankarsan,

When I checked your rule for ZPRN, need a clarification.

ZPRN

  *

     ****

           VARSTFREE

                 Y

                      LEAVE

                 N

                      VARSTHOLCL

                          *

                             HRS=1

                             ADDDB1000Z

                          1

                             LEAVE

Here 1000 is the time type where period balance should be ticked for this Ttype1000.

Here, you mentioned above as Varstfree, if Y then Leave.

For Students & Contractors, Planned hours is always "0"and it wont proceed further.

Srikanth

[Sanky · Accepted solution]

Hi,

If employee comes in the day then you have to maintain the dws in the IT2003. then you can calculate the working day's of 30days or 1 day/5days/7days.

If you will not pass employee's present day either IT2003 or IT2002 maintain.

Regards,

Sankarsan

[Srikanth02 · Accepted solution]

Hi Sankarsan,

We do have record in IT2002, whenever employee works for the week.

Srikanth

[Sanky · Accepted solution]

Hi,

Modify ZPRN

ZPRN

  *

     ****

           VARSTP2002

                 N

                      LEAVE

                  Y

                      HRS=1

                      ADDDB1000Z

Check and tell me.

Regards,

Sankarsan

[Srikanth02 · Accepted solution]

Hi Sankarsan,

When I try to enter NUM=CZJULD, its giving error ïts not a valid operation".

And also in table t511k, I cannot maintain 2 records with same constant values with 1 and 2.

I could maintain only one record and also value comes with decimal.

Srikanth

[sikindar_a · Accepted solution]

C is to call the values which are related to time in time Schema

You have to use NUM=KZJULD , if you are writing the PCR in Time

then  HRS=CZJULD

[Srikanth02 · Accepted solution]

Hi Sikander,

Still getting same error.

NUM=KZJULD is not a valid operation

Srikanth

[Sanky · Accepted solution]

U have to use as

NUM=CZJULD

Regards,

Sankarsan

[sikindar_a · Accepted solution]

Are u writing PCR in Payroll or Time ? in case of time you have to use HRS=

[Srikanth02 · Accepted solution]

Hi Sankarsan,

still getting error.

NUM=CZJULD is not a valid operation

Srikanth

[Sanky · Accepted solution]

Hi Srikanth,

I am extremely sorry for given wrong operation.

That is HRS=CZJULD

Regards,

Sankarsan

[Srikanth02 · Accepted solution]

Hi Sankarsan,

No problem. Can you please let me know on point #3 as you mentioned above.

Srikanth

[Sanky · Accepted solution]

Hi,

For the point no 3,

What should i check for it?

Am i check the weeks. Suppose on the particular week he has worked for 5days and orked for 25 hours and in next week 1st two day's he has worked 10 hours then before completing the week he had worked more than 30hours so shall i calculate that time or i should calculate once week will be completed.

1st week    5 days    25 hours

2nd week   2 days    10 hours  ----> shall i calculate this point =(35/30)

2nd week   5 days     15 hours ----> shall i calculate in this point= (50/30)

Clarify my doubt and then i will try to give a solution.

Regards,

Sankarsan

[Srikanth02 · Accepted solution]

Hi Sankarsan,

It is better to go with after week completion.. even if it is more than 30 hours, next time same hours wont be included as we considering based on week.

1st week    5 days    25 hours

2nd week   5 days     15 hours ----> shall i calculate in this point= (50/30)

[Sanky · Accepted solution]

Hi,

Another query i have that if 30days are going to end at the mid of the week then rest days will be counted for that week or next week onwards should start calculating.

And tell me what is the week 1st day and 7day?

Regards,

Sankarsan

[Srikanth02 · Accepted solution]

Hi Sankarsan,

First day is Sunday & 7th day is Saturday.

If 30 days is completing in mid week, include the remaining working days in the same week. So that it would be easy to check if we have any issue.

Srikanth

[Sanky · Accepted solution]

OK. You can go through the below document for point no 3.

If you have doubt then i will send the details design based on th epoint no 3.

Check and let me know.

Regards,

Sankarsan

[Srikanth02 · Accepted solution]

Hi Sankarsan,

Thankyou very much for the document and it was really helpful.

As per your above PCR ZWRK it will check for whether employee has worked 30 days or not for first accrual. And once it is accrued from second time onwards, how do I check for next 30 hours and that's where I got confused.

Srikanth

[Sanky · Accepted solution]

Hi,

If your query is answered then close the thread with correct answer marking.

Regards,

Sankarsan

[former_member182377]

Hi Srinkanth,

Are writing the PCR for Time? then why are you using the operation NUM here..

Use HRS and get the value, can you please share you PCR as well..

Thanks

Sriram