Global Absence Elective Disbursement Evaluation Formula
The Global Absence Elective Disbursement Evaluation formula is used to validate elective disbursements in an accrual plan and set payment percentages for the disbursement. The formula can also be used to override the disbursement amount elected by the worker.
An organization might have a rule such that if an employee’s accrual balance as of the election date is below a certain minimum threshold limit, then the disbursement should not be allowed. Whereas, if the balance is between two other threshold values, then the payment percentage should be 75%. In such cases, you can compose a Global Absence Elective Disbursement Evaluation formula and attach it to the accrual plan.
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 Carryover Rule field.
- After defining the carryover rule as desired, select Formula in the Carryover Proration field
- Select the defined formula from the Carryover 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_BAND_CHG_DT1* | Date | If the accrual matrix band definition consists of grades or derived factors length of service or age, then this input value fetches the date on which worker has had a change in any of these factors within the period. |
| IV_BAND_CHG_BEFVAL1* | Number | Accrual value as per the matrix before IV_BAND_CHG_DT1 |
| IV_BAND_CHG_AFTVAL1* | Number | Accrual value as per the matrix after IV_BAND_CHG_DT1 |
| IV_EVENT_DATES | Date_Number | Array of dates returned by the Accrual Event formula. |
| IV_ACCRUAL_VALUES | Number_Number | Array of accrual values fetched from the accrual matrix as of the dates contained in the accrual event dates array. |
| IV_ACCRUAL_CEILING | Number | Annual accrual limit from the accrual matrix |
| IV_DISB_TYPE | Text | The disbursement type for current record which is being processed. Possible values: CSH / ORA_ANC_CSH_YREND / ORA_ANC_ELECT_DISB |
| IV_DISB_VALUE | Number | The disbursement value for current record which is being processed |
| IV_DISB_ELECTED_AMT | Number | Elected amount for the elective disbursement |
| IV_DISB_ELECTION_DATE | Date | Election date for the elective disbursement |
| IV_DISB_PROCD_DATE | Date | Exact processed date for the elective disbursement |
| IV_DISB_ELECT_PENDING | Text | If the elective disbursement is marked as pending or not. "Y" stands for pending, "N" stands for not pending. |
Return Variables
| Variable Name | Data Type | Description |
|---|---|---|
| paymentPercentage | Number | Payment percentage for the elective disbursement value |
| overrideValue | Number | Override value for elective disbursement |
Sample Formula
Requirement: If the current balance of an employee is below 8 hours, then 0 hours are to be disbursed.
Solution: A Global Absence Elective Disbursement Evaluation formula such as the one below can be used.
FORMULA NAME: ANC_ELECTDISBEVAL
FORMULA TYPE: Global Absence Elective Disbursement Evaluation
DESCRIPTION: This formula validates the elective disbursement values for an accrual plan.
DEFAULT FOR IV_DISB_TYPE IS 'XX'
DEFAULT FOR IV_DISB_VALUE IS -1
INPUTS ARE IV_DISB_TYPE, IV_DISB_VALUE, IV_ACCRUAL_CEILING
ln_plan_balance = GET_PLAN_BALANCE(‘Vision Accrual Plan’)
paymentPercentage = 100
overrideValue = IV_DISB_VALUE
IF (IV_DISB_TYPE = 'ORA_ANC_ELECT_DISB') THEN
(
IF (ln_plan_balance <5) THEN
(
paymentPercentage = 0
overrideValue = 0
)
)
RETURN paymentPercentage,overrideValue