School Finance Fridays


Published: August 16th, 2019

School Finance Friday 8/16/2019 Notes

Payment 2 Hot Topic

AzEDS Reconciliation Training

  • Step 1: Submit Student Data
  • Step 2: Verify Successful Submission using AzEDS Reports
  • Step 3: Verify Student Data Passed Integrity
  • Step 4: Pull ADM Reports
  • Attend a Wednesday Workshop for additional help
  • Watch the archived Wednesday Workshop training video from your desk

Posted in School Finance Fridays |
Published: July 12th, 2019

School Finance Friday 7/12/2019 Notes

Canceling Webinar

  • Moving 7/26/2019 to 8/2/2019

New AzEDS Issues

2019: Some LEAs are reporting deleted 12th grade students in FY2019 after rollover to FY2020. If syncing FY2019 data does not fix the problem, please send ticket describing the issue to [email protected]

2020: 3 districts are reporting missing FY2020 calendars after posting them. School Finance recommends re-posting the calendar to AzEDS and taking a screencap showing it there. If it is deleted again, please send a TRANS15 report and the screencap to [email protected]

First Payment of 2020

Join us on August 2nd at the same link: https://www.youtube.com/channel/UC0PJ7Mg5plHOoZ5XjiC56lg/live

Posted in School Finance Fridays |
Published: April 12th, 2019

School Finance Friday 4/12/2019 Notes

Integrity Rule 10127

  • Approximately 2000 students were failing AzEDS Integrity rule 10127 when we turned it on earlier this month.
  • Works with 10200 to make sure current students don’t have diplomas already. 10200 checks prior year data for codes, 10127 checks within the same year for graduation codes.
  • This rule will be implemented again after IT fixes it.
  • [email protected] for support.

Integrity Rule 10200

  • Approximately 1200 students started failing 10200 after IT found a bug and corrected it.
  • This rule checks prior years for graduation codes.
  • When you see the error, you can search previous years in your SIS for G/W7 codes. You can also reach out to other schools on the student’s transcript.
  • One school may need to request a 915.

AzEDS 915

  • A 915 in AzEDS uses the same submission model as current year data in AzEDS, that is to say data is synced through the AzEDS API. Prior year datasets in AzEDS have a closed API. The 915 process opens a correction window through the API for specific students or schools. The external csv file outlined below is used as the filter to allow the open window in the API. For more information, please see:

SAIS 915

  • 915 Request for FY2016 deadline May 31
  • SAIS Online retiring
  • We want to send out a communication, who should we send it to?
    • AzEDS coordinator
    • Business Manager
    • Superintendent

Wednesday Workshops

  • 4/17/2019 New Year Calendars cancelled due to delays in demonstration screen captures. In its place, we will provide written guidance and a video of changes to the AzEDS Instructional Calendar for FY 2020.
  • 5/1/2019: School Finance New Charter Training *new
  • 7/25/2019*: Instructional Calendar FY 2020 (*Thursday)
  • 8/1/2019*: Instructional Calendar FY 2020 (*Thursday)
  • 10/30/2019: AzEDS Reports and Reconciliation

Merge Tickets

  • We’ve been working with IT to improve Merges and trying new prioritizations of existing tickets.
  • Team has resolved 400 merge tickets in the past 2 weeks.
  • We received 85 new merge requests since 04/01/2019.

Join us on April 26th at the same link: https://www.youtube.com/channel/UC0PJ7Mg5plHOoZ5XjiC56lg/live

Posted in Hot Topics, School Finance Fridays |
Published: October 18th, 2018

School Finance Friday Cancelled

To better address the volume of calls and emails to support the data and system issues impacting the November 1st payment, School Finance is cancelling the webinar planned for 10/19/2018.

School Finance updates can be found on the October Memo, SF 19-021.

AzEDS updates can be found on the AzEDS Blog.

If you need assistance with data or ADM for state aid payment, please email [email protected].

