Versions Compared

Version Old Version 96 New Version 97
Changes made by

Lori Miller

Lori Miller

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 95


Tip
titleWelcome to the SSDT shared reports library.

Contains USPS template reports created and shared by other users which can be downloaded and used in your local application.  The Example are mainly PDF


Search this documentation

Live Search
spaceKeySRL



Section
bordertrue

Per pay Reports

Title (downloadable rpd-json file)ExampleDescription
Current Pay Report .rpd-jsonClick HereSummary of Payroll information in Payroll Payments - Current. Sorted by Name.
Deduction History Report (SSN) 403b(a).rpd-jsonClick HereCreates a CSV file containing information needed for common remitter. When running report, enter Payroll Item code(s) and date range for payroll dates to include in file.
Future Pay Report by Pay Group.rpd-jsonClick HerePayroll Future report. Sorted and totaled by pay group. Used to help balance exceptions in payroll. (We are aware there is a $ before the first unit number and are working on correcting this within the software)
Child Support .rpd-jsonClick HereLists employees with amounts deducted for Child Support Pay Items. Shows amounts for each pay date included in date range entered with a subtotal per employee. (We are aware there are comma's in the case number and flip code and are working to correct this within the software)
Specific Payroll Item(s) by Pay Date.rpd-jsonClick HerePayroll Item Report specific codes specific pay date taxable gross added ran in summary only one line per employee. Used to send with pay item checks. The example is run is summary form.
Payee check numbers by payroll.rpd-jsonClick HereLists payee check numbers with information about each check within a specified date range
Payroll Item Detail.rpd-jsonClick HereSorts by employee number and lists deductions and deduction information. Can be filtered by a specific account code


Monthly Reports

Title (downloadable rpd-json file)ExampleDescription
Rita Tax Report.rpd-jsonClick HereRITA Payables History report to complete Form 11, the example is the summary version of the full report.
CCA Tax Report.rpd-jsonClick HerePayroll Item History report, range of codes, range of dates. Totals by code/residence or employment tax, one line per employee. Used to complete the monthly CCA remittance form. The example is run in summary form.


Quarterly Reports

Title (downloadable rpd-json file)ExampleDescription
ODJFS Not Reportable.rpd-jsonClick HereThis report shows any employees with QTD wages greater than zero that are not marked to report to ODJFS. Can be used to find employees that should be reported that are not marked correctly.


FYE-Based Reports

Title (downloadable rdp-json file)ExampleDescription
New Contract Compensation Worksheet.rpd-jsonClick HereThe report pulls information into an Excel Worksheet from the Employee's current Compensation Contract record. Headers that would be needed for the New Contract Import are written into the worksheet so districts can modify and use to import new contracts.
New Contract Payroll Accounts & Original Pay Account.rpd-jsonClick HereSummary of records in New Contracts page that also shows their current Payroll Accounts since these do not show in New Contract. Districts requested a way to see accounts easily to help with updates.
Leave Usage.rpd-jsonClick HereEmployee Leave usage, date used, type of leave used, choice by certified and classified, each employee on separate page


CYE-Based Reports

Title (downloadable rdp-json file)ExampleDescription
OAPSE Report.rpd-jsonClick HereOAPSE union requests of specific employee information. In Excel format. Contains Employee name, Employee ID, address, primary email, YTD gross, address, and home phone.
Detailed Contract Compensation.rpd-jsonClick HereList employees with their position and detailed compensation information for Contract Compensations only. Includes YTD earnings. (The sample report has the Active parameter selected)
CITY TAX REPORT.rpd-jsonClick HereCity tax report that can be used for W2's, allows for multiple codes, each code on separate page with subtotal by code. Must make Dec the "current" period before running to get accurate information fo the CY, 


EMIS Related Reports

Title (downloadable rdp-json file)      ExampleDescription
EMIS List.rpd-jsonClick HereLists employees with their compensation and position flags. Also lists an employee's position information

Miscellaneous Reports

Title (downloadable rdp-json file)ExampleDescription
Absence-Attendance Report by Employee Name.rpd-jsonClick HereAbsence or Attendance Report similar to Classic ABS101. Sort and subtotal by full name then leave category. Also includes Leave Balances.
Certified Rehired Retirees.rpd-jsonClick HereLists certified employees with their rehired retiree flags marked true. Report also includes date employee was rehired.
Classified Rehired Retirees.rpd-jsonClick HereLists classified employees with their rehired retiree flags marked true. Report also includes date employee was rehired
Employee Info.rpd-jsonClick HereLists all employees with their contact information and address. Also lists birth date and hire date
Pay Distribution Codes.rpd-jsonClick HereLists employees sorted by employee number with their pay distribution information
Position Report.rpd-jsonClick HereLists employees and their positions, position numbers, position codes, and pay groups
Historical Payroll Item Report.rpd-jsonClick HereHistoricalPayrollItem Report provides detail of payroll item by pay. You can choose individual or multiple payroll items as well as individual or multiple employees by employee number
Payroll Item History Report.rpd-jsonClick HereReport of payroll items that also lists the Deduction, Type of Employment, or Residential etc. allows for Multiple items, and by dates
Total Leave Used During Date Range (1).rpd-jsonClick HereAttendanceJournal Report shows total leave used for entered time period - without each absence being listed
American Fidelity Demographics.rpd-jsonClick HereDemographic Report for American Fidelity- Filter by Last Paid Date (greater than or equal to) 
American Fidelity Census.rpd-jsonClick HereCensus Report for American Fidelity. Can be sorted by Last Paid Date Greater Than or Equal to. CSV can be filtered to remove duplicates by SSN
American Fidelity Payroll Item.rpd.jsonClick Here

Payroll  Item Report for American Fidelity-Payroll Item codes need to be added in query and Last Paid Date greater than need to be added.

EEO-5.rpd-jsonClick HereReport in csv format listing Full Name, Position Description, Assignment Area, Gender, Hispanic Latino Option, Race options, ODJFS Hire Date, Compensation Start Date and Part-time.
Check Register.rpd.jsonClick HereList of checks- payroll, refund, deduction checks based on issued date(s) entered-Check Number, Payment Number, Pay to Name, Transaction Type, Amount, Issued Date, Transaction Date, Reconciled Date, Status and Voided Date.
Direct Deposit Register.rpd.jsonClick HereList of Direct Deposits based on issued date(s) entered-Payment Number, Employee Name, Amount, Issued Date, Transaction Date, Reconciled Date, Status and Voided Date
Electronic Payment Register.rpd.jsonClick HereList of Electronic Payment based on issued date(s) entered-Payment Number, Name on Payment, Amount, Issued Date, Transaction Date, Reconciled Date, Status, Voided Date
Payroll Item Detail w/YTD TotalsClick HereList of queried Payroll Items with Employee Name, Number, Code, Rate Type, Rate, Additional Withholding, Employer Rate, Pay Cycle, Max Amount, Start Date, Stop Date, YTD Applicable Gross, YTD Employer Amount, YTD Total Gross and YTD Withholding.
Regular Pay Account History ReportClick HereRegular pay accounts charged, sorted by expenditure account. Includes Pay Date, Employee Number, Position Number, Employee Name, Expenditure Account, Amount Charged and Chargeable Calculation Percentage.Specific Miscellaneous Accounts History ReportClick HereSpecific Miscellaneous accounts are listed that were charged during payroll. Includes Pay Date, Position Number, Employee Number, Employee Name, Any employee paid out of a specific miscellaneous account will be listed under the Specific Accounts Charged header.