Package Function PQP_GB_SCOTLAND_LGPS_PENSIONPY.PQP_DERIVE_APP Incorrect Periods Calculated (Doc ID 2605636.1)

Last updated on MARCH 14, 2022

Applies to:

Symptoms

The Oracle function PQP_GB_SCOTLAND_LGPS_PENSIONPY.PQP_DERIVE_APP uses the payroll frequency to decide the number of payroll periods to calculate the APP from, BUT it does not adhere to the rule relating to WHOLE PERIODS. therefore if an employee starts part way through a payroll period, the calculation may determines that to be one of the periods to be considered, BUT that period should be excluded.

Example: Employee on a Monthly Payroll starts on the 15th July. They are then on reduced pay sickness in October. The process uses the salary from July (which is a part month) August and September to calculate the APP value (dividing the value accumulated by 3) where it should just use August and September, dividing the total by 2.

This is in line with the requirements specified in document http://www.lgpslibrary.org/assets/gas/scot/Pv1.8c.pdf section 4.2 Assumed Pensionable Pay (APP) which denotes 'Complete months' or 'Complete Periods':

"The calculation of APP uses the 3 complete months or 12 complete weeks pensionable pay the member receives relating to that employment before the period of reduced contractual pay or nil pay due to sickness or injury, or relevant child related leave commenced or the date the member commenced reserve forces leave. If during the period of 3 months or 12 weeks pensionable pay used to calculate the APP the member ceases one employment and is reemployed on a new contract of employment the calculation of the value of the APP is based on the pensionable pay received in the new employment only using the number of complete weeks or complete months available in that employment to calculate the APP."

EXPECTED BEHAVIOR

Function PQP_GB_SCOTLAND_LGPS_PENSIONPY.PQP_DERIVE_APP should consider the Whole Periods only.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.