Global Absence Plan Period Anniversary Event Date
The Global Absence Plan Period Anniversary Event Date fast formula can be used to specify the date to be used as the calendar leave year start date for accrual plans whose term is of type Anniversary year.
If the calendar leave year for a vacation plan in an organization is based on the original hire date of a worker, then a formula of this type can be composed to return the required date to the plan calculations.
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 Plan Attributes tab, Plan Term section, select Anniversary year in the Type field.
- Then select Formula in the Anniversary Event Rule field.
- Select the defined formula from the Anniversary Event 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 |
Return Variables
| Variable Name | Data Type | Description |
|---|---|---|
| anniversaryDate | Date | Date used to determine the leave year start date for anniversary based accrual plan term |
Sample Formula
Requirement: The organization has an accrual plan term that is based on the anniversary of the worker. If the person is a regular worker, then the leave year is to be based on the earliest start date of the Worker. If the person is an Intern or Graduate, then the leave year is to be based on the latest legal employer hire date.
Solution: A Global Absence Plan Period Anniversary Event Date formula such as the one below can be used.
FORMULA NAME: ANC_PLN_PRD_ANNIV_DATE
FORMULA TYPE: Global Absence Plan Period Anniversary Event Date
DESCRIPTION: This formula returns the calendar leave year start date for Anniversary year based on the person type
DEFAULT FOR PER_ASG_USER_PERSON_TYPE IS 'Worker'
DEFAULT FOR PER_PERSON_ENTERPRISE_HIRE_DATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR PER_ASG_REL_DATE_START IS '4712/12/31 00:00:00' (date)
IF (PER_ASG_USER_PERSON_TYPE = 'Worker')
THEN
(
anniversaryDate = PER_PERSON_ENTERPRISE_HIRE_DATE
)
ELSE
(
anniversaryDate = PER_ASG_REL_DATE_START
)
RETURN anniversaryDate