This option lets you restore your Human Resources Payroll tables in a case where you need to correct and recalculate a pay run. In addition to restoring pay run tables from a backup file, the system reverses manual and void check entry based on the check numbers you provide. This is necessary for any manual and void checks you may have entered after the pay run was calculated.
Caution
You must run this option as soon as possible after a failed pay run to restore your database to its pre-calculation state. The restoration process updates tables associated with the last calculated pay run. However, the longer you wait to run the restore, the greater the chance other Human Resources tables could change, thus affecting the pay run you are restoring. If you are unsure about running this option, review the following information. If you are still uncertain, contact PowerSchool support.
Menu Path: System Administration > Administration > Miscellaneous > Automated Payroll Restore
System Processing
When you run the Automated Payroll Restore option, you return your pay run-related Human Resources tables to the state they were in just prior to the last pay run calculation. As long as you run the option shortly after a failed pay run and you account for manual and void checks, the system takes care of the rest using the pay run number and the backup file created prior to pay calculation.
-
The restore process moves data from the following backup tables into your Human Resources database:
|
Backup Table Database Name |
Human Resources Table Updated |
|---|---|
|
bk_adv_pay |
Advanced Pay |
|
bk_attend |
Attendance |
|
bk_dedtable |
Deduction Table |
|
bk_deduct |
Employee Deductions |
|
bk_empuser |
Employee User-Defined Windows |
|
bk_pay2file |
Pay Run Employee Information |
|
bk_paycode |
Employee Pay Code |
|
bk_payfile |
Pay Run Payroll Detail |
|
bk_paygroups |
Pay Run Pay Groups |
|
bk_payrate |
Pay Rate Detail |
|
bk_payroll |
Employee Payroll |
|
bk_position |
Position Information |
|
bk_posn_data2 |
Additional Position Information |
|
bk_predist |
Pre-Calculation Gross Distribution |
|
bk_sumdetdist |
Summer Pay Fiscal Year Accrual Detail Distribution Table |
|
bk_sumfiscdist |
Summer Pay Fiscal Year Accrual Table |
|
bk_timecard |
Pay Run Timecards |
|
bk_wrkdept |
Workers' Comp Department Data |
|
bk_wrktable |
Workers' Comp Reference |
|
posn_control |
Position Control Table (25.7) |
bk_position, bk_posn_data2 or bk_posn_data3 are restored in versions 23.10 and below. For version, 25.7 the backup now includes posn_control and populates bk_posn_control.
In the updated Human Resources tables, evidence of the faulty pay run is completely erased.
-
Based on pay run number, the restore deletes Detail Distribution (detdist), Check History (checkhis and checkhi2), and Check Reconciliation (checkrec) records.
-
The Automated Payroll Interface file and batch payables generated from the pay run are deleted as long as they have not been posted yet in the Fund Accounting System.
-
Based on your entry in the Automated Payroll Restore page, the system deletes manual check records from the Check History table and clears the Void setting for void checks.
-
If you have state or custom tables that are backed up prior to payroll calculation, these tables are restored as well.
All other users should be logged out of Human Resources before you run this procedure.
Run the Automated Payroll Restore
-
Select System Administration > Administration > Miscellaneous > Automated Payroll Restore to display the Automated Payroll Restore page.
If there are no manual or void checks to enter, you can skip ahead to Step 4. -
If there are manual checks you need to delete, select the Manual Checks section's Add button.
-
Use the Manual Checks section to enter the appropriate numbers for all manual checks added after the last pay run was calculated, and then select OK.
-
If any of the manual checks either do not exist or were not a part of the last calculated pay run, a message displays noting this. Select Continue to close and proceed.
-
-
If there are void check entries you need to reverse, select the Voided Checks section's Add button.
-
Use the Voided Checks section to enter the appropriate numbers for all checks that were voided after the last pay run was calculated, and then select OK.
-
If any of the void checks either do not exist or were not part of the last calculated pay run, a message displays noting this. Select Continue to close and proceed.
-
-
Select OK when you are satisfied with all entries.
-
In the confirmation dialog, select Yes to run the restoration process.
Fields
Restore Information Section
This section displays detailed information on the last calculated pay run:
|
Field |
Description |
|---|---|
|
Pay Run |
Code and description for the last calculated pay run. The restore will use this code to delete records from the Check History, Detail Distribution, and Check Reconciliation tables. |
|
Start Date |
Default start date for the last calculated pay run. |
|
End Date |
Default end date for the last calculated pay run. |
|
Calced By |
User ID for the person who calculated the identified pay run. |
|
Date Or Time |
System date and time stamp applied when the pay calculation occurred. This information could be useful for identifying manual and void checks that need to be cleared. |
|
Checks |
Range of checks printed in the last calculated pay run. This range does not include numbers for any manual checks that might have been entered. |
|
Vouchers |
Range of direct deposit vouchers created in the last calculated pay run. |
|
Email Vouchers |
Range of direct deposit email vouchers created in the last calculated pay run. |
|
Payroll Interface |
Control number for the Fund Accounting Interface file associated with this pay run. If a control number displays, then you know the interface file has not yet been posted in Fund Accounting. The restore process deletes the interface file. If the interface file was already posted in Fund Accounting, the restore cannot delete the record and thereby reverse the processing. |
|
Batch Payables |
Control number for the batch file where automatic vendor payments from the pay run are stored in Fund Accounting. If the batch file's records have not yet been posted in Fund Accounting, the restore process deletes the entire batch. If the batch was already posted, the restore cannot reverse the ledger updates. |
Manual Checks Section
Use this section to enter numbers for manual checks that were added after calculation of the indicated pay run. Select the section's Add button to access the accompanying fields.
|
Field |
Description |
|---|---|
|
Manual Checks |
Numbers for all manual checks that were added after the indicated pay run was calculated. You can enter up to 20 manual checks in this section. The restore process will then delete the appropriate Check History records. You can select manual checks associated with any pay run, but make sure that all the records you indicate were actually added after the pay run was calculated. |
Voided Checks Section
Use this section to enter numbers for checks that were voided after calculation of the indicated pay run. Select the section's Add button to access the accompanying fields.
|
Field |
Description |
|---|---|
|
Voided Checks |
Numbers for all checks that were voided after the indicated pay run was calculated. You can enter up to 15 check numbers in this section. The restore process clears each check record's Void setting in the Check History table. The voided checks do not have to be associated with the displayed pay run, but make sure that all records you indicate were actually voided after the pay run was calculated. |