Global Absences Annual Accrual Limit Proration
The Global Absence Annual Accrual Limit Proration fast formula can be used in cases where a proration factor (or a multiplication factor) needs to be applied onto the annual accrual limit rule.
An organization has a rule that asks for the annual accrual limit to be prorated based on FTE value of the worker. In such a case, after defining the annual accrual limit rule, the annual accrual limit proration rule can be specified using this formula to return a proration factor, which is multiplied onto the annual accrual limit before returning the final value against the worker’s enrollment data.
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 Plan Limits section, select a value other than None in the Annual Accrual Limit Rule field.
- After defining the Annual Accrual Limit Rule as desired, select Formula in the Limit Proration Rule field.
- Select the defined formula from the Limit 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_ACCRUAL_CEILING | Number | Annual accrual 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 |
Return Variables
| Variable Name | Data Type | Description |
|---|---|---|
| PRORATIONFACTOR | Number | Multiplication factor for annual accrual ceiling limit |
Sample Formula
Requirement: The organization has an annual accrual limit rule, which allows workers to accrue up to a maximum of 35 days. This Annual year accrual limit needs to be prorated by FTE of workers who have the jobs ‘Wealth Management’ or ‘Trade Associate’ assigned against their assignment record.
Solution: A Global Absences Annual Accrual Limit Proration fast formula such as the one below can be used.
FORMULA NAME: ANC_ANNUALCEILPRORAT
FORMULA TYPE: Global Absences Annual Accrual Limit Proration
DESCRIPTION: This formula returns the proration factor for the annual accrual ceiling limit for the absence plan
DEFAULT FOR PER_ASG_FTE_VALUE IS 1
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 = ROUND(PER_ASG_FTE_VALUE,2))
RETURN PRORATIONFACTOR