Appendix: Reviewing the Parallel Test Checklist

This appendix discusses:

Click to jump to parent topicParallel Test Guidelines

The following are some guidelines for parallel testing:

Click to jump to parent topicParallel Test Checklist

Use this checklist to ensure that the parallel phase of the payroll implementation is complete.

Note. (CAN) Canadian Structured Query Reports (SQRs) contain the ending CN (for example, PAY001CN).

Note. (USF) Federal SQRs begin with FG (for example, FGPY001).

Process

Task

Program

Expected Result

Target Date

Initials

Preproduction Clean Up

 

 

 

________

______

Load Data

Time Input

Runtime Input Process

Job completed

________

______

 

 

 

Data reconciled to current system

________

______

Verify Data

Run Audit Programs

PreSheet Audit PAY034

Confirms data complete for creating paysheets

________

______

 

 

 

Paysheets created

________

______

On-Cycle Testing

Run Paysheets

 

Job completes

________

______

Verify Data

Run Audit Programs

Precalculation PAY035

Confirms payroll key data correct for running calculations

________

______

 

Run Preliminary Payroll Calculation

PAY001 Deduction Register

PAY001CN

 

________

______

 

Run Reports for Payroll Calculation

PAY002 Payroll Register

 

________

______

 

 

PAY006 Other Earnings Register

 

________

______

 

 

PAY008 Deductions Not Taken

 

________

______

 

 

PAY011 Payroll Error Messages

 

________

______

 

 

PAY021 Employer Benefit Contributions

PAY021CN

 

________

______

 

 

An iterative series of steps: run until each report is error-free

Data reconciles to current system on subsequent report runs

________

______

 

Correct invalid data shown by reports

 

Job completes

________

______

 

Re-run preliminary payroll calculation

 

 

________

______

 

Re-run reports for payroll calculation

 

Job completes error free

________

______

 

Run final payroll calculation

 

Job completes error free

________

______

 

Run payroll confirmation

PAY001 Deduction Register

PAY001CN

Each report completes

________

______

 

Run final payroll confirmation reports

PAY002 Payroll Register

Each report reconciles to current system

________

______

Verify Data

Run Audit Programs

PAY036

Preconfirm Audit

Confirms that Pay Data is Correct Before Confirming Payroll

________

______

 

 

PAY003 Check Print

PAY003CN

PYCHKUSA Create Check PDF

PYCHQCAN

In the required format

________

______

 

 

PAY004 Check Register

 

________

______

 

 

DDP005 Direct Deposit Prenotification

 

________

______

 

 

DDP006 Direct Deposit Prenote Memo

 

________

______

 

 

DDP001 Direct Deposit Create file

DDP001CN

Transmittal file produced in the correct format

________

______

 

 

DDP002 Direct Deposit Register

 

________

______

 

 

DDP003 Direct Deposit Advice Print

DDP003CN

PYDDAUSA Create Advice PDF

PYDDACAN

 

________

______

 

 

DDP004 Direct Deposit Advice Register

 

________

______

 

Process Payroll Savings − Canada

PAY132CN

Canada Payroll Savings File

Transmittal file produced in the correct format

________

______

 

 

PAY005 Cost Center

 

________

______

 

 

PAY006 Other Earnings Register

 

________

______

 

 

PAY007 Deductions in Arrears

 

________

______

 

 

PAY008 Deductions Not Taken

 

________

______

 

 

PAY010 Employees Not Processed

 

________

______

 

 

PAY015A Check Reconciliation

 

________

______

 

 

PAY015B Check Reconciliation Report

 

________

______

 

 

PAY016A Bond Purchase

 

________

______

 

 

PAY018 Payroll Summary

PAY018CN

 

________

______

 

 

PAY021 Employer Benefit Contributions

PAY021CN

 

________

______

 

 

TAX001 Tax Deposit Summary

TAX003CN

 

________

______

 

 

 

Check numbers are reassigned

________

______

 

