Pay Information Reports

This directory contains documentation for SQL scripts that generate various pay-related reports and exports. These reports cover payroll processing, employee compensation analysis, invoice generation, and administrative pay functions.

Available Reports

Payroll Processing Reports

Report	Description	Key Features
Basic Pay Export	Comprehensive pay export for external payroll systems	Hourly/dollar pay designations, Workgroup integration, External system compatibility
Voucher Report v1	Detailed voucher-style payroll report with subtotals	Employee pay details, Hierarchical subtotals, Official documentation format
Secondary Salary Processing	Utility for processing secondary salary distributions	HR field parsing, Salary distribution mapping, Diagnostic feedback

Time and Compensation Analysis

Report	Description	Key Features
Sum Hours by Period	Compensatory time calculations across pay periods	Multi-period processing, 1.5x multiplier, Pay period integration
PTO True-Up Report	PTO accrual and ESTA calculations	ESTA calculations, Perfect attendance tracking, Accrual rate framework
Supplement Pay Report	Weekly hour breakdown for supplement pay analysis	Daily pivot tables, PTO tracking, Rate calculations
Calendar Report Card	Calendar-style view of employee pay history	Monthly calendar grid, Visual work patterns, Pay designation display

Billing and Invoice Reports

Report	Description	Key Features
Invoice Export	Standard invoice data for agricultural operations	Work activity aggregation, Crew tracking, Standard billing format
Invoice Export with Transactions	Detailed invoice with transaction timing information	Transaction timing, Start/end times, Enhanced billing details

Operational Reports

Report	Description	Key Features
Daily Posting Report	Daily staffing analysis comparing scheduled vs actual hours	Scheduled vs worked hours, Position analysis, Census integration

Utilities and Development

Report	Description	Key Features
Bankers Rounding WIP	Comparison of rounding methods for payroll calculations	Banker's vs standard rounding, Side-by-side comparison, Custom function implementation

Common Features

Most reports in this category include:

Date range parameters for flexible reporting periods
Employee filtering and access control
Multiple pay designation support
Workgroup integration for organizational reporting
Formatted output suitable for external systems

Usage Guidelines

Date Parameters: Most reports use @MIN and @MAX date parameters
Employee Access: Many reports include user access control filtering
Pay Designations: Reports typically filter specific pay designation numbers
Output Formats: Results are formatted for specific use cases (exports, analysis, billing)

See Payroll Exports for additional payroll-related functionality
See Employee Information for employee-focused reports
See System Information for system administration reports

Pay Information Reports

On this page