Contents
1 Overview
2 Writing Formulas
- Overview of Writing Formulas
- Improve Formula Performance
- Formula Compilation Errors
- Formula Execution Errors
- Example of Writing a Fast Formula Using Expression Editor
- Example of Writing a Fast Formula Using Formula Text
- Formula Compilation
- FAQs for Writing Formulas
3 Fast Formula Components
- Overview of Using Fast Formula Components
- Types of Variables
- Formula Statements
- Naming Schemes for Variables
- Database Items
- Overview of Generating Flexfield Database Items
- Example of Generating Flexfield Database Items
- Formula Operators
- Literals
- How Formulas Determine Variable Data Types
- Array Variables
- Formula Contexts
- Overview of Working Storage Area
- Overview of Calling a Formula from a Formula
- Examples of Calling a Formula from a Formula
4 Fast Formula Functions
- Overview of Fast Formula Functions
- Text Formula Functions
- Numeric Formula Functions
- Date Formula Functions
- Data Conversion Formula Functions
- Miscellaneous Formula Functions
5 Formulas for Payroll
- Overview of Payroll Formulas
- Create Conversion Formulas for Proration
- Configure Periodicity Conversion Rules
- Element Input Validation Formula Type
- User Table Validation Formula Type
- Payroll User Interface Configuration Formula Type
- Payroll Access to HR Formula Type
- Payroll Relationship Group Formula Type
- Flow Schedule Formula Type
- Balance Exception Formula Type
- Element Skip Formula Type
6 Formulas for Absence Management
- Options to Define Qualification Plans
- Options to Define Accrual Plans
- Formulas for Accrual Plans
- Global Absence Accrual Matrix Formula
- Global Absences Annual Accrual Limit
- Global Absences Annual Accrual Limit Proration
- Global Absence Carryover
- Global Absence Carryover Proration
- Global Absence Ceiling
- Global Absence Ceiling Proration
- Global Absence Discretionary Disbursement Rule
- Global Absence Elective Disbursement Evaluation Formula
- Global Absence Discretionary Donation Rule
- Global Absence Partial Period Accrual Rate
- Global Absence Plan Duration
- Global Absence Plan Enrollment End
- Global Absence Plan Enrollment Start
- Global Absence Plan Period Anniversary Event Date
- Global Absence Plan Use Rate
- Global Absence Proration
- Global Absence Rollover
- Global Absence Rollover Proration
- Global Absence Target Plan
- Global Absence Transfer
- Global Absence Transfer Proration
- Global Absence Vesting Period
- Formulas for Qualification Plans
- Global Absence Plan Duration
- Global Absence Band Entitlement
- Global Absence Plan Enrollment Start Date
- Global Absence Plan Entitlement
- Global Absence Plan Roll Backward End
- Global Absence Plan Roll Forward Start
- Global Absence Plan Use Rate
- Formulas for Absence Type
- Global Absence Entry Validation
- Global Absence Linkage Exclusion
- Global Absence Type Duration
- Frequently Used Formula Functions
- Database Items
- Troubleshooting Tips
7 Formulas for Compensation Plans
- Overview of Formulas for Compensation Plans
- Formula Type Is Compensation Currency Selection
- Formula Type Is Compensation Default and Override
- Formula Type Is Compensation Hierarchy Determination
- Formula Type Is Compensation Person Selection
- Formula Type for Total Compensation Item
- Using Profiles DBI in Fast Formula
8 Formulas for Benefits
- Overview of Benefits Formulas
- Person Change Causes Life Event
- Participation and Rate Eligibility
- Rounding
- Age Calculation
- Person Selection
- Benefits Extract Custom Data Rule
- Life Event Reason Timeliness
- Coverage Amount Calculation
- Rate Value Calculation
- Dependent Eligibility
- Age Determination Date
- Enrollment Opportunity
- Beneficiary Certification Required
- Compensation Calculation
- Post Election Edit
- Enrollment Period Start Date
- Default Enrollment
- Evaluate Life Event
- Waiting Period Value and UOM
- Coverage Amount Limit
- Rate Periodization
- Dependent Certification Required
- Length of Service Date to Use
- Enrollment Certification Required
- Coverage Upper Limit
- Rate Start Date
- Enrollment Coverage Start Date
- Default to Assign Pending Action
- Extra Input
- Common Mistakes in Formulas
- Formula Debugging and Troubleshooting
- Formula – FAQ
- Appendix 1: Contexts
- Appendix 2: Input Values
- Appendix 3: Formula Function
- Appendix 4: Formula Errors: Compile time
- Appendix 5: Formula Errors: Run time
- Appendix 6: Database Items
9 Formulas for Performance Management
10 Formula Types, Contexts, Functions, and Input Attributes for Workforce Management
- Rule Templates, Rules, and Rule Sets for Time and Labor
- Formula Types for Workforce and Time Rule Templates
- WORKFORCE_MANAGEMENT_TIME_ADVANCED_CATEGORY_RULES Formula Type
- WORKFORCE_MANAGEMENT_TIME_CALCULATION_RULES Formula Type
- WORKFORCE_MANAGEMENT_TIME_DEVICE_RULES Formula Type
- WORKFORCE_MANAGEMENT_TIME_ENTRY_RULES Formula Type
- WORKFORCE_MANAGEMENT_TIME_SUBMISSION_RULES Formula Type
- WORKFORCE_MANAGEMENT_WORKFORCE_COMPLIANCE_RULES Formula Type
- WORKFORCE_MANAGEMENT_SUBROUTINE Formula Type
- WORKFORCE_MANAGEMENT_UTILITY Formula Type
- Formula Contexts for Workforce Management
- Workforce Management Functions
- Input Attributes for Workforce Management Fast Formulas
11 DAVE Functions for Workforce Management Fast Formulas
- DAVE_FIND_TIME_GAP Function
- DAVE_TIME_SCAN_SET Function
- DAVE_TIME_SCAN_RESET_INDEX Function
- DAVE_TIME_SCAN_REC_DAY Function
- DAVE_TIME_SCAN_REC_TOTAL Function
- GET_REPEATING_PERIOD_ID Function
- DAVE_TIME_SCAN_REC_DTL2 Function
- GET_PERIOD_ID_BY_BAL_DIM_NAME Function (NonJava)
12 Advanced Time Category Rule Fast Formulas
13 Time Calculation Rule Fast Formula
- ORA_WFM_TCR_ACCESS_ATTESTATION_ANSWERS_AP Fast Formula
- ORA_WFM_TCR_ALLOCATION_TIME_AP Fast Formula
- ORA_WFM_TCR_OT_EARNED_DAYS_FOR_ENTRIES_THAT_SPAN_DAYS Fast Formula
- ORA_WFM_TCR_THRESHOLD_WITH_EVENT_CHANGES_MSR_AP Fast Formula
- ORA_WFM_TCR_UNIT_CALC_PAYTYPE_AP Fast Formula
- ORA_WFM_TCR_UNIT_CALC_TIME_RANGE_AP Fast Formula
- ORA_WFM_TCR_UNIT_CALC_WEEKEND_AP Fast Formula
- WFM_TCR_INSUFFICIENT_REST_PERIOD_PREMIUM_AP Fast Formula
- WFM_SHIFT_PREMIUM_CALCULATION Fast Formula
- WFM_TCR_HOLIDAY_THRESHOLD_PREMIUM_AP Fast Formula
- WFM_TCR_THRESHOLD_TWO_TIER_SEVEN_DAY_AP Fast Formula
- WFM_THRESHOLD_TIME_CALCULATION_RULE Fast Formula
- WFM_THRESHOLD_TIME_CALCULATION_RULE_AP Fast Formula
- WFM_THRESHOLD_W_ABS_TIME_CALCULATION_RULE_AP Fast Formula
- WFM_VARIABLE_DAY_START_TIME_CALCULATION Fast Formula
14 Work Day Definition and Time Calculation Rule Fast Formula
- Work Day Definition Example
- Delivered Time Calculation Rule Threshold Formulas Use Starttime
- Custom Threshold Formula That Uses Either the Actualdate or Refdate
15 Time Device Rule Fast Formula
- WFM_TDR_VALIDATE_REST_PERIOD_DURATION_AP Fast Formula
- WFM_TDR_VALIDATE_SCHEDULE_DEVIATION_AP Fast Formula
- WFM_TDR_VALIDATE_SUPPLIER_EVENT_AP Fast Formula
16 Time Entry Rule Fast Formula
- ORA_WFM_TER_MIN_MAX_PAYTYPE_UNITS_AP Fast Formula
- ORA_WFM_TER_PERIOD_MAX_WITH_MSG_MEASURE_FORMAT_OPTION_AP Fast Formula
- ORA_WFM_TER_RESUBMIT_VALIDATION_AP Fast Formula
- ORA_WFM_TER_WEEKEND_UNITS_AP Fast Formula
- WFM_COMPARE_WRKR_SCHEDULE_TO_REPORTED_HOURS Fast Formula
- WFM_PERIOD_MAXIMUM_TIME_ENTRY_RULE Fast Formula
- WFM_PERIOD_MINIMUM_TIME_ENTRY_RULE Fast Formula
- WFM_TER_COMPARE_WRKR_HOLIDAY_TO_REPORTED_HOURS_AP Fast Formula
- WFM_TER_VALIDATE_REST_PERIOD_DURATION_AP Fast Formula
17 Time Submission Rule Fast Formula
- WFM_TSR_SUBMIT_OR_SAVE_ON_NUMBER_OF_DEVICE_EVENTS_AP Fast Formula
- WFM_TSR_SUBMIT_OR_SAVE_ON_NUMBER_OF_HOURS_AP Fast Formula
- WFM_TSR_SUBMIT_OR_SAVE_ON_SPECIFIC_DAY_AP Fast Formula
- WFM_TSR_SUBMIT_OR_SAVE_ON_WORK_SCHEDULE_AP Fast Formula