Fast Formula – Absence
In our previous sections, we went
over the basics of Fast Formula and how Compensation uses the Formula in their
products.
In this session, we will cover the Fast Formula usages in
Absences.
Since we covered the Types, Input Values, Context and how to write a Fast Formula in detail in our previous sections, we will not get into that again in these sections.
If you have any questions or doubts, please post us a message.
Since we covered the Types, Input Values, Context and how to write a Fast Formula in detail in our previous sections, we will not get into that again in these sections.
If you have any questions or doubts, please post us a message.
Absence Formula
Types:
|
Formula Type Name
|
Description
|
Usage
|
|
Global Absence Accrual
|
This formula type can be used to
define the bands that identify how much paid time eligible workers accrue
over the course of an accrual period. The criteria may be years of service,
grades, hours worked etc. However, use this formula only if using the accrual
matrix option and its corresponding formulas does not meet the requirement.
|
Manage Absence Plans -> In the Plan Type field, select Accrual ->
Accruals tab Accrual Attributes section, select Formula
|
|
Global Absence Accrual Event
|
The Global Absence Accrual Event
fast formula can be used to capture information about events that occur
during a calendar year which would cause a change in the accrual band that
the worker belongs to. This formula can capture such dates and return to the
accrual matrix formula which would automatically fetch the respective band
values as of each of the dates fed into the accrual matrix formula
|
You cannot attach this formula to
the plan definition at any point. When you create the formula, the formula
name needs to be the same as the absence plan name. This automatically links
the formula to the plan.
|
|
Global Absence Accrual Matrix
|
The Global
Absence Accrual Matrix fast formula can be used in conjunction with the
accrual matrix to implement requirements such as band change pro-ration, FTE
pro-ration etc.
|
Manage Absence Plans -> Plan
Type field, select Accrual -> Accrual Matrix section -> the defined formula in the Accrual Formula
column
|
|
Global Absence Band Entitlement
|
The Global
Absence Band Entitlement fast formula can be used to define the bands of
entitlement duration and percentage of payment that is applicable against a
qualification plan entitlement.
|
Manage Absence Plans -> Plan
Type field, select Qualification ->, Qualification Band Matrix table ->
Qualification Details -> Entitlement Formula
|
|
Global Absence Carryover
|
The Global
Absence Carryover fast formula can be used in cases where a single carryover
rule does not apply to the entire population that belongs to the accrual
plan.
|
Manage Absence Plans -> Plan
Type field, select Accural -> in Accural Tab, Plan Limits -> Carryover Rule
|
|
Global Absence Carryover Proration
|
The Global
Absence Carryover Proration fast formula can be used in cases where a
pro-ration factor (or a multiplication factor) needs to be applied onto the
maximum carryover limit.
|
Manage Absence Plans -> Plan
Type field, select Accural -> in Accural Tab, Plan Limits -> Carryover Proration Formula
|
|
Global Absence Ceiling
|
The Global
Absence Ceiling fast formula can be used in cases where a single ceilingr
rule does not apply to the entire population that belongs to the accrual
plan.
|
Manage Absence Plans -> Plan
Type field, select Accural -> in Accural Tab, Plan Limits -> Ceiling Formula
|
|
Global Absence Ceiling Proration
|
The Global
Absence Ceiling Proration fast formula can be used in cases where a
pro-ration factor (or a multiplication factor) needs to be applied onto the
maximum ceiling limit.
|
Manage Absence Plans -> Plan
Type field, select Accural -> in Accural Tab, Plan Limits -> Ceiling Proration Formula
|
|
Global Absence Entry Validation
|
The Global Absence Entry Validation
fast formula can be used in cases where a custom data validation or business
rule validation needs to be performed when an absence entry is being made
|
Manage Absence type -> Absence
Type page Type Attributes tab, General Attributes section -> the
Validation Formula
|
|
Global Absence Partial Period
Accrual Rate
|
The Global
Absence Partial Period Accrual Rate fast formula is where any logic required
for pro-ration of accrual balance during enrollment year and un-enrollment
year needs to be entered.
|
Manage Absence Plans -> Plan
Type field, select Accural -> in Accural Tab, Plan Limits -> Partial Accrual Period Formula
|
|
Global Absence Plan Duration
|
The Global Absence Plan Duration
fast formula can be used to over-ride the default duration calculation logic
for daily accrual duration entries against accrual plans. For example, if the
accrual deduction to be considered for an absence entry in an accrual plan in
an organization depends on the location of the worker, then this formula can
be leveraged to specify this dynamic calculation logic. This formula will be
invoked once for each day of absence.
|
Manage Absence Plans -> Plan Type
field, select Accural -> in Accural Tab, Plan Limits -> Conversion Formula
|
|
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.
|
Manage Absence Plans -> Plan
Type field, select Accural -> in Accural Tab, Plan Limits -> End Date Formula
|
|
Global Absence Plan Enrollment
Start
|
The Global
Absence Plan Enrollment Start fast formula can be used to over-ride 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.
|
Manage Absence Plans -> Plan
Type field, select Accural -> in Accural Tab, Plan Limits -> Start Date Formula
|
|
Global Absence Plan Entitlement
|
The Global
Absence Plan Entitlement fast formula can be used to define the entire
entitlement structure for a qualification plan for cases where matrix
architecture does not fit the bill.
|
Manage Absence Plans -> Plan
page Entitlements tab , Entitlement Attributes section -> Entitlement
Formula
|
|
Global Absence Plan Period
Anniversary Event Date
|
The Global
Absence Plan Period Anniversary Event Date fast formula can be used to
specify the date to be used as the calendar leave year start date for accrual
plans whose term is of type Anniversary year.
|
Manage Absence Plans -> Plan
Type field, select Accural -> in Accural Tab, Plan Limits -> Anniversary Event Formula
|
|
Global Absence Plan Roll Backward
End
|
The Global
Absence Plan Roll Backward End fast formula is to be used to determine the
start date of a plan term that uses the Roll Backward term rule.
|
Manage Absence Plans -> Plan
Type field, Qualification -> Plan page Plan Attributes tab, Plan Term
section -> Start Formula
|
|
Global Absence Plan Use Rate
|
The Global
Absence Plan Use Rate fast formula can be used to dynamically specify the
rate definition associated with the qualification plan depending on custom
conditions.
|
Manage Absence Plans -> Plan
Type field, Qualification -> Plan
page Entries and Balances tab -> Formula
|
|
Global Absence Proration
|
The Global
Absence Proration fast formula can be used to apply a pro-ration factor (or a
multiplication factor), onto the final accrual calculated and returned by the
accrual calculation rules in an accrual based absence plan.
|
Manage Absence Plans -> Plan
Type field, select Accural ->Plan page Accruals tab, Accrual Attributes
section -> Accrual Proration Formula
|
|
Global Absence Type Duration
|
The Global
Absence Type Duration fast formula can be used to over-ride the default
calculation logic that the application uses to determine the absence entry
duration and accrual plan usage against absence entries.
|
Manage Absence Type -> Type
Attributes tab, General Attributes section -> Conversion Formula
|
|
Global Absence Vesting Period
|
The Global
Absence Vesting Period fast formula can be used to enforce a custom vesting
period (a period during which the Worker is enrolled into the plan and
accruing balance but cannot use them) logic while defining an absence plan.
|
Manage Absence Plans -> Plan
Type field, select Accural ->Plan page Accruals tab, Accrual Attributes
section -> Vesting Period Formula
|
Absence Formula Type’s
Contexts:
|
Formula Type Name
|
Context Name
|
|
Global Absence Accrual
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Accrual Event
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Accrual Matrix
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Band Entitlement
|
ABSENCE_CATEGORY_ID
|
|
ABSENCE_ENTRY_ID
|
|
|
ABSENCE_MATERNITY_ID
|
|
|
ABSENCE_REASON_ID
|
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Carryover
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Carryover Proration
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Ceiling
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Ceiling Proration
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Entitlement End Date
|
ABSENCE_CATEGORY_ID
|
|
ABSENCE_ENTRY_ID
|
|
|
ABSENCE_MATERNITY_ID
|
|
|
ABSENCE_REASON_ID
|
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Entry Validation
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_REASON_ID
|
|
|
ABSENCE_TYPE_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Linkage Exclusion
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_REASON_ID
|
|
|
ABSENCE_TYPE_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Partial Period
Accrual Rate
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Plan Duration
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Plan Enrollment End
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Plan Enrollment
Start
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Plan Entitlement
|
ABSENCE_CATEGORY_ID
|
|
ABSENCE_ENTRY_ID
|
|
|
ABSENCE_MATERNITY_ID
|
|
|
ABSENCE_REASON_ID
|
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Plan Period
Anniversary Event Date
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Plan Roll Backward
End
|
ABSENCE_CATEGORY_ID
|
|
ABSENCE_ENTRY_ID
|
|
|
ABSENCE_MATERNITY_ID
|
|
|
ABSENCE_REASON_ID
|
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Plan Roll Forward
Start
|
ABSENCE_CATEGORY_ID
|
|
ABSENCE_ENTRY_ID
|
|
|
ABSENCE_MATERNITY_ID
|
|
|
ABSENCE_REASON_ID
|
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Plan Use Rate
|
ABSENCE_CATEGORY_ID
|
|
ABSENCE_ENTRY_ID
|
|
|
ABSENCE_MATERNITY_ID
|
|
|
ABSENCE_REASON_ID
|
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Proration
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Type Duration
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
|
|
|
|
|
Global Absence Vesting Period
|
ABSENCE_ENTRY_ID
|
|
ABSENCE_TYPE_ID
|
|
|
ACCRUAL_PLAN_ID
|
|
|
DATE_EARNED
|
|
|
EFFECTIVE_DATE
|
|
|
END_DATE
|
|
|
ENTERPRISE_ID
|
|
|
HR_ASSIGNMENT_ID
|
|
|
HR_RELATIONSHIP_ID
|
|
|
HR_TERM_ID
|
|
|
JOB_ID
|
|
|
LEGAL_EMPLOYER_ID
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
|
|
ORGANIZATION_ID
|
|
|
PAYROLL_ASSIGNMENT_ID
|
|
|
PAYROLL_ID
|
|
|
PAYROLL_RELATIONSHIP_ID
|
|
|
PAYROLL_TERM_ID
|
|
|
PERSON_ID
|
|
|
START_DATE
|
Absence Formula Type
Input values:
|
Formula Type Name
|
Input variables
|
Type
|
Description
|
|
Global Absence Accrual
|
IV_ACCRUALPERIODSTARTDATE
|
Date
|
Start date of accrual period
|
|
IV_ACCRUALPERIODENDDATE
|
Date
|
End date of accrual period
|
|
|
IV_CALEDARSTARTDATE
|
Date
|
Start date of accrual calendar year
|
|
|
IV_CALEDARENDDATE
|
Date
|
End date of accrual calendar year
|
|
|
IV_PLANENROLLMENTSTARTDATE
|
Date
|
Start date of enrollment
|
|
|
IV_PLANENROLLMENTENDDATE
|
Date
|
End date of enrollment
|
|
|
|
|
|
|
|
Global Absence Accrual Event
|
IV_CARRYOVER
|
Date
|
Carryover limit received from
accrual matrix
|
|
IV_CEILING
|
Date
|
Ceiling limit received from the
accrual matrix
|
|
|
IV_ACCRUALPERIODSTARTDATE
|
Date
|
Start date of accrual period
|
|
|
IV_ACCRUALPERIODENDDATE
|
Date
|
End date of accrual period
|
|
|
IV_CALEDARSTARTDATE
|
Date
|
Start date of accrual calendar year
|
|
|
IV_CALEDARENDDATE
|
Date
|
End date of accrual calendar year
|
|
|
IV_PLANENROLLMENTSTARTDATE
|
Date
|
Start date of enrollment
|
|
|
IV_PLANENROLLMENTENDDATE
|
Date
|
End date of enrollment
|
|
|
IV_BAND_CHG_DT1 .. 5
|
Date
|
If the accrual matrix band
definition consists of grades or derived factors length of service or age,
then this input value fetches the date on which worker has had a change in
any of these factors within the period.
|
|
|
IV_BAND_CHG_BEFVAL1 .. 5
|
Number
|
Accrual value as per the matrix
before IV_BAND_CHG_DT1
|
|
|
IV_BAND_CHG_AFTVAL1 .. 5
|
Number
|
Accrual value as per the matrix
after IV_BAND_CHG_DT1
|
|
|
|
|
|
|
|
Global Absence Accrual Matrix
|
IV_ACCRUAL
|
Number
|
Accrual value received from the
accrual matrix
|
|
IV_CARRYOVER
|
Number
|
Carryover limit received from
accrual matrix
|
|
|
IV_CEILING
|
Number
|
Ceiling limit received from the
accrual matrix
|
|
|
IV_ACCRUALPERIODSTARTDATE
|
Date
|
Start date of accrual period
|
|
|
IV_ACCRUALPERIODENDDATE
|
Date
|
End date of accrual period
|
|
|
IV_CALEDARSTARTDATE
|
Date
|
Start date of accrual calendar year
|
|
|
IV_CALEDARENDDATE
|
Date
|
End date of accrual calendar year
|
|
|
IV_PLANENROLLMENTSTARTDATE
|
Date
|
Start date of enrollment
|
|
|
IV_PLANENROLLMENTENDDATE
|
Date
|
End date of enrollment
|
|
|
IV_BAND_CHG_DT1 .. 5
|
Date
|
If the accrual matrix band
definition consists of grades or derived factors length of service or age,
then this input value fetches the date on which worker has had a change in
any of these factors within the period.
|
|
|
IV_BAND_CHG_BEFVAL1 .. 5
|
Number
|
Accrual value as per the matrix
before IV_BAND_CHG_DT1
|
|
|
IV_BAND_CHG_AFTVAL1 .. 5
|
Number
|
Accrual value as per the matrix
after IV_BAND_CHG_DT1
|
|
|
IV_EVENT_DATES
|
Date_Number
|
Array of dates returned by the
Accrual Event formula.
|
|
|
IV_ACCRUAL_VALUES
|
Number_Number
|
Array of accrual values fetched
from the accrual matrix as of the dates contained in the accrual event dates
array.
|
|
|
|
|
|
|
|
|
|
|
|
|
Global Absence Band Entitlement
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
Global Absence Carryover
|
IV_ACCRUAL
|
Number
|
Accrual value received from the
accrual matrix
|
|
IV_CARRYOVER
|
Number
|
Carryover limit received from
accrual matrix
|
|
|
IV_CEILING
|
Number
|
Ceiling limit received from the
accrual matrix
|
|
|
IV_ACCRUALPERIODSTARTDATE
|
Date
|
Start date of accrual period
|
|
|
IV_ACCRUALPERIODENDDATE
|
Date
|
End date of accrual period
|
|
|
IV_CALEDARSTARTDATE
|
Date
|
Start date of accrual calendar year
|
|
|
IV_CALEDARENDDATE
|
Date
|
End date of accrual calendar year
|
|
|
IV_PLANENROLLMENTSTARTDATE
|
Date
|
Start date of enrollment
|
|
|
IV_PLANENROLLMENTENDDATE
|
Date
|
End date of enrollment
|
|
|
|
|
|
|
|
Global Absence Carryover Proration
|
IV_ACCRUAL
|
Number
|
Accrual value received from the
accrual matrix
|
|
IV_CARRYOVER
|
Number
|
Carryover limit received from
accrual matrix
|
|
|
IV_CEILING
|
Number
|
Ceiling limit received from the
accrual matrix
|
|
|
IV_ACCRUALPERIODSTARTDATE
|
Date
|
Start date of accrual period
|
|
|
IV_ACCRUALPERIODENDDATE
|
Date
|
End date of accrual period
|
|
|
IV_CALEDARSTARTDATE
|
Date
|
Start date of accrual calendar year
|
|
|
IV_CALEDARENDDATE
|
Date
|
End date of accrual calendar year
|
|
|
IV_PLANENROLLMENTSTARTDATE
|
Date
|
Start date of enrollment
|
|
|
IV_PLANENROLLMENTENDDATE
|
Date
|
End date of enrollment
|
|
|
|
|
|
|
|
Global Absence Ceiling
|
IV_ACCRUAL
|
Number
|
Accrual value received from the
accrual matrix
|
|
IV_CARRYOVER
|
Number
|
Carryover limit received from
accrual matrix
|
|
|
IV_CEILING
|
Number
|
Ceiling limit received from the
accrual matrix
|
|
|
IV_ACCRUALPERIODSTARTDATE
|
Date
|
Start date of accrual period
|
|
|
IV_ACCRUALPERIODENDDATE
|
Date
|
End date of accrual period
|
|
|
IV_CALEDARSTARTDATE
|
Date
|
Start date of accrual calendar year
|
|
|
IV_CALEDARENDDATE
|
Date
|
End date of accrual calendar year
|
|
|
IV_PLANENROLLMENTSTARTDATE
|
Date
|
Start date of enrollment
|
|
|
IV_PLANENROLLMENTENDDATE
|
Date
|
End date of enrollment
|
|
|
|
|
|
|
|
Global Absence Ceiling Proration
|
IV_ACCRUAL
|
Number
|
Accrual value received from the
accrual matrix
|
|
IV_CARRYOVER
|
Number
|
Carryover limit received from
accrual matrix
|
|
|
IV_CEILING
|
Number
|
Ceiling limit received from the
accrual matrix
|
|
|
IV_ACCRUALPERIODSTARTDATE
|
Date
|
Start date of accrual period
|
|
|
IV_ACCRUALPERIODENDDATE
|
Date
|
End date of accrual period
|
|
|
IV_CALEDARSTARTDATE
|
Date
|
Start date of accrual calendar year
|
|
|
IV_CALEDARENDDATE
|
Date
|
End date of accrual calendar year
|
|
|
IV_PLANENROLLMENTSTARTDATE
|
Date
|
Start date of enrollment
|
|
|
IV_PLANENROLLMENTENDDATE
|
Date
|
End date of enrollment
|
|
|
|
|
|
|
|
Global Absence Entitlement End Date
|
|
|
|
|
|
|
|
|
|
Global Absence Entry Validation
|
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
|
|
|
|
|
|
|
Global Absence Linkage Exclusion
|
|
|
|
|
Global Absence Partial Period
Accrual Rate
|
IV_ACCRUAL
|
Number
|
Accrual value received from the
accrual matrix
|
|
|
IV_CARRYOVER
|
Number
|
Carryover limit received from
accrual matrix
|
|
|
IV_CEILING
|
Number
|
Ceiling limit received from the
accrual matrix
|
|
|
IV_ACCRUALPERIODSTARTDATE
|
Date
|
Start date of accrual period
|
|
|
IV_ACCRUALPERIODENDDATE
|
Date
|
End date of accrual period
|
|
|
IV_CALEDARSTARTDATE
|
Date
|
Start date of accrual calendar year
|
|
|
IV_CALEDARENDDATE
|
Date
|
End date of accrual calendar year
|
|
|
IV_PLANENROLLMENTSTARTDATE
|
Date
|
Start date of enrollment
|
|
|
IV_PLANENROLLMENTENDDATE
|
Date
|
End date of enrollment
|
|
|
IV_BAND_CHG_DT1 .. 5
|
Date
|
If the accrual matrix band
definition consists of grades or derived factors length of service or age,
then this input value fetches the date on which worker has had a change in
any of these factors within the period.
|
|
|
IV_BAND_CHG_BEFVAL1 .. 5
|
Number
|
Accrual value as per the matrix
before IV_BAND_CHG_DT1
|
|
|
IV_BAND_CHG_AFTVAL1 .. 5
|
Number
|
Accrual value as per the matrix
after IV_BAND_CHG_DT1
|
|
|
|
|
|
|
Global Absence Plan Duration
|
IV_START_DATE
|
Date
|
This is the start date of the
absence being entered
|
|
|
IV_END_DATE
|
Date
|
This is the end date of the absence
being entered
|
|
|
IV_START_DURATION
|
Number
|
This is the start date duration for
the absence being entered. This is applicable when absence entry is being
recorded against an Elapsed based work schedule
|
|
|
IV_END_DURATION
|
Number
|
This is the end date duration for
the absence being entered. This is applicable when absence entry is being
recorded against an Elapsed based work schedule
|
|
|
IV_START_TIME
|
Text
|
This is the start time on the start
date for the absence being entered. This is 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
|
This is the end time on the end
date for the absence being entered. This is applicable when absence entry is
being recorded against a Time based work schedule. For elapsed work schedules
it will be 23:59.
|
|
|
IV_UOM
|
Text
|
Unit of measure of the current
absence entry
|
|
|
|
|
|
|
Global Absence Plan Enrollment End
|
|
|
|
|
|
|
|
|
|
Global Absence Plan Enrollment
Start
|
|
|
|
|
|
|
|
|
|
Global Absence Plan Entitlement
|
|
|
|
|
|
|
|
|
|
Global Absence Plan Period
Anniversary Event Date
|
|
|
|
|
Global Absence Plan Roll Backward
End
|
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
|
|
|
|
|
|
|
|
Global Absence Plan Roll Forward
Start
|
|
|
|
|
|
|
|
|
|
Global Absence Plan Use Rate
|
|
|
|
|
|
|
|
|
|
Global Absence Proration
|
IV_ACCRUAL
|
Number
|
Accrual value received from the
accrual matrix
|
|
IV_CARRYOVER
|
Number
|
Carryover limit received from
accrual matrix
|
|
|
IV_CEILING
|
Number
|
Ceiling limit received from the
accrual matrix
|
|
|
IV_ACCRUALPERIODSTARTDATE
|
Date
|
Start date of accrual period
|
|
|
IV_ACCRUALPERIODENDDATE
|
Date
|
End date of accrual period
|
|
|
IV_CALEDARSTARTDATE
|
Date
|
Start date of accrual calendar year
|
|
|
IV_CALEDARENDDATE
|
Date
|
End date of accrual calendar year
|
|
|
IV_PLANENROLLMENTSTARTDATE
|
Date
|
Start date of enrollment
|
|
|
IV_PLANENROLLMENTENDDATE
|
Date
|
End date of enrollment
|
|
|
|
|
|
|
|
|
|
|
|
|
Global Absence Type Duration
|
IV_START_DATE
|
Date
|
Start date of absence entry
|
|
IV_END_DATE
|
Date
|
End date 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_UOM
|
Text
|
Unit of Measure
|
|
|
|
|
|
|
|
|
|
|
|
|
Global Absence Vesting Period
|
IV_ACCRUAL
|
Number
|
Accrual value received from the
accrual matrix
|
|
IV_CARRYOVER
|
Number
|
Carryover limit received from
accrual matrix
|
|
|
IV_CEILING
|
Number
|
Ceiling limit received from the
accrual matrix
|
|
|
IV_ACCRUALPERIODSTARTDATE
|
Date
|
Start date of accrual period
|
|
|
IV_ACCRUALPERIODENDDATE
|
Date
|
End date of accrual period
|
|
|
IV_CALEDARSTARTDATE
|
Date
|
Start date of accrual calendar year
|
|
|
IV_CALEDARENDDATE
|
Date
|
End date of accrual calendar year
|
|
|
IV_PLANENROLLMENTSTARTDATE
|
Date
|
Start date of enrollment
|
|
|
IV_PLANENROLLMENTENDDATE
|
Date
|
End date of enrollment
|
Absence Formula
Type’s Return values and variables:
|
Formula Type Name
|
Return Variable Name
|
Return Type
|
Description
|
|
Global Absence Accrual
|
accrual
|
Number
|
Amount of accrual that the worker
accrues in the specific period.
|
|
ceiling
|
Number
|
Maximum time that a worker can
accrue
|
|
|
carryover
|
Number
|
Maximum unused time that a worker
can transfer to the next accrual term
|
|
|
prorationFactor
|
Number
|
Multiplying factor that the accrual
is multiplied.
|
|
|
vestingUnits
|
Number
|
Period for which time-off is
accrued, but cannot be used by worker.
|
|
|
vestingUOM
|
Text
|
Unit of measure for the vesting
period duration. UoM can be Calendar Days (‘C’), Weeks (‘W’), Months (‘M’) or
Years (‘Y)
|
|
|
carryOverProration
|
Number
|
Multiplication factor for carryover
|
|
|
ceilingProration
|
Number
|
Multiplication factor for ceiling
|
|
|
adjustmentvalues
|
Number_Number
|
Array of balance adjustments that
when returned by the formula is applied against the accrual plan enrollment.
|
|
|
adjustmentdates
|
Date_Number
|
Array of dates associated with the
array of balance adjustment values to specify the dates on which each of the
balance adjustments need to be applied
|
|
|
adjustmenttypes
|
Text_Number
|
Array of adjustment reasons used
for the balance adjustments
|
|
|
absvalues
|
Number_Number
|
Array of absence accrual usages
that can be applied against an accrual plan enrollment. Useful for cases
where the absence entry itself is not captured in Global Absence Management,
but rather via other modules (such as payroll element entries) or even third
party systems and the absence deduction against the accrual plan needs to
happen in Fusion. When using this, it should be noted that absence entries
should not be made for the same dates.
|
|
|
absdates
|
Date_Number
|
Array of dates associated with the
absence accrual usages on which the deduction is applied.
|
|
|
|
|
|
|
|
Global Absence Accrual Event
|
IV_EVENT_DATES
|
Date_Number
|
Array of dates that feeds into the
accrual matrix which can be used for band change pro-ration. Corresponding
accrual values derived from the matrix also feeds into the matrix formula
|
|
|
|
|
|
|
Global Absence Accrual Matrix
|
accrual
|
Number
|
Amount of accrual that the worker
accrues in the specific period.
|
|
ceiling
|
Number
|
Maximum time that a worker can
accrue
|
|
|
carryover
|
Number
|
Maximum unused time that a worker
can transfer to the next accrual term
|
|
|
adjustmentvalues
|
Number_Number
|
Array of balance adjustments that
when returned by the formula is applied against the accrual plan enrollment.
|
|
|
adjustmentdates
|
Date_Number
|
Array of dates associated with the
array of balance adjustment values to specify the dates on which each of the
balance adjustments need to be applied
|
|
|
adjustmenttypes
|
Text_Number
|
Array of adjustment reasons used
for the balance adjustments
|
|
|
absvalues
|
Number_Number
|
Array of absence accrual usages
that can be applied against an accrual plan enrollment. Useful for cases
where the absence entry itself is not captured in Global Absence Management,
but rather via other modules (such as payroll element entries) or even third
party systems and the absence deduction against the accrual plan needs to
happen in Fusion. When using this, it should be noted that absence entries
should not be made for the same dates.
|
|
|
absdates
|
Date_Number
|
Array of dates associated with the
absence accrual usages on which the deduction is applied.
|
|
|
|
|
|
|
|
Global Absence Band Entitlement
|
BANDPAYFACTOR
|
Number
|
Pay factor for entitlement band
value
|
|
BANDENTITLEMENT
|
Number
|
Entitlement duration that worker is
eligible for
|
|
|
|
|
|
|
|
Global Absence Carryover
|
carryover
|
Number
|
Maximum unused time that a worker
can transfer to the next accrual term
|
|
|
|
|
|
|
Global Absence Carryover Proration
|
prorationFactor
|
Number
|
Multiplication factor for carryover
|
|
|
|
|
|
|
Global Absence Ceiling
|
ceiling
|
Number
|
Maximum time that a worker can
accrue
|
|
|
|
|
|
|
Global Absence Ceiling Proration
|
prorationFactor
|
Number
|
Multiplication factor for ceiling
|
|
|
|
|
|
|
|
|
|
|
|
Global Absence Entry Validation
|
VALID
|
Text
|
Determines validity of absence
entry. ‘N’ throws an error message and stops the transaction from being
submitted
|
|
|
ERROR_MESSAGE
|
Text
|
Custom error message for invalid
absence entry. Error message can either be written into the formula or
defined via Manage Messages and invoked here.
|
|
|
|
|
|
|
|
|
|
|
|
Global Absence Partial Period
Accrual Rate
|
accrual
|
Number
|
Partial period pro-rated accrual
value returned for the particular partial repeating period. Value is returned
gets added as an accrual line. For processing termination of enrollment for
front loaded plans, the variable should return a negative value, to deduct
pro-rated amount from the existing annual accrual value.
|
|
|
|
|
|
|
Global Absence Plan Duration
|
DURATION
|
Number
|
Duration of plan entries
|
|
|
|
|
|
|
Global Absence Plan Enrollment End
|
enrollmentEndDate
|
Date
|
End date of enrollment
|
|
|
|
|
|
|
Global Absence Plan Enrollment
Start
|
enrollmentStartDate
|
Date
|
Start date of enrollment
|
|
|
|
|
|
|
Global Absence Plan Entitlement
|
BAND1PAYFACTOR
|
Number
|
Pay factor for the entitlement
BAND1ENTITLEMENT
|
|
|
BAND1ENTITLEMENT
|
Number
|
Entitlement duration that the
worker is eligible for
|
|
|
BAND2PAYFACTOR
|
Number
|
Pay factor for the entitlement
BAND2ENTITLEMENT
|
|
|
BAND2ENTITLEMENT
|
Number
|
Entitlement duration that the
worker is eligible for
|
|
|
BAND3PAYFACTOR
|
Number
|
Pay factor for the entitlement
BAND3ENTITLEMENT
|
|
|
BAND3ENTITLEMENT
|
Number
|
Entitlement duration that the
worker is eligible for
|
|
|
BAND4PAYFACTOR
|
Number
|
Pay factor for the entitlement
BAND4ENTITLEMENT
|
|
|
BAND4ENTITLEMENT
|
Number
|
Entitlement duration that the
worker is eligible for
|
|
|
BAND5PAYFACTOR
|
Number
|
Pay factor for the entitlement
BAND5ENTITLEMENT
|
|
|
BAND5ENTITLEMENT
|
Number
|
Entitlement duration that the
worker is eligible for
|
|
|
|
|
|
|
|
|
|
|
|
Global Absence Plan Period
Anniversary Event Date
|
anniversaryDate
|
Date
|
Date used to determine the leave
year start date for anniversary based accrual plan term
|
|
|
|
|
|
|
Global Absence Plan Roll Backward
End
|
REFERENCEDATE
|
Date
|
Start date for the Rolling Backward
plan term.
|
|
|
|
|
|
|
|
|
|
|
|
Global Absence Plan Use Rate
|
RATECODE
|
Text
|
Rate code for rate associated with
qualification plan
|
|
|
|
|
|
|
Global Absence Proration
|
prorationFactor
|
Number
|
Multiplication factor used to pro-rate
final accrual amount
|
|
|
|
|
|
|
Global Absence Type Duration
|
DURATION
|
Number
|
Duration of absence entry
|
|
|
|
|
|
|
Global Absence Vesting Period
|
vestingUOM
|
Text
|
Unit of measure for the vesting
period duration. UoM can be Calendar Days (‘C’), Weeks (‘W’), Months (‘M’) or
Years (‘Y)
|
|
|
vestingUnits
|
Number
|
Period for which time-off is
accrued, but cannot be used by worker.
|
The above
information is collected as of the latest release from Absence, this may not be
true to your release, please contact Absence Support /Development or us for any
questions or doubts.
