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
- 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 Qualification.
- Click Continue.
- On the Edit Absence Plan page Participations tab, Enrollment Rules section, choose Formula in the Qualification Date Rule field.
- 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