The Student Reconciliation Tool is a web-based application that provides a set of tools designed to help LEAs (Local Education Agencies) reconcile data between their local SIS and their state's Ed-Fi data store. It was designed by individuals with extensive understanding of the Ed-Fi REST API as implemented by the Arizona Department of Education.
Among other features, it presents student, school, staff, and parent information in a way that helps the LEA compare the information that exists at the state level with the information stored in the LEA’s local SIS. It uses the same REST API as your local SIS to retrieve information from the state on your behalf. And because it is completely independent of your local SIS, no customization of your SIS is required.
The current version offers the following features:
Uses an HTTPS secure connection to protect your data.
Provides a "launching page" for the district, allowing them to select from a list of schools for that district.
Look up information for a given student.
Look up information for a given school, such as course offerings and sections.
Look up information for a given staff member.
Look up information for a given parent.
Look up information for prior years, providing the LEA has the proper permissions from the state to do so.
Paginate through large volumes of information such as course offerings and sections.
Delete records from the state data store which you do not show in your local SIS and should not exist at the state level.
Cross-reference students, schools, staff, and parents by clicking on their respective unique ids.
Uses the LEA’s existing api key and secret (equivalent to a user name and password) that you already use to send data to the state.
The student, school, staff, or parent id can be included as part of the Url address, immediately focusing on that specific id's information. This provides an optional direct link that SIS vendors can someday use to quickly pull up information so you can easily compare what you have in your local SIS with what the state data store shows.
Features being considered for future versions include:
From the School Tab, provide the ability to click on a class section and see the class "roster" in a new tab.
Import a list of students, schools, staff, and/or parent all at one time.
Export results to a file using one or more formats.
Import information directly from the local SIS, allowing the tool to handle most of the reconciliation automatically (this will require coordination with each SIS vendor).
Search filters to help narrow down searches results.
ADM (Average Daily Membership) approximations for those LEAs that depend on accurate data at the state level for budgeting.