Queries involving Archived Records

The advanced/historical query build has some powerful tools which can query for and compare historical record data to get your desired result set.
 

• Find historical records
• Compare current and archived record data

 

How to find records from your district even if the 'current' is no longer at your district, or changed to 504 Plan, etc.

When you are on the MIS Summary page, you see the 'archived' records menu.

This method allows you to find these archives from the past.

 

In the screenshot example below, we will look for archives representing the meetings held in your district during the 2021 - 2022 school year.

 

If you are looking for one record search for the SSID or student ID in the search bar up top.

When no records are found that is normal as the record isn't in your district.

 

• Click Modify
• Select Historical/Advanced Query TAB
• Change Historical Query Type from Current record to Archived Records
• Modify the Date Criteria to have a date range to include the report event date of the archive
• Click Search to List
• The list will include dates in the student name links to indicate the date of the archive.

 

 

 

 

 

 

 

 

 

 

Data Comparison

The following is an example of a way to query for records that have dropped a Speech Service.

 

Method 1- find archived records where current record has changed
 

1. a Most Recent Archive As Of query
2. Date Range could be last academic year, or going back 2 years.  This needs to include the date of the archive where the student has the service 415.
3. Search criteria = Active Status, All Services = 415
4. Comparison Criteria = Services Has Changed

1. Report event date within the date range
2. Archived record has service 415
3. Archived record is at your district/SELPA (user-based restrictions)
4. Current record does not have service 415
5. Current record could be anywhere.