1. Administering Payroll for the United Kingdom
  2. Sample Formula for Contractual Opt-Out

Sample Formula for Contractual Opt-Out

You might need different employees with different end dates for opt-out period or it depends on the type of join. You can write a user formula and call it from the pensions automatic enrolment process to determine the opt-out period end date.

  • Formula name: Naming convention <<%CONTRACTUAL OPT OUT%>>
  • Formula type: Oracle Payroll | Calculation Utility | Payroll Access to HR
  • Return value: The formula must be compiled and return variable PCE_OOP_END_DATE, which must contain the opt-out end date.
  • Formula text:
FORMULA NAME: SAMPLE CONTRACTUAL OPT OUT FORMULA
FORMULA TYPE: Oracle Payroll
DESCRIPTION:  This sample formula returns the opt-out period end date for
              contractual enrolments.

Change History:
Name   Date        Version   Comments
-------------------------------------------------------------------------------
Oracle 2019-07-01  1.0       Initial Version
***************************************************************************** */
PCE_OOP_END_DATE = TO_DATE('2019/07/31', 'YYYY/MM/DD')

RETURN PCE_OOP_END_DATE