/
State Software Repository

State Software Repository

Owned by Sara Glore
Last updated: Jun 05, 2024 by Stephanie Schmucker

Cron Expression Generator & Explainer

This page is intended to be a sharing area for all Redesign Reports.


USAS

Report DefinitionDescription

USAS-R User Listing for Auditors.rpd-json

This report lists enabled Users in USAS. It contains username, name, last login and their assigned roles with descriptions of those roles.

Cash Summary (Classic FINSUM).rpd-json

This report is equivalent to the Classic FINSUM. It filters out any accounts with all zeros

Budget Summary FS,F2,O1.rpd-json

This report is a Budget Summary sorted and subtotaled by fnd/scc, 2 digit function and 1 digit object.

Outstanding Invoices with vendor and created user parameters.rpd-json

This report will generate a listing of outstanding invoices. There are two query parameters on this report that you could display only outstanding invoices created by particular username (can add more than one separated by a comma) or for a particular vendor. It is comparable to the Classic INVLST.

Outstanding Purchase Order Detail by FF# for 001 only.rpd-json

This report will generate a listing of outstanding purchase order line items sorted by five year forecast line number for general fund only.

Forecast Budget Summary.rpd-json

This report is a Budget Summary sorted/subtotaled by five year forecast line number.

Forecast Revenue Summary.rpd-json

This report is a Revenue Summary sorted/subtotaled by five year forecast line number.

Revenue Summary Prior Years by FF.rpd-json

This report shows the FYTD received amount for three years prior plus the current year, Sorted first by account code then five year forecast line number. 

Budget Summary Prior Years by FF.rpd-json

This report shows the FYTD expended amount for three years prior plus the current year, Sorted first by account code then five year forecast line number. 

Budget Account Activity Report by FF.rpd-json

This report is a Budget Account Activity Report sorted/subtotaled by five year forecast line number.

Budget Account Activity Report vendor parameter.rpd-json

This report is the SSDT Budget Account Activity Report with an include vendor(s) query parameter. 

Budget Expense Worksheet by FF & Obj.rpd-json

This report is a Budget Expense Worksheet sorted/subtotaled by five year forecast line number.

Revenue Account Activity by FF.rpd-json

This report is a Revenue Account Activity Report sorted/subtotaled by five year forecast line number.

Revenue Expense Worksheet by FF.rpd-json

This report is a Revenue Expense Worksheet Report sorted/subtotaled by five year forecast line number.

CCIP Budget Summary.rpd-json

This report is a Budget Summary sorted/subtotaled by 2 digit function, 1 digit object with query parameters for fund, special cost center and active accounts.

Financial Detail Report July 1 Cash Balances by 1 digit Object.rpd-json

This report is a Financial Detail run for the current fiscal year that is sorted by fnd/scc and then 1 digit object code. It includes the July 1 initial cash balance and the current period ending cash fund balance.

Purchase Order Detail with fund_scc query parameters.rpd-json

This report is a the SSDT Purchase Order Detail with two query parameters added for fund and scc. The fund and scc query parameters are a one of so you can enter several funds, sccs separating them by a comma.

Purchase Order Detail with Item Descriptions.rpd-json

This report is the SSDT Purchase Order Detail with the addition of the PO Line item Description as a column on the report.

Purchase Order Detail item descrip fndscc query.rpd-json

This report is the SSDT Purchase Order Detail with the addition of the PO Line item Description as a column on the report as well as fund and scc query parameters using wildcards. 

Purchase Order Detail multiple full account codes parameter.rpd-json

This report is the SSDT Purchase Order Detail with the query parameter for the full account code set to a 'one of' meaning that you can enter multiple full account codes separated by a comma.

Financial Detail Report by FF Line #.rpd-json

This report is the SSDT Financial Detail sorted and subtotaled by Five Year Forecast Line #.

Budget Account Activity Report object range.rpd-json

This report is the SSDT Budget Account Activity with a customized object range query parameter.

Requisition Detail Report - Excluding Vendor and Greater than Object Query Parameter1.rpd-json

This report is the SSDT Requisition Detail with customized query parameters to exclude vendors and objects greater than the entered value 

Filter Report.rpd-json

This report will generate a listing of Account Filters with their associated accounts. It contains a query parameter that you can use to enter a specific Account Filter name or enter more than one separated by a comma. 

Negative Appropriation Account Exclude AdvanceReport.rpd-json

This report is the SSDT Negative Appropriation Account report but with a built in query parameter of excluding 7410 and 7420 functions.


Catch up extract for inventory items (1).rpd-json

This report is used to pull any invoice items that match the user entered query parameters to populate an extract file that can be imported into the EIS pending file. This should only be used when directed.  You should use the SSDT Inventory Extract Report to import into EIS pending file on a regular basis unless otherwise notified. 

Current Period Disbursement Summary.rpd-json

This report lists a summary of disbursements for the current period. It is comparable to a Classic CHECKS report. 

Five Year Forecast Revenue Summary.rpd-json

This report lists out the total per Five Year Forecast line #. It is comparable to Classic SM12REVSUM.

Five Year Forecast Budget Summary.rpd-json

This report lists out the total per Five Year Forecast line #. It is comparable to Classic SM12EXPSUM.

Receipt_Refund Ledger.rpd-json

This report lists out receipts (RX and RX) and refunds sorted by transaction date, fund and receipt code and subtotaled by fund and receipt code. (Classic equivalent RECFND.TXT)

