ESR – NHS Pensions Interface
Contents
1. e The Opt Out Flag is not set to Yes or e The Opt Out Flag is set to Yes but the Opt Out Date is after the reporting period end date Or 2 Pension End Date on the Pension NHS Element has not been set l e is NULL or The Pension End Date on the Pension NHS Element is set but it is after the reporting period end date 22 NHS Pensions Data Matching Analysis The NHS Pensions Data Matching Analysis will provide details of the data that is currently held on the ESR Data Matching Tables at the time of running This was initially used to assist in the data Matching Exercise This data is now off loaded via a separate interface on request from NHS Pensions 23 NHS Recalled Leavers by Reason Worksheet Recalled Leavers by Reason Code 29 This worksheet lists instances of pensionable pay made against employee assignments after the last standard process date associated with their period of employment This is useful for identifying leaver adjustments Oracle Discoverer MCK NHS Recalled Leavers by Reason Code Analysis File Edit Sheet Tools Graph Help S TOOAH P AaAaOsnzrgsriga NHS Recalled Leavers by Reason Code Analysis Recalled Leavers by Reason Code on 05 MAY 05 at 11 30 41 AM Parameter Values Payroll 434 MonthlyT01 Per od Page Items Organisation Name 434 Ward 3 Period Start Date 01 AUG 2004 Period End Date 31 AUG 2003 Employee Surname initialis NI Number Date Of Pens2. for which the report is run The worksheet returns data where the following conditions are met Where the Pension Status field on the NHS Pension Element is either None or Blank AND Either e On the Start Date of their Pension an employee is younger than 16 or older than 70 Or e On the End Date of their Pension an employee is younger than 16 or older than 70 e Where the Pension Status field on the NHS Pension Element is either Current amp Previous MHO Current MHO Only Special Classes AND Either 27 e On the Start Date of their Pension an employee is younger than 16 or older than 65 Or e On the End Date of their Pension an employee is younger than 16 or older than 65 e Start End Date for pension scheme outside permitted range This worksheet lists those Assignments where an employee is either younger than 16 years or older than 70 years on the Start or End Date of their Pension Scheme Where the Pension Status in the Pension NHS Element is one of the following values the permitted age range becomes 16 to 65 Current amp Previous MHO Current MHO Only Special Classes f NI Cat shows Pensionable but Pension Element is not Active This worksheet lists those Assignments where the employee s National Insurance letter indicates Pensionable but the employee s pension record between the reporting start period and end dates
3. The Total Pensionable Pay figure TPP is usually the yearly pensionable pay earned in the best of the last three years immediately before termination counting backwards in 365 paid days of pensionable employment Contributions will have been collected on it and benefits will eventually be calculated on it It is assumed that the pension s officer will run the report three times with the appropriate dates and then choose the best year 13 amp Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C DER Eile Edit Folda ndow Help ORACLE aSo R Request 4 Run this Request Name NHS Pensionable Pay Report American English Language Settings Debug Options Pa At these Tin Date To mployee ox J cancel K cear BE Her KO i Upon Comp Helpful hint this report uses pensionable balances rather than pensioned so if for some reason the assignment was not in the scheme for any period in the selected dates the value would be wrong Also check starting and end dates of assignment as the report estimates pensionable values based on other payments PENSION REPORTS NHS Pensionable Pay Report Report Parameters Employee Number 20015987 Employee Name OO8S5teele K Date From O1 JaN 2003 ONHS Business Group Effective Date Date To O8 APR 2005 Report Date Page Organisation 436 Ward 9 NES Pens onte Pay Report Payroll Employee Number Full Name Period for TPP Calculation
4. 00 SD Number Assignment Number YTD 88 784 25 Employment ID YTD 0 00 Capacity Code YTD 0 00 ITD 0 00 Max Part Time Flag ITD 0 00 Employment Category YTD 0 00 Employee Category ITD 0 00 ITD 0 00 Employment Type Pension Start Date Date of Leaving Pension Scheme Reason for Leaving Pension Scheme Address Line 1 Address Line 2 Address Line 3 County Postcode Verified Job Title Place of Employment MHO Indicator Field Changed Start Date Capacity Code Annual Pens Consultant Medical AANNNNNNA 57 123456 99999999 00 Tot 3C N Permanent Arrears Full Time Ar Ar nn Aaaaaaa Aaaa Aaaaaaaa AAnn Naa Consultant NNN NN AHospital Old Value New Value Report Date ion list 29 MAY 2009 15 26 59 EE s Contributions YTD 6 194 28 EE s Pensionable Pay ER s Contributions YTD 11 562 60 ER s Pensionable Pay EE s Gross Rate of Pay Annual Basic Salary 82 590 00 Additional Conts al Add Pension Purchase Cont Arrears Pension Contribution Arrears of Pension Balance Arrears of Pension periods of AVC Pension Contribution rears of AVC Pension Balance rears of AVC Pension periods YTD 7 433 16 Non Pensionable Days 0 Number of Part Time Hours Sessions Worked YTD 0 Contracted Out NI Earnings this Tax Year 35 364 00 Actual Hours Sessions 10 00 Standard Hours Sessions 10 00 Frequency Week Effective Date
5. 31 MAR 2009 Date of Birth 31 JUL 1957 Gender F Title DR Former Surname Changes in Period Date of Change Effective 01 APR 2008 kxk End of Report The following fields are reported in the Changes in Period Section e Actual Hours sessions e Standard Hours Sessions e Maximum Part Timer flag e Capacity Code e Pension Status e Pension Start Date e National Insurance number e Surname e Date of Birth e Date of Birth Verified Warning If the assignment has been opted out during the year the values displayed could be incorrect This report uses Pensionable Pay rather than Pensioned Pay 2 NHS Detail Element Report This report will display details of any payroll element or element set For each assignment there will be a column for the input value name and the associated Run Result Value It could be used to check the Pension NHS element settings for a number of assignments Alternatively it could be used to check the information in respect of Additional contributions etc Results can be sorted by up to three criteria defined locally Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C DEK File Edit Folie Wine elp ap raa At these Tin Run Upon Comp Ty ESR NHS Pe Ar 5 2 Oracle Appli e Oracle Appii oracle appli A sample output is as follows Report Information Report Date 219 MAY 2009 15 59 Detail Element Report Report Parameters Assignment Number
6. Date 25 MAY 2009 16 09 Page 1 of 2 NHS Pensions Agency Inbound Interface Report Source System Code NHS Interface File Id Interface File Name Multiple Files Interface Summary Interface Status Completed with Interface Errors 15 Number of Lines Successfully Imported 786 Number of Lines with Validation Errors 12 Number of Lines with Import Errors 5 Report Date 25 MAY 2009 16 09 Page 2 of 2 NHS Pensions Agency Inbound Interface Report Source System Code NHS Interface File Id Interface File Name Multiple Files Interface Errors Assignment Number 51266495 Pension Start Date 01 DEC 2008 SD Number 58999998 Employment ID 1 Errors 1 Unable to update record in Pensions Interface custom table Assignment Number 2856387380 Pension Start Date 01 JUL 2000 SD Number 77999999 Employment ID 2 Errors 1 Invalid Assignment Number Assignment Number 61016192 Pension Start Date SD Number 90999999 Employment ID 1 Errors 1 Pension Start Date is NULL Assignment Number 70020671 Pension Start Date 09 DEC 1983 SD Number 46999999 Employment ID 1 Errors 1 API Error The HR object is invalid Assignment Number 89025682 Pension Start Date 01 SEP 2001 SD Number 49999999 Employment ID 16 Errors 1 API Error The primary key specified is invalid Assignment Number 99021657 2 Pension Start Date 19 APR 2007 SD Number 58888888 Employment ID 3 Errors 1 Pension NHS Element Entry can not be found for thi
7. Hours Sessions XXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXX XXNNNNNNA NNNNNNNN XXX XXXXXXXXXXXXXX NNN x x XX KKK XK KKK KKK XXXXXXXXXXXXXXXXXXXXXXXX x DD MON YYYY DD MON YYYY Periodic Pension List XXX XXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXL XK KKK OXX KOX XXXX XLOKK OO KOK KO XXOOOKK KKK XXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXX x Old Value x XXNNNNNNA DD MON YYYY 99 99 EE s Contributions PTD EE s Pensionable Pay PTD ER s Contributions PTD ER s Pensionable Pay PTD EE s Gross Rate of Pay PTD Annual Basic Salary Additional Conts PTD Report Date Arrears Pension Contribution PTD Arrears of Pension Balance ITD Arrears of Pension Periods ITD Arrears of AVC Pension Contribution PTD Arrears of AVC Pension Balance ITD Arrears of AYC Pension Periods ITD Non Pensionable Days Number of Part Time Hours Scosions Worked PTD Contracted Out NI Earnings this Tax Year Actual Hours Sessions Standard Hours Sessions Frequency Period Name Effective Date Date of Birth Gender Title Farmer Surname Changes ir Period TEK ORACLE 05 JUN 2003 16 45 9999999 99 9999999 99 9999999 99 9999999 99 9999999 99 9999999 99 9999999 99 9999999 99 9999999 99 9999 9999999 99 9999999 99 9999 9999 999999 9999999 99 99 99 99 99 XXXXOXX
8. Pension NHS element entered Pension Start Date is 258DLEWIS 08 SEP 2005 blank 258 DL Whitley Org 20000573 DLAdoption Mrs Dorothy 20000573 15 JUL 2005 Pension NHS element entered Pension Start Date is 258DLEWIS 16 SEP 2005 blank Culfa Page 1 of1 PIP 25 Rows per Page m Pension Changes and Highlights g Opening http esrhw mhapp nhs uk 40000 plus_files oracle discofimage EE Local intranet an GOBA B Zed san sar Me Mo Se em oe ENES oe 22 NHS Pensions Exceptions Analysis The NHS Pensions Exceptions Analysis highlights exceptions that occur at any time during a user specified period 26 This Analysis is split into various worksheets that allow you to review potential data errors that may require corrective action A Worksheet WTE Exception The WTE Exception worksheet lists those Employees where the sum of the WTE of their Assignments is greater than 1 0 It does not pick up Non recurring entries B Capacity Code is incompatible with Grade This worksheet lists those Assignments where the job name and capacity code are incompatible C Date of birth not verified This worksheet lists those Assignments where the Date of Birth Verified field is blank d Chosen Age to be reached in next 6 weeks This worksheet lists those Assignments where the Chosen Age to cease pension contributions will be reached within 6 weeks of the Period End Date
9. indicates they are Non Pensionable Criteria Data will be returned where the following is applicable NI Category on the NI Element is Pensionable D E or L but 1 No associated Pension NHS Element exits between the reporting start period and end period dates Or 2 The Pension NHS Element exists i e is active between the reporting start period and end period dates but e The Opt Out Flag is set to Yes yet the Opt Out Date is before or equal to the reporting period end date e The Opt Out Flag is set to Yes yet the Opt Out Date has not been set Or 28 e The Pension NHS Element has an effective End Date set that is Before or equal to the reporting period end date e The Pension NHS Element has an effective End Date that is before or equal to the reporting period end date yet no subsequent Pension NHS Element exits in its place G NI Cat shows Non Pensionable but Pension Element is active This worksheet lists those Assignments where the employee s National Insurance letter indicates Non Pensionable but the employee s pension record between the reporting start and end dates indicates they are Pensionable Criteria Data will be returned where the following is applicable NI Category on the NI Element is not Pensionable A B or J but 1 Pension NHS Element exists between the reporting start period and end period dates where
10. on band Allocation 11 7 NHS Pensions Exceptions Report This report is designed to highlight exceptions that relate to Pension Payments including a check of National Insurance Contributions amp Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C Run this Request Name NHS Pension Exceptions Report CEE American English Language Settings Debug Options At these Times Parameters Payroll IE Upon Completion Payroll Period i Layout Cancel Notify eal D Run the Job p uu Heb O swm 321 Toytown University Hospital Report Date NHS Pension Exception Report Report Parameters Payroll 321 Monthly Payroll Period 12 2005 Calendar Month O1 MAR OS 31 MAR OS 321 Toytown University Hospital Report Date Page NHS Pension Exception Report Organisation 25 ASE Nursing Staff Employee Last Neme Initials NI Number Assignment SD Number Reason For Exception 12345678 Smith AB AB123409Z 10007348 878765431 The Pensionable Hours in Period 271 Hrs exceed WTE for Grade 162 95 Hr 321 Toytown University Hospital Report Date Page NHS Pension Exception Report 12 The report will identify potential error on assignment records that affect the payment of Pensions Be aware it will report Opt Out Date missing for opt out records this message can be ignored as can some of the capacity code versus job roll exceptions for items such as Health care Assistants These
11. 4 Ward 9 20014602 SteeleOl Mrs 5 2004 Calendar Month 27 90 Kerry Payroll 27 90 Total Element Passenger Allowance NR NP NT NNI NHS 17 NHS Date Track Changes and Highlights Analysis This workbook displays selected date tracked changes and highlight selected conditions for current employees and leavers within a specified period 22 Full details of the report and sample output are available in the ESR Discoverer Reports user manual available on K Base The worksheets available are WORKSHEET EMPLOYEE CHANGES AND HIGHLIGHTS This worksheet lists selected date tracked changes and highlights selected conditions that relate to Employee data WORKSHEET ASSIGNMENT CHANGES AND HIGHLIGHTS This worksheet lists selected date tracked changes and highlights selected conditions that relate to Assignment data WORKSHEET PAYE amp NI CHANGES AND HIGHLIGHTS This worksheet lists selected date tracked changes and highlights selected conditions that relate to PAYE amp NI data WORKSHEET ELEMENT ENTRY CHANGES AND HIGHLIGHTS This worksheet lists selected date tracked changes and highlights selected conditions that relate to Element Entry data WORKSHEET OTHER CHANGES AND HIGHLIGHTS This worksheet lists selected date tracked changes and highlights selected conditions that relate to data other than employee assignment PAYE amp NI or element entries Data that falls into this category includes Pay Method Costing and Termina
12. 99999999 Consolidation Set Element Set Name NHS Pension Elements Element Name Organization Payroll Name Payroll Period Start Date 01 APR 09 Payroll Period End Date 30 APR 09 Accounting Period From Accounting Year From Accounting Period To Accounting Year To Sort Selection 1st Choice Sort Selection 2nd Choice Sort Selection 3rd Choice Input Value 1st Choice Input Value 2nd Choice Input Value 3rd Choice Trust Identifier nnn Aaaaaaaaaaaaaaa NHS Detail Element Report Healthcare NHS Trust Report Date 29 MAY 2009 15 59 Page 1 of 1 From 01 APR 2009 to 30 APR 2009 Element Set Name NHS Pension Elements Element Pension Add Yrs Full 1 NHS Payroll Name nnn Monthly Payroll Period 12009 Organisation Name Assignment Number Employee Name Leaving Date Input Value Name Result Value NNN General Medic 999999999 Consultant Dr medical 01 MAY 09 Employee Percentage 9 Senior Medical Staff Chosen Age 60 Yrs Purchased Days Purchased Date Worked Pay Value 619 43 Element Pension NHS Payroll Name nnn Monthly Payroll Period 12009 Organisation Name Assignment Number Employee Name Leaving Date Input Value Name Result Value Nnn General Medicine 99999999 Consultant Dr Medical 01 MAY 09 Scheme NHS Senior Medical Staff Capacity Code 3C Medical Staff Band C Override Pen Start Date Opt Out No Opt Out Date Pension Capping No Capping Date Employment ID 00 Pension Status None
13. ESR NHS Pensions Interface ESR Reports Introduction ESR has two methods of providing Reports firstly via the Requests facility various reports can be run Items 1 to 16 below contain relevant detail Users can also use Discoverer to provide various different repots as details in Items 17 to 24 below Users can also obtain details of the items reported on the various interfaces by requesting the available reporting spreadsheets via the NHS Hub 1 NHS Annual Pension List Report amp Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C File Edi gels Wi w Help SOSH Oe LIAO OIs12 fo Submit Request Run this Request Name NHS Annual Pension List Report American English Language Settings Debug Options At these Tin parameters Run D ED Pint noprint O O OOOO OO U UO O E D The report has been designed to allow the user to audit the year to date pension record for an assignment It is particularly useful for using alongside POL when a record has been rejected on the Year End interface but will also help you check records in year As can be seen above there are two parameters e Assignment enter assignment number for required record e Date This will default to today s date amend to relevant date e g 31 MAR 2009 to display year end data A sample report is displayed below Trust ID nnn Surname Forename s YTD 282 590 00 NI Number YTD 82 590
14. NHS Pension Band Allocation Report Parameters Tax year 2009 Percent 10 Message No No Message 8 712 Check Band Assignment has more than one 212 status in year Band defaulted due to hours worked in period 526 missing lt 0 Check Band No Grade or spot salary Defined Band defaulted due to pensionable pay in period 19 lt 0 Check Band Assignment on maternity but withno 8 OMP element Total 9 485 10 The following columns are then provided e Assignment Number e Lastname e First Name e Middle name Title e Latest Start Date e Assignment Status e Assignment Status count e Assignment Category e Payscale e Grade salary e Spot salary e Contract Hours e Override Hours e Annualised hours e Pensionable Pay e Hours Worked e Deemed Hours e Annualised WTE Pensioinable Pay e Old Capacity code e New Capacity code e Boundary Flag e Messages The reports are provided to give Payroll Pension staff details of the system determined Pension band allocation It should be noted that the script has produced the calculations based on the payroll runs completed up to the end of the tax year Contributions for the NHS Pension Scheme for the forthcoming Tax Year will be allocated against employees Whole time Annual Equivalent Pensionable Earnings in the previous financial year Any new joiner will be scaled up to an annualized Whole time equivalent See the separate document
15. NI Number SD Number 436 MonthlyT00 20015987 O08Steele K From 01 JAN 2003 to O8 APR 2005 WA436215a Contracted Hours Part Time 22 5 hours per week Assignment Number 20015987 Absence Days Tctal Pen Hrs Total TPP lt OSP gt lt OMP gt Pay Period Days fcr P T Staff Element Name Amount Deemed Pay for Period U F H N F H WN 31 JAN 03 31 97 77 0 00 9 00 o 0 Oo oO Oo 0 Q 28 FEB 03 28 97 77 0 00 0 00 6 00000 0 31 MAR 03 31 97 77 0 00 0 00 0 0 0 0 0 0 0 Totals 829 2665 86 0 00 0 00 14 9 NHS Pensions Agency Inbound Interface Report This report is an essential tool for Pensions Officers as it highlights potential problems with Pension Records As such it should be checked on a regular basis at the beginning of each pay period You will often find that items reported on here are records that are on the Data Matching Reports available from NHS Pensions and by correcting that data you will reduce the items on this report amp Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C EE elp ep JAN an I e ene 4osgsi2 lo O Submit Request Run this Request EEE American English Language Settings Debug Options At these Times Parameters r x GUTT As Soon as Possible Upon Completion Date To FY T Save all Output Files Notify Help Pusat The input parameters associated with this report are simply date from and date to A sample report is detailed below Report
16. Override Pen End Date Employment Type Specialist Employee Rate 7 5 Employer Rate 14 End of Report 3 NHS Element Result Listing This report can be run to identify payments in a given period This may be useful for reviewing items paid in a period or reviewing particular pay items It could be used to check items such as previous scheme arrears payments or added years etc TER ORACLE At these Tin Run Upon Comp Payroll Organisation Assignment Employee Sum Pay Value Name Name Number Name 436 MonthlyTO1 436 Ward 9 20016047 BakerOl Mrs Yve 2201 2 436 Ward 9 20015612 HollowayO1 Mr 758 22 Simon 436 Ward 9 20015787 Johnson01 Mr 1421 67 Andrew 436 Ward 9 20015954 LawrenceOl Mrs 1421 67 Mary 436 Ward 9 20016113 MartinOl Mrs 1421 67 Elizabeth 436 Ward 9 20016037 NevilleOl Mrs 1519 17 Christine 436 Ward 9 2nn1s79n Smirhoi Mr Ren 1421 67 436 Ward 9 20015668 SteeleOi Mrs 941 50 Kerry Payroll Total 11106 86 4 NHS Monthly Summary for Pension Schemes This report should be used to assist you in paying over the total Pension contributions due to NHS Pensions at the end of each month Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C DER en maa i s Run this Regues Parameters Start Date End Date At these Tin Run Upon Comp The NHS Monthly Summary for Pension Schemes gives the following amounts for each Payroll that has been run
17. XXXXXXXXXXXXXXXXX OKO XK XXXXXXXXXXX DD MON YYYY DD MON YYYY x XXXX Verified X XX XXXKKX XXKKK KXKKK XXXXXXX New Value Date of Change Effective Start Date x DD MON YYYY DD MON YY YY XXNNNNNNA DD MON YYYY DD MON YYYY DD MON YYYY DD MON YYYY DD MON YYYY 99 99 DD MON YYYY DD MON YYYY 19 13 NHS Redundancy Statement Report This report should not be used as it is not up too date you should use the POL calculator 14 NHS Salary History Report This report will detail the salary history of an assignment or a group of employee s From a pension point of view it may be useful in assessing unusual pay increases prior to the payment of an Award It also assists in pay quires Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C DER ORACLE oE Request Run this Request Name NHS Salary History Reporti Parameters COTE American English T eee Parameters At these Tin Payroll es bul Period Frorn S Period To i d Upon Comp a m o cD acs 15 NHS Summary Element Report This report details Pay Value run results processed for a particular element a defined period allowing the user to report on any payroll element or a predefined set of elements and provides totals by payroll and by report 20 amp Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C DER File Edit View Folder T vindow Help en 74 an i s na VUIO SS SRD Doe ZI4O
18. and employee assignment changes are highlighted 24 ESR NHS Pensions Interface ESR reports v1 0 doc Created by JStevenson to be Reviewed September 2010 Oracle Discoverer MCK NHS Employee Update Analysis File Edit Sheet Tools Graph Help a aGoGi TVONOHE g sti OS x AST 4 8 Bees NHS Employee Update Analysis Employee Update on 19 APR 05 at 05 04 46 PM Parameter Values Organisation Hierarchy 432 Women amp Children s 01 Record Legacy Surname Initials Title National Employee Start Date Status Payroll Insurance Category Number Changes O07 Lane WAS32375A Full Time 01 JAN 2001 Changes 007 Lawrence WA432186A Full Time 01 JAN 2001 Changes 007 Lewis Sarah Sarah WA432259A Full Time 01 JAN 2001 Changes 007 Neville Chesitine Chesitine WA4S32230A Full Time 01 JAN 2001 Changes DOBHolloway simon Simon WAS32202A Part Time 01 JAN 2001 2 Changes OCB Lawrence WA432195A Full Time 01 JAN 2001 Changes OCB Lewis WA432260A Full Time 01 JAN 2001 Changes OBS mith WA432245A Full Time 15 JUL 2003 Nif 4 Page1 gt gt gt 150 Rows per Page E Employee Update 20 NHS Leavers Analysis This workbook provides information about all leavers in an organisation for HR and management purposes Worksheet List of Leavers This worksheet displays personal detailed information for each leaver Worksheet By Leaving Reason This worksheet provides you with Leavers Information Monitoring by Leaving Reason in Summary and Detailed
19. are currently being reviewed However this is still a useful tool 7 NHS Pensionable Pay Report This report was designed to assist in determining TPP figures for Pension Award or Estimate purposes This report will be used when employees are approaching retirement so a figure of the Total Pensionable Pay can be forwarded to the Pensions Agency The report will provide a listing of the elements that have been used to calculate the Total Pensionable Pay This report will be applicable to non practitioner members only The TPP period usually covers a period of 365 paid days of pensionable employment but in certain circumstances it may be less than 365 days For example an employee may not be in employment for as long as 365 days Alternatively the Pensions Agency may request the TPP period to cover less than 365 days Where there is a period of unauthorised unpaid absence or unpaid sick leave the period over which pay for benefit purposes would normally be calculated would need to be extended backwards into the previous period for a period equal to the unpaid leave This will have the effect of making up the TPP period to 365 paid days This is commonly referred to as stepping back The report can also be used to estimate the TPP for a period in the future When forecasting the TPP will be calculated projected using the basic salary and any other recurring pensionable elements that form part of contractual pay e g shift allowance
20. during the specified period e Total Employer Pensionable Pay e Total Employee Pensionable Pay e Total Employee Contributions including Previous e Pension Arrears e Total Employer Contributions e Total Employee Additional Contributions pre 2008 e Total Add Pen Purchase e Total Contributions Where the assignment has been end dated the restriction will be assessed at the end date in all other cases the restriction will be assessed for each payroll period in the reporting period Only assignments that have been processed in a Payroll Run or Quick Pay or Reversal in the selected accounting year will be considered Report Display Form Name Field Name Name For the NHS Pension Scheme Total ER Pension Balance NHS_PENSIONED_PAY_ERS Pay Total EE Pension Balance NHS_PENSIONED_PAY_EES Pay Total EE Balance NHS_PENSION_CONT_EES Contribution NHS PREV_PEN_ ARREARS Total ER Balance NHS_PENSION_CONT_ERS Contribution Total EE Additional Balance NHS_ADDYRS_CONT Contribution pre NHS PREV_ADDYRS_ARREARS 2008 Total Add Pen Balance NHS_APP_TOT_EE CONT Purchase Total Cont for Period Calculated The sum of all the foregoing Number of Calculated A count of assignments which have at any time during the Employees reporting period had a Pension ER NHS run result with a non zero value 5 NHS Payment History Report This report provides a payment history for a giv
21. en number of periods This was designed for use in responding to pay queries covering a number of periods It could be of use to Pensions staff when reviewing a TPP or assessing pension banding Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C DER F en JAN an I e File Edit elp iJ 128 A American English ters At these Tir Payroll E Run 0 Upon Comp Cane CEE 6 NHS Pension Band Allocation Report This report allows users to check the band allocation applied at year end The table is only refreshed in a special once a year process run at the end of each financial year so you cannot run this in advance of year end DER Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C F a mata i s Eile Edit elp AFE Dsl fo Submit Request d Run this Request ECTE American English Language Settings Debug Options At these Times sl OAOT As Soon as Possible Tax Year End p009 Upon Completion Percent FY k Save all Output Files yn NHS Pension Band Allo Print to IESR NHS Pensions Interface ESR reports doc Microsoft Word wt AM Bo Bo Bo m E es one Bh This report allows users to check the band allocation applied at year end The table is only refreshed in a special once a year process run at the end of each financial year so you cannot run this in advance of year end The report header will show Name of EA
22. ion Assignment TPP Employee Employee Employer Contracted Pensziol Birth so Pension Additional Pension Out NI Pay Hours i Number Contribution Pension Contribution Tirq Contribution 20014725 HollowayO1 S WL4241874 01 J4N 1060 0 00 0 00 0 30 Page 1 of 150 Rows per Page E Recalled Leavers by Reason Code 24 Worksheet Maternity As part of the NHS Absence Management Analysis Workbook the Maternity Worksheet identifies employees who are on maternity leave as of the date selected and also identifies their expected return date This may be useful for checking employees returning from Maternity Leave and checking the Pension Arrears outstanding is correctly applied 25 Hub Spreadsheets These reports are spreadsheets that are produced on monthly basis and it contain all the records that have been sent to Pensions subsequent to the execution of the NHS Outbound Interfaces The spreadsheets have three separate tabs for each Outbound Interface Joiners Changes and Leavers The colour of each column within each separate tab indicates the frequency at which Pensions will upload the records on their system Also a Year End file will be produced once a year after the end of the Financial Year subsequent to the last to the last Payroll Updated Interface 30 Column Colours No colour updates applied immediately Orange updates stored Yellow updates applied cyclically The spreadsheets are
23. is instance the assignment had been terminated on ESR and there was no pension record on ESR This record needs to be closed down on POL it will be part of the data matching exercise iv API Error The HR object is invalid In this case the Pension Start Date is before the creation of the ESR Record Again the data matching process will identify these errors and they should be fixed using that process v API Error The primary key specified is invalid In this case the Pension Start date does not match the POL date Again this needs investigating as part of data matching vi Pension NHS Element Entry can not be found for this Assignment the EA had deleted the Pension element but that cancellation had not been passed across to NHS Pensions This record needs to be deleted from Pensions Systems Again data matching will pick this up 17 vii API Error DateTrack update not allowed for a record which started today In this case an incorrect Pen Override Date in the future is held on the Pension NHS element The system is saying it cannot update a record that has not commenced Amend the Pen Start Date on ESR collect arrears and correct record on POL 10 NHS Pensions Annual Benefit Statement Non Members This report was originally provided to assist in providing benefit estimates to non members It has not been updated for the New Scheme so should not now be used 11 NHS Periodic Payments Summary Report This report wi
24. ll history users are encouraged to download and keep a copy ona secure local directory 26 Payslip Address Report This report is available in the Payroll URP s but can be used to feed Address labels which can be used to direct leaflets etc to the employee The report only picks up the primary address but this ensures the leaflet gets to the employee 31
25. ll provide a summary or detailed list of payments made to an employee over the period input This is intended to assist in pay queries but can also assist pension staff in reviewing payments made to an employee when assessing total pensionable pay Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C File Edit o Submit Request Run this Request Name NHS Periodic Payment Summary Report ECTE American English Parameters At these Tin Payroll E ny From Time Pero o To Time Period is U C mary Mode a nmn o o as 18 12 NHS Periodic Pension List Report This report is similar to the Annual Pension List Report but is limited to a particular pay period and will show the same details for that individual period Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C er T Help E FEMEIE A At these Tin Par Run Upon Comp E ox J cancel JE clear A tote l LE tee ms Trust ID XXX Surname Forename s NI Number SD Number Assignment Number Employment ID Capacity Code Max Part Time Flag Employment Category Employee Category Euployment Type Pension Start Date Date of Leaving Tension Scheme Reason for Leaving Pension Scheme Address Line 1 Address Line Address Line 3 County Postcode Job Title Place of Employment MHO Indicator Field Changed Max Part Time Flag NI Number Date of Birth Standard
26. oegs Submit Request Run this Request At these Tin Run Upon Comp O Organisation Trust Identifier Summary Element Report Report Date Page 434 Buckinghamshire Hospitals NHS From 01 aUG 2004 to 31 aUG 2004 Trust Element Set Name NHS Expense Elements Element Parking Costs NR NP NT NNI NHS Payroll Organisation Assignment Employee Date of Payroll Name Name Number Name Leaving NHS Period Pay Value 434 MonthlyT01 434 Ward 9 20014602 Steele01 Mrs 5 2004 Calendar Month 27 90 Kerry Payroll 27 90 Total Element Passenger Allowance NR NP NT NNI NHS 16 Multiple Assignments Report This report is designed to assist in the monitoring of the Tax and NI position of employees with multiple assignments It is a useful document for Pensions as it helps identify those employees with more than one open assignment Oracle Applications PROD ESR Release 5 5 5 2A with DM24 0C DER File Edit ap Toe ndow Help en JAN an I e ZS x equest At these Times Run the Job Upon Completion Uptions Notif Print to Help C Cancel O Organisation Trust Identifier Summary Element Report Report Date Page 434 Buckinghamshire Hospitals NHS From 01 aUG 2004 to 31 AUG 2004 Trust Element Set Name NHS Expense Elements Element Parking Costs NR NP NT NNI NHS Payroll Organisation Assignment Employee Date of Payroll Name Name Number Name Leaving NHS Period Pay Value 434 MonthlyTO1 43
27. produced monthly over the first weekend of each month and contain data that was passed on the interface for the previous month An e mail notification advising the availability of the report is generated by the new process Trusts are asked to provide an appropriate e mail account to have the notifications delivered to The new report is produced by a process running on the NHS Interface Hub and the new reports will reside on the NHS Hub In order to safeguard the security of the data on the report users are provided with a secure web based mechanism to access the reports via the NHS Hub Where a Payroll Department is responsible for more than one VPD a single log on is provided that enables access to all the reports for the associated VPD s To obtain the log on credentials for your trust users are requested to log an SR on the ESR Helpdesk using the following text in the SR Summary replacing the nnn with the relevant VPD s that the caller is responsible for Please refer this call to the ESRNHSINT queue Please enable the NHS Interface Hub based Web Access to the Monthly Pension Interface Report for VPD s nnn nnn nnn and nnn Please send the e mail alerts to example address yourtrust nhs net The log on credentials will be added to the SR as will a copy of the User Guide which describes the log on process and the access mechanism Reports will be kept available for a period of 40 days In order for a user to have a fu
28. reports Worksheet By Destination This worksheet provides you with Leavers Information Monitoring by Destination in Summary and Detailed reports 25 21 NHS Pension Changes and Highlights Analysis This worksheet lists selected date tracked changes and highlights selected conditions that relate to pension data Columns e Employee No e Full Name e Assignment No e Effective Start Date e Highlights e Last Updated By e Last Update Date e Organisation Name Example Output Results E Oracle Application Server Discoverer MCK NHS Pension Changes and Highlights Analysis Microsoft Internet Explorer a xl File Edit Sheet Tools Graph Help QaVCSS AMNOAH I AMEX ATI amp A NHS Pension Changes and Highlights Analysis Pension Changes and Highlights a on 15 SEP 2005 at 03 22 35 PM Parameter Values Payroll 262 Monthly Organisation All i Report Type Payroll Period ed Organisation Employee Full Name Assignment Effective Highlights Last Updated By Last Update Number Start Date Date 258 DL Whitley Org 200004901 DLSutherland Mr Robert 20000401 01 JUL 2005 Pension NHS element entered Pension Start Date is 258DLEWIS 08 SEP 2005 blank 258 DL Whitley Org 20000496 DLExternal Sir Supervisor 20000496 01 JUL 2005 Pension NHS element entered Pension Start Date is 258DLEWIS 08 SEP 2005 blank 258 DL Whitley Org 200004907 DLManson Mr Andrew Fred 20000497 26 JUL 2005
29. s Assignment Assignment Number 20971418 Pension Start Date 03 SEP 2008 SD Number 76027569 Employment ID 9 Errors 1 API Error DateTrack update not allowed for a record which started today Assignment Number 10025749 2 Pension Start Date 27 APR 2003 SD Number 60122482 Employment ID 6 Errors 1 API Error The primary key specified is invalid 16 End of Report Each error has to be considered on its own merit although a look at the assignment usually gives you a clue These items are trying to match on Assignment Number and Pension Start Date On examination of the data it was found the above errors were caused by the following i Unable to update record in Pensions Interface custom table In this case the record was a Bank Record and the Pension Start Date on the inbound was before the ESR record commenced ii Invalid Assignment Number In this case this is a legacy payroll number so the record has never been matched Check your Data matching spreadsheet and correct the outstanding error Then ask NHS Pensions to resend the inbound interface data Other cases of this had a correct Assignment Number and so presumably had been passed across from ESR to NHS Pensions This looks like a legacy error from pre go live days You need to check the record on POL as it is possible an incorrect employee exists on your EA code Discuss with Data Management Team iii Pension Start Date is NULL In th
30. tion data 18 NHS Employee Change Event Log Workbook The NHS Employee Change Event log provides details on change events that have occurred against employees during a given period 23 Sample output Oracle Discoverer MCK NHS Employee Change Event Log OE x File Edit Sheet Tools Graph Help QavVos i A9OOAH 9 t DESKS amp SS Bees NHS Employee Change Event Log Employees on 19 APR 05 at 04 17 29 PM Parameter Values Organisation Hierarory 432 Women amp Children s 01 Change Date Change Event Full Name Employee Number Payroll 13 Feb 05 13 32 47 Update Assignment Location Peters06 Mrs Mary 20019198 12Feb 05 13 32 47 Update Person Grade Peters06 Mrs Mary 20019198 13 Feb 05 13 32 47 Update Assignment Location Holloway04 Mr Simon 20019204 13 Feb 05 13 32 47 Update Person Grade Holloway04 Mr Simon 20019204 13 Feb 05 13 32 47 Update Person Grade Craddock14 Mr Stuart 20018972 13 Feb 05 13 32 47 Update Person Grade Wright04 Ms Dierdre 20019211 13 Feb 05 13 32 47 Update Employment Category Johnson04 Mr Andrew 20019210 13 Feb 05 13 32 47 Update Person Grade Johnson04 Mr Andrew 20019210 4 PEDOL D Ni a Page1 gt 150 Rows per Page E Employees 19 NHS Employee Update Analysis This worksheet lists starters leavers and current employee details for a specified organisation hierarchy within a defined reporting period New starters leavers
Download Pdf Manuals
Related Search