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
- 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 Participation tab, Enrollment Rules section, select Formula in the Enrollment Start Rule field.
- 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