Global Absence Plan Enrollment End

The Global Absence Plan Enrollment End fast formula can be used to over-ride the default enrollment end date rule for the absence plan when workers are being terminated from the organization or when the Update Accrual Plan Enrollments batch job is being run.

In an organization the absence plan un-enrollment rule could be such that for termination, workers have to serve a notice period of one month during which time the worker should not be enrolled into any absence plan. In such a case a Global Absence Plan Enrollment End formula can be composed to derive this alternate enrollment end date.

Configuration Point in HCM Cloud

If you have created this formula, you can attach this formula to the absence plan definition.

Navigation

1. In the Absence Administration work area, click Absence Plans to open the Absence Plans page.
2. On the Search Results section toolbar, click Create to open the Create Absence Plan dialog box.
3. In the Plan Type field, select Accrual.
4. Click Continue.
5. On the Edit Absence Plan page Participation tab, Termination Rules section, select Formula in the Enrollment End Rule field.
6. Select the defined formula from the End Date 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
enrollmentEndDate	Date	End date of enrollment

Sample Formula

Requirement: Upon entering of termination information, the worker needs to be un-enrolled from the plan, one month before the actual termination date (in this case, the event date).

Solution: A Global Absence Plan Enrollment End formula such as the one below can be used.

FORMULA NAME: ANC_ENRMNTEND

FORMULA TYPE: Global Absence Plan Enrollment End

DESCRIPTION: This formula returns the Enrollment End Date for absence plan enrollments by subtracting 1 month from the termination date

enrollmentEndDate = GET_CONTEXT(EFFECTIVE_DATE, '4712/12/31 00:00:00' (date))
enrollmentEndDate  = ADD_MONTHS(enrollmentEndDate, -1)
RETURN enrollmentEndDate