Global Absence Proration
The Global Absence Proration fast formula can be used to apply a proration factor (or a multiplication factor), onto the final accrual calculated and returned by the accrual calculation rules in an accrual based absence plan.
If an organization has an accrual plan where the accrual rate varies based on Worker grades, and on top of that if a multiplication factor such as 0.75 needs to be applied depending on the Worker work location, then the band based on grades can be defined in the accrual matrix and the multiplication factor of 0.75 based on work location can be defined in the Global Absence Proration formula.
Configuration Point in HCM Cloud
If you have created this formula, you can attach this formula to the absence plan definition.
Navigation
- In the Absence Administration work area, click Absence Plans to open the Absence Plans page.
- On the Search Results section toolbar, click Create to open the Create Absence Plan dialog box.
- In the Plan Type field, select Accrual.
- Click Continue.
- On the Edit Absence Plan page Accruals tab, Accrual Attributes section, select Formula in the Accrual Proration Rule field.
- Select the defined formula from the Accrual Proration Formula field.
Contexts
The following contexts are available in this formula type:
| Context Name | Data Type |
|---|---|
| ABSENCE_ENTRY_ID | Number |
| ABSENCE_TYPE_ID | Number |
| ACCRUAL_PLAN_ID | Number |
| DATE_EARNED | Date |
| EFFECTIVE_DATE | Date |
| END_DATE | Date |
| ENTERPRISE_ID | Number |
| HR_ASSIGNMENT_ID | Number |
| HR_RELATIONSHIP_ID | Number |
| HR_TERM_ID | Number |
| JOB_ID | Number |
| LEGAL_EMPLOYER_ID | Number |
| LEGISLATIVE_DATA_GROUP_ID | Number |
| ORGANIZATION_ID | Number |
| PAYROLL_ASSIGNMENT_ID | Number |
| PAYROLL_ID | Number |
| PAYROLL_RELATIONSHIP_ID | Number |
| PAYROLL_TERM_ID | Number |
| PERSON_ID | Number |
| START_DATE | Date |
Input Values
| Variable Name | Data Type | Description |
|---|---|---|
| IV_ACCRUAL | Number | Accrual value received from the accrual matrix |
| IV_CARRYOVER | Number | Carryover limit received from accrual matrix |
| IV_CEILING | Number | Ceiling limit received from the accrual matrix |
| IV_ACCRUALPERIODSTARTDATE | Date | Start date of accrual period |
| IV_ACCRUALPERIODENDDATE | Date | End date of accrual period |
| IV_CALEDARSTARTDATE | Date | Start date of accrual calendar year |
| IV_CALEDARENDDATE | Date | End date of accrual calendar year |
| IV_PLANENROLLMENTSTARTDATE | Date | Start date of enrollment |
| IV_PLANENROLLMENTENDDATE | Date | End date of enrollment |
| IV_ACCRUAL_CEILING | Number | Annual accrual limit from the accrual matrix |
Return Variables
| Variable Name | Data Type | Description |
|---|---|---|
| prorationFactor | Number | Multiplication factor used to pro-rate final accrual amount |
Sample Formula
Requirement: The organization has an accrual matrix based on grade of Workers. On top of the values defined by the matrix, Workers who belong to jobs ‘Wealth Management’ or ‘Trade Associate’ should have their annual accrual amount pro-rated by a factor of 0.75 as they have flexible working arrangements and do not fall under the standard absence accrual benefit policy of the organization.
Solution: Once the accrual rules are defined in the accrual matrix, a Global Absence Proration formula such as the one below can be used.
FORMULA NAME: ANC_PRORAT
FORMULA TYPE: Global Absence Proration
DESCRIPTION: This formula returns the proration factor accrual absence plan
DEFAULT FOR PER_ASG_JOB_NAME IS ' '
prorationFactor = 1
IF (PER_ASG_JOB_NAME = 'Wealth Management Consultant' OR PER_ASG_JOB_NAME = 'Trade Associate')
THEN
(prorationFactor = 0.75)
RETURN prorationFactor