Special Search Codes for the Start Page

Special Search Codes for the Start Page

On the Start page, you can search for more than just a name or number. The following has some common scenarios which you can use for other searches.  From the PowerSchool Community.




Enrolled in Course.Section

Format: *enrolled_in=[Course_Number].[Section_Number}

Example: *enrolled_in=SOC1000

Example: *enrolled_in=SOC1000.5


Enrolled in Number of Classes

Format: *number_of_classes[operator][number]

Example: *number_of_classes=7

Example: *number_of_classes<8

Example: *number_of_classes>6


Date of Birth is MM/DD/YYYY

Format: DOB=[MM/DD/YYYY]

Example: DOB=03/01/2012


Birthday (Anniversary) is MM/DD

Format: *birthday=[MM/DD]

Example: *birthday=today

Example: *birthday=03/01

Example: *birthday>=04/01;*birthday<=04/30


Active in Current School as of MM/DD/YYYY

Format: *as_of=[MM/DD/YYYY]

Example: *as_of=03/01/2011


Has No Historical Grades for Course_Number

Format: *has_not_completed=[Course_Number}

*has_not_completed=9500


Has Medical Alerts

Alert_Medical#


Has Guardian Alerts

Alert_Guardian#


Has Discipline Alerts

Alert_Discipline#


Use the IN comparator to search by a list of values.

Return all active students in 3rd, 8th, and 11th grade.

grade_level in 3,8,11
    • Related Articles

    • Special Services Data and Responsibilites

      This document provides a list of student data, and shows the staff that is responsible for managing the data. Data Managed By Procedure Page Homeless Students Wilie IEP Case Managers Case Managers create IEPs in Goalview. IEP and 504 data is imported ...
    • Reports for Special Services

       The following reports are available under the Special Services category in SQL Reports Child Count Active students with IEP Entry Code is "CF", and Exit Date is not null student#, Last Name, First Name, Gender, Race, DOB, School, Entry Date, Exit ...
    • Attendance Codes and Categories

      SCHOOLID SCHOOL ATT_CODE SLDS CAT SLDS Daily Status DCID Value Description 52 BHS AE EA Absent Absent Excused 52 BHS ALT Present Alternative Program (Off-site) 52 BHS AU UA Absent Absent Unexcused 52 BHS Unset Present Unset (no code) 52 BHS P Present ...
    • Student Attendance - Daily/Meeting Summary List Report

      To see attendance for an individual student, select student so he/she appears listed on the Start page. OR To see attendance for a school, select your school. This will work with whatever is selected on the Start page.  Click on PSCB Reports under ...
    • Direct Cert - Procedure Overview

      What is Direct Certification? Direct Certification (fondly referred to as Direct Cert or DC) is used to identify students who qualify for free or reduced lunches based on other State services they are receiving.  Who Qualifies? EdFusion provides a ...