Helpful PowerSchool Search Commands

  • pssearches

    (Copy/paste BOLD search statements below into PowerSchool search window.)

No classes assigned

  • Students who DO NOT have any classes assigned:
    *Number_of_Classes<1

Not enrolled in a period

  • Students who are NOT enrolled  in a specified period:
    *Not_enrolled_in_period=1

Not enrolled in a course

  • Students who are NOT currently enrolled in a specified course:
    *Not_enrolled_in=XXXXXXXX

No historical grades

  • Students who DO NOT have any historical grade entries for a specified course:
    *Has_not_completed=XXXXXXXX

Blank in a data field

  • Students who have a “blank” in a data field:

    Gender=
    (This search will produce a list of active students whoDO NOT have an entry in the “Gender” field.)

     /Gender=
    (Enter a  “forward slash”  before the field name to include inactive AND active students in the search.)

Lunch Status Commands

  • Active students whose lunch status is coded “Full Pay:”
    LunchStatus=P

    Active students whose lunch status is coded “Free:”
    LunchStatus=F

    Active students whose lunch status is coded “Reduced:”
    LunchStatus=R

    Active students whose lunch status is “blank:”
    LunchStatus=

    Active students who lunch status is NOT equal to “blank:”
    LunchStatus#

Inactive Students

  • Students who are inactive in your database for the current school year:
    /Exitdate=>8/16/2020;Exitdate#6/8/2021

Enrolled in classes

  • Students who are currently enrolled in a specified number of classes:
    *Number_of_Classes=8
    *Number_of_Classes<7
    *Number_of_Classes #6

Current course enrollment

  • Students who are currently enrolled in a specified course:
    *Enrolled_in=XXXXXXXX
    (XXXXXXXX=Course Number)

Has completed command

  • Students who have at least one historical grade entry for a specified course:
    *Has_completed_course=XXXXXXXX

Cumulative Credit Hours

  • Students with the specified number of credit hours:
    *Cumulative_credit_hours=12
    *Cumulative_credit_hours<15
    *Cumulative_credit_hours>5

Date of birth commands

  • Students whose birthday is today:
    *Birthday=today

    Students with birthday on a certain date:
    *Birthday = 5/3

    Students whose birthdays fall within specific range:
    *Birthday>=5/1; *Birthday<=5/31

Medical alerts

  • Students with Medical Alert
    Alert_Medical#

    Students with Guardian Alert
    Alert_Guardian#

    Students with Discipline Alert
    Alert_Discipline#

    Students with Other Alert
    Alert_Other#

Student active

  • Students who were active on a particular day:
    *as_of=2/1/2020
    (This search will find every student who was active at your school on 2/1/2020 even if the student transferred to another school within the district.)