Posted in Hot Topics, School Finance Fridays |
Published: July 27th, 2018

School Finance Friday 7/27/2018 Notes

Update on Streaming Issue

  • We’re having trouble with the Q&A feature in our webinars. We’re still troubleshooting but this week have tried 3 fixes to help diagnose the issue. It appears users without @gmail.com email are kicked out sometimes.

AzEDS Update: 21st Century Community Learning Center

Data Submission Guidelines:

  • Resources required for 21st CCLC:
    • Student Program Association
      • Required fields: Student ID, Program name, Program type ID – Support Program(59), School id, LEA ID and Program begin date.
    • Student Program Attendance Event
      • Addition to Student Program Association it needs “Event Date” to be submitted as required field
      • Attendance Begin time and Attendance End Time are optional fields
    • Submission Start Date: Aug 27, 2018
    • For questions contact [email protected]

School Finance Training: Calendar Multiple Descriptor Issue

  • ADE designed transactions, tables, and reports but were not involved with the screen displaying your calendar in your SIS.
  • Some people are having trouble with more than one descriptor on the same date. To troubleshoot, School Finance recommends using the calendar UI in conjunction with the INTEG35 and CAL reports.

Join us on August 10th at the same link: https://www.youtube.com/channel/UC0PJ7Mg5plHOoZ5XjiC56lg/live

Posted in School Finance Fridays |
Published: June 29th, 2018

School Finance Friday 6/29/2018 Notes

For updates see:

http://www.azed.gov/aelas/category/azedsupdates/

http://www.azed.gov/finance/category/hot-topics/

Calendars for Fiscal Year 2019

School Finance published a hot topic explaining the AzEDS Calendar Certification process: http://www.azed.gov/finance/2018/06/26/instructional-calendar-certification-instructions/. It links to SF Memo 18-055 and SF Memo 18-065 which have further detail on AzEDS Calendar.

Overview and Demo AzEDS Calendar Feature

The video below walks through the AzEDS Calendar Feature and certification process. It includes:

  • Common Logon LEA Calendar versus AzEDS Calendar
  • SIS Vendor certification
  • Submission to AzEDS
  • AzEDS Calendar Integrity
  • Changes to AzEDS for the weekend of July 1
  • Permissions to the AzEDS Calendar feature

Join us on July 13th at the same link: https://www.youtube.com/channel/UC0PJ7Mg5plHOoZ5XjiC56lg/live

Posted in School Finance Fridays |
Published: October 6th, 2017

School Finance Friday 10/6/2017 Notes

AzEDS: Integrity Rule -10116

Rule -10116 was failing for all JTED students. It reads, “The Track submitted for a student’s enrollment record must be for the school the student is attending or the Track for the LEA under which the school resides.”

  • Short Term Solution is DONE!: Temporarily remove JTED logic from rule
  • Long Term Solution is in progress: Rework rule for REST API 3.0 Track data schema

AzEDS: Integrity Rule -20037

Rule -20037 should be Fiscal Year 2017 specific and reads, “This student was submitted with one of the Summer Withdrawal Codes which are being discontinued. The only code that will be accepted is S7.”

This rule has been disabled in AzEDS for Fiscal Year 2018 onwards.

Deadline for November Payment

The data capture deadline was October 3rd and the ADM data is significantly improved over previous months.

Wednesday Workshop October: Integrity for Beginners

Planning a training at our Jefferson office to help new data coordinators with Integrity errors. You can email [email protected] to sign up.

Last Week of SDER

The deadline is 10/16/2017. Please see our Hot Topic for more information.

Training: Summary ADM and Payment, or “Why is my payment is so short?”

You can call (602) 542-5695 for help reconciling ADM20 reports from AzEDS, ADMS46-1 reports from the web, and Payments reports.

 

Join us on October 20th at the same link: https://www.youtube.com/channel/UC0PJ7Mg5plHOoZ5XjiC56lg/live

Posted in Data Hot Topics, Hot Topics, School Finance Fridays |