Support HubUtilities
Overview
The Utilities section provides a collection of scripts for data correction, diagnostics, and system maintenance. These tools are designed to address specific data inconsistencies or perform administrative tasks that are not part of the standard reporting features.
Available Utility Scripts
Data Correction & Diagnostics
| Script | Description | Key Features |
|---|---|---|
| Find Missing Periods | Scans all active employees to find missing weekly pay periods in the ARCHIVES table. | System-wide check, Identifies specific missing periods, Summarizes findings per employee |
| Missing Periods Benefit Schedule to Pay | Checks a single employee for benefit schedules that are missing corresponding pay records. | Employee-specific, Calculates potential lost dollars, Pay status check |
| Missing Periods Insert (Safety Check) | Previews the records that would be inserted to fix missing pay periods for an employee without changing data. | Read-only, Detailed preview, Employee-specific |
| Insert Missing Periods | Inserts placeholder records into ARCHIVES to fix the data gaps identified by the find script. | Data insertion, Employee-specific, Confirms action |
| Missing Benefits Insert (Safety Check) | Previews the benefit-related pay records that would be inserted for an employee into PAYDESHIST and BENHIST. | Read-only, Dual-table preview, Employee-specific |
| Insert Missing Benefits Pay | Inserts missing benefit pay records into PAYDESHIST and BENHIST to correct pay discrepancies. | Dual-table insertion, Accurate calculations, Employee-specific |
Common Use Cases
- Fixing Payroll Gaps: When an employee reports a missing paycheck or benefit payment, use the "Find" and "Benefit Schedule to Pay" scripts to diagnose the issue.
- Data Integrity Audits: Periodically run the
Find Missing Periodsscript to ensure all employee pay records are contiguous. - Preparing for Data Correction: Always use the "Safety Check" scripts to verify the changes before running any "Insert" script to prevent unintended data modification.
Technical Notes
- All scripts that modify data are designed to be run for a single employee at a time to minimize risk.
- The scripts related to missing periods are based on a hardcoded start date of
2025-04-20. - It is crucial to run the scripts in the correct order: Find -> Safety Check -> Insert.