Home

Quick Pay Checker User Manual 4.6 Draft.

1. Full Name ki Employee No ius Assignment No Ba Element Name Source Element Stewart Mrs Anabela NA219029A 219029 219029 Advance 0 62 0 62 Misc Net Deduction Stewart Mrs Anabela NA219029A 219029 219029 Basic Salary 761 54 761 54 Basic Pay Stewart Mrs Anabela NA219029A 219029 219029 Net Pay 1 927 43 1 927 43 Bank Transfer Stewart Mrs Anabela NA219029A 219029 219029 NI Employee 22942 229 42 Employee NIC Stewart Mrs Anabela NA219029A 219029 219029 NI Employer 266 96 266 96 Employer NIC Stewart Mrs Anabela NA219029A 219029 219029 Occupational Maternity Pay 1 960 05 1 960 05 OMP 100 Stewart Mrs Anabela NA219029A 219029 219029 PAYE E 404 20 404 20 Tax paid Stewart Mrs Anabela NA219029A 219029 219029 Pension Ees Contribution 159 92 159 92 Pension Stewart Mrs Anabela NA219029A 219029 219029 Pension Ers Contribution E 239 89 239 89 Pension Ers Stewart Mrs Anabela NA219029A 219029 219029 Taxable Pay E 2 561 67 2 561 67 Taxable Pay To close the side by side view you simple need to close one of the windows and click on the remove filter icon to restore the remaining window Page 43 of 56 Quick Pay Checker User Manual 4 6 3 10 6 Show Next Show Previous After comparing the results for a specific employee the Show Next and Show Previous icons allow the user to automatically move on the next employee with a difference in the side by side comparison view This allows users to
2. rename the source data elements to restore a one to one mapping or a many to one mapping as shown below Overtime 1 Overtime Overtime 2 Overtime Double Overtime 1 5 Overtime Time and Half 2 The alternative method is to combine the individual target elements into a common element name or alias If you are using the Oracle Payroll data extraction reports this can be easily managed by entering the element aliases in the XXPCT ELEMENT MAPPING application utility lookup table A common example of this is if you are mapping individual NI contribution elements It is common to alias the individual NI category contributions into a single element value such as NI Employee or NI Employer When the element mapping information has been entered click the Check Mapping toolbar icon 121 or use the toolbar menu Parallel Run gt Mapping gt Check Mapping to sort the element list so that the combined totals can be correctly calculated Page 15 of 56 Quick Pay Checker User Manual 4 6 3 3 Entering the Source Data The Source Sheet contains the payroll run results from the source legacy payroll and needs to be provided in the following format Full Name ID Employee No Element Name Source Value Optional field that should be provided to help identify individuals Can be provided in any format MANDATORY This is the reference that the tool uses to match source data to the target payroll data This typically can be NI
3. e Click on the Custom Settings button e Inthe ActiveX controls and plug ins section ensure Download unsigned Activex controls is set to Enable or Prompt e Click OK to save these settings e Open Microsoft Excel and open Tools gt Macro gt Security e Ensure Security Level is no higher than Medium e Click on the Trusted Publishers tab and set Trust access to Visual Basic Project check box Page 48 of 56 Quick Pay Checker User Manual 4 6 Once the integrators have been created and the form function associations have been completed a layout is required The layout should be created to replicate the Oracle Sheet in the Parallel Run Comparison Tool The Layout should be the same for both views Layout Name Par Value Report Layout Mame Net Pay Report Prepayments Select All Select None Select Field Name PAYROLL ACTION ID xl PAYROLL MAME xl PERIOD MAME xl FULL MAME x MI NUMBER xl EMPLOYEE SLUMBER xl ASSIGNMENT NUMBER xl ELEMENT MAME xl PAY VALLE Default Value H t e f T F Line Header 1 Header 1 Line Line Line Line Line RAE Linie Page 49 of 56 Default Type Mane None none none 21 none 21 None zl None Quick Pay Checker User Manual 4 6 4 2 Extracting the Target Data from Oracle Payroll 4 2 1 Extracting the Results using SQL To extrac
4. 3 9 1 Create New Parallel Run Sheet Once all the mappings errors have been rectified and both the Source sheet and the Target sheets are populated with the latest data the comparison checks can be started Click on the New Run icon on the toolbar or select Parallel Run gt Run gt Create New Run from the Menu bar to create a new blank worksheet for the comparison report A new worksheet will be created depending on the next run number If this is the first run then a new worksheet called Run 1 will be created Summary Mapping Source Target Run 1 s Initially the run sheet is blank so the process will ask if you want to generate the run results now If you select Yes the comparison process will start If you click No the sheet will remain blank You can start the comparison process anytime by clicking the Create Run Results icon zi or selecting Parallel Run gt Run gt Create Run Results from the menu bar v Page 32 of 56 Quick Pay Checker User Manual 4 6 3 9 2 Match Tolerance Settings Before you generate the run results you may want to adjust the tolerance settings of the comparison process l e set the level of match acceptance By default the tolerance setting is set to 1p so that anything less than 1p difference is classified as an exact match If you want to change the tolerance settings click on the da Set Match Tolerance icon on the tool bar or select Parallel Run gt Tools
5. users can define which balances are extracted and can also change the name of specific elements in the report where several target elements need to be mapped to a single source element Full Name Employee No BB X Assignment No BB Element Name B OraciePavvalue B Gane Katherine 219187 219187 219187 Advance 244 22 Gane Katherine 219187 219187 219187 Basic Salary 9500 Gane Katherine 219187 219187 219187 Dental Salary Sacrifice 21 65 Gane Katherine 219187 219187 219187 Net Pay 5332 45 Gane Katherine 219187 219187 219187 NI Employee 404 22 Gane Katherine 219187 218187 219187 NI Employer 1103 66 Gane Katherine 219187 219187 219187 PAYE 3117 46 Gane Katherine 219187 219187 219187 Pension Ees Contribution 380 Gane Katherine 219187 219187 219187 Pension Ers Contribution 2327 5 Gane Katherine 219187 219187 219187 Tax Adjust 21 65 Gane Katherine 219187 219187 219187 Taxable Pay 9120 Holmes Jane 219065 219065 219065 Advance 0 15 Holmes Jane 219065 219065 219065 Basic Salary 7083 33 Holmes Jane 219065 219065 219065 Critical Illness Salary Sacrifice 24 68 Holmes Jane 219065 219065 219065 Dental Salary Sacrifice 21 65 Holmes Jane 219065 219065 219065 Net Pay 4630 72 Holmes Jane 219065 219065 219065 NI Employee 377 23 Holmes Jane 219065 219065 219065 NI Employer 758 21 Holmes Jane 219065 219065 219065 PAYE 1340 68 Holmes Jane 219065 219065 219065 Pension Ees Contribution 637 5 Holmes Jane 219065 219065 219065 Pension Ers Contribution
6. 1 574 26 REASON Emp Missing Employee Not Found in Target Data Emp Missing Emplayee Mot Found in Target Data Emp Missing Emplayee Mot Found in Target Data Emp Missing Emplayee Mot Found in Target Data Emp Missing Employee Mot Found in Target Data Emp Missing Employee Not Found in Target Data Emp Missing Emplayee Mot Found in Target Data Unmatched transactions occur for the following reasons Page 35 of 56 An employee is missing an element in the target run results An employee on the Source Sheet is missing from the Target Sheet A mapped source element has not been included in the target results A source element has been mapped to the wrong target element Quick Pay Checker User Manual 4 6 3 9 5 Parallel Run Results Summary Statistics For each run the summary sheet provides comparison result statistics and for ranges of differences for each transaction line An overall percentage success figure is also provided to quickly ascertain the success of the run Parallel Run Results Total Data Element Lines 2961 Data Lines Unmatched Employee Missing 10 Data Lines Unmatched Element Not Found 40 Element lines to within 2p IELI Element lines that are between 2p 10p Difference 20 Element lines that between 10p 1 Difference 38 Element lines that are between 1 10 Diference 14 Element lines that are between 10 100 Diference 2f Element lines that are between 100 1000 Difference 19 Element lines tha
7. 72 480 286 00 64 28 Pension Pension Ees Contribution 75 078 44 75 078 44 75 143 37 64 93 memi dk Enter Unmapped Elements Below 1 945 860 11 1 945 860 11 3 766 046 86 1 820 186 75 Adjust NI Tax Adjust Unmapped Data Elements A Unmapped Oracle Elements fy Taxable pay Adjust MI Travel Insurance vertime Tax Adjust Taxable Pay Travel Salary Sacrifice Page 6 of 56 Quick Pay Checker User Manual 4 6 2 1 3 Source Sheet Summary Mapping Source Target The Source Sheet is the page that contains the data from the reference payroll system that is being replicated by the parallel run process As part of the payroll parallel run requirements a report will be required from the source system to provide the reference data for the payroll period that is being tested This Sheet determines the format that this data needs to be provided Full Name Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 218187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Bayes Mr Floyd 219233 Bayes Mr Floyd 219233 Bayes Mr Floyd 219233 Bayes Mr Floyd 219233 Bayes Mr Floyd 219233 Bayes Mr Floyd 219233 Employee No kul 27881 27881 27881 27881 27881 27881 27881 27881 27881 339925 339925 339925 33992
8. 850 Holmes Jane 219065 219065 219065 Tax Adjust 46 33 Holmes Jane 219065 219065 219065 Taxable Pay 6395 11 Oracle Lines Data Element Check A Data Employee Check A Unmatched Misc Meat Deduction Basit Pay HusvHees Hank Transter Employee NIC Employer NIC Tax paid Pension Pension Ers Season Ticket MAPPING ERROR Page 8 of 56 Quick Pay Checker User Manual 4 6 2 2 Toolbar Functions The tool has the following toolbar functions also known as Add Ins in Microsoft Excel 2007 Each function is referenced later in the manual when describing the functional operation of the parallel run comparison tool 34k 2 Seg go gk Ee d i New Sheet Information Create Run Results Set Match Tolerance Delete Run Results Find Check Mapping Next Clear Sheet Previous Add Line Compare Results Remove Line Remove Filter Add Unmapped Element Filter List Parallel Run 7 Toolbar functions are also available from the Parallel Run Menu Bar item Page 9 of 56 Quick Pay Checker User Manual 4 6 2 3 Parallel Run Approach The size of the payroll being tested i e number of employees will affect the approach used for parallel running For Small to Medium sized payrolls parallel run analysis can be more conducted at a more detailed level Comparisons at payroll element level are possible where the number of employees is less than 4000 For larger payrolls is it is more efficient to analysis balance data only e g taxable pay Nlable pay
9. Element Name column in the Mapping table or by using the Add Unmapped Element function 3 Each time the Target Data Sheet or Target Mapping Table information is changed the check mapping process should be run If this hasn t been done the Summary sheet will provide a warning CHECK MAPPING REQUIRED Page 28 of 56 Quick Pay Checker User Manual 4 6 3 8 Preliminary Run Early Indicators With both the Source and the Target data now loaded and verified the tool is now ready to produce the data comparison results However before starting the comparison there are now several early indicators that should be checked to help improve the comparison results 3 8 1 Missing Employee Early Indicator The Employee Count section on the Summary sheet counts the numbers of employee records and also cross references the employees between the Source sheet and the Target Sheet The number of discrepancies is highlighted To identify the missing employees select either error cell and click on the 4 information icon and click Yes Select the top cell to locate the employees that are included in the Target run results but do not exist in theSource data and select the bottom cell to locate the employees that are included in the Sob results There are Employees included in the Target run that are not on the Source Sheet Show list of missing employees Full Name gt m Power Mrs Yasmin NA219116A 219116 219116 Full Name
10. L I zd lu Distant Mr Chris NA219138A 965650 Bank transfer 3 725 81 Click on the remove filter icon K to restore the data back to the full list Page 29 of 56 Quick Pay Checker User Manual 4 6 You can alternatively identify the missing employees by filtering on Source Employee Check column on the Target sheet or the Target Employee Check column on the Source sheet F J M N Target Value B Combined Total Source Element Source Employee Check Fi 0 11 0 11 Misc Net Deduction Employee notin Source E 1 A Target Element Target Employee Check 3 725 81 Met Pay Employee notin Target Click on the remove filter icon K to restore the data back to the full list 3 8 2 Missing Element Early Indicator When the target data has been entered it is useful to check the mapping sheet for early indicators of potential missing or mismatched elements l e target elements defined in the mapping table but are not present in the source data and visa versa If there are occurrences of this the Summary sheet will display a Mapping Warning Selecting the Mapping Warning cell and clicking on the Information icon dg will display a dialog window explaining the reason for the warning Mapping Warning E Some potential mismatches have been identified on the mapping sheet highlighted in Orange These mismatches have been identified where pay values are only found on one side of a mapping These warnings will not stop
11. Source Mapping Table information is changed the check mapping process should be run If this hasn t been done the Summary sheet will provide a warning CHECK MAPPING REQUIRED Page 22 of 56 Quick Pay Checker User Manual 4 6 3 5 Extracting the Target Data With the source data and source element mapping complete the parallel run process can commence on the target payroll Target payroll results will now need to be extracted so that the data can be populated in the target data sheet Oracle Payroll users must run both the Payroll Run UK process and the Pre payments process to use the reports provided The Pay Value and the Balances Report both use the Payroll Run Process and the Net Pay report uses the Prepayments process See Section 4 2 for details on running the extraction SQL scripts or Web ADI integrators View Header View Line PAYROLL NAME Demo Monthly PERIOD NAME 6 2011 Calendar Month FULL NAME ID EMPLOYEE NUMBE ASSIGNMENT NUP ELEMENT NAME PAY VALUE Sandiford Mrs Deirc NA219187A 219187 219187 Advance 2344 22 Sandiford Mrs Deirc NA219187A 219187 219187 Basic Salary 9500 Sandiford Mrs Deirc NA2191874 219187 219187 Dental Salary Sacrifii 21 65 Sandiford Mrs Deirc NA219187A 219187 219187 Net Pay 5332 45 Sandiford Mrs Deirc NA219187A 219187 219187 NI Employee 404 2 Sandiford Mrs Deirc NA2191874 219187 219187 NI Employer 1103 66 Sandiford Mrs Deirc NA219187A 219187 219187 PAYE 3117 46 Sandiford Mrs Deirc NA219187A 219187 21
12. as discussed in Section 3 4 2 The Source Sheet Total now displays the total pay values entered on the Source Sheet This value is used to cross reference the Source Mapping Total which is the total pay values from the Mapping table to ensure all elements are mapped The Source Sheet Mapping Difference highlights any differences between pay values entered on the data sheet and total values in the mapping sheet This essentially means that there are source elements that included in the Source data missing from the mapping table SOURCE MAPPING ERROR More information about Summary error messages and warnings can be retrieved by selecting the error message and clicking on the information toolbar icon lg Page 21 of 56 Quick Pay Checker User Manual 4 6 i Some Source elements are not entered on the mapping sheet To fix run Check Mapping on the Source Sheet to get a list of unmapped elements Do you want to run this now To display the unmapped source elements run the Check Mapping process on the Mapping Sheet or the Source Data sheet J Unmapped Source Elements CSL Student Loan Ded Travel Insurance The unmapped source elements can be either by added manually by typing the missing element into the Source Element Name column in the Mapping table or select the next available row in the Source Element Name column and click the Add Unmapped Element toolbar icon Each time the Source Data Sheet or
13. gt Set Match Tolerance from the menu bar Select the tolerance from the drop down list and select applv The difference ranges on the summarv sheet will adjust accordingiv NOTE Vou can oniv change the match tolerance BEFORE anv comparison run results have been generated Once a comparison has been generated vou will not be able to adjust the match tolerance until vou have removed the generated results Page 33 of 56 Quick Pay Checker User Manual 4 6 3 9 3 Create Parallel Run Results To generate the comparison results click on the Create Run Results icon on the toolbar A run sheet must be present before the comparison report can be generated if a run sheet has not been created then the application will prompt for a new run sheet to be created first Depending on the size of the data set it may take a few moments to process the comparison Twit Ta ka im A fa ision Ers 5902 50 paid ployee NIC ployer NIC THT c Basic Adjustment E 8272 58 When the process is completed the Run Sheet will be populated with the comparison results and the Summary sheet will display the result statistics TA Full Name E Bn Element Name Source Valuet SOURCETotal TARGETIA DIFF Runswick MrAG NA184832A 431638 Bank transfer 5 840 31 5 840 31 5 840 31 Runswick Mr A G NA184832A 431638 Basic Pay 9 875 00 9 875 00 9 875 00 Runswick Mr A G NA184832A 431638 BusyBees
14. is mapped to a target object 3 4 1 Unmapped Source Elements If at the end of the check mapping process there is found to be source objects that are not entered in the mapping table then these objects are listed in the Unmapped Source elements column on the mapping sheet Difference Unmapped Source Elements B 3450 50 E 1168345050 CSL Student Loan Ded 1 907 95 E 21 907 95 Travel Insurance 1584260 1182358425 114 E Ls VN Mur sa NNI There are 2 unmapped Source Elements Do you want to add ALL these elements to the mapping table Page 17 of 56 Quick Pay Checker User Manual 4 6 The application will prompt the user to add these to the mapping table Choosing Yes at the prompt will move the unmapped source elements to the mapping table and automatically re run the check mapping process again The unmapped source elements can also be added manually by typing the missing element into the Source Element Name column in the Mapping table or by selecting the next available row in the Source Element Name column and clicking the Add Unmapped Element function on the toolbar Remember to enter the appropriate target element for each new object added to the mapping table axapie ray 1axapie ray ik Tey yuo E UNION Union Deduction E 200 CSL Student Loan Ded A 2 518 00 Travel Insurance E 150 99 Once all source elements are accounted for in the mapping table the check mapping process will c
15. need to modify the database view so that the correct ID value is return in the correct column after the Full Name For example the scripts in Appendix A use return the national identifer in the ID column You will need to change this all the places highlighted in yellow in the Appendix papf full name papf employee number paaf assignment number Compile these views as APPS in the Oracle Database containing the new payroll If you are planning to extract the reports using SQL query then this stage is now complete 4 1 4 Create Web ADI Integrators When access to SQL is difficult or if preferred the database views can be linked to Web ADI Integrators so that the Oracle run reports can be exported directly from the application Register the Views with the PAYWSACT Form l e the Payroll Process Folder For information on how to set up Web ADI integrators refer to the Oracle Support website for implementation guides See below for example entry on the HR Integrator Setup document Note you will need to create a custom application in Oracle for your integrators Metadata Type Application Short Integrator User Name View Name Form Name DOWLOAD Pay Value Report MAPCT GB PAY VALUES W PA WSACT DOWNLOAD Met Pay Report prepayments XXPCT GB MET PAY Vv PATWEARCDI NOTE Before using Web ADI you must ensure your desktop security settings are correct e Open internet explorer and open Tools gt Internet Options e Click on Security Tab
16. the comparison run fram running If data is found for an element in only the Source or Target data a potential mismatch is flagged up These elements are highlighted in orange on the Mapping Sheet Note These warnings will not stop the application from performing the comparison Page 30 of 56 Quick Pay Checker User Manual 4 6 Source Element Name EM Target Element Name Source Total Be Combined Source Total ia Combined Target Total Employee NIC NI Employee 106 692 23 106 692 23 106 390 73 Employer NIC NI Employer 211 065 95 211 065 95 210 720 36 OMP 100 Occupational Maternity Pay 15 682 09 15 582 09 15 682 09 OSP 100 6 548 91 6 548 91 Overtime 236 07 Overtime x 2 Overtime Double 252042 252042 2 520 62 Overtime x 1 12 236 04 236 04 Overtx 1 5 not 8am 8pm Overtime Time and Half 10 160 30 10 160 30 10 159 91 Tax paid PAYE E 480 221 72 480 221 72 473 876 26 These warning messages should help identify significant data issues before the main comparison run has even been started If they are unwanted elements then you may need to either remove the surplus element data from the Source data using the Remove Lines function or move the unwanted Target element to the below the Sum line of the mapping sheet so it is excluded from the comparison process Page 31 of 56 Quick Pay Checker User Manual 4 6 3 9 Generate the Parallel Run Results
17. the previous run then the reason entered on the previous run is copied into the current run If there is a change to a difference and a difference remains then the reason from the previous run is copied into the Previous Reason If Changed column REASON ASSIGNED Bg PREVIOUS REASON IF CHANGED 5 822 58 Basic Pay Adjustment separate in Oracle Run NONE 0 01 Error with Payment Formula z Repeat the process as many times until only acceptable differences remain Page 45 of 56 Quick Pay Checker User Manual 4 6 4 Oracle Payroll Installation and Configuration This section describes the steps required to Install and Configure the Quick Pay Checker data extraction scripts for Oracle Application Environment These steps need to be completed in every instance that Parallel Run Comparison data is to be extracted 4 1 Installing the Oracle Output Reports 4 1 1 Create Element Extract Table When extracting the pay values from the Oracle payroll run results the element name used by default is the element definition name The pay value extract allows the user to override this default where required For example one recommended use for this for combining different Oracle elements into a single common element name This is useful when there are multiple Oracle elements against a single source data element To enter the element name mappings e Create a new Application Uti
18. work methodically through each employee To close the side by side view you simple need to close one of the windows and click on the remove filter icon to restore the remaining window 3 10 7 Using Find opecific fields can be found using either the standard search facility in Microsoft Excel or by using the add in Find function Click on the d Find icon to launch the find toolbar Enter a value in the Find box and click the Enter button If you want to find an exact Match click on the Match button so that the option is set with a tick or set to x if you want a partial match Click on Find Next to proceed to the next match Find Next X Match w 398685 found at C 480 Page 44 of 56 Quick Pay Checker User Manual 4 6 3 11 Generating Successive Runs When you have either exhausted all the comparison checks or you have reached a tipping point where one or more common faults are responsible for a large number of differences it is time to fix the differences in the payroll system and move on to the next parallel run test To create a new run the steps taken in Section 3 need to be repeated e Repopulate the Oracle Sheet e Resolve any Mapping Issues e Perform Preliminary Error checks e Prepare the Data e Generate a new Run Sheet e Create the new run results A new run complete with statistics is displayed on the Summary Sheet On the new run sheet if there is a difference that has not changed since
19. 243 00 243 00 243 00 Runswick Mr A G NA184832A 431638 Employee NIC 405 61 405 61 405 61 Runswick Mr A G NA184832A 431638 Employer NIC 1 121 41 1 121 41 1 121 41 Runswick Mr A G NA184832A 431638 Misc Net Deduction 9 32 9 32 9 32 Runswick Mr A G NA184832A 431638 Pension 395 00 395 00 395 00 Runswick Mr A G NA184832A 431638 Pension Ers 59250 59250 59250 Runswick Mr A G NA184832A 431638 Season Ticket 103 50 103 50 103 50 Runswick Mr AG NA184832A 431638 Tax paid 287826 287826 287826 Runswick MrAG NA184832A 431638 Taxable pay 9237 00 9237 00 9237 00 Barre Mr Abderrazak NA185756A 437478 Bank transfer 5 937 75 5 937 75 6 517 75 580 00 Barre Mr Abderrazak NA185756A 437478 Basic Pay 7 677 42 7 677 42 8 500 00 822 58 Barre Mr Abderrazak NA185756A 437478 Employee NIC E 405 01 405 01 455 67 50 66 Barre Mr Abderrazak NA185756A 437478 Employer NIC 111378 1 113 78 1 278 13 164 35 Barre Mr Abderrazak NA185756A 437478 Misc Basic Adjustment 822 58 822 58 822 58 Barre Mr Abderrazak NA185756A 437478 Tax paid 2 834 66 2 834 66 2 999 18 164 52 Barre Mr Abderrazak NA185756A 437478 Taxable pay 9177 42 917742 10 000 00 82258 Barrett Mr Abdul NA191742A 396328 Bank transfer 3 840 87 3 840 87 3 840 87 Marrat Bie A Hil RIAANATANA 4ncann Nanaia Ma
20. 5 339925 339925 Oracle Element Check A MAPPING ERRUR MAPPING ERRUR MAPPING ERRUR MAPPING ERROR MAPPING ERRUR MAPPING ERRUR MAPPING ERRUR MAPPING ERRUR MAPPING ERRUR MAPPING ERROR MAPPING ERRUR Page 7 of 56 Element Name Critical Illness Misc Net Deduction Employee NIC Employer MIC Pension Ers Tax paid Bank transfer Basic Pay Taxable pay Pension Misc Net Deduction Employee NIC Employer NIC Pension Ers Tax paid Oracle Employee Check us Employee notin Oracle mmmmmhm mm A MIA A dh Source Value Ba 7375 0 11 369 17 654 96 1 275 00 1 654 66 3 568 98 5 666 67 5 666 67 1 100 00 130 90 412 24 1 206 27 2 915 00 3 041 86 Quick Pay Checker User Manual 4 6 2 1 4 Target Sheet Summary Mapping Source Target The Target Sheet is the page that contains the payroll run results from the new payroll system for comparison against the source reference data This sheet is usually the last sheet to be populated and when completed means that the tool is ready to generate run result comparisons A number of SQL database views are provided with this version of the tool to use with Oracle Payroll to create Web ADI download reports or for use as direct SQL queries Using the views provided ensures that data is extracted in the correct format With Oracle Applications users are also able to manage the data that is exported by the views For example
21. 9187 Pension Ees Contrib 380 Sandiford Mrs Deirc NA2191874 219187 219187 Pension Ers Contribi 2327 5 Sandiford Mrs Deirc NA219187A 219187 219187 Tax Adjust 21 65 Sandiford Mrs Deirc NA219187A 219187 219187 Taxable Pay 9120 Orchard Ms Annie NA2190654 219065 219065 Advance 0 15 Orchard Ms Annie NA219065A 219065 219065 Basic Salary 7083 33 Orchard Ms Annie NA219065A 219065 219065 Critical Illness Salary 24 68 Orchard Ms Annie N 219065A 219065 219065 Dental Salary Sacrifi 21 65 Orchard Ms Annie NA2190654 219065 219065 Het Pay 4630 72 Orchard Ms Annie NA219065A 219065 219065 NI Employee 377 23 Orchard Ms Annie NA219065 219065 219065 NI Employer 758 21 Orchard Ms Annie NA2190654 219065 219065 PAYE 1340 68 Orchard Ms Annie NA219065A 219065 219065 Pension Ees Contrib 637 5 Orchard Ms Annie MA219065 219065 219065 Pension Ers Contribi 850 Orchard Ms Annie NA219065A 219065 219065 Tax Adjust 46 33 Page 23 of 56 Quick Pay Checker User Manual 4 3 6 Entering the 6 Target Data However the target data is extracted it must be populated in the Target data sheet in the following format e Full Name e ID e Employee No e Assignment No e Element Name Pay Value Optional field that should be provided to help identify individuals Can be provided in any format MANDATORY This is the reference that the tool uses to match source data to the target payroll data This typically can be NI Number or Employee Num
22. Healthcare Healthcare Cash Plan Salary Sacrifice Additional Responsibility Higher Duties Holiday Pay Holiday Pay Buy Annual Leave Holiday Purchase Net Advance Recovery Net Pay Adjustment CF E Employee NIC NI Employee E Employer NIC NI Employer E E When the element or balance names are entered the sheet will reference the source and target data sheets to total the pay value for each item added IMPORTANT When entering elements all entries must be made above the sum total line indicated by END END Enter Unmapped Elements Below 3 2 3 Adding or Removing lines from the Mapping Table If you need to add or remove lines from the mapping sheet use the SR Add Lines or Remove Lines toolbar icons Clicking on the Add Lines icon will create one additional line above the sum total line To add multiple lines simply select the number of rows you want to add by selecting a range of cells in column A and then click on the Add Lines icon This function is also accessible from the drop down Menu bar Parallel Run Mapping Add New Lines To remove lines select either a single line or a range of lines and click on the ES remove lines icon You will be prompted to accept the delete before the lines and data if the line is populate is removed rax pala PATE Pension Pension H Pension Ers Pension B Medical Ins
23. Number or Employee Number If the employee numbers are changing then using the NI Number as a comparison is the preferable as it eliminates any need to manually map the employee number from old number to new number Optional In case the ID used is not the employee number a separate column is available to hold this value which will be useful when referencing the source payroll system MANDATORY The name or ID of the source element or balance that has been paid deducted These elements will need to be recorded in the first column on the mapping sheet IMPORTANT Only include elements balances that need to be tested MANDATORY Monetary value of the payment deduction or balance IMPORTANT Deductions in Oracle are exported as positive monetary values To ensure correct comparisons ensure that the source deductions are also positive otherwise a large discrepancy is reported Copy and Paste the source reference pay result data into the first 5 columns only Ensure that the data is populated into the correct columns and that the 3 mandatory columns are populated Full Name and Employee Number are optional columns Full Name Sandiford Mrs Deirdre Sandiford Sandiford Sandiford Sandiford Sandiford Sandiford Sandiford Sandiford Bayes Bayes Bayes Bayes Bayes Bayes Mrs Deirdre Mrs Deirdre Mrs Deirdre Mrs Deirdre Mrs Deirdre Mrs Deirdre Mrs Deirdre Mrs Deirdre Mr Floyd Mr Floyd Mr Floy
24. ON NIABLE PAY select DISTINCT paa payroll_action_id ppf payroll_name ptp period_name papf full_name papf national_identifier ID papf employee_number paaf assignment_number NIable Pay Element_Name hr gbbal calc all balances ptp end date PAAF ASSIGNMENT ID pdb defined balance id Pay Value from pay assignment actions paa pay payroll actions ppa per all assignments f paaf per all people Fr papt pay balance types pbt pay balance dimensions pbd pay defined balances pdb pay all payrolls f ppt per time periods ptp where ppa pavroll action id paa payroll action id and paa assignment id paaf assignment id and paaf person id papf person id and ppa effective date between papf effective start date and papf effective end date and ppa effective date between paaf effective start date and paaf effective end date and ppa paeayroll id ppf pavroll id and ppa effective date between ppf effective start date and ppf effective end date and ppa time period id ptp time period id and pbt balance name NIable Pay and pbt legislation code GB and pbt business Group id IS NULL and pbd dimension name ASG RUN and pbd legislation code GB and pbt balance type id pdb balance type id and pbd balance dimension id pdb balance dimension id RE USE THE NIABLE PAY SELECT STATEMENT TO ADD OTHER BALANCES IF REQUIRED Page 54 of 56 Quick Pay Checker User Manual 4 6 XXPCT GB NET PAY V Retur
25. Quick Pay Checker Quick Pay Solutions Ltd Quick Pay Checker Parallel Run Comparison Tool User Manual Version 4 6 Draft Last Updated 24 June 2012 Quick Pay Checker User Manual 4 6 TABLE OF CONTENTS 1 INTRODUCTION ml h PURPOSE MANAGEMENT SUMMARY 2 OVERVIEW 2 1 2 1 1 2 12 2 1 3 2 1 4 2 2 2 3 2 A 2 5 WORKSHEETS SUMMARV SHEET MAPPING SHEET SOURCE SHEET TARGET SHEET TOOLBAR FUNCTIONS PARALLEL RUN APPROACH ELEMENT MAPPING OVERVIEW PARALLEL RUN PROCESS OVERVIEW 3 USING THE QUICK PAV CHECKER TOOL SET PROJECT ENVIRONMENT PROPERTIES ENTER PRE DEFINED MAPPING DETAILS SCOPE OF THE MAPPING ENTERING MAPPING INFORMATION ADDING OR REMOVING LINES FROM THE MAPPING TABLE MAPPING RULES ENTERING THE SOURCE DATA CHECKING THE SOURCE DATA UNMAPPED SOURCE ELEMENTS REMOVING UNWANTED SOURCE DATA SOURCE DATA SUMMARY INFORMATION EXTRACTING THE TARGET DATA ENTERING THE TARGET DATA CHECKING THE TARGET DATA UNMAPPED TARGET ELEMENTS REMOVING UNWANTED TARGET DATA TARGET DATA SUMMARV INFORMATION PRELIMINARY RUN EARLY INDICATORS MISSING EMPLOYEE EARLY INDICATOR MISSING ELEMENT EARLY INDICATOR GENERATE THE PARALLEL RUN RESULTS CREATE NEW PARALLEL RUN SHEET MATCH TOLERANCE SETTINGS CREATE PARALLEL RUN RESULTS PARALLEL RUN RESULT SHEET PARALLEL RUN RESULTS SUMMARY STATISTICS UNMATCHED SOURCE TRANSACTIONS DIFFERENCE SUMMARY UNMATCHED TARGET TRANSACTIONS Page 2 of 56 Quick Pay Chec
26. Target Data Employee Not Found in Target Data 3 10 3 Running the Element Difference Report Before analysing the individual differences it is useful to run the Element Difference Report This report produces a list of total percentage differences for each element This is useful to highlight key issues with specific elements early in the analysis process On the summary sheet this can be run from the menu bar Parallel Run Reports Element Difference Report 100 00 100 00 Overtime x 1 12 100 0095 SSP Amount 100 0095 Overtx 1 5 not 83am 8pm SMP amount Overtime x2 CSL Student Loan Ded Buy Annual Leave Page 42 of 56 Quick Pay Checker User Manual 4 6 3 10 4 Filter List The Filter List function will toggle the view on the Parallel Run Results through each difference range The DIFF column on the parallel run results sheet will indicate which range is currently filtered Click on the filter icon to cycle through the various ranges melle r a a eee TARGET ARGET 100 1000 293 00 600 545833 29168 5458 33 291 68 41664 875 533245 356898 40422 369 17 21081 669 950000 566667 1 103 66 654 96 Click on the remove filter icon to restore the parallel run result data back to the full list 3 10 5 Compare Side By Side When viewing the differences it is possible to compare the source and the target data for a specific employee in two
27. action id ppf payroll name ptp period name papt tull name papf employee number paaf assignment number SUM prrv result value PAY VALUE from pay run result values prrv pay run results prr pay element types f petf pay assignment actions paa per all assignments f paaf per all people f papf pay input values f pivf pay payroll actions ppa pay all payrolls f ppf per time periods ptp where prrv run result id prr run result id and prr element type id petf element type id and prr assignment action id paa assignment action id and paa payroll action id ppa payroll action id and paa assignment id paaf assignment id and ppa effective date between papf effective start date and papf effective end date and ppa effective date between paaf effective start date and paaf effective end date and ppa effective date between petf effective start date and petf effective end date and ppa effective date between pivf effective start date and pivf effective end date and paaf person id papf person id and prrv input value id pivf input value id and pivf name Pay Value and ppa payroll id ppf payroll id and ppa effective date between ppf effective start date and ppf effective end date and ppa time period id ptp time period id and prrv result value IS NOT NULL and petf element name NOT IN group by paa payroll action id ppf payroll name ptp period name papf full n
28. age 10 of 56 Quick Pay Checker User Manual 4 6 2 5 Parallel Run Process Overview To achieve the best results with this tool there is a recommended approach that should be followed Adopting this process for the parallel run testing will improve the quality of the run result comparison and reduce the time and effort in completing the parallel run analysis 1 2 10 11 Define the scope of the parallel run e g payroll and period Enter the pre defined element mapping information Extract the Source run results and populate the Source data sheet Complete and validate the source to target element mapping table Run the Test Payroll Extract the Target Data run results and populate the Target data sheet Create New Run Sheet Generate the Parallel Run comparison results Run the comparison report and start to analyse the differences Populate the Results Sheet with reasons and assign Actions Problem resolution Repeat Steps 5 11 until the remaining differences are all acceptable Each process step is discussed in detail in the next section Page 11 of 56 Quick Pay Checker User Manual 4 6 3 Using the Quick Pay Checker Tool This chapter describes how to use the Quick Pay Checker tool for each stage of the parallel run process 3 1 Set Project Environment Properties The project environment properties dialog box is launched automatically when opening the application and can also be invoked from the tool
29. ame papf employe e number paaf assignment number papf national identifier petf element name UNION TAXABLE PAY select DISTINCT paa payroll_action_id ppf payroll_name ptp period_name papf full_name papf national_identifier ID papf employee_number paaf assignment_number Taxable Pay Element_Name Page 53 of 56 Quick Pay Checker User Manual 4 6 hr gbbal calc all balances ptp end date PAAF ASSIGNMENT ID pdb defined balance id Pay Value from pay assignment actions paa pay payroll actions ppa per all assignments f paaf per all people f papf pay balance types pbt pay balance dimensions pbd pay defined balances pdb pay all payrolls f ppf per time periods ptp where ppa pavroll action id paa payroll action id and paa assignment id paaf assignment id and paaf person id papf person id and ppa effective date between papf effective start date and papf effective end date and ppa effective date between paaf effective start date and paaf effective end date and ppa payroll id ppf payroll id and ppa effective date between ppf effective start date and ppf effective end date and ppa time period id ptp time period id and pbt balance name Taxable Pay and pbt legislation code GB and pbt business Group id IS NULL and pbd dimension name ASG RUN and pbd legislation code GB and pbt balance type id pdb balance type id and pbd balance dimension id pdb balance dimension id UNI
30. and click on the information icon 4 Selecting Yes at the prompt will automatically filter the results to show the missing transactions for the category selected There are 40 lines unmatched because the element is missing from the J Target run results This will be because either the element has not been entered into Target or the mapping between the Source Element and the Target Element is incorrect for the individual assignment There may need to be changes made to the element name on the Source Sheet Show a list of unmatched run results No Click on the remove filter icon W to restore the results back to the full list 3 9 7 Difference Summary The summary sheet provides the number of differences by range For each value in the differences column the information icon can be used to view the corresponding transactions that comprise the total Select the cell and click on the information icon on the toolbar Le Page 37 of 56 Quick Pay Checker User Manual 4 6 Selecting Yes at the prompt will automatically filter the results to show only differences for the range selected G L Deere Br cae srs Bs te o E 405 01 455 67 50 66 E 169 00 117 00 52 00 E 1888 15 192743 39 28 709 68 76154 51 86 Click on the remove filter icon K to restore the results back to the full list The unmatched Net Pay Lines and Net Pay differences highlighted in the Net Pay Summary se
31. bar menu Parallel Run gt Tools gt Set Environment Set Environment M Company Name Demo Company Project Mame Demo Project Payroll Name Demo Monthly Period Name September 2011 Source Source Target Target W Launch properties window on startup e Companv Name Name of the organisation that the product is licensed to For e Project Name e Pavroll Name e Period Name Source e Target evaluation copies users can edit this property Enter the name of the payroll implementation project Enter the name of the new payroll that is being tested Enter the payroll period that is being tested Edit this property if you want to change the name of the source data system i e the payroll system that is the reference point for the new payroll Note the Source worksheet name will change to this property Edit this property if you want to change the name of the target data system i e the new payroll system that is replicating the source system Note the Target worksheet name will change to this property Deselect the launch properties checkbox to disable the Set Environment dialog box from launching on start up Page 12 of 56 Quick Pay Checker User Manual 4 6 3 2 Enter pre defined mapping details The Quick Pay Checker does not in any way replace current project methodologies or practices For the tool to work effectively the Payroll Project Team need to perform an accurate element mappin
32. ber If the employee numbers are changing then using the NI Number as a comparison is the preferable as it eliminates any need to manually map the employee number from old number to new number Optional In case the ID used is not the employee number a separate column is available to hold this value which will be useful when referencing the source payroll system Optional In case of multiple assignments the assignment number could be different to the employee number so a separate column is available to hold this value which will be useful when analysing the target payroll system MANDATORY The name or ID of the target element or balance that has been paid deducted These elements will need to be recorded in the second column on the mapping sheet MANDATORY Monetary value of the payment deduction or balance Copy and Paste the target reference pay result data into the first 6 columns only If the target data is You will need to paste the results from the second report to the bottom of the first report so that the Oracle Sheet contains the results from both reports Full Name Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Sandiford Mrs Deirdre 219187 Orc
33. ction can be identified in the same way as described above using the information icon Unmatched Net Pay Lines may occur for the following reasons e Anemployee on the Source Sheet is missing from the Target Sheet e For Oracle Payroll users missing net pay transactions may be due to the employee not having a payment method The Net Pay report will only retrieve Net Pays for employees with a BACS payment method on the assignment record Page 38 of 56 Quick Pay Checker User Manual 4 6 3 9 8 Unmatched Target Transactions The Summary sheet also provides a summary of Target transactions not matched to Source transactions On the Summary sheet the number of unmatched Target lines is highlighted ce Results This will be due to either employees or element entries not existing in the Source Sheet Show a list of unmatched run results To locate the unmatched lines select the cell and click the information icon Mi M N P Source Element Source Employee Check ie Target Lines Unmatched KA Misc Net Deduction Employee notin Source Notin Run Basic Pay Hot in Run Critical Illness Notin Run Bank Transfer Not in Run Emplayee MIC Hot in Run Employer NIC Not in Run Tax paid Not in Run Pension Ers Not in Run Taxable Pay Notin Run Click on the remove filter icon to restore the target data back to the full list Unmatched Target transactions occur for the following reasons e An employee on the Target Sheet is miss
34. d Mr Floyd Mr Floyd Mr Floyd Employee No ka em ia EE LE Name MAZ19157A 27881 Critical Illness E H 2198187A 27 881 Misc Met Deduction E NAZ19187A 27 881 Emplayee MIC E NA219187A 27881 Employer MIC E NAZ19187A 2 881 Pension Ers E MAZ19187A BT ax paid E N 2198187A 27881 Bank transfer E NH 2198187A 27881 Basic Pay E NA219187A 27881 Taxable pay E NAZ219233A 339925 Pension E N 2198233A 339925 Misc Met Deduction E N 219233A 339025 Employee NIC E N 2198233A 339025 Emplayer NIC E NH 219233A 330925 Pension Ers E N 2198233A 339925 Tax paid E Page 16 of 56 Source Value rim 0 11 369 17 654 96 1 275 00 1 654 66 3 558 98 5 666 67 5 666 67 1 100 00 130 90 412 24 1 206 27 2 915 00 3 041 86 Quick Pay Checker User Manual 4 6 3 4 Checking the Source Data After the source data has been populated the summary sheet will indicate that the check mapping function needs to be run to format and validate the source data CHECK MAPPING REQUIRED From the source data sheet click on the Check Mapping toolbar icon xi or use the toolbar menu Parallel Run gt Source gt Check Mapping to start the check mapping function which will format and validate the source data The check mapping function will perform the following functions and checks e Format the data and columns e Check to see if any source elements are missing from the mapping table e Check that the source object
35. e data sheet to recheck the data Select Yes to re run this process Another example of source data cleansing would be to remove all the rows of data where the pay value is 0 To do this simply select a cell in the Source Value column and click on the Remove Lines icon R or use the toolbar menu Parallel Run gt Source gt Remove Lines Page 19 of 56 Quick Pay Checker User Manual 4 6 Bank transfer 2 716 18 MetP Basic Pay 4208 34 H Employee NIC 35532 NII Employer MIC 477 74 NII Fension Ers E 946 88 Pel Season Ticket Loan Ded Tax paid 1 013 46 Taxable pay E 4 208 34 Bank transfer E 3 173 70 Basic Pay E 5 000 00 Employee NIC 359 80 Employer MIC 535 00 The remove lines function will work on all 5 Source data columns so the other columns can be used for removing unwanted source employees that should not be included in the parallel run comparison NA2190054 NAZ 190064 NA219006A NA219007A NA219007A NA219007A NA219007A NA219007A NA219007A NA219007A NAZT90074 NA219007A Page 20 of 56 Quick Pay Checker User Manual 4 6 3 4 3 Source Data Summary Information With Source Data populated the Summary sheet will provide additional information on the data entered The Source Employee Count will now report the number of employees loaded Check that this number is the expected number of employees Unwanted employees can be removed from the Source data sheet using the Remove Lines function
36. etc and other key elements such as Salary and Pension contributions 2 4 Element Mapping Overview The single most important requirement for a parallel run is accurate element mapping The success of the parallel run testing is dependent on correct mappings between the source payroll elements and the target payroll elements to be accurate Putting effort into ensuring the relationship between the source and the target elements is defined will drastically improve resolution times and increase the quality of the run result comparisons It is therefore recommended that this task is adopted early on in the implementation lifecycle so that when it is time for parallel running the link between source element and target element is well documented e If the parallel run tool is being used as part of a new Oracle Payroll implementation then the implementation methodology should include an element analysis document which maps client source elements to the new or existing elements in the Oracle Payroll system This mapping should include existing seeded elements as well as new custom built elements e lf the parallel run tool is being used to test two identical systems e g as part of a system upgrade etc then the element mapping is very straightforward since the source element names will be the same as the target element names However even though the element names are the same the mapping details will still need to be entered in the Mapping Sheet P
37. for a specific payroll period The tool has been designed for use with Oracle Payroll but the tool can be easily employed on other payroll systems Using Quick Pay Checker you can e Quickly identify differences between legacy and new payroll results e Perform up to 10 iterative runs for a specific payroll period e Record reasons for differences for each run for audit purposes e Allocate fixes to the right party for problem rectification e Roll over reasons from previous runs to avoid re analysis of the same problem on subsequent runs e Deliver detailed Management Statistics to keep sponsors informed on the progress of the parallel run process e Maintain a formal structure to the parallel run process to reduce time and effort during this potentially labour intensive process e Provides an auditable document for formal sign off a parallel run process In practice this tool can save up to 50 time and effort on a typical parallel run process IMPORTANT The Quick Pay Checker uses Visual Basic Macros Users must enable Macros when opening the tool to be able to use the functionality Page 4 of 56 Quick Pay Checker User Manual 4 6 2 Overview Quick Pay Checker is a simple but effective tool for quickly analysing payroll parallel run results for Payroll Implementation projects The tool itself is standalone and not system specific the tool comes with SQL reports to extract run results from Oracle Payroll systems with UK o
38. g analysis as part of the payroll implementation The more accurate this mapping is then the more effective the parallel run comparison will be An acceptable element mapping process should aim to marry every source element with a target element in the new payroll system This mapping information must be entered carefully into the mapping sheet Completing the element mapping involves entering the name of the source reference element in the first column and the name of the corresponding target payroll element in the second column However there are several rules that need to be obeyed when completing the mapping table The following sections describe how best to complete this section of the tool 3 2 1 Scope of the Mapping The top line on the mapping sheet is reserved for Net Pay mapping and must not be removed At the very minimum a mapping must be done between the source Net Pay element name and the target Net Pay element name All other mapping components are now optional For payroll with a large number of employees you should consider performing a parallel run analysis at a higher level and compare key balances only to find the differences Checking differences between individual elements with a large number of employees would introduce potentially very high numbers of differences to check If this detail is required then consider extending the scope later in the cycle when a lot of the key issues have been resolved and therefore the number
39. hard Ms Annie 219065 Orchard Ms Annie 219065 Orchard Ms Annie 219065 Orchard Ms Annie 219065 Orchard Ms Annie 219065 Orchard Ms Annie 219065 Orchard Ms Annie 219065 Orchard Ms Annie 219065 5 Employee No lu HA219187A NAZ191874 NAZ191874 HA219187 NAZ191874 NAZ191874 HA219187A NAZ191874 NA219187A NA21018 A NAZ191874 NA219065A MA219065A NA219065A H 219065A HA219065A H 219065A H 219065A HA219065A Page 24 of 56 Assignment No ku 219187 219187 219187 219187 219187 219187 219187 219187 219187 219187 219187 219065 219065 219065 219065 219065 219065 219065 219065 a ITE Name Advance Basic Salary Dental Salary Sacrifice Net Pay NI Employee NI Employer PAYE Pension Ees Contribution Pension Ers Contribution Tax Adjust Taxable Pay Advance Basic Salary Critical Illness Salary Sacrifice Dental Salary Sacrifice Net Pay NI Employee NI Employer PAYE Target Value 244 22 9500 21 65 XARRAB 404 22 1103 66 3117 46 380 2327 5 21 65 9120 0 15 7083 33 24 68 21 05 4630 72 377 23 738 21 1340 68 Quick Pay Checker User Manual 4 6 3 7 Checking the Target Data After the target data has been populated the summary sheet will indicate that the check mapping function needs to be run to format and validate the target data CHECK MAPPING REQUIRED From the target sheet click on the Check Mapping toolbar icon E or use the toolbar menu Parallel Run gt Ta
40. id papf person id AND ppa business group id papf business group id AND ptp end date BETWEEN papf effective start date AND papf effective end date AND ppa payroll id ppf payroll id AND paaf organization id haou organization id AND paaf business group id haou business group id AND ptp end date BETWEEN ppf effective start date AND ppf effective end date group by ppa payroll action id ppf payroll name ptp period name ptp end date paaf assignmen t id papf full name papf employee number paaf assignment number papf national iden tifier Page 55 of 56 Quick Pay Checker User Manual 4 6 End of Document Page 56 of 56
41. ing from the Source Sheet e Anelement entry in the Target run results is not found in the Source data e An information or unwanted element in the target results is included in the mapping Page 39 of 56 Quick Pay Checker User Manual 4 6 3 9 9 Regenerating the Parallel Run Results If for some reason the comparison report generated is unsuitable for checking for example perhaps a large number of elements have been omitted then the current run sheet can be overwritten by clicking on the Generate Run Results a button again ee E S S WARNING You will lose any reasons entered on the run sheet if you choose to regenerate a comparison report over the top of an existing report 3 9 10 Removing the Run Results Parallel Run Sheets can also be removed completely Only the latest run sheet can be removed To delete a parallel run sheet click on the Remove Run icon K on the toolbar Removing the parallel run results will also remove all statistics corresponding to the parallel run results Only perform this action if the latest parallel run results are no longer required Page 40 of 56 Quick Pay Checker User Manual 4 6 3 10 Analysing the Parallel Run Results With the parallel run results now complete the next task is to analyse the differences and determine the reason for the difference and the course of action to resolve the difference if required This can normally be a time consuming process but using the tools a
42. ker User Manual 4 6 3 9 9 3 9 10 3 10 3 10 1 3 10 2 3 10 3 3 10 4 3 10 5 3 10 6 3 10 7 3 11 REGENERATING THE PARALLEL RUN RESULTS REMOVING THE RUN RESULTS ANALYSING THE PARALLEL RUN RESULTS ANALYSIS METHODOLOGY PREDICTIVE REASONING RUNNING THE ELEMENT DIFFERENCE REPORT FILTER LIST COMPARE SIDE BY SIDE SHOW NEXT SHOW PREVIOUS USING FIND GENERATING SUCCESSIVE RUNS 4 ORACLE PAYROLL INSTALLATION AND CONFIGURATION 4 1 4 1 1 4 1 2 4 1 3 4 1 4 4 2 4 2 1 4 2 2 INSTALLING THE ORACLE OUTPUT REPORTS CREATE ELEMENT EXTRACT TABLE CREATE BALANCES EXTRACT TABLE COMPILE DATABASE VIEWS CREATE WEB ADI INTEGRATORS EXTRACTING THE TARGET DATA FROM ORACLE PAYROLL EXTRACTING THE RESULTS USING SQL EXTRACTING THE RESULTS USING WEB ADI APPENDIX A ORACLE DATABASE VIEWS Page 3 of 56 40 40 41 41 42 43 43 44 45 46 46 46 47 48 50 50 50 53 Quick Pay Checker User Manual 4 6 1 Introduction 1 1 Purpose The purpose of this guide is to give an overview of the functionality delivered with the Quick Pay Checker and provide user instructions on how to set up and work the Parallel Run Comparison Tool The guide also includes general advice on how to optimise the success of your parallel run testing 1 2 Management Summary Quick Pay Checker is a simple to use standalone analysis program that is used to quickly and effectively manage an iterative parallel run process
43. lity Lookup called XXPCT ELEMENT MAPPING C Application Utilities Lookups Access Level Type XXPCT ELEMENT MAPPING User Meaning Element Mapping for Parallel Run Tool x l Extensible Application Payroll system Description Effective Dates Enabled Code Meaning Description Tag From Ta DJ um NI A NI Employee ES NIB MI B Nl Employee NIC NIC MI Employee a MID NI DI MI Employee cad MIE MI E NI Employee i e Inthe lookup values enter a meaningful code and populate the Meaning and Description field where o Meaning Actual Element Name o Description New Element Name It is recommended that UK users use the example above to combine the different NI payment elements into a single NI Employee element Page 46 of 56 Quick Pay Checker User Manual 4 6 4 1 2 Create Balances Extract Table When extracting the balance values from the Oracle payroll run results the using the balance view provided users need to specify which balances to extract in the application utility lookup XXPCT BALANCES MAPPING Extracting balance data is extremely important for results for Taxable Pay and Nlable Pay and other key balances when working with larger payroll systems e Create a new Application Utility Lookup called XXPCT BALANCES e Inthe lookup values enter a meaningful code and populate the Meaning and Description field where o Meaning Actual Balance Name It is recommended that UK users use the example above to extract Nlable Pay a
44. ments are accounted for in the mapping table the check mapping process will complete without warning Target Mapping Check Page 26 of 56 Quick Pay Checker User Manual 4 6 3 7 2 Removing Unwanted Target Data If the target data includes objects that should not be included in the parallel run comparison then these lines can be excluded in a number of ways 1 3 7 3 Modify the extract reports directly to exclude these elements from being included in the report in the first place Or If the target element information is required i e it may be useful when analysing the results but does not have a corresponding source object then the element can be entered below the sum total line in the Mapping Sheet Entering the element name in the column beneath the Enter Unmapped Elements Below will exclude the target elements from the comparison report END Enter Unmapped Elements Below Adjust NI Tax Adjust Or Use the Remove Lines ES function on the Target Sheet in the same way as described on the source data sheet to manually remove occurrences of a single element zero values or employees that should not be included in the analysis This method is not recommended as each time you extract the target data you will need to remove the unwanted data manually each time you should try to exclude unwanted data directly on the target payroll data so the parallel run comparison is checking against results that have not bee
45. n tampered with Target Data Summary Information With Target Data populated the Summary sheet will provide additional information on the data entered The Target Employee Count will now report the number of employees loaded from the target payroll system The Target Sheet Total now displays the total pay values entered on the Target Sheet This value is used to cross reference the Target Mapping Total which is the total pay values from the Mapping table to ensure all elements are mapped Page 27 of 56 Quick Pay Checker User Manual 4 6 The Target Sheet Mapping Difference highlights any differences between pay values entered on the data sheet and total values in the mapping sheet This essentially means that there are target elements that included in the Target data missing from the mapping table TARGET MAPPING ERROR More information about Summary error messages and warnings can be retrieved by selecting the error message and clicking on the information toolbar icon i Some Target elements are not entered on the mapping sheet To fix run Check Mapping on the Target Sheet to get a list of unmapped elements Do you want to run this now No To display the unmapped target elements run the Check Mapping process on the Mapping Sheet or the Source Data sheet Unmapped Target Elements iu Overtime The unmapped target elements can be either by added manually by typing the missing element into the Target
46. nd Taxable Pay from the payroll run results 4 1 3 Compile Database Views Three database views are delivered with the comparison tool for extracting the data from an Oracle payroll run to populate on the Target Data Sheet The views provided are based on UK payroll reports See Appendix A for the scripts to create these views e XXPCT GB PAY VALUES V This database view retrieves the element pay values and the taxable and Nlable pays for a UK payroll run e XXPCT GB BALANCES V This database view retrieves the ASG RUN balance results for the UK balances entered in the XXPCT_BALANCES application utility lookup e XXPCT GB NET PAY V This database view retrieves the net pay values for a UK payroll from the prepayments run Note Negative Net Pays and employees with no Bank Account Details are not returned from this run e XXPCT IE PAY VALUES V This database view retrieves the element pay values and the taxable and Nlable pays for an Ireland payroll run e XXPCT IE BALANCES V This database view retrieves the ASG RUN balance results for the Ireland balances entered in the XXPCT BALANCES application utility lookup Page 47 of 56 Quick Pay Checker User Manual 4 6 e XXPCT IE NET PAY V This database view retrieves the net pay values from the prepayments run Note Negative Net Pays and employees with no Bank Account Details are not returned from this run If you intend to use the views directly or as Oracle Web ADI Downloads you may
47. nd methodology of the Quick Pay Checker this process can vastly improved 3 10 1 Analysis Methodology The Quick Pay Checker encourages thorough problem analysis The more issues than can be identified and resolved in each parallel run the fewer parallel runs are required and thus the quicker the parallel run process will take For each difference found the parallel run sheet encourages the user to enter a Reason then Assign a category to the difference as e NONE The difference is acceptable or caused by another issue No action is required to rectify this specific difference e SOURCE The difference is due to incorrect data entered in the payroll run A fix to the data is required e TARGET The difference is due to an error in the new target payroll system Some configuration or further investigation is required aa fEfk REASON gt Clean 3 231 60 Net Pay incorrect due to other errors NONE E INONE E OK NONE OK NONE 47 50 ER s Pension migrated incorrectly ORACLE Yes E OK NONE E OK NONE E 488 44 Misc Net Deduction entered positive should be negative ORACLE Yes 3 231 60 PAYE refund check balances DATA E 401 65 Taxable Pay incorrect due to missing payment NONE E 2 990 35 No Net Pay Paid because of PAYE underpaid issue DATA The fixed column should also be used to record if the issue has been resolved This will help ensure issues are addressed and provide an audit trail during the
48. ns the net pay values from the pre payments run CREATE OR REPLACE FORCE VIEW XXPCT GB NET PAY V AS SELECT ppa payroll_action_id ppf payroll_name ptp period_name papr rtull name papf employee_number paaf assignment_number Net Pay Element_Name SUM LTRIM TO_CHAR ppp value 999999990 00 pay value FROM pay_payroll_actions ppa pay_assignment_actions paa pay_pre_payments ppp pay_personal_payment_methods_f popmf pay payment types tl ppttl Day pavmenL cvpes ppt pay external accounts pea per time periods ptp per all people f papt per all assignments f paaf peay all payrolis r pet hr all organization units haou WHERE ppa payroll action id paa payroll action id AND ppa action type IN U P AND ppa action status C AND paa assignment action id ppp assignment action id AND ppt payment type id ppttl payment type id AND ppttl LANGUAGE US USERENV LANG AND ppa EFFECTIVE DATE BETWEEN ptp START DATE AND ptp END DATE AND ppa pavroll id ptpipayroll id AND ptp end date BETWEEN popmf effective start date AND popmf effective end date AND ppp personal payment method id popmf personal payment method id AND popmf external account id pea external account id AND ppttl payment type name BACS Tape AND paa assignment id paaf assignment id AND ppa business group id paaf business group id AND ptp end date BETWEEN paaf effective start date AND paaf effective end date AND paaf person
49. of specific differences is reduced For smaller payrolls it is still acceptable to only compare key balances but introducing individual elements into the scope will help pinpoint specific element issues more quickly Key balances such as Taxable Pay Nlable Pay and NI Contributions for UK legislation are encouraged P B C Source Element Name m Target Element Name m Bank Transfer Net Pay Taxable Pay Taxable Pay Mlable Pay Nlable Pay 3 2 2 Entering Mapping Information All additional elements to analyse must be entered below the grey Net Pay line The source element or balance name is entered in the first column and the corresponding target element or balance name is entered in the second column Page 13 of 56 Quick Pay Checker User Manual 4 6 Source Element Name Target Element Name Source Total Combined Source Total Combined Target Total Difference E E E E Taxable Pay Taxable Pay E Nlable Pay Nlable Pay E E UNION Union Deduction Misc Net Deduction Advance E E Basic Pay Basic Salary Misc Basic Adjustment Basic Salary Arrears E BusyBees Childcare Vouchers E BusyBees2 Childcare Vouchers E E E Critical Illness Critical Illness Salary Sacrifice Bikes Cycle to Work E Dental Insurance Dental Salary Sacrifice Payroll Giving GAYE Salary Sacrifice E
50. omplete without warning n EL NS Check Mapping Complete All Source Elements are mapped OK Page 18 of 56 Quick Pay Checker User Manual 4 6 3 4 2 Removing Unwanted Source Data If the source data included objects that should not be included in the parallel run comparison then these lines should be removed from the source data sheet To remove lines from the source data select a cell on the source data sheet that contains the item to be removed For example if you want to delete all rows for a specific element then select the object in the Element Name column and click on the delete rows icon aN or use the toolbar menu Parallel Run gt Source gt Remove Lines Element Name BI Sourcevaluet B Target Element Pension Ers 2 301 60 Pension Ers Contribution Tax paid 3 076 66 PAYE Taxable pay Bank transfer Basic Pay Dental Insurance Employee MIC Employer NIC Medical Insurance Misc Met Deductian Overtx 1 5 not Bam 8pm Overtime x 2 Payroll Giving Pension Pension Ers LLI ow e ka a rh P oH m om Jgo60 Df Tr STISIUTI Ce SUIT TILTTEPLIETICITI 538 00 Pension Ers Contribution mom Selecting Ves at the prompt will then remove all rows where element is the same as the row selected E ccc2 h Remove Source Lines 0 EE Remove Source Lines w Once the rows have been removed the application will recommend that the check mapping process is re run on the Sourc
51. project Entering reason information is also important as the reason information will be automatically rolled forward onto subsequent parallel run sheets if the same difference reoccurs An initial parallel run will usuallv generate low success rates and large numbers of differences and it is tempting to rush into a subsequent run to generate a higher score success In practice re runs should oniv be initiated when all the differences have been analvsed or in the case of the first few runs there is a high number of common errors that if fixed will reduce the number of differences significantiv When more than one person is involved with the checking it is important that one person retains a copy of the Master spreadsheet Copies of the Run Sheet can be made and the Page 41 of 56 Quick Pay Checker User Manual 4 6 checking divided up by a range of rows This arrangement makes it easier to copy the reasons back into the Master 3 10 2 Predictive Reasoning The parallel run comparison run will automatically populate the reasons if the difference is already known such as a missing element or missing employee This will save time and ensure users are only checking actual unknown differences M REASON Employee Not Found in Target Data Employee Not Found in Target Data Employee Mat Found in Target Data Employee Not Found in Target Data Employee Mat Found in Target Data Employee Not Found in Target Data Employee Not Found in
52. r Ireland Legislation 2 1 Worksheets Quick Pay Checker is a Microsoft Excel based application and has the following main worksheets 2 1 1 Summary Sheet The Summary sheet contains at a glance management information and comparison Statistics The Summary sheet also provides early indicators of specific errors in configuration mapping for example missing employees or unmatched transactions The Summary sheet also generates comparison reports to assist with diagnosing the parallel run differences Quick Pay Checker Page 5 of 56 Quick Pay Checker User Manual 4 6 2 1 2 Mapping Sheet Target gq Source The Mapping sheet is the page that determines how the source payroll elements are mapped to the new target payroll system elements To achieve a fast and effective parallel run process this mapping must be completed according to the mapping rules discussed later in this guide The mapping sheet provides totals and differences by element and also assists with resolving mapping issues by highlighting mapping errors and creating lists of unmapped elements Data Element Name Oracle Element Name Data Total Combined Data Total Combined Oracle Total Difference Bank Transfer Net Pay 1 168 450 50 1 168 450 50 1 169 780 83 1 330 33 Misc Net Deduction Advance 21 907 95 21 907 95 21 907 95 Basic Salary 1 825 238 221 1 825 238 21 Misc Basic Adjustment Basic Salary A
53. rget gt Check Mapping to start the check mapping function which will format and validate the target data Checking Element Mapping Processing 44 E The check mapping function will perform the following functions and checks e Format the data and columns e Check to see if any target elements are missing from the mapping table e Check that the target object is mapped to a source object e Check for unmatched employees Page 25 of 56 Quick Pay Checker User Manual 4 6 3 7 1 Unmapped Target Elements If at the end of the check mapping process there is found to be target objects that are not entered in the mapping table then these objects are listed in the Unmapped Target elements column on the mapping sheet There are 6 unmapped Target Elements Please review the list of AM elements on the Mapping Sheet You can use the Add Unmapped Element button to copy to mapping table Unmapped Source Elements Unmapped Target Elements Adjust NI Overtime student Loan Tax Adjust Travel Salary Sacrifice Unpaid Leave The unmapped source elements can be added manually or by clicking the Add Unmapped Element function on the toolbar 47 When using the Add Unmapped Element function the unmapped element at the top of the list is automatically placed into the cell that is currently selected A cell in the Target Element Name column must be selected before the function button is pressed Once all unmapped target ele
54. rrears 11423 11423 11423 BusyBees Childcare Vouchers 6 834 00 BusyBees2 Childcare Vouchers 5 290 05 1 543 95 1543 95 Critical Illness Critical Illness Salary Sacrifice 1 017 82 1 017 82 1017 82 Bikes Cycle to Work 772 31 772 31 772 31 Dental Insurance Dental Salary Sacrifice 555 05 555 05 55505 Payroll Giving GAYE Salary Sacrifice 1 515 00 1 515 00 1 515 00 Healthcare Healthcare Cash Plan Salary Sacrifice 1425 1425 1425 Additional Responsibility Higher Duties 233 33 23333 E 233 33 Holiday Pay Holiday Pay 324975 324975 3 250 00 0 25 Buy Annual Leave Holiday Purchase 551 62 551 62 58559 33 97 Net Advance Recovery Net Pay Adjustment CF 53 59 53 59 53 59 Employee NIC NI Employee 106 692 23 106 692 23 106 712 11 19 88 Employer NIC NI Employer 211 065 95 211 065 95 211 247 72 181 77 Niable Pay Nlable Pay OMP 10096 Occupational Maternity Pay 15 582 09 15 682 09 15 682 09 OSP 100 OcclipationalSickPay 654891 654891 6 548 91 Overtime x 1 12 Overtime 236 04 236 04 236 07 0 03 Overtime x 2 Overtime Double E 2 520 42 2 520 42 2 520 62 0 20 Overt x 1 5 not 8am 8pm Overtime Time and Half 10 160 30 10 160 30 10 159 91 0 39 Tax paid PAYE 48022172 480 221
55. ss p eancnn _ C Anc nn eane nn Page 34 of 56 3 9 4 Quick Pay Checker User Manual 4 6 Parallel Run Result Sheet The results sheet is produced by comparing the source data against the target data The process tries to match each source transaction to a target transaction using the ID and Element Name as the lookup reference If a matching target transaction is found the result sheet then displays the source pay value compared to the target pay value and the difference Flement Name Basic Pay Employee NIC Employer NIC Misc Basic Adjustment Tax paid Taxable pay My prom omm Source Value B TETT 42 405 01 1 113 78 827 58 2 834 55 g 177 42 TARGET amp SOURCE Total E 6 42 6500 00 3 40501 455 67 1 113 78 1 278 13 82258 82258 3 283455 2899918 E 901 742 10 00000 If a matching target transaction is not found then the result sheets shows the transaction line as Not Found in the Error column The reason column is automatically populated with the reason for the difference SOURCE Total 24358 7 05 190 00 2268 00 171 00 G 24358 7 05 228 00 171 00 mon m om m 190 00 Mot Found REASON Occupational Sick Pay Element Mot Found in Target Data SOURCE Total B 372 04 591 71 1 64 245 00 1378 13 206 25 1574 26 mit MAN mo 372 04 691 71 1 64 245 00 1 378 12 206 25
56. t are gt 1000 Difference 5 TOTAL Element line Differences 123 Percentage Element Lines Correct 94 00 Percentage Element Lines Correct lt 10p 95 00 In practice the Source transactions will rarely map exactly to the Target transactions Net Pay statistics provide a clearer assessment of the accuracy of parallel run The Summary sheet gives the same range of statistics for Net Pay comparisons as well as a total Net Pay difference Total Net Pay Lines 303 Met Pay Lines Unmatched Employee Missing Met Pay Lines Unmatched Element not Found 0 Net Pay lines to within ZEE Met Pay lines that are between 2p 10p Difference 5 Met Pays that are between 10p 1 Difference 13 Met Pays that are between 1 10 Difference 0 Net Pays that are between 10 100 Diference 4 Net Pays that are between 100 1000 Difference 4 Net Pays that are gt 1000 Difference 1 TOTAL Net Pay Differences 2f Percentage Net Pay Lines Correct 91 00 Percentage Net Pay Lines Correct lt 10p 93 00 source Met Pay Total 1 168 450 50 Target Met Pay Total 1 163 066 04 Net Pay Difference 5 384 46 Page 36 of 56 Quick Pay Checker User Manual 4 6 3 9 6 Unmatched Source Transactions The summary sheet indicates the number of source transaction lines that have not been matched to target transactions These unmatched transactions are due to missing elements or missing employees To view the corresponding transactions select the cell
57. t the data you need to know either the PAYROLL_ACTION_ID or the PAYROLL NAME and PERIOD NAME Run either of the following SQL queries as APPS to extract the data Pay Values Report Using the Payroll Name and Period Name select FULL NAME EMPLOYEE NUMBER ASSIGNMENT NUMBER ELEMENT NAME PAY VALUE from XXPCT GB PAY VALUES V WHERE PAYROLL NAME payroll name gt AND PERIOD NAME period name gt ORDER BY ID ELEMENT NAME Pay Values Report Using the Payroll Action ID select FULL NAME EMPLOYEE NUMBER ASSIGNMENT NUMBER ELEMENT NAME PAY VALUE from XXPCT GB PAY VALUES V WHERE PAYROLL ACTION ID payroll action id for Run ORDER BY ID ELEMENT NAME Net Pay Report Using the Payroll Name and Period Name select FULL_NAME EMPLOYEE NUMBER ASSIGNMENT NUMBER ELEMENT NAME PAY VALUE from XXPCT GB NET PAY V WHERE PAYROLL NAME payroll name gt AND PERIOD NAME period name ORDER BY ID Net Pay Report Using the Payroll Action ID select FULL_NAME EMPLOYEE_NUMBER ASSIGNMENT_NUMBER ELEMENT_NAME PAY_VALUE from XXPCT GB NET PAY V WHERE PAYROLL ACTION ID payroll action id for Prepayments gt ORDER BY ID 4 2 2 Extracting the Results using Web ADI To extract the Pay Value Report Navigate to the Payroll Processes Folder and find the specific payroll process to extract Page 50 of 56 Quick Pay Checker User Manual 4 6 QFP awroll Processes Pa
58. urance Private Me season Ticket ISeason Tf season Ticket Loan Ded season T SMP amount SMP Paid SSP Amount SSP Paid Standby Payment Standby CSL Student Loan Ded Student L Unpaid Leave Unpaid Lees Page 14 of 56 Quick Pay Checker User Manual 4 6 3 2 4 Mapping Rules Ideally each element or balance will have a one to one mapping but in many cases that is not that possible Many To One Relationship It is quite common to have one single target element that replaces multiple source elements This arrangement is acceptable To negotiate this the comparison tool will sum the source totals together to create a Combined Source Total for comparison with the single target total BusyBees Childcare Vouchers BusyBees 2 Childcare Vouchers One To Many Relationship The scenario where a single source element is mapped to a number of possible target elements should be avoided The comparison tool does not support this arrangement because when matching the source data to the target data the application does not have a direct mapping Duplicate source elements or balances entered in the mapping table are highlighted in red and this must be resolved before the application can perform the parallel run analysis Overtime Overtime Flat Rate Overtime Overtime Double Rate Overtime Overtime Time and Half Rate This relationship can be resolved in two ways 1 To preserve the individual identity of the target elements the only option is to
59. windows The enable this function ensure a cell is selected in a row belonging to the employee whose results you want to compare and click on the Compare Side By Side function icon on the toolbar The current sheet will appear at the top filtered on the selected employee and a new window will appear at the bottom with the matching employee data already filtered Source Value hy Employee Stewart Mrs Anabela NA219029A 394039 Bank transfer 1 888 15 1 888 15 1 927 43 39 28 Stewart Mrs Anabela NA219029A 394039 Basic Pay E 709 68 709 68 761 54 51 86 Stewart Mrs Anabela NA219029A 394039 Employee NIC E 223 16 223 16 229 42 6 26 Stewart Mrs Anabela NA219029A 394039 Employer NIC 259 68 259 68 266 96 7 28 Stewart Mrs Anabela NA219029A 394039 Misc Net Deduction 0 62 0 62 0 62 Stewart Mrs Anabela NA219029A 394039 OMP 100 1 960 05 1 960 05 1 960 05 Stewart Mrs Anabela NA219029A 394039 Pension 165 00 165 00 159 92 5 08 Stewart Mrs Anabela NA219029A 394039 Pension Ers 24750 247 50 239 89 7 61 Stewart Mrs Anabela NA219029A 394039 SMP amount 1 610 67 1 610 67 1 610 67 NotFound SMP Paid Elemen Stewart Mrs Anabela NA219029A 394039 Tax paid 39280 39280 40420 11 40 Stewart Mrs Anabela NA219029A 394039 Taxable pay 250473 250473 2506167 56 94 gt M Summary Mapping Source lt Target Runi 3 OO a EEE
60. yroll From Action Type Retry fa Period Type Name Payroll Status E 2 NOS ZDDS B 2009 Calenda Run 3 Monthly Complete m 28 OCT 2009 7 2009 Calenda Run 4 Monthly Complete 27 SEP 2009 B 2009 Calenda Run e Monthly Complete Assignment Process Click on the button to list the processed assignments and then click on the export data icon Z Select the Pay Value Report integrator and correct version of Excel ensuring the reporting checkbox is ticked and click continue until the spreadsheet is downloaded If you have any problems downloading the report ensure your security settings are correct as described in Section 2 5 2 To extract the Net Pay Report perform the same process as above but find the Pre payments process and select the Net Pay Report as the integrator C Payroll Processes Payroll Fram Actian Type ivt Retry Date Ferind Type Name Payrall status I ID MO2ODS 01 Nov 2008 Pre payments UK Monthly Complete S cT GOUCT 2008 01 OCT 2009 2 Pre payments UK Monthly Complete E 30 SEP 2009 01 SEP 2009 Pre payments UK Monthly Complete Page 51 of 56 Quick Pay Checker User Manual 4 6 Page 52 of 56 Quick Pay Checker User Manual 4 6 Appendix A Oracle Database Views XXPCT GB PAY VALUES V Returns the element pay values Nlable Pay and Taxable Pay values from a Run process CREATE OR REPLACE VIEW XXPCT GB PAY VALUES V AS select paa payroll

Quick Pay Checker User Manual 4.6 Draft.

Contents

Download Pdf Manuals

Related Search

Related Contents