on 08-21-2014 6:57 AM
Hi Experts,
Here is the client requirement and please let me know how to solve this.
Earned Leave: after 1 year earned leave should generate and pro-rata quota should generate next year on jan 1st.
Example: if employee joins on 01/07/2012 after 1 year i.e 01/07/2013 quota should generate 22 days next year on 01/01/2014 pro-rata quota i.e 01/07/2013, 11 days pro-rata quota should generate. Total 22+11 =33 have to generate on 01/01/2014. and next year 01/01/2015 (22+11+22)=55.
Note: on 1/7/2013 = 22 days
on 1/1/2014 = 11 days +22 days; total=33
on 1/1/2015 = 33 days +22 days; total=55
Conditions: if employee joins before 15th date of current month include the current month, if employee joins after 15th date exclude the current month.
Hi Anil,
What kind of requirement is this?
Is there any company where the annual leave grant keeps on increasing every year? I would need to quit my job to join this company where I can enjoy more and more leaves.
Please consult your client and find out the details of the requirement and update.
I think you are mixing leave carry forward and annual leave grant.
Thanks and regards,
Vivek Barnwal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You will need 2-3 PCRs to address this.
In one PCR you need to query the Date of Hire (from IT0041 - I guess you are maintaining this) using HRS=YDAYxx - where xx is the date type. You can then check it it is the first year anniversary or not by using HRS?01. If the condition satisfies populate a custom time type with 22 days.
In another PCR, you need to check for 01 Jan by using HRS=BCURMO and HRS=BCURDY. In this PCR check again the length of service (see above). If it is more than 1, then proceed to give the pro-rata amount.
If the pro-rata formula is simple you can use the second PCR or you would need a 3rd PCR to get the pro rata amount. Using HRS=Y**** operator you can query many date differences which will help.
Regards
Pramod
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.