Data Hot Topics


October 19th, 2017

Merge request submissions

Please submit a request for the numbers to be merged via an e-mail to [email protected] or through the Self-Service Portal at http://help.azed.gov/ so that ticket number will be generated and the ID can be retired correctly.

Include the following:

  • Student full name
  • Date of Birth
  • Both IDs

You will receive an email once the merge is complete. We currently have a large volume to process. Your patience is appreciated.

It is important that each Merge request is made for a single student.

Posted in Data Hot Topics |
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 follow along on the video or 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 |
September 27th, 2017

SDER Application Open

The School District Employee Report (SDER) On-Line Application is now to accept employee data.  This application is accessible through Common Logon.

 

You must submit your SDER data by 4:30 p.m. on Monday, October 16, 2017.

 

The FY2018 Memo 18-018 that includes instructions for submitting data has been published in the memo section of the School Finance webpage: https://sf.azed.gov/sf/numberedmemos/FY2018%20Numbered%20Memos/18-018.pdf

 

If you have any questions about your SDER, please contact the [email protected]

 

Please note that SDER is required for districts.  Please include the 1.06% teacher salary increase for FY2018 in the total salary reported for each individual certified teacher.

Charter schools sponsored by the AZ State Board for Charter Schools, universities and community colleges are not obligated to submit the data and should not submit data.

Posted in Data Hot Topics, Hot Topics |
September 18th, 2017

Data for Payment 3

The deadline for data for Payment 3 ADM was 9/5/2017. As of the deadline, all LEAs except one were submitting to AzEDS. Many LEAs were very successful, however, various technical issues affected some LEAs. After analysis, School Finance is using ADM from ACE on 9/7/2017 for some LEAs, as listed below. With the exception of the one LEA that hadn’t yet submitted, all other LEAs will be paid using the same methodology as the first 2 payments: basing payment on Charter Estimated Counts for charter districts and FY 2017 ACE results for school districts.

Please plan for AzEDS ACE results on the evening of October 3rd for the November 1st payment, returning to the posted schedule.

list of LEAs for FY18 Payment 3 using 9/7 ADM

 

 

Posted in Data Hot Topics, Hot Topics |
September 8th, 2017

SB1156 – Changes to Full-Time Equivalency (FTE) Determination

SB1156 was approved this spring, updating instructional time requirements for students attending high school.

School Finance is currently writing guidance on this recent change and in the interim encourages all local education agencies (LEAs) to adhere to the wording of the bill as much as possible. Please see the Arizona State Legislature website for the text of the bill: http://www.azleg.gov/legtext/53leg/1R/laws/0333.htm.

A few key items to keep in mind:

  • Full-time enrollment still requires 4 or more subjects, each of which must meet 123 hours during the year.
  • Time for lunch, study hall, and other scheduled time which contributes to the academic success of the students may only be used for the difference between the 720 hours required annually and the instructional time for the 4 or more subjects.
  • Time other than the 4 or more subjects which is counted toward the 720 hours must be scheduled within your student information system just as the subjects are.

When the guidance is completed it will be posted on the School Finance webpage: http://www.azed.gov/finance/.

Posted in Data Hot Topics, Hot Topics |
July 25th, 2017

Charter Estimates Window Now Open

Charter Estimated Counts is now open for all active charter holders to submit new or revised estimates of their ADM (Average Daily Membership) for FY2018 and will close on August 14, 2017 at 4:30 p.m.

The data within Estimated Counts on August 14, 2017 will be used as the basis for the September 1, 2017 state aid disbursement.

Please see the table below submission and payment dates:

For Payment Date: Estimated Counts Submission OPEN DATE Estimated Counts Submission DEADLINE (by 4:30 p.m.)
September 1, 2017 July 25, 2017 August 14, 2017

 

Please see Memo 17-055 for submission instructions and more detail.

If you have questions regarding the submissions, please the Account Analyst Team at [email protected].

Posted in Data Hot Topics |
July 12th, 2017

Reminder: Charter Estimated Counts Deadline is 7/14/17

The first payment for Fiscal Year 2018 is expected August 1. The first payment for charter districts will be based on Charter Estimated Counts. Please confirm your charter district has submitted the necessary data.

The deadline for Charter Estimated Counts is coming on Friday, July 14th. You can access the application via Common Logon.

Before the payment is processed, your LEA must also have their Calendar submitted. The deadline for LEA Calendar has passed. You can access the application via ADEConnect.

Posted in Data Hot Topics |
June 29th, 2017

FY 2018 Monthly Payment and AzEDS Processing Schedules

FY 2018 Monthly Payment Processing Schedule

Every month ADE uses student data submitted by LEAs to calculate Average Daily Membership (ADM) to use as a basis for state aid funding. LEAs submit student data to AzEDS and ADM is calculated in the ADM Calculation Engine (ACE). The student data must reside within AzEDS on time to be included in the scheduled Integrity and ACE processing for each month’s payment.

Data Capture Deadline, 5 p.m. To be considered for:
September 5, 2017 Payment on October 2, 2017
October 3, 2017 Payment on November 1, 2017
November 7, 2017 Payment on December 1, 2017
December 5, 2017 Payment on January 2, 2018
January 2, 2018 Payment on February 1, 2018
February 6, 2018 Payment on March 1, 2018
March 6, 2018 Payment on April 2, 2018
April 3, 2018 Payment on May 1, 2018
May 1, 2018 Payment on June 1, 2018
June 5, 2018 Payment on June 29, 2018

Click thumbnail for calendar summary view.

AzEDS Processing Schedule

Please note that regardless of the monthly payment processing schedule, current year integrity will run at least five days per week. Integrity is scheduled every weeknight and will at least include data submitted to AzEDS up until 5 p.m. ACE is scheduled to run immediately after Integrity each run.

 

First Payments for Fiscal Year 2018

The first two payments of the year will not be calculated using AzEDS ACE results. The August 1, 2017 and September 1, 2017 payments will be based on Charter Estimated Counts for charter districts and FY 2017 ACE results for school districts.

 

FY 2018 Year End Recalculation Schedule

All LEA Submission Deadline July 13, 2018 @ 5 p.m.
Recalculation July 13-14

 

 

Posted in Data Hot Topics |