Skip to Content
Author's profile photo @ Dey Sankarsan

Absence Quota Generation Monthwise Constant with Mid Month Joinees Pro Rata.

Hi,

Recently i have been gone through the below scenario in the scn and by which i have deen designed the solution.

Earned leave, on monthly basis it has to be added from April-March through time evaluation but the entitlement should be rounded off since it is 2.17 leaves 26/12=2.17 & it should be distributed in the 6th & 12th months for regular employees which means during the September & March the Earned leaves should be 3 & rest all months it should be 2 only which is 26 per year . For mid joiners, the earned leaves should be rounded off to 2 if the employee joins before 15th & 1 if the employee joins after 15th of the month(Rest all months it should be same).

For above the scenario kindly find the approach and solution of my reply on that thread link Privilege Leave Adjustment

Testing Scenario:-

1. Employee joins on tha August 19th 2014.

So in the August month he should get 1 quota since it’s less that half of 2.17 month accrual.

/wp-content/uploads/2014/10/1_570862.png

Same employee will get quota value 3 in the month of september. So i am assuming that he has not used his quota from august so on the september end he will be having total (1+3)=4 quota value.

/wp-content/uploads/2014/10/1_570862.png

2. Now in the second scenario thesting that employee joins on 8th September 2014.

So on the September he should get 2 quota value because it lies in between 1.085 to 2.17.

/wp-content/uploads/2014/10/1_570862.png

again i am assuming that employee has not yet the quota for the month september.so after october he will have (2+2)= 4 quotas in his account.

/wp-content/uploads/2014/10/1_570862.png

In the following we can achieve the above business requirement. Hope so you all are understood the requirment details, process design, testing scenarion cases. Any inputs are highly thankful to me for document ugradation and as well as come with new solution ideas.

Thanks,

Sankarsan Dey

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good document sankarsan..

      Vijay

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Hi Vijay,

      Thanks. Please rate the document.

      Regards,

      Sankarsan

      Author's profile photo Former Member
      Former Member

      This is a very useful information, Sanskaran.. Thanks for the same..

      Regards,

      Vamsi

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Hi Vamshi,

      Thanks. Please rate the document.

      Regards,

      Sankarsan

      Author's profile photo Venkatesh Orusu
      Venkatesh Orusu

      Nice document Sankarsan if you do not mind can you check if employee joins on 16.08.2014 what could be the output.

      Regards

      Venkatesh

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Hi Vankatesh,

      thanks.

      It's working. If you found any error please let me know.

      You can check with the 1st Example which i had shared.

      Regards,

      Sankarsan

      Author's profile photo Venkatesh Orusu
      Venkatesh Orusu

      First example is with 19.08.2014 so it works but 16.08.2014 as per logic 2.17 will have to pro rate, Condition is if employee joins after 15.08.2014 quota has to generate 1 day but as per logic 16 to 31 16 days and calculation might happens on the prorata basis(Monthly) 2.17/31 = 0.07 *16 =1.12 and rounded it to nearest value 1.085 2.17 - 2 is it works can you cross check.

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Hi Venkatesh,

      Thanks for your input.

      See if employee joins on the 16th then it would not be mid month for July and August month or for 31day's month. At the same time for Feb how you will be taking consider 🙂 .

      I think you understood and even client is doing same way. If i am not wrong.

      But still client wants to do like that what you said then we can further drilling the rounding rule also required one PCR for feb month calculation.

      Check and tell me.

      Regards,

      Sankarsan

      Author's profile photo Venkatesh Orusu
      Venkatesh Orusu

      See am not the right person to say that if employee joins on 16th whether they are going to consider him as mid join's or not even though if they consider him as mid join how much quota should be given to employee is up to them.

      Where this is a general case mid join's term comes in to the picture when ever employee joins not on 1st day of the month and last day of the month and in general 1st 15 days can be considered into 1st half of the month 16 to end considered as 2nd half.

      So that reason i had given a input how we can handle in that case That's all.

      Regards

      Venkatesh

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Ok.

      Can you tell me what's your design to handle this and share with me.

      Regards,

      Sankarsan

      Author's profile photo Venkatesh Orusu
      Venkatesh Orusu

      Before going to that solution i have one more input if employee joins in the mid of the month(either 1st half or 2 nd half of the month) which is either September or March what is the quota accrual, As per the existing configuration it gives 2 days.

      For this requirement from my end the solution is HRS=FDAAXX better you go for that option if you are okay with that.

      Regards

      Venkatesh

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Hi ,

      Thanks for your valuable input. I will check.

      Regards,

      Sankarsan