Global Absence Plan Enrollment Start Date

The Global Absence Plan Enrollment Start Date fast formula can be used to specify the Qualification date for the absence plan.

An organization might have a rule for Maternity entitlements according to which the qualification date is on the absence start date if actual dates are entered. If it is not entered, then the qualification date needs to be the event date (actual if available, or else, the planned date). For including such conditional logic to determine the qualification date, formulas of this type can be used.

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 Qualification.
4. Click Continue.
5. On the Edit Absence Plan page Participations tab, Enrollment Rules section, choose Formula in the Qualification Date Rule field.
6. Select the defined formula in the 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_START_DATE	Date	Start date of absence entry
IV_END_DATE	Date	End date of absence entry
IV_TOTALDURATION	Number	Duration of absence entry
IV_START_DURATION	Number	Start date duration of the absence entry. Applicable when absence entry is being recorded against an Elapsed based work schedule
IV_END_DURATION	Number	End date duration of the absence entry. Applicable when absence entry is being recorded against an Elapsed based work schedule
IV_START_TIME	Text	Start time on the start date of the absence entry. Applicable when absence entry is being recorded against a Time based work schedule. For elapsed work schedules it will be 00:00.
IV_END_TIME	Text	End time on the end date for the absence being entered. Applicable when absence entry is being recorded against a Time based work schedule. For elapsed work schedules it will be 23:59.
IV_ACTUALCHILDBIRTHDATE	Date	Actual date of childbirth entered for the absence. Applicable for Childbirth/placement absence pattern
IV_ACTUALSTARTDATE	Date	Actual start date of absence. Applicable for Childbirth/placement absence pattern
IV_ACTUALENDDATE	Date	Actual end date of absence. Applicable for Childbirth/placement absence pattern
IV_EXPECTEDCHILDBIRTHDATE	Date	Expected date of childbirth entered for the absence. Applicable for Childbirth/placement absence pattern
IV_PLANNEDSTARTDATE	Date	Expected start date of absence. Applicable for Childbirth/placement absence pattern
IV_PLANNEDENDDATE	Date	Expected end date of absence. Applicable for Childbirth/placement absence pattern
IV_ABSENCE_REASON	Text	Absence reason in the language of the current session

Return Variables

Variable Name	Data Type	Description
ENROLLMENTSTARTDATE	Date	Qualification date used by the absence plan

Sample Formula

Requirement: The organization has a rule for Maternity entitlements according to which the qualification date is on the absence start date if actual dates are entered. If this is not provided, then the qualification date needs to be the event date (actual if available, or else, the planned date).

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

FORMULA NAME: ANC_ENROLMNT_START

FORMULA TYPE: Global Absence Plan Enrollment Start Date

DESCRIPTION: This formula returns the qualification date as of which participation to qualification plan needs to be terminated

DEFAULT FOR IV_ACTUALCHILDBIRTHDATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR IV_ACTUALSTARTDATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR IV_EXPECTEDCHILDBIRTHDATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR PER_ASG_REL_ACTUAL_TERMINATION_DATE IS '4712/12/31 00:00:00' (date)

INPUTS ARE IV_ACTUALCHILDBIRTHDATE (date), IV_ACTUALSTARTDATE (date), IV_EXPECTEDCHILDBIRTHDATE (date)

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

IF (IV_ACTUALSTARTDATE WAS NOT DEFAULTED)
THEN
   (
     ENROLLMENTSTARTDATE = IV_ACTUALSTARTDATE
   )
ELSE
   (
     IF (IV_ACTUALCHILDBIRTHDATE WAS NOT DEFAULTED)
    THEN
       (
          ENROLLMENTSTARTDATE = IV_ACTUALCHILDBIRTHDATE
     )
     ELSE
     (
        ENROLLMENTSTARTDATE = IV_EXPECTEDCHILDBIRTHDATE
      )
    )

RETURN ENROLLMENTSTARTDATE