Page tree
Skip to end of metadata
Go to start of metadata

(tick) Subscribe to the SSDT Newsletter by clicking here.  Your email will be added to a distribution list.        


The April newsletter contains feature articles on certification reports and the creation of query parameters in template reports.  Because these articles are pretty detailed, we provided links below so you can easily click on a specific section of the article.   So much good information, we wouldn't want you to miss a section of it! 

Certification Reports Available in USAS-R

Classic's USACERT programs are available in the Redesign.  They are all located under the Periodic menu and include the following: (click on the sample report to view a PDF version of each)

RedesignClassicSample ReportDescription
Appropriation ResolutionAPPRESClick HereReport of the district's temporary resolution prior to fiscal year closing or as a final resolution
Certificate of Available BalancesCERTBALClick HereA certificate of available balances which is to be submitted to the county auditor at the beginning of the fiscal year
Amended Official Certificate of Estimated ResourcesAMDCERTClick HereReport to be submitted to the county auditor when there have been changes made to estimated resources.

Prior to running one of the above reports. fund levels for reporting can be set up under CORE>Accounts' Fund tab.  This is a one-time setup.  The 'Resolution Levels' and 'Include in Resolution' checkbox pertain to the Appropriation Resolution report.  By default,  all funds and all resolution levels are included of which you can modify.  The 'Certificate Reporting' pertains to the Certification reports.  You can choose between Fund/SCC or Fund reporting for each Fund.

Appropriation Resolution

You can choose one of the following 'amounts to use' depending on whether a temporary resolution or permanent resolution report is needed.   The selected amounts will appear on the report.

  • Beginning Balances Only (July 1st Cash balance)
  • Next Year Proposed
  • FTD Appropriation, Carryover, and Totals
  • FTD Appropriation minus Carryover Encumbrances

The Appropriation Resolution narrative from Classic's APPRES program, which includes the the date/time/location and the listing of Board members adopting the Resolution, is not available within the Redesign.  Instead, a sample narrative (in Word format) is available in the documentation which you can then save and customize with your district information. 

Certificate of Available Balances and the Amended Official Certificate of Estimated Resources

Separate summary and detail report options are available for both reports.   Like the Appropriation Resolution report, the Certificate and Amended Certificate programs have sample narratives available in the documentation you can save and customize.

Certificate of Available Balances Options and Calculations

Fiscal Year: Enter the fiscal year to report on.  

Exclude Fund/SCC: enter Fund/SCCs you want to exclude from the report. 

Principal Amounts for Permanent Fundenter the Fund/SCC along with the associated principal amount for any permanent funds. Reporting requirements state that only interest earnings are supposed to be considered available for expenditure when certifying year-end balances of a permanent fund to the county auditor.  The principal amount entered for each Fund/SCC will be subtracted from the beginning cash balance listed on the report.

Advances Not Repaid: enter advances that have not been repaid as of July 1st.  A positive amount should be entered for the fund that made the advance and a negative amount entered for the fund that will be making the reimbursement.

The resulting report contains the following columns.  Included is how the amounts are calculated:

  • Cash Balance June 30: Cash Balance as of June 30 of the prior year
  • Encumbrances June 30: all outstanding encumbrances as of June 30 which have been carried over into the new year
  • Advances not Repaid: Advances not repaid that were entered in the program
  • Carryover Balance Available for Appropriation: Column 1 – Column 2 +/- Column 3.
  • Total Amount From all Sources Available for Expenditures: Pulled from the receivable amounts stored on the revenue accounts.  For example, the total in this column for the general fund should equal the total sum of all receivable amounts for general fund revenue accounts  If you did not enter temporary or permanent appropriations to your revenue accounts, this amount will be zero.
  • Total Amount Available Plus Balances: Column 4 + 5

Amended Official Certificate of Estimates Resources Options and Calculations

Fiscal Year: enter the fiscal year to report on.  

Tax Options: By default, values listed will be included in the "Taxes" column on the report unless you check them. NOTE: Income Tax is receipt code 1130 and Other Taxes is receipt code 1190.   

Exclude Fund/SCC: enter Fund/SCCs you wish to exclude from the report. 

Principal Amounts for Permanent Funds: enter the FUND/SCC along with the associated principal amount for any permanent funds. (Same as Certificate option) 

Advances Not Repaid: enter advances that have not been repaid as of July 1st. (same as Certificate option)

