State Software Repository
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 the SSDT Budget Account Activity Report with an include vendor(s) query parameter. | |
| 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. | |
| This report lists a summary of disbursements for the current period. It is comparable to a Classic CHECKS report. | |
| This report lists out the total per Five Year Forecast line #. It is comparable to Classic SM12REVSUM. | |
| This report lists out the total per Five Year Forecast line #. It is comparable to Classic SM12EXPSUM. | |
| 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) | |
| 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 Definition | Description |
| Absence-Attendance Report by Employee Name.rpd-json | This report will provide attendance details by employee |
| This report will generate an account history report for a date range. | |
| This report will provide attendance details by building. | |
| This can be created in .CSV format and used for Benelogic reporting/upload. | |
| 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. | |
| 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 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. | |
| EMIS Staff Report.rpd-json | Lists 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-json | Future Pay Report of Entries with No Effective Dates and Those With Effective Dates Within a Date Range. |
| This report generates a Future Pay Report by or for pay group(s). | |
| Leave Balance Extract.rpd-json | This report will provide an excel or pdf report of current sick leave balances. |
| Leave Balance Extract-Red Rover.rpd-json | This 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. |
| This report will provide an excel report of specific payroll items with their Max Amount, Rate, and Remaining Employee Max Amount | |
| 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-json | This 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-json | This 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-json | This report will sort by payroll item and lists all employees who contributed to that payroll item between any pay date. |
| 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-json | This 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 Balancing | This report lists compensation data that can be used to balance the STRS Advanced Positions Report. |
| TSA Monthly Data Transmission.rpd-json | This report creates a monthly report to upload annuity data to TSA Consulting. |
| 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-json | This 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 Worksheet | This 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-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. |
| 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-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. |
| New Contract Load | This report will extract information needed for building new contracts. |
| 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. |
| Print Employer Amount Flag | This 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). |