School Finance Friday 3/17/17 Notes

AzEDS IT Updates

School Finance Updates

  • Data Capture was this week. ADM for payment looks good.
  • March Workshop Wednesday is Reconciliation again
    • One more session in person at our Jefferson office on 3/22 @ 1-3 pm. Email your Account Analyst to sign up.

Merge and Split

  • Merge tickets are a little slow this week
  • Split is expected in the coming month

Educating Graduates

  • There was a rule in December that failed students with a previous graduation date. Rule 10200 back in development. Please check students that might be affected.

Grades Served by District

  • There is a design difference SAIS vs AzEDS where grades are approved at the site or LEA level.
  • This has affected unified school districts all year
  • 10008 checks if a membership meets the approved grades at the school level
  • There is a Hot Topic on SF homepage that explains how to correct the situation if you’re still facing it.


  • It’s almost the time of year where memberships will require Year End Statuses. There’s a slight change between SAIS and AzEDS, where SAIS didn’t require a date for a Year End Status, unlike a Withdrawal code.
  • For further information:
    • A Membership is the time period where a student receives instruction
      • Has an Enrollment date and Exit date
    • Membership activity codes describe qualities of the enrollment and exit
      • Has an Enrollment or Re-enrollment code, and a Withdrawal Code or Year End Status

Training: Concurrencies in AzEDS

Limited ADM report

  • Requires AzEDS Data Coordinator – ADM Reports role in ADEConnect
  • For each of your students, displays limited intervals
  • Output columns mirror ADM15
  • NOTE: will not show multiple enrollments for a student who is not Limited.

Student Analysis Tool

  • Requires AzEDS Data Coordinator – Base Reports role in ADEConnect
  • For one student, by ID or demographic data, displays enrollments, programs, needs, etc.
    • First phase, more features to come

Multiple Enrollments

  • Students can have memberships at multiple schools:
    • Time element
      • At exactly the same time
      • With some overlapping days
      • Consecutively
    • ADM element
      • Limited ADM
      • ADM is not limited

Catch up online:

YouTube Preview Image

Please join us next week:


AzEDS Integrity: Grade Level not offered at this School

Due to the increased occurrence of integrity error -10008, School Finance has decided to temporarily amend the process for making changes for grade levels served at individual schools.

There is a difference between grade checks for memberships in AzEDS in comparison to SAIS. For the integrity error “-10008: Grade Level Code not offered at this School”, SAIS Integrity would check the grade levels approved at the District level.  With the conversion to AZEDS, Integrity was redesigned to check the grade levels offered at the School level.

To help with the change in methodologies for FY2017, School Finance has decided to allow a signed letter from the superintendent on district letterhead in place of the Governing Board minutes. For FY2018 and forward, the Governing Board minutes will be required for grade changes. For change requests any year, please include an Entity Profile form.

Please find the Entity Profile Form in the Forms tab on the School Finance website and here.

March Wednesday Workshop: ADM Reconciliation

Wednesday Workshops!

March Topic:  AzEDS Submission to ADM Reports, Revisiting Reconciliation


This beginner level session is designed new Data Coordinators at an LEA or for staff that would need a review of AzEDS data process. We will discuss which ADM reports to use for reconciling student data. What is ADM? What goes into my LEA’s payment? Where do I find reports in AzEDS? What does “reconcile your ADM” even mean? I need help on my Integrity errors; who do I ask for guidance?


  • Attendees must have access within ADE Connect to view ADM Reports.
    • If you do not have access to view these reports, please contact your Entity Administrator within you school to grant you access.

We are offering three March sessions:

  • Wednesday, March 08, 2017 – 1:00pm – 3:00pm
  • Wednesday, March 15, 2017 – 1:00pm – 3:00pm
  • Wednesday, March 22, 2017 – 1:00pm – 3:00pm

 Email your Account Analyst to sign up for one!

SDER Application Open for Data Modifications

SDER Application Open for Data Modifications

The School District Employee Report (SDER) On-Line Application is currently available and ready to accept employee data modifications prior to final TEI calculations.   This application is accessible through Common Logon.

SDER data may be modified between February 1, 2017 and March 2, 2017.  Final data modifications must be made by 4:00 p.m. Wednesday, March 1, 2017.

Preliminary TEI reports were made available in October of 2016, and can be accessed here.  Final TEI reports will be available on or prior to March 15, 2017. Final TEI figures may differ between the preliminary report and the final report even if your district does not modify its data, as the statewide average number of FTE Years of experience value may change due to its recalculated value for the final reports.

