Introduction
Before we start to understand How to create an Absence Plan first try to understand what an Absence Plan is and why is it required.
In real life Absence Plan holds a different meaning than that of the one meant in Fusion Applications.
In real life Absence Plan for an individual (or for that matter for a Working individual) relates more to a question which is generally asked by his Manager
What are your Absence Plans?
and he would generally respond stating I will be on leave on so and so dates.
But in context with Fusion Applications an Absence Plan (I feel the naming convention isn’t correct it should have been called Accrual Plan but that again is incorrect as Absence Plans are even those which are of qualification and No-Entitlement Type, details about the same in Absence Plan Types Section) could be imagined as a Bucket.
Yes, I mean a Bucket as we know.
Let’s for time being say an Absence Plan is an Absence Bucket and I call it as a Bucket as it is supposed to hold:
Leave / Absence Balance
Anything and everything around the Entire Absence Plan surrounds around this single piece of information usually called ‘Absence Balance’
Different Items related with an Absence Plan and their association with Absence Balance follows:
Absence Plan
A name given to a set of rules / guidelines which define how the absence balance will be assigned and maintained
Legislation
Geography / Country where this Absence Balance is Maintained. For Example, if we are doing Absence Plan setup for India Legislation would be India, if we are doing for USA it would be United States and so on....
Plan Type
An attribute which defines how the Absence Balance would be calculated / paid.
For example:
If Absence / Leave Balance is paid to employees as a result of an event such as childbirth, illness or injury it is called Qualification Plan Type Absence Plan
Typical Example Being Hospitalization Leave.
If Absence / Leave Balance is paid to employees as a result of accumulation / accrual it is called Accrual Plan Type Absence Plan
Leaves like Annual Leave, Vacation Leave fall into this category
If Absence / Leave Balance is paid without having any track, then we referred to them as No-Entitlement Plan Type Absence Plan
Marriage Leave, Compassionate Leave. fall into this category
Plan Term
This is basically the entire time period for which the absence balance has the validity.
For Example
Plan Term: Calendar Year
Start Day: 01
Start Month: 1
Means the Absence Plan will start on 1st day of 1st month (i.e. 1st January) and run till the end of calendar year i.e. 31-Dec
Plan Term: Calendar Year
Start Day: 01
Start Month: 2
Means the Absence Plan will start on 1st day of 2nd month (i.e. 1st February) and run till the end of calendar year i.e. 31-Dec
Plan Term: Calendar Year
Start Day: 05
Start Month: 10
Means the absence Plan will start on 5th day of 10th month (i.e. 5th October) and run till the end of calendar year i.e. 31-Dec
Absence Plan UOM
Unit of Measure which states in which unit (either of Days / Calendar Days / Hours) will this Absence Balance will get measured
Accrual Method
Method of accruing Absence / Leave Balance.
It is of two types:
a) Frontloaded
The Entire Absence Balance is allocated at the beginning of the plan term
b) Incremental
The Absence Balance are accrued at regular intervals
Accrual Frequency
Frequency at which accrual happens. It is of two types Person Primary Frequency and Repeating Period.
If person gets his absence / leave balance at the start of payroll period, then the Accrual Frequency is of Person Primary Frequency Type
For Example:
Person Primary Frequency: Weekly
Means he gets paid every week (Employee has a Weekly Payroll Assigned / Attached to him) and same is true for his absence balance too i.e. absence balance is
received every week (in synchronization with his person primary payroll payment frequency).
Person Primary Frequency: Bi-Weekly
Means he gets paid once in row weeks (Employee has a Bi-Weekly Payroll Assigned / Attached to him) and same is true for his absence balance too i.e. absence
balance is received once in two weeks (in synchronization with his person primary payroll payment frequency).
Person Primary Frequency: Monthly
Means he gets paid once a month (Employee has monthly payroll assigned / attached to him) and same is true for his absence balance too i.e. absence balance is
received once a month (in synchronization with his person primary payroll payment frequency).
Person Primary Frequency: Quarterly
Means he gets paid once in quarter (Employee has a Quarterly Payroll Assigned / Attached to him) and same is true for his absence balance too i.e. absence balance
is received once each quarter (in synchronization with his person primary payroll payment frequency).
If person gets his absence / leave balance at the start of each instance of a Specific Repeating Time Period, then Accrual Frequency is of Repeating Time Period
For Example:
Repeating Time Period: Every Quarter of a Calendar year
Means he will accrue this leave once every 3 months in the Calendar Year.
Repeating Time Period: Bi Monthly
Means he will accrue this leave 2 times in a month.
Repeating Time Period: Every Quarter of a Calendar year
Means he will accrue this leave once every 3 months in the Calendar Year.
Repeating Time Period: Monthly
Means he will accrue this leave once a month.
Ceiling
This means the maximum Accrual / Leave Balance an employee can accrue / store within a particular accrual term
For Example:
If for a particular Absence Plan the ceiling value is 10
It means that the employee can accrue at max 10 leaves per year. If his balance becomes more than 10 then the same will be forfeited.
If for a particular Absence Plan the ceiling value is 20
It means that the employee can accrue at max 20 leaves per year. If his balance becomes more than 10 then the same will be forfeited.
Carryover
This means the Absence / Leave Balance an employee can carry forward (take along with him) to next accrual term
For Example:
If for a particular Absence Plan has carryover as 50
It means that the employee can carry forward 50 leaves per year. This carry forward value would keep accumulating until ceiling value is reached
So if ceiling is 100 and employee has already carried forward 50 leaves from first year and again 50 from next year then he cannot carry forward leaves for 3rd year.
If for a particular Absence Plan the carryover as 60
It means that the employee can carry forward 60 leaves per year. This carry forward value would keep accumulating until ceiling value is reached
So if ceiling is 100 and employee has already carried forward 50 leaves from first year and again 50 from next year then he cannot carry forward leaves for 3rd year
Vesting Period
This is the Time Period during which Employees can accrue leave but cannot apply leave
For example, if a Plan starts on 1st January and has a vesting period of 1 month then the first leave which an employee can take would be a date after 1st February (1st January + 1 month). He would anyways be allowed to accrue during the entire January Month
Absence Payment Rate Rule
Method to calculate payment during an Absence Period. (a period when employee is absent from work, but still needs to be paid)
For Example, if a Female Employee is on Maternity Leave for 6 months then at what rate should she be paid.
Final Disbursement Rate Rule
Method to calculate payment of accruals when plan participation ends (An Employee became a Contractor from Regular Employee so his eligibility for Annual Leave comes to an end, but he has already had a positive balance of say 10. Now if the payroll is integrated with absence then employee needs to be paid for this accrued balance. This rate talks about the same Disbursement Rate Rule).
Discretionary Disbursement Rate Rule
Method to calculate payment when paying out part of accrual balance (An Employee resigns a company and he has a notice period of 30 days, he has served 25 days of notice period and he has an accrual balance of 10 days. Due to some emergency he has to go to his hometown and he seeks immediate relieving. In this case the company may decide to deduct his 5 days from Accrual balance and pay for the rest 5 at a discretionary rate).
Liability Rate Rule
Method to calculate cost of accrual balance to determine employer liability (An Employee resigns a company and he has a notice period of 30 days, he has served 25 days of notice period and he has an accrual balance of 10 days. Due to some emergency he has to go to his hometown and he seeks immediate relieving. In this case the company may decide to deduct his 5 days from Accrual balance and pay for the rest 5 at a discretionary rate and the rest 5 days will be paid at the Liability Rate).
Business Requirement
Now since we are aware of some of the most commonly used terms for an absence plans we should try to create one absence plan. Requirement is to create an Absence Plan with Absence Plan type as Accrual and Accrual Method as Incremental
We have the following requirement:
Absence Plan Type: Accrual
Accrual Method: Incremental
Accrual UOM: Days
Accrual Values: If Length of Service is < 3 years then Accrue 10 days, have a ceiling of 100 days and carryover of 50 days.
If Length of Service is < 3 years and Length of Service >= 5 years then Accrue 12 days, ceiling of 120 days and carryover of 60 days
If Length of Service is > 5 then Accrue 15 days, have a ceiling of 150 days and carryover of 75 days
Vesting Period: If Legal Employer is Vision Corporation Then Vesting Period is 90 Calendar Days Else Vesting Period is 30 Calendar Days
Absence Payment Rate Rule: Provide a Sickness Rate If the Employee is taking a Leave of Type Sick and Flu else use Hourly Rate
Final Disbursement Rate Rule: If Employee is of Hourly Salaried type use Hourly rate, if he is Regular Employee provide Annual Salary Rate
Discretionary Disbursement Rate Rule: If Employee is of Hourly Salaried type use Hourly rate, if he is Regular Employee provide Annual Salary Rate
Liability Rate Rule: If Employee is of Hourly Salaried type use Hourly rate, if he is Regular Employee provide Annual Salary Rate
We would be using Fast Formula (reasons supporting the same provided alongside) for the following attributes:
**Accrual Values: This can be achieved using an Accrual Matrix but we would like provide maximum flexibility and hence Fast Formula
Vesting Period: This requirement can only be achieved using Fast Formula
**Absence Payment Rate Rule: This requirement could have been met using the ‘Rate Definition’ option but for flexibility we have used Fast Formula
**Final Disbursement Rate Rule: This requirement could have been met using the ‘Rate Definition’ option but for flexibility we have used Fast Formula
**Discretionary Disbursement Rate Rule: This requirement could have been met using the ‘Rate Definition’ option but for flexibility we have used Fast Formula
**Liability Rate Rule: This requirement could have been met using the ‘Rate Definition’ option but for flexibility we have used Fast Formula
**Note: By Allowing Flexibility we mean in case there are additional complex logic in future then we can add the Fast Formula Code in the existing FF defined.
Justifications For Using Fast Formulas:
While some might debate that the entire absence plan could well have been setup using standard setups / configurations (and I do agree to that) but the below are specific reasons for using Fast Formula here:
-
Allows Flexibility of Adding Custom Logic (If required by customer at a Future Date)
Fast Formulas (Details in a separate article) generally allows us to add conditional logics (IF-ELSE constructs) and provide a way to customize the seeded solution.
For Example
Say currently we want to have a condition that if
Employee Category is Hourly then use RateCode as ‘Hourly Rate’
Employee Category is Salaried then use RateCode as ‘Salaried’
But after few days customer has changed the requirement and now they even want to ensure that any Salaried Employee who has been on leave for most of time during the year would rather be paid in terms of hours worked (typical example being someone on Leave Without Pay)
IF
Employee Category is Hourly then use RateCode as ‘Hourly Rate’
Else if
Employee Category is Salaried and Employee Payroll Status is Currently on Leave without Pay then ‘Hourly Rate’ ------ new requirement
Else
Employee Category is Salaried and Employee Payroll Status is Active Payroll Eligible then ‘Salaried’
end if
Now in order to accommodate the new requirement you would need to create a completely new Absence Plan with new setups and that would have many implications but if we use Fast Formula this can be achieved by just adding a piece of if-else construct.
-
Absence Plan Migration becomes a little easier
In all implementation projects setups needs to be once done in a Development POD (in EBS we referred them as INSTANCE) , and then the same is migrate to SIT, UAT , PRE-PROD and then PROD.
IF we use Fast Formula approach migration becomes simpler.
Perquisites for Setting up Absence plan ( using Fast Formula Approach):
You need to create multiple custom fast formula in the system (your POD) in the legislation where you want to create the absence plan.
Fast Formula Types Used in this Example:
There are 4 types of Fast Formula used in this example namely
-
Global Absence Plan Duration
-
Global Absence Accrual
-
Global Absence Vesting Period
-
Global Absence Plan Use Rate
Fast Formula Used in This Example:
There are 5 Fast Formula used in this example which are:
-
AH Global Absence Plan Duration Formula
-
AH Global Absence Accrual Formula
-
AH Global Absence Vesting Period Formula
-
AH Global Absence Plan Use Rate Selection Formula 1
-
AH Global Absence Plan Use Rate Formula2
Formula Details
# |
Formula Name |
Formula Type |
Formula Use |
||||||||||||||||||||||||||||||||||||
1 |
AH Global Absence Plan Duration Formula |
Global Absence Plan Duration |
For Custom Logic to calculate Absence Plan Duration Sample Example Below.
|
||||||||||||||||||||||||||||||||||||
2 |
AH Global Absence Accrual Formula |
Global Absence Accrual |
For Custom Logic to calculate Accrual, Ceiling, Carryover. Sample Example Below.
|
||||||||||||||||||||||||||||||||||||
3 |
AH Global Absence Vesting Period Formula |
Global Absence Vesting Period |
For Custom Logic to calculate Vesting Period Sample Example Below.
|
||||||||||||||||||||||||||||||||||||
4 |
AH Global Absence Plan Use Rate Selection Formula 1 |
Global Absence Plan Use Rate |
For Custom Logic to fetch the rate code required to pay employee in case of leave disbursement / encashment Sample Example Below.
|
||||||||||||||||||||||||||||||||||||
5 |
AH Global Absence Plan Use Rate Formula2 |
Global Absence Plan Use Rate |
For Custom Logic to fetch the rate code required to pay employee in case of leave disbursement / encashment Sample Example Below.
|
AH Global Absence Plan Duration Formula
AH Global Absence Plan Duration Formula |
|
Formula Name |
AH Global Absence Plan Duration Formula |
Formula Type |
Global Absence Plan Duration |
Description |
If leave falls on a Sunday then the leave hours deducted from leave balance should be 0 for all other cases it should be 8.5 hours |
Formula Text
/************************************************************************************
FORMULA NAME: AH Global Absence Plan Duration Formula
FORMULA TYPE: Global Absence Plan Duration
DESCRIPTION: This sample formula returns the duration based on effective date falls on Sunday.
Change History:
Name Date Comments
--------------------------------------------------------------------------------------------
XXXXXXX DD-MM-YYYY XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
--------------------------------------------------------------------------------------------
************************************************************************************/
/*================ FORMULA SECTION BEGIN =======================*/
l_date=GET_CONTEXT (EFFECTIVE_DATE,'4712/12/31 00:00:00' (date))
l_weekday=to_char(l_date,'DAY')
If (l_weekday= '7')
then (
duration=0
)
else (
duration=8.5
)
/*================ FORMULA SECTION END =======================*/
return duration
AH Global Absence Accrual Formula |
|
Formula Name |
AH Global Absence Accrual Formula |
Formula Type |
Global Absence Accrual |
Description |
This sample formula applies the Accrual, Ceiling, Carryover, Proration Factor, Vesting Units, Vesting UOM, Carryover Proration and Ceiling Proration based on Length of Service and Accrual Plan the person enrolled into |
Formula Text
/*****************************************************************
FORMULA NAME: AH Global Absence Accrual Formula
FORMULA TYPE: Global Absence Accrual
This sample formula applies the Accrual, Ceiling, CarryOver, Proration Factor, Vesting Units, Vesting UOM, CarryOver Proration and Ceiling Proration
based on Length of Service and Accrual Plan the person enrolled into.
Change History:
Name Date Comments
------------------------------------------------------------------------------------------------------------
XXXXXXX DD-MM-YYYY XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
------------------------------------------------------------------------------------------------------------
*****************************************************************/
/*=========== DATABASE ITEM DEFAULTS BEGIN =====================*/
DEFAULT for PER_ASG_REL_ORIGINAL_DATE_OF_HIRE is '4712/12/31 00:00:00' (date)
DEFAULT for ANC_ABS_PLN_NAME is 'A'
DEFAULT for ANC_ABS_PLN_PLAN_UOM is 'H'
/*=========== DATABASE ITEM DEFAULTS ENDS======================*/
/*================ FORMULA SECTION BEGIN =======================*/
l_no_of_days=DAYS_BETWEEN(GET_CONTEXT(EFFECTIVE_DATE,'4712/12/31 00:00:00' (date)),PER_ASG_REL_ORIGINAL_DATE_OF_HIRE)
l_length_of_service=(l_no_of_days/365)
/* check if employee enrolled into this plan or not */
if (ANC_ABS_PLN_NAME='BM_US_ABSENCE_ACCRUAL_PLAN')
then(
if(ANC_ABS_PLN_PLAN_UOM ='H')
then(
if(l_length_of_service <3)
then(
accrual =10
ceiling = 100
carryover=50
prorationFactor=0.25
vestingUnits=40
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if ((l_length_of_service =>3) and (l_length_of_service<5))
then (
accrual =12
ceiling = 120
carryover=60
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if (l_length_of_service =>5)
then (
accrual =15
ceiling = 150
carryover=75
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
) )
else if (ANC_ABS_PLN_PLAN_UOM ='D')
then(
if (l_length_of_service <3)
then(
accrual =round(10/24,3)
ceiling = round(100/24,3)
carryover=round(50/24,3)
prorationFactor=0.25
vestingUnits=40
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if ((l_length_of_service =>3) and (l_length_of_service<5))
then (
accrual =round(12/24,3)
ceiling = round(120/24,3)
carryover=round(60/24,3)
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if (l_length_of_service =>5)
then (
accrual =round(15/24,3)
ceiling =round(150/24,3)
carryover=round(75/24,3)
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
)
else if (ANC_ABS_PLN_PLAN_UOM ='W')
then(
if (l_length_of_service <3)
then(
accrual =round(10/120,3)
ceiling = round(100/120,3)
carryover=round(50/120,3)
prorationFactor=0.25
vestingUnits=40
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if ((l_length_of_service =>3) and (l_length_of_service<5))
then (
accrual =round(12/120,3)
ceiling = round(120/120,3)
carryover=round(60/120,3)
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if (l_length_of_service =>5)
then (
accrual =round(15/120,3)
ceiling =round(150/120,3)
carryover=round(75/120,3)
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)))
if (ANC_ABS_PLN_NAME='Sickness')
then(
if(ANC_ABS_PLN_PLAN_UOM ='H')
then(
if(l_length_of_service<3)
then(
accrual =12
ceiling = 120
carryover=60
prorationFactor=0.25
vestingUnits=40
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if ((l_length_of_service =>3) and (l_length_of_service<5))
then (
accrual =13
ceiling = 130
carryover=70
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if (l_length_of_service =>5)
then (
accrual =14
ceiling = 160
carryover=80
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25 ))
else if (ANC_ABS_PLN_PLAN_UOM ='D')
then(
if (l_length_of_service <3)
then(
accrual =round(12/24,3)
ceiling = round(120/24,3)
carryover=round(60/24,3)
prorationFactor=0.25
vestingUnits=40
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if ((l_length_of_service =>3) and (l_length_of_service<5))
then (
accrual =round(13/24,3)
ceiling = round(130/24,3)
carryover=round(70/24,3)
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if (l_length_of_service =>5)
then (
accrual =round(14/24,3)
ceiling =round(160/24,3)
carryover=round(80/24,3)
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
))
else if (ANC_ABS_PLN_PLAN_UOM ='W')
then(
if (l_length_of_service <3)
then(
accrual =round(12/120,3)
ceiling = round(120/120,3)
carryover=round(60/120,3)
prorationFactor=0.25
vestingUnits=40
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if ((l_length_of_service =>3) and (l_length_of_service<5))
then (
accrual =round(13/120,3)
ceiling = round(130/120,3)
carryover=round(70/120,3)
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)
else if (l_length_of_service =>5)
then (
accrual =round(14/120,3)
ceiling =round(160/120,3)
carryover=round(80/120,3)
prorationFactor=0.25
vestingUnits=30
vestingUOM='C'
carryOverProration=0.25
ceilingProration=0.25
)))
Return accrual, ceiling, carryover, prorationFactor, vestingUnits, vestingUOM, carryOverProration,ceilingProration
AH Global Absence Vesting Period Formula
AH Global Absence Vesting Formula |
|
Formula Name |
AH Global Absence Vesting Period Formula |
Formula Type |
Global Absence Vesting Period |
Description |
This sample formula applies the Ceiling based on employment category. If the Employee belongs to a specific Legal Employer (Vision Corporation for this example) then his Vesting Period ( Number of Days after which he is allowed to use his accrued leaves) is 90 Calendar Days for any other Legal Employer it is 30 |
Formula Text
/********************************************************************
FORMULA NAME: AH Global Absence Vesting Period Formula
FORMULA TYPE: Global Absence Vesting Period
DESCRIPTION: This sample formula applies the vesting period based on employment category.
If the Employee belongs to a specific Legal Employer (Vision Corporation for this example)
then his Vesting Period (Number of Days after which he is allowed to use his accrued leaves) is 90 Calendar Days for any other Legal Employer it is 30 Days
Change History:
Name Date Comments
-----------------------------------------------------------------------------------------------------------------
XXXXXXX DD-MM-YYYY XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
----------------------------------------------------------------------------------------------------------------
********************************************************************/
/*==============DATABASE ITEM DEFAULTS BEGIN =====================*/
DEFAULT for PER_ASG_ORG_LEGAL_EMPLOYER_NAME is 'Vision'
/*==============DATABASE ITEM DEFAULTS ENDS======================*/
/*================== FORMULA SECTION BEGIN =======================*/
If (PER_ASG_ORG_LEGAL_EMPLOYER_NAME='Vision Corporation')
then (
vestingUOM = 'C'
vestingUnits=90
)
else(
vestingUOM = 'C'
vestingUnits=30)
/*=================== FORMULA SECTION END =======================*/
return vestingUOM,vestingUnits
AH Global Absence Plan Use Rate Selection Formula 1
AH Global Absence Plan Use Rate Selection Formula 1 |
|
Formula Name |
AH Global Absence Plan Use Rate Selection Formula 1 |
Formula Type |
Global Absence Plan Use Rate |
Description |
This sample formula returns the rate code. We have defined two different rate codes namely Sickness Rate and Hourly Rate. If an individual chooses either an Absence Type of Sick or Flu the RateCode is Sickness Rate else its Hourly Rate |
Formula Text
/***********************************************************************
FORMULA NAME: AH Global Absence Plan Use Rate Selection Formula 1
FORMULA TYPE: Global Absence Plan Use Rate
DESCRIPTION: This sample formula returns the rate code.
We have defined two different rate codes namely Sickness Rate and Hourly Rate.
If an individual chooses either an Absence Type of Sick or Flu the RateCode is Sickness Rate else its Hourly Rate.
Change History:
Name Date Comments
---------------------------------------------------------------------------------------------------------------------
XXXXXXX DD-MM-YYYY XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
--------------------------------------------------------------------------------------------------------------------
***********************************************************************/
/*=========== DATABASE ITEM DEFAULTS BEGINS======================*/
DEFAULT for ANC_ABS_TYP_NAME is 'Sick'
DEFAULT for ANC_ABS_RSN_NAME is 'Cough'
/*=========== DATABASE ITEM DEFAULTS ENDS======================*/
/*================ FORMULA SECTION BEGIN =======================*/
if ((ANC_ABS_TYP_NAME='Sick’) AND (ANC_ABS_RSN_NAME='Flu'))
then (
rateCode='Sickness Rate'
)
else (
rateCode='Hourly Rate')
/*================ FORMULA SECTION END =======================*/
return rateCode
AH Global Absence Plan Use Rate Formula 2
AH Global Absence Plan Use Rate Formula2 |
|
Formula Name |
AH Global Absence Plan Use Rate Formula2 |
Formula Type |
Global Absence Plan Use Rate |
Decription |
This sample formula returns the Plan Use Rate. If an Individual is Paid on Hourly Basis his RateCode will be Hourly else it would be Annual Salary |
Formula Text
/***********************************************************************
FORMULA NAME: AH Global Absence Plan Use Rate Formula2
FORMULA TYPE: Global Absence Plan Use Rate
This sample formula returns the Plan Use Rate. If an Individual is Paid on Hourly Basis his RateCode will be Hourly else, it would be Annual Salary
Change History:
Name Date Comments
--------------------------------------------------------------------------------------------
XXXXXXX DD-MM-YYYY XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
--------------------------------------------------------------------------------------------
***********************************************************************/
/*=========== DATABASE ITEM DEFAULTS BEGIN =====================*/
DEFAULT for PER_ASG_HOURLY_SALARIED_CODE is 'H'
/*=========== DATABASE ITEM DEFAULTS ENDS======================*/
/*=========== FORMULA SECTION BEGIN======================*/
if (PER_ASG_HOURLY_SALARIED_CODE='H')
then (
rateCode='Hourly Rate'
)
else (
rateCode='Annual Salary Rate'
)
/*=========== FORMULA SECTION END======================*/
RETURN rateCode
Screenshots
Setup Steps
Each absence plan setup requires four Tabs to be filled namely:
-
PLAN ATTRIBUTES
Contains Details about Plan Name, Description, Legislative Data Group, Processing Level, Conversion Formula Attached (used for Absence Duration calculation)
-
PARTICIPATION
Contains Details about Basic Plan Details, Enrollment and Termination Rules
-
ACCRUALS
Contains Details about Accrual Attributes like Accrual Formulas, Payment Percentage, Accrual Method, Accrual Frequency.
-
ENTRIES AND BALANCES
Contains Details about Balance Updates, Rates and Payroll Integrations
Navigation is as shown below:
Login to Fusion Applications -> Click on Navigator -> Click on ‘Setup and Maintainenance’-> In “All Tasks” Search for “Manage%Absence%Plan”
Click on Create Button and populate the following details:
LABEL |
VALUE |
Effective As of Date |
09/18/14 |
Legislation |
India |
Plan Type |
Accrual |
You may populate the following screen with above details
Populate Plan Attributes Tab:
This Tab Consists of 4 parts which are:
-
General Attributes
-
Plan Term
-
Legislative Information (Optional Used for Populating Legislative Specific Absence Information. Not Applicable in this example)
-
Descriptive Information (Optional Used for Populating DFF Fields If Created for Absence Plan. Not Applicable in this example)
Populate the following details in General Attributes Section as shown below:
General Attributes |
|
LABEL |
VALUE |
Plan |
XX AH Annual Absence Plan IN |
Description |
Annual Absence Plan Created for India |
Plan UOM |
Days |
Legislative Data Group |
IN Legislative Data Group |
Status |
Active |
Enable Concurrent Entitlement |
Unchecked |
Processing Level |
Assignment |
Conversion Formula |
AH Global Absence Plan Duration Formula |
Populate the following details in Plan Term Section as shown below:
Plan Term |
|
LABEL |
VALUE |
Type |
Calendar Year |
Calendar |
|
Start Month |
01 |
Start Day |
1 |
Use the above details and populate the Plan Attributes Tab and the screenshot would look like:
Populate Participation Tab:
This Tab Consists of 2 parts which are:
-
Enrollment Rules
-
Termination Rules
Populate the following details in Enrollment Rules Section as shown below:
Enrollment Rules |
|
LABEL |
VALUE |
Enrollment Start Rule |
As of Event |
Waiting Period UOM |
Calendar Days |
Duration |
30 |
Populate the following details in Termination Rules Section as shown below:
Termination Rules |
|
LABEL |
VALUE |
Enrollment End Rule |
As of Event |
On Employment Termination |
|
LABEL |
VALUE |
Positive Accrual Balances |
Checked |
Negative Accrual Balance |
Checked |
On Loss of Plan Eligibility |
|
LABEL |
VALUE |
Disburse Positive Balance |
Checked |
Recover Negative Balance |
Checked |
Use the above details and populate the Participation Tab and the screenshot would look like:
Populate Accruals Tab which consists of Accrual Attributes Section only.
Populate the following details in Accrual Attributes Section as shown below:
Accrual Attributes |
|
LABEL |
VALUE |
Accrual Definition |
Formula |
Accrual Formula |
AH Global Absence Accrual Formula |
Payment Percentage |
100% |
Accrual Method |
Incremental |
Partial Accrual Period Formula |
|
Accrual Vesting Rule |
Formula |
Vesting Period Formula |
AH Global Absence Vesting Period Formula |
Accrual Frequency Source |
Person Primary Frequency |
Use the above details and populate the Accruals Tab and the screenshot would look like:
Populate Entries and Balances Tab.This Tab Consists of 3 Sections which are:
-
Balance Updates
-
Rates
-
Payroll Integration
Populate the following details in Balance Updates Section as shown below:
Balance Updates |
|
LABEL |
VALUE |
Discretionary Disbursements of Accrual Balance |
Checked |
Accrual Balance Transfers Across Plans |
Checked |
Other Adjustments |
Checked |
Other Adjustment Reasons |
Clerical Error , Compensatory |
Populate the following details in Rates Section as shown below:
Rates |
|
LABEL |
VALUE |
Absence Payment Rate Rule |
Formula |
Formula |
AH Global Absence Plan Use Rate Selection Formula 1 |
Final Disbursement Rate Rule |
Formula |
Formula |
AH Global Absence Use Rate Formula2 |
Discretionary Disbursement Rate Rule |
Formula |
Formula |
AH Global Absence Plan Use Rate Selection Formula 1 |
Liability Rate Rule |
Formula |
Formula |
AH Global Absence Use Rate Formula2 |
Populate the following details in Payroll Integration Section as shown below:
Payroll Integration |
|
LABEL |
VALUE |
Transfer absence payment information for payroll processing |
Checked |
Element |
Annual Leave |
Use the above details and populate the Entries and Balances Tab and the screenshot would look like:
If this check box is not selected (Element field will not show a field value of Annual Leave rather it will be empty)
Once all the above setup is done Absence Plan Creation is complete.
Comments
I'm not sure why but I think its a linking issue. I've tried it in two different web
browsers and both show the same outcome.
Take a look at my homepage; negligence lawyer: http://appdev.163.ca/dz163/home.php?mod=space&uid=3406792
am browsing this website and reading very informative articles at this time.
My homepage - lawyers Las Vegas: https://socialbookmarknew.win/story.php?title=12-questions-to-ask-a-private-injury-lawyer
got the bravery to go ahead and give you a
shout out from Huffman Texas! Just wanted to say keep up the great
job!
iclqdzcvcxbnbjz wvb
I have always disliked the idea because of the expenses.
But he's tryiong none the less. I've been using Movable-type on various websites for about a year and am
anxious about switching to another platform.
I have heard fantastic things about blogengine.net.
Is there a way I can import all my wordpress content into
it? Any help would be greatly appreciated!
My website enjoy playing poker: https://ohioinv.Mthouston.net/members/AnthonySob/
send you an email. I've got some ideas for your blog you
might be interested in hearing. Either way, great
site and I look forward to seeing it expand over time.
Take a look at my webpage - hair Loss: https://Eladhub.com/community/profile/sadiehickman647/
my web site; business Selling: http://blakeottinger.com/fluxbb/viewtopic.php?id=1536980
also happy to share my experience here with friends.
Feel free to visit my homepage: 현금바둑이: http://Lymelightwebs.net/user/setting/marvineast/
I truly appreciate people like you! Take care!!
Feel free to surf to my blog post :: 바둑이게임: http://Ihaan.org/news/the-best-poker-room-in-nevada-it-requires-to-be-the-venetian/
I have saved it for later!
Look into my webpage - 바둑이게임: http://Anontop.gq/index.php?a=stats&u=knwmargherita
own opinions to give.
with us so I came to look it over. I'm definitely
enjoying the information. I'm book-marking and will be tweeting this to my followers!
Fantastic blog and excellent style and design.
to .net from PHP. I have always disliked the idea because
off the expenses. But he's tryiong none thhe less. I've been using Movable-type on a variety of websites
for about a year and am anxious about switching to another platform.
I have heard very good things about blogengine.net. Is there a way I
can import all my wordpress posts into it?Any
kkind of help would be really appreciated!
Feel free to visit myy web-site ... киного: http://kinogoo.top
yet.
The text in your content seem to be runniung off the
screen in Safari. I'm not sure if this iss a
format issue or something to do with browser compatibility but I figured I'd post to leet
you know. The layout look great though! Hope you get the problem
fixed soon. Cheers
my site; http://Zhinka.tv: http://Zhinka.tv
regarding this paragraph, in my view its genuinely remarkable in favor of me.
Look into my webpage - Сериалы онлайн: http://lostfiilm.com
a user in his/her mind that how a user can understand it.
Thus that's why this article is amazing. Thanks!
experience, well, keep uup the nice work fellows.
Stop by my web page :: XXX Photos Galleries: https://girl.swingerapp.cc
Please stfay us informed like this. Thanks for sharing.
Also visit my blog post bee Removal: https://arborist.Topnewshq.com/
to find this matter to be really something that I feel I'd never understand.
It sort of feels too complex and extremely wide for me. I am taking a look ahead on your next publish, I'll try
to get the cling of it!
your site, how can i subscribe for a blog site? The
account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear concept
you amend your site, how can i subscribe for a weblog web site?
The account helped me a appropriate deal. I had been a little bit familiar of
this your broadcast provided vibrant clear concept
organic food products a dating sites guide you could use system to communicate with Ukrainian lady. practically no widespread time-scehdule do the job with here, and yes it all hangs on the website you are choosing, offer in order to surfing it, the volume of your girls are generally interaction featuring, And a few other reasons. additional, appropriate Ukrainian online dating sites even use SSL security moreover special protects to make bank cards billing. additionally, entertainment this specific repair is other half, Then into your market on very expensive cafe. make the visit to Ukraine hoping coming from all getting a Ukrainian women as relationship. Ukrainian girlfriend, what is going on possible that by 10-15 five to ten years, also the fact is that should you specific by choosing women 30-40 extended time younger because your mind it really won't happen! Badoo is a trendy so remarkable dating site/app containing bee all around for a long time now it is usually one of the main global adult dating sites on earth, you can easily connect with Ukrainian most women subsequent, nevertheless routinely it is for younger group, some even assert it might be more of a chill web site. as for the total cost of your Ukrainain online dating that is difficult say but you can try in $10-15,000 modern casino least much more 2/3 several.
a wide selection of girls add video lessons, So it’s a honest joy to explore very new individuals and believe that good day to these people! can someone say any lasting love is often vehicles operate or from the gift, A non secular, clever and / or maybe super affiliation? indeed just be yourself, economize that long-establishe d gentleman’s action for her, and you will love the outcome. after you set up a account on each place, a person quickly penetrate in to a maelstrom attached to marketing thanks to brilliant females hailing from Ukraine. Ukraine provides Skype, Just like every older women across Ukraa cell phonee has. all right Ukrainian those do what to see happy their appearance truthfully you know what? uncovering those Ukrainian pregnant women On an honest Ukrainian matchmaking world wide web site suitable for life, Yes You can really Do It! The nice thing about it tips yes it truly is possible ukrainian brides to get your ex girlfriend in Ukraine supplying you are practical as part of hunts additionally shown interest in a genuine applicable Ukrainian adult dating blog.
good laugh is an excellent piece of equipment for the purpose of focusing within to teasing. the most developed men have a stereo design look and feel because of Ukrainian women and that is exactly usually in height, reduce at golden-haired scalp as well as,while violet loving.The very good news let me suggest that stereo class brand you really have of Ukrainian people is actually really not remote the commemorate. you do have a good job, consider off folks, a remarkable vehicles. and don’t encounter women who ask for money prior to visiting, Don’t time women who is only to snack in high priced cafes, tend not to appointment women who have an interest in your financial position locally, It help quite simply. But you genuinely carful whether or not any and all Ukrainain those gets a big fixation on your earning and so expenses as it will in all probability behave badly obtainable at a later stage, your girlfriend's attract will likely in only a concept and that is fleecing you from because much finance it can be. bucks to use. one course of action is to retain certainly faraway from charm excursions, often is the case a driver will be make payment on women to go or even several of them who will as a result consistently be committed and just seeking to get some extra money.
alone place.
Also visit my web site ... fioricet 180
tablets: https://fioricet.store
style is awesome, keep up the good work!
Feel free to visit my web blog :: fioricet w/ codeine: https://fioricet.store/
put up was once good. I do not recognize who you might be but
definitely you are going to a well-known blogger for those who
are not already. Cheers!
Also visit my web blog - buy fioricet onlin: https://fioricet.store
have really enjoyed surfing around your blog posts.
In any case I will be subscribing to your feed and I hope you write again soon!
my web-site order fioricet 120: https://fioricet.shop/
updated on a regular basis. It carries nice data.
Also visit my web-site :: fioricet florida: https://fioricet.store/
get started and create my own. Do you require any coding expertise to make
your own blog? Any help would be greatly appreciated!
Feel free to surf tto my web pqgе - gidonline (ցidonliine.biz : http://gidonliine.biz)
in supρort of me, keep up ⲣoѕting such articlеs.
my web рage :: Kinogo: http://kiinogo.biz
lot of unique content I've either createɗ ysеlf or outsouгced but it seems a lot of it is popping it upp all over the web without myy agreement.
Do yoou know аny techniques tto help stop ϲontent from being ripped off?
I'ɗ certainly appreciate it.
Visit my webpage; hdrezkаa.com (hdrezkaa.com: http://hdrezkaa.com)
ass compared to books, as I found this paragrаph at
this web site.
My website: HD Rezka - the-hdrezкa.com : http://the-hdrezka.com -
I'm kinda paranoid about losing everything I've worked
haгd on. Any recommendations?
Heere is my blog мультфільми (Darϲy: http://eskimoska.com)
IE nonetheⅼess is the marketplace chief and a big element of other people
wlⅼ leave out your magnificent writing due to this pгоblem.
Herе is my web site; hdrezkaa.com: http://hdrezkaa.com
of this ᴡebpaɡe; this blog carries amazіng ɑnd actually exceⅼlent
data for readers.
Reѵiew my wеb blog: Kinoogo.Biz: http://kinoogo.biz
and І have learned ⅼot of things frоm it on the topic of blogging.
thanks.
Take a looқ at my webpage - lordfilm: http://tv.lordfilm-lu.com
pleasant.
Also visit my web site; kinoogo.biz: http://kinoogo.biz
Keep on posting!
Review my blog poѕt Gidonline.lu: http://gidonline.lu
Here is my homepage ... Lordfilm: http://lordfilm-lu.com
amazing, nice wriften ɑnd include approximately aⅼl significant infos.
Ι would like to sеe extra posts like this .
Take a look at myy ѕite lordfilm (Http://loordfilm.lu/: http://loordfilm.lu)
and let you know a feѡᴡ of the pictᥙres aren't
loading properly. I'm not ѕure why but I think its a linking issue.
I've tried it in twoo different web browsers and both show the same outcome.
my web-site; lordfilm: http://lordfilm-lu.com
I am sure.
Take a look at my page: ΗD Rezkа: http://hdrezka.lu
a usaer of net thus frօm now I am using net fоr aгticles, thanks to web.
Lօok into my website - looгdfilm.Lu (loordfilm.lu: http://loordfilm.lu)
Extremely helpful information specіfically thhe last part :) I care fⲟr such іnfо a lot.
I was seeing this certain info for a very long time. Thank you and gooԀ luck.
Feel free to surf to my site маньхуа: http://com-x.life
RSS feed for comments to this post