Cron Expression Generator & Explainer

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

USAS
Report DefinitionDescription
This report lists enabled Users in USAS. It contains username, name, last login and their assigned roles with descriptions of those roles.
This report is equivalent to the Classic FINSUM. It filters out any accounts with all zeros
This report is a Budget Summary sorted and subtotaled by fnd/scc, 2 digit function and 1 digit object.
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.
This report will generate a listing of outstanding purchase order line items sorted by five year forecast line number for general fund only.
This report is a Budget Summary sorted/subtotaled by five year forecast line number.
This report is a Revenue Summary sorted/subtotaled by five year forecast line number.
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. 
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. 
This report is a Budget Account Activity Report sorted/subtotaled by five year forecast line number.
This report is a Budget Expense Worksheet sorted/subtotaled by five year forecast line number.
This report is a Revenue Account Activity Report sorted/subtotaled by five year forecast line number.
This report is a Revenue Expense Worksheet Report sorted/subtotaled by five year forecast line number.
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.
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.
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.

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

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. 
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.
This report is the SSDT Financial Detail sorted and subtotaled by Five Year Forecast Line #.

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

This report is the SSDT Requisition Detail with customized query parameters to exclude vendors and objects greater than the entered value 
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. 
This report is the SSDT Negative Appropriation Account report but with a built in query parameter of excluding 7410 and 7420 functions.


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. 


USPS
Report DefinitionDescription
This report lists enabled Users in USPS. It contains username, name, last login and their assigned roles with descriptions of those roles.
This can be created in .CSV format and used for Benelogic reporting/upload.
This report generates a Future Pay Report by or for pay group(s).
This report will generate an account history report for a date range.
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.
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.
This report can be created in .CSV format and used for reporting 403b and 457 (REMIT) reporting.
This report is a replacement for Classic's CURPAY.
This report can be run for a specific payroll item for a date range and total by employee.
This report will provide attendance details by building.
EMIS_list.rpd-jsonLists employees with their compensation, employee, and position flags. Also lists an employee's position information and can filter out specific pay groups
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


USPS-Reports for Mass Loading Description
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.
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.
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.
New Contract LoadThis report will extract information needed for building new contracts.