Perform paycheck reprint process

 

Balance records are removed from the balance tables

________

______

 

Delete balances

 

All payroll records updated with manually derived data

________

______

Off-Cycle Processes

Perform manual payroll check print

 

 

________

______

 

Create Online Check

 

 

________

______

 

Disable direct deposit

 

 

________

______

 

Perform gross up process

Override

Jobs complete

________

______

 

Calculate one-time deductions

Addition

 

________

______

 

 

Refund

 

________

______

 

 

Arrears Payback

 

________

______

 

 

Override

Jobs complete

________

______

 

Calculate one-time garnishment

Suspend

 

________

______

 

 

Override

Jobs complete

________

______

 

Calculate one-time tax data

Refund

 

________

______

 

 

Addition

 

________

______

 

 

 

Balance records show negative entries for reversal

________

______

 

Perform paycheck reversal

 

 

________

______

 

Perform paycheck adjustment

 

 

________

______

 

Run preliminary payroll calculation for off-cycle

PAY001 Deduction Register

PAY001CN

 

________

______

 

Run reports for preliminary payroll calculation for off-cycle

PAY002 Payroll Register

 

________

______

 

(USF) Run Electronic Certification

FGPY004 ECS Interface

 

________

______

 

 

PAY006 Other Earnings Register

 

________

______

 

 

PAY008 Deductions Not Taken

 

________

______

 

 

PAY010 Employees Not Processed

 

________

______

 

 

PAY011 Payroll Error Message

 

________

______

 

Run final payroll calculation for off-cycle

 

 

________

______

 

Run off-cycle confirmation

DDP005 Direct Deposit Prenotification

 

________

______

 

Run reports for off-cycle confirmation

DDP006 Direct Deposit Prenote Memo

 

________

______

 

 

DDP001 Direct Deposit Create file

DDP001CN

 

________

______

 

 

DDP002 Direct Deposit Register

 

________

______

 

 

DDP003 Direct Deposit Advice Print

DDP003CN

PYDDAUSA Create Advice PDF

PYDDACAN

 

________

______

 

 

DDP004 Direct Deposit Advice Register

 

________

______

 

 

PAY001 Deduction Register

PAY001CN

 

________

______

 

 

PAY002 Payroll register

 

________

______

 

 

PAY003 Check Print

PAY003CN

PYCHKUSA Create Check PDF

PYCHQCAN

 

________

______

 

 

PAY004 Check Register

 

________

______

 

 

PAY005 Cost Center

 

________

______

 

 

PAY006 Other Earnings Register

 

________

______

 

 

PAY007 Deductions in Arrears

 

________

______

 

 

PAY008 Deductions Not Taken

 

________

______

 

 

PAY015A Check Reconciliation

 

________

______

 

 

PAY015B Check Reconciliation Report

 

________

______

 

 

PAY016A Bond Purchase

 

________

______

 

 

PAY018 Payroll Summary

PAY018CN

 

________

______

 

 

TAX001 Tax Deposit Summary

TAX003CN

 

________

______

 

(USF) Run interface programs

FGPY004, ECS Interface;

FGPY001, RITS INTERFACE;

FGPY002, TSP Interface;

FGPY003, Treasury / FRB Bond Interface;

FGPY006, FGPY007, FGPY008, FGPY009, Individual Retirement Records

 

________

______

 

Compare PeopleSoft and current system data to verify earnings

 

 

________

______

 

Run quarterly reports

 

 

________

______

 

Run general ledger interface

 

 

________

______

 

Run payroll check print

 

 

________

______

Special Processes

Leave accrual process

Vacation

 

________

______

 

 

Personal

 

________

______

 

 

Process Adjustments

 

________

______

 

(USF) Leave Accrual

Cascading Leave, Annual Entitlement, Accrual Summary Ledger

 

________

______

 

Set up prior year calendar

 

 

________

______

 

Run year-end processes

 

 

________

______

 

Test other processes (as applicable)

 

 

________

______