How to Run the Beyond Tier 1 Support SQL Report Without a Case Manager

Learn how to run the Beyond Tier 1 Support SQL report without a case manager to check for errors and ensure no students fall through the cracks.

August 5, 2026 By Cindy Warner-Dobrowski

This guide explains how to run the Beyond Tier One SQL report without specifying a case manager. Completing this task allows you to check for data errors and identify students you work with who are case-managed by someone else, ensuring no student falls through the cracks.

This guide applies to counselors, grade-level coordinators, and support specialists who need to verify student support data and case management assignments during their regular caseload planning workflows.

Run the SQL Report

Step #1: Expand the Data and Reporting menu and click Reports. — Expand the **Data and Reporting** menu and click **Reports**.

Step #2: Click sqlReports. — Click **sqlReports**.

Step #3: Expand the Student Services Team folder. — Expand the **Student Services Team** folder.

Step #4: Select Beyond Tier 1 Support. — Select **Beyond Tier 1 Support**.

Step #5: Select your school division, open the Case Manager dropdown menu, and select the blank option at the top of the menu. — Select your school division, open the **Case Manager** dropdown menu, and select the blank option at the top of the menu.

Leaving the Case Manager field blank ensures you generate a complete list of all students in your division receiving beyond Tier One support, rather than limiting the results to your own specific caseload.

Step #6: Click Submit to generate the report. — Click **Submit** to generate the report.

Review the Report

Once the report is generated, you can narrow down the results depending on your role by filtering the columns by Grade or Counselor Name. Review the student records to make sure everything is accurate and accounted for.

Review Task	Description
Verify Case Managers	Confirm that the case manager listed for each student is correct.
Find Missing Data	Look for mismatched support fields. For example, if a student has Academic, Behavior, or Social-Emotional Support marked "Yes," ensure a corresponding support level is also selected.
Identify Shared Students	Spot students who receive services from you but are case-managed by a different specialist (e.g., a student managed by a Speech and Language Pathologist who receives Tier Two academic support from you).

Q: Why should I leave the Case Manager field blank?

A: Leaving it blank pulls all students with Beyond Tier One support marked as "Yes." This helps you find students you work with but who are assigned to a different primary case manager.

Q: What kinds of data entry errors should I look for?

A: Look for mismatched data fields, such as "Academic Support" being checked as "Yes" while the specific "Academic Level" is left blank. Also check that the correct case manager is listed.

Q: What do I do if I find a mistake?

A: You can navigate to the Student Snapshot, correct the error, and click Submit to save your changes.

Term	Definition
SQL Report	A custom database query used in PowerSchool to pull specific sets of student data.
Case Manager	The primary staff member responsible for overseeing and coordinating a specific student's support plan.
Tier One Support	Universal academic or behavioral support and accommodations provided to all students in a general education classroom.

Run the SQL Report

Review the Report

Review Task

Description

Verify Case Managers

Confirm that the case manager listed for each student is correct.

Find Missing Data

Look for mismatched support fields. For example, if a student has Academic, Behavior, or Social-Emotional Support marked "Yes," ensure a corresponding support level is also selected.

Identify Shared Students

Spot students who receive services from you but are case-managed by a different specialist (e.g., a student managed by a Speech and Language Pathologist who receives Tier Two academic support from you).

Q: Why should I leave the Case Manager field blank?

A: Leaving it blank pulls all students with Beyond Tier One support marked as "Yes." This helps you find students you work with but who are assigned to a different primary case manager.

Q: What kinds of data entry errors should I look for?

A: Look for mismatched data fields, such as "Academic Support" being checked as "Yes" while the specific "Academic Level" is left blank. Also check that the correct case manager is listed.

Q: What do I do if I find a mistake?

A: You can navigate to the Student Snapshot, correct the error, and click Submit to save your changes.

Term

Definition

SQL Report

A custom database query used in PowerSchool to pull specific sets of student data.

Case Manager

The primary staff member responsible for overseeing and coordinating a specific student's support plan.

Tier One Support

Universal academic or behavioral support and accommodations provided to all students in a general education classroom.