Smart Procure Purchase Order Detail.rpd-json

This report lists out the purchase order number, purchase order date, line item descriptions, line item quantity, line item price, total line item amount, filled and paid and vendor name and number. Numerous districts use this report for the SmartProcure Public records request. 


USPS

Report DefinitionDescription
Absence-Attendance Report by Employee Name.rpd-jsonThis report will provide attendance details by employee

Account History Report.rpd-json

This report will generate an account history report for a date range.

Attendance Report By Building.rpd-json

This report will provide attendance details by building.

Benelogic Updated.rpd-json

This can be created in .CSV format and used for Benelogic reporting/upload.

BirthHire.rpd-json

This report is comparable to the Classic Birthhire report. It contains the employee number, full name, birth date and hire date. It has query parameters for entering a hire date range as well as pull in particular position numbers. 

CES (1).rpd-json

This report will generate a total of employees by gender for a specific pay date. This can be used the current employment statistics (CES) reporting to the Bureau of Labor Statistics.

Current Payroll Report.rpd-json

This report is a replacement for Classic's CURPAY.

Deduction Totals (1).rpd-json

This report can be run for a specific payroll item for a date range and total by employee.
EMIS Staff Report.rpd-jsonLists employees with their position, position code, status, separation date, reason, degree, semester hours, work days, and stop date. Filtering by EMIS Reportable Flags and Pay Groups.
Future Pay Amount Report-No effective date .rpd-jsonFuture Pay Report of Entries with No Effective Dates and Those With Effective Dates Within a Date Range.

Future Pay By Pay Group Report.rpd-json

This report generates a Future Pay Report by or for pay group(s).
Leave Balance Extract.rpd-jsonThis report will provide an excel or pdf report of current sick leave balances.
Leave Balance Extract-Red Rover.rpd-jsonThis report will provide an excel report of current sick leave balances with the headings already set up for Red Rover, with the exception of the School Year ID and As of Date.

Max Amount-Regular Payroll Item.rpd-json

This report will provide an excel report of specific payroll items with their Max Amount, Rate, and Remaining Employee Max Amount

OAPSE Report.rpd-json

This report will generate a total gross for the calendar year for all employees that had the OAPSE payroll item withheld. This can be generated in EXCEL format for OAPSE reporting.
Pay Distribution Codes.rpd-jsonThis report will generate a list of Pay Distributions for each employee with a detail about the distribution.
Payroll Items by Pay Date/Code Report.rpd-jsonThis report will sort by payroll item and lists all employees who contributed to that payroll item between any pay date, plus it has the option to filter by code.  The gross and applicable gross for those deductions are also listed.
Payroll_Items_by_Pay_Date_Report.rpd-jsonThis report will sort by payroll item and lists all employees who contributed to that payroll item between any pay date.

REMIT (1).rpd-json

This report can be created in .CSV format and used for reporting 403b and 457 (REMIT) reporting.
Specific_Payroll_Items_by_Pay_Date_-_Summary.rpd-jsonThis report lists a one line summary per employee per payroll item and how much the employee/employer have been contributed for a time period. 
STRS Advance Positions Report BalancingThis report lists compensation data that can be used to balance the STRS Advanced Positions Report.
TSA Monthly Data Transmission.rpd-jsonThis report creates a monthly report to upload annuity data to TSA Consulting.

USPS-R User Listing Report for Auditors.rpd-json

This report lists enabled Users in USPS. It contains username, name, last login and their assigned roles with descriptions of those roles.
Pay Accounts-SpecificAccounts.rpd-jsonThis report can be used in conjunction with the SSDT Account History v2 Report to generate a total of specific pay accounts charged - since the SSDT report is excluded those as of now.


USPS-Reports for Mass Loading 

Description
26 to 24 Pay Compensation WorksheetThis report will extrac data needed to review and update compensations that are set up as 26 bi-weekly pays and will be moving to 24 semi-monthly pays.
Annuity Updates.rpd-jsonThis report will extract data and heading titles to use for changing annuity amounts for both employee and employer.  This report can also be used to add a stop date on an annuity.
City Tax Rate Update.rpd-jsonThis report will extract data and heading titles for updating city tax rates.
COVID Federal Deduction Fields.rpd-json This report will extract heading titles and Employee IDs for loading COVID payment amounts into the Federal Tax Payroll Item.
EMIS Years of Experience.rpd-jsonThis report will extract data and heading titles for updating EMIS fields: Authorized Years of Experience, Total Years of Experience, and Principal Years of Experience 
EMIS Long Term Illness Days.rpd-jsonThis report will extract data and heading titles to use for clearing EMIS long term illness days.
HSA Updates.rpd-jsonThis report will extract data and heading titles to use for updating HSA payroll items with new employee/employer amounts, max amounts, ACH data, and stop dates.
New Contract LoadThis report will extract information needed for building new contracts.
OSDI Rate Update.rpd-jsonThis report will extract data and heading titles for updating Ohio School District tax rates.  This can also be used to place a stop date on an OSDI payroll item.
Print Employer Amount FlagThis report will extract the print employer amount flag for pay stubs that is on the Payroll Item Configuration.
Regular Pay Item Update.rpd-json

This report will extract data for mass updating union due amounts with a maximum and the specific date type.  

The Specific Date column will need to be added to the spreadsheet after the extract (employeeDeductMaxAmount.specificDate and/or employerDeductMaxAmount.specificDate).

Related content