Cron Expression Generator & Explainer
This page is intended to be a sharing area for all Redesign Reports.
| USAS | |
|---|---|
| Report Definition | Description |
| 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. | |
| USPS | |
|---|---|
| Report Definition | Description |
| 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. | |
| 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-json | Lists 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-json | This 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-json | This 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-json | This report will extract data and heading titles for updating city tax rates. |
| EMIS Years of Experience.rpd-json | This 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-json | This report will extract data and heading titles to use for clearing EMIS long term illness days. |
| HSA Updates.rpd-json | This 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-json | This 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 Load | This report will extract information needed for building new contracts. |