Global Absence Plan Enrollment Start

The Global Absence Plan Enrollment Start fast formula can be used to override the default enrollment start date rule for the absence plan when workers are being hired into the organization or when the Update Accrual Plan Enrollments batch job is being run.

In an organization the absence plan enrollment rule can be configured such that only workers are allowed to enroll into the plan from the hire date, whereas Interns and Graduates have to complete a waiting period of 1 month before being enrolled into the plan. In such cases, the Plan Enrollment Start formula can be used to derive the alternate enrollment date (one that is different from the hire date or the date passed into the parameter when submitting the Update Accrual Plan Enrollments batch job).

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, Enrollment Rules section, select Formula in the Enrollment Start Rule field.
6. Select the defined formula from the Start 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
enrollmentStartDate	Date	Start date of enrollment

Sample Formula

Requirement: All new Interns and Graduates who are hired into the organization should get enrolled into the plan only after one month of employment. All other workers should get enrolled into the plan as of hire date.

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

FORMULA NAME: ANC_ENRMNTSTART

FORMULA TYPE: Global Absence Plan Enrollment Start

DESCRIPTION: This formula returns the Enrollment Start Date for absence plan enrollments by adding 1 month to the event date for Interns and Graduates

DEFAULT FOR PER_ASG_USER_PERSON_TYPE IS 'Worker'

enrollmentStartDate = GET_CONTEXT(EFFECTIVE_DATE, '4712/12/31 00:00:00' (date))

IF (PER_ASG_USER_PERSON_TYPE != 'Worker')
   THEN (enrollmentStartDate  = ADD_MONTHS(enrollmentStartDate, 1))
RETURN enrollmentStartDate