The resulting report contains the following columns. Included is how the amounts are calculated

  • Unencumbered Balance July 1: calculated for each fund by taking the July 1 cash balance - Prior year carryover encumbered + Advances not repaid - Principal entered in program
  • Taxes and Other Sources Columns: are the receivable amounts; these are the final receivables at the time which would include any additions or deductions made.  If you did not enter temporary or permanent appropriations to your revenue accounts, this amount will be zero.
  • Total:  total of Column 1 + Column 2 + Column 3



How are the Query Parameters created when generating a report? 

With Classic reports, you are stuck with a few options under the 'Selection Criteria' prompts to filter your report by.  Not the case with Redesign.  When customizing a template report, the 'Configure Filters' tab is the behind-the scenes mastermind that allows you to create filterable prompts that display as 'Query Parameters' when generating a report.  Most template reports provide default Query Parameters.  However,  if you want to create your own query parameter prompt, please refer to the following steps:

Cash Summary Configure Filters.....become the Query Parameters prompts when generating the report

  1. Open the Report Definition in the Report Manager Grid  
  2. Click on   .  On the far left is a list of Properties to filter from.  Select a property which will be pulled into 'Display Name
  3. Select the desired Operation from the drop-down. 
  4. In the Filter Value, enter the following function:  param("name","default value","label")
    1. The "name" must be unique within the query. Most template reports use the (string) value which is displayed when hovering over a display name property
    2. The "default value" is optional. 
      1. Is there a default value you want displayed in the Query Parameter?  Example: creating a date range parameter and you want it to default to current period.  Please refer to Greater or equal/Less or equal example under Operations Table.
      2. NOTE: If leaving the default value blank, all but the 'One of' operation require double quotations "" for a blank default value.   
    3. The "label" is the prompting value shown to the user when generating the report.  This is optional.  If left blank, it will display the 'Display Name'.  I would recommend creating a label to further define the parameter.

Operations Table

The table below summarizes the more popular 'Operations' you can use and how to create a Query Parameter.  For more detailed information about the various 'Operations' and how to to create them, click here.

OperationDefinition

Create a Parameter Value 

How it's Displayed

Equals

Match an exact value

  

One of

Able to enter multiple values separated by commas 

Not Equals

Exclude a value

Like

Begins with

Contains

Entered Value Anywhere in the Field

BetweenBetween two Values


Greater or equal/Less or equalGreater than or equal/ Less than or equal value entered






Follow us: 


Useful links:



Did You Know?

New Contract Checklist Available

Creating new contracts in Redesign has never been easier.  Click here for a checklist that can be used to assist in the new contract creation process.



STRS Advance Changes

STRS has made changes to how part-time employees service credit is calculated.  This is effective for the current STRSAD in July 2020.  There are NO changes for full-time employees.  STRSAD determines whether an employee is full-time or part-time by the drop down box on the 450 Payroll Item record. 

To view the changes online, go to the STRS website:   https://www.strsoh.org/employer/_pdfs/guides/50-380.pdf  

Please click on the link below for a printable doc of the calculation of Part-Time Employees:

STRS service credit calculation.docx

  • Here are the new calculations for Part-time employees:
    • If less than 90 days worked.  Calculate days/180 and calculate actual compensation/$12,000.  The Service Credit is the LESSER of the two calculations.
    • If greater than 89 and less than 120 days worked.  Calculate days/180 and calculate actual compensation/$12,000.   The Service Credit is the LESSER of the two calculations.
    • If greater than 119 days and salary is less than the state minimum of $30,000.  Calculate days/180 and calculate actual compensation/$12,000.  The service Credit is the LESSER of the two calculations.
    • If greater than 119 days and salary is greater than the state minimum of $30,000.  The Service Credit is 1.00 or 100%.



REDESIGN STATUS

166

Sites Live on Redesign

115

Total Wave 5 Sites

17

Participating ITCs

236

Total Districts Participating


Please view the Current List of Districts & Status to see a comprehensive list of school districts along with their ITC, implementation status and the wave they are scheduled to migrate from Classic to Redesign.

The following terminology is used to determine where in the implementation process the entity is currently at:

  • Implementing: The ITC is running test imports and balancing reports on the entity.  The district and ITC are working to schedule dates to begin dual processing and go live.

  • Paralleling: The entity is inputting all production transactions into both Classic and Redesign.

  • Live: The entity is using Redesign for production processing; no parallel processing is being performed;  Classic is available in 'read-only' mode.





  • No labels