The SDER instructions can be found at the end of the FY2017 SDER Memo. You may also view the SDER presentation for more guidance located here.

Please contact your Account Analyst with any additional SDER questions.

School Finance Friday 1/6/2017 Notes

AzEDS IT Update

  • ADE is pulling back 2 rules for further analysis:
    • 10075 Attendance minutes for alternative school students
    • 10200 re-enrolled Graduates

School Finance Update

January Workshop Wednesday

  • for districts, Transportation
  • 1/25 at our Jefferson office
  • Webinar option available


Q: Is there a report available to see the assigned cohorts for my students?

A: There is a report on ADEConnect in Accountability. Email [email protected] for more information.

Q: Is there a report available to show me the students that will have labels for my coming Assessment?

A: Email the Testing Inbox for support and information.

Follow along online!

YouTube Preview Image

School Finance Friday 12/23/2016 Notes

AzEDS Updates

For information about the AzEDS system, you can sign up for IT communications.

  • Subscribe to the AzEDS Updates Blog! This will provide you an opportunity to receive updates automatically on items like news, releases, and FAQs.
  • Sign up for RedFlag! This will provide you with emails and texts on items like system outages and urgent notifications.

Sign up for IT Redflag updates and blog updates here:

School Finance Updates

  • -20005 is currently working for ~99% of students.
    • There is a unique scenario. We described it in the video below.
    • If a student in an tuition-out-type enrollment changes DOR mid-year, the rule isn’t behaving as we all expect. ADE IT, School Finance, and Accountability are analyzing the issue. See the AzEDS blog for details next week.
  • 10200, a new AzEDS Integrity rule went into AzEDS this week.
    • If a student previously graduated, they cannot be fundable going forward. If your student is failing 10200 look for a W7, S7, or G code in SAIS in previous years or on the student’s transcript from a previous school. If you think the 10200 flag is in error, please submit a ticket to [email protected]
  • Wednesday Workshops for January are going to be about Transportation reporting for districts. The session(s) will be in the latter half of January, so watch the site for details.
  • No School Finance Friday next week. Happy New Year!

Follow along on the video below!

YouTube Preview Image

School Finance Friday 12/16/2016 Notes


  • Wednesday Workshop
  • What is the Verification Dashboard?
  • What is an ADMS46-1?
  • When are 46-1s generated?

Wednesday Workshops for January are going to be about Transportation reporting for districts. The session(s) will be in the latter half of January, so watch the site for details.

Follow along in the vide for the trainings!

YouTube Preview Image

School Finance Friday 12/9/2016 Notes

AzEDS IT Update

Fixed Issues Update

  • LMTADM25 – fixed “duplicate”
  • Tuition Payer code=2, PS students no longer generating fundable intervals
  • Integrity rule -20002 is updated

Known Issues Update

  • 40000 rules that need to be updated
    • –40050
    • –40051
  • Rule -40036 which checks for age

School Finance Update

Data Capture Date for January

  • Declining Districts
    • FY 2017 only
  • To verify ADM:

Wednesday Workshops

Prioritize Integrity failures

  • Inactive calendar fixed; therefore contact School Finance if you have a calendar
  • Please don’t ignore rules if you think it might be broken.
  • AzEDS site to read Integrity rules

Training: What do these roles even mean?

EA for ADEConnect

Follow along on the video!

YouTube Preview Image

Link for School Finance Friday

School Finance Friday 11/25/16 Notes

AzEDS, Fixed Issue Update

  • Integrity rule 30001 was incorrectly failing.
  • Fixed Integrity Rule related to calendar status and track.
  • On the STAFF10, Educator Stakeholder ID field corrected.

AzEDS, New Functionality

  • R21 and S21codes were deployed to API.
  • Limited ADM report available. Called LMTADM25.
  • Attendance event report released.

AzEDS, Known Issues Update

  • 20002, Integrity rule about readmission
  • Tuition payer 2, PS students: Issue analysed and impacting 300 students only at ADM level
  • Integrity this week failed 11/22 evening, issue fixed

School Finance, Wednesday Workshops for December

  • Reconciliation: AzEDS Submission to ADM reports
  • At Jefferson
    • 12/7/16 1-3pm
    • 12/14/16 1-3pm
  • Depending on interest, can expand to include a Thursday or an online session

School Finance, Prioritize Integrity Failures

  • Inactive calendar fixed; therefore contact School Finance if you have an inactive calendar.
  • Please don’t ignore rules if you think they might be broken.

Training: 2 New Reports

Follow along on the video for more detail!

YouTube Preview Image