Dears,
I need a help to define the following element in payroll.
Now i need this element to deduct 2% from the basic salary in the first run for this element.
In the second, third and fourth run i want this element to be paused.
In the fifth, sixth, seventh,.........etc. run i want this element to deduct 0.5% from the basic salary.
Can anyone help me on this????? Please i need your help : (
Ibrahim
HRMS Implementer
I Need Help for Element Definition
-
- Posts: 12
- Joined: Mon Dec 25, 2006 4:58 am
- Location: Pakistan
-
- Posts: 258
- Joined: Sun Oct 12, 2008 1:50 pm
- Location: Saudi Arabia
- Contact:
Dear Abdilhaq,
Use the following Skip Rule:
==========================================
==========================================
/* Defaults Section */
default for SKIP_FLAG IS 'N'
Default For PAY_PROC_PERIOD_END_DATE is '4712/12/31 00:00:00'(date)
Default For EMP_HIRE_DATE is '0001/01/01 00:00:00'(date)
/* Formula Body */
no_of_months =trunc(months_between(PAY_PROC_PERIOD_END_DATE, EMP_HIRE_DATE))
if no_of_months <= 1 then
SKIP_FLAG = 'N'
ELSE IF no_of_months > 1 and no_of_months <=4 then
SKIP_FLAG = 'Y'
ELSE IF no_of_months > 4 then
SKIP_FLAG = 'N'
RETURN SKIP_FLAG
==========================================
==========================================
Also In Element Formula, put the calculation logic to deduct 2% on the first run, and 0.5 % on the fifth and above. Use the same function above.
I hope that helped...
Regards,
Ahmad Ghanem
Senior Oracle HRMS Consultant
Use the following Skip Rule:
==========================================
==========================================
/* Defaults Section */
default for SKIP_FLAG IS 'N'
Default For PAY_PROC_PERIOD_END_DATE is '4712/12/31 00:00:00'(date)
Default For EMP_HIRE_DATE is '0001/01/01 00:00:00'(date)
/* Formula Body */
no_of_months =trunc(months_between(PAY_PROC_PERIOD_END_DATE, EMP_HIRE_DATE))
if no_of_months <= 1 then
SKIP_FLAG = 'N'
ELSE IF no_of_months > 1 and no_of_months <=4 then
SKIP_FLAG = 'Y'
ELSE IF no_of_months > 4 then
SKIP_FLAG = 'N'
RETURN SKIP_FLAG
==========================================
==========================================
Also In Element Formula, put the calculation logic to deduct 2% on the first run, and 0.5 % on the fifth and above. Use the same function above.
I hope that helped...
Regards,
Ahmad Ghanem
Senior Oracle HRMS Consultant
<b><font face="Verdana">Dear Ahmad Ghanem,
Thank you so much for your reply...
But the problem is that i need this element to deduct 2% from the Basic Salary starting from the date that you entered that element and not the date of hiring i mean that no_of_months =trunc(months_between(PAY_PROC_PERIOD_END_DATE, EMP_HIRE_DATE)) will not work because it depends on the Hire Date and not the date of the element effective date...
Please help...</font id="Verdana"></b>
Thank you so much for your reply...
But the problem is that i need this element to deduct 2% from the Basic Salary starting from the date that you entered that element and not the date of hiring i mean that no_of_months =trunc(months_between(PAY_PROC_PERIOD_END_DATE, EMP_HIRE_DATE)) will not work because it depends on the Hire Date and not the date of the element effective date...
Please help...</font id="Verdana"></b>
-
- Posts: 258
- Joined: Sun Oct 12, 2008 1:50 pm
- Location: Saudi Arabia
- Contact:
Dear Abdilhaq,
You are most welcome dear. This forum is for sharing knwoledge, experience and opinions.
In my solution, I assumed that the element is entered starting from Employee Hire Date. If this is not the case then you can use Database Items such as "BASIC_SALARY_PAY_VALUE_START_DATE" to capture the start date of the bay value and include it in the FastFormula.
Alternativley, you can create a function that captures the effective start date of this element entry and use it in the Fast Formula that I suggested. Notice that this element should have an input value such as a sequence_id that is automatically generated to distinguish it when retrieving its date in the function, thus, the function should have a parameter of this sequence id.
I hope this helped
If you still have any queries, feel free to ask...
Best Regards,
Ahmad Ghanem
Senior Oracle HRMS Consultant
You are most welcome dear. This forum is for sharing knwoledge, experience and opinions.
In my solution, I assumed that the element is entered starting from Employee Hire Date. If this is not the case then you can use Database Items such as "BASIC_SALARY_PAY_VALUE_START_DATE" to capture the start date of the bay value and include it in the FastFormula.
Alternativley, you can create a function that captures the effective start date of this element entry and use it in the Fast Formula that I suggested. Notice that this element should have an input value such as a sequence_id that is automatically generated to distinguish it when retrieving its date in the function, thus, the function should have a parameter of this sequence id.
I hope this helped
If you still have any queries, feel free to ask...
Best Regards,
Ahmad Ghanem
Senior Oracle HRMS Consultant
-
- Posts: 12
- Joined: Mon Dec 25, 2006 4:58 am
- Location: Pakistan
<font color="blue">Dear Abdil Haq
Do u want to deduct from the basic salary whenever u rcieved instruction to do? if YES so solution is Make Balance of ASG_RUN (for Basic Salary) which will be passed in formula as an input (By this solution u will not have to create any function).
Remaining Skip rule will cater for the 1st & 5th run issue.</font id="blue">
<font color="maroon">Thanx
Shawaiz Khan --Pakistan</font id="maroon">
Do u want to deduct from the basic salary whenever u rcieved instruction to do? if YES so solution is Make Balance of ASG_RUN (for Basic Salary) which will be passed in formula as an input (By this solution u will not have to create any function).
Remaining Skip rule will cater for the 1st & 5th run issue.</font id="blue">
<font color="maroon">Thanx
Shawaiz Khan --Pakistan</font id="maroon">
Who is online
Users browsing this forum: No registered users and 3 guests