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

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


    Students who are NOT enrolled  in a specified period:

    *Not_enrolled_in_period=1


    Students who are NOT currently enrolled in a specified course:

    *Not_enrolled_in=XXXXXXXX


    Students who DO NOT have any historical grade entries for a specified course:

    *Has_not_completed=XXXXXXXX


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

    Gender=
    (This search will produce a list of active students who
    DO 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.)


    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#


    Students who are inactive in your database
    for the 2010-11 school year:

    /Exitdate=>8/16/2010;Exitdate#6/8/2011


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


    Students who are currently enrolled in a specified course:

    *Enrolled_in=XXXXXXXX

    (XXXXXXXX=Course Number)


    Students who have at least one historical grade entry for a specified course:

    *Has_completed_course=XXXXXXXX


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


    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


    Students with Medical Alert

    Alert_Medical#


    Students with Guardian Alert

    Alert_Guardian#


    Students with Discipline Alert

    Alert_Discipline#


    Students with Other Alert

    Alert_Other#


    Students who were active on a particular day:

    *as_of=2/1/2011

    (This search will find every student who was active at your school on 2/1/2011 even if the student transferred to another school within the district.)