PowerSchool TechNote:

PowerSchool: Various Student Search Commands


The following student search command examples can be used from the start page in PowerSchool (copy & paste in the blue text shown below).


Birthdays (today)
*birthday=today
Finds all students whose birthday is today, matching only month and day.


Birthdays (date)
*birthday=5/1
Find all students whose birthday is May 1


Birthdays (range)
*birthday>=5/1/99;*birthday<=5/31/99
Find all birthdays in May of 1999


Birthdays (Month)
*birthday>=5/1/05;*birthday<=5/31/05
Find all the students whose birthday is in the month of May. Note: The year value in the date has no effect on the search, though it is required. The search will find all students with a May birthday, regardless of the year of their birth.


Active students
*as_of=2/1/2010
All students in the school that were active as of 2/1/2010


Students not in a period
*not_enrolled_in_period=1
All students not enrolled in period 1


Students in a course
*enrolled_in=Chem_101
Students in course number Chem_101


Students in a course and section
*enrolled_in=Chem_101.1
Students in course Chem_101 section 1


Students not in a course
*not_enrolled_in=Chem_101
Students not enrolled in course number Chem_101


Students who have completed a course
*has_completed_course=Chem_101
Students who have at least one entry of course Chem_101 on the historical grades screen


Students who have not completed a course
*has_not_completed=Chem_101
Students who do not have any entries of course Chem_101 on the historical grades screen


Students with X amount of credits
*cumulative_credit_hours<15
Students with less than 15 credit hours on their historical grades screen


Requested credit hours
*hours_requested<10
Students who have requested more than 10 credit hours


Students without a Photo in the PowerSchool System
PhotoFlag=0
Contact the Tech Group if you'd like your LifeTouch photos imported in bulk for your students.


All Students
*allstudents=all
A list of students in all grades who are taking classes in the current school, including those students enrolled in the current school. The search command *allstudents= will provide the same results.

*allstudents=9
A list of students in grade 9 who are taking classes in the current school, including those students enrolled in the current school.


Find incoming 9th Graders
/enroll_status = -1
Typically used to view students prior to the End of Year (EOY) process. You can also search for their "future" entry date, such as /entrydate = 9/1/11
Note the slash / in front of the search command. This also works as a stacked search to find incoming 9th graders (when used between May and August) /enroll_status = -1;sched_nextyeargrade = 9

Find students based on "future" grade level
sched_nextyeargrade = 9
or
sched_nextyeargrade = 10
or
sched_nextyeargrade = 11
or
sched_nextyeargrade = 12
Typically used to view students prior to the End of Year (EOY) process.


Find students that have transferred out of your school.
/enroll_status = 2
Used to view students that are nornally hidden from the search results.
Note the slash / in front of the search command.


Search for all fields with data (field is not blank):
List of all students that have a medical alert:
alert_medical#
The # sign is 'does not equal' and by leaving it blank afterwards you'll search where that field isn't blank.

 

The Searches below are useful for the Tech Group only:
Find students in Graduates Students that attended CHS and graduated as the class of 2010:
/Graduated_SchoolID=4;ExitDate=07/01/2010

Find students in Graduates Students that attended HTHS and graduated as the class of 2011:
/Graduated_SchoolID=10;ExitDate=07/01/2011

Find students in Graduates Students that attended one of the 5 academies and graduated as the class of 2012:
AAHS: /Graduated_SchoolID=25;ExitDate=07/01/2012
BTHS: /Graduated_SchoolID=28;ExitDate=07/01/2012
CHS: /Graduated_SchoolID=4;ExitDate=07/01/2012
HTHS: /Graduated_SchoolID=10;ExitDate=07/01/2012
MAST: /Graduated_SchoolID=20;ExitDate=07/01/2012

 

Stacking Searches
Find pre-enrolled students that have applied to AAHS and require entrance exam accommodations:
/Applying_To_MCVSD=AAHS;Admit_Accommodations_Yes_MCVSD=Yes

Find pre-enrolled students that have applied to BTHS (and other Career Academy examples) and require entrance exam accommodations:
/Applying_To_MCVSD=BTHS;Admit_Accommodations_Yes_MCVSD=Yes
/Applying_To_MCVSD=CHS;Admit_Accommodations_Yes_MCVSD=Yes
/Applying_To_MCVSD=HTHS;Admit_Accommodations_Yes_MCVSD=Yes
/Applying_To_MCVSD=MAST;Admit_Accommodations_Yes_MCVSD=Yes

Find students that have been offered admission and have not yet replied to MCVSD with their acceptance of admission::
/Admit_Acceptance_MCVSD=Yes;Admit_Acceptance_Reply_MCVSD=

Searching with "&" to narrow results
Run a "stored search" first. (such as Admission: Applying to AAHS)
This initial search will capture all matches.
Then use the "search box" to run an "&" search to further narrow the results of the stored search.
&/Admit_Accommodations_Yes_MCVSD=Yes

OR

Run a "search box" search first (such as /Applying_To_MCVSD=AAHS)
This initial search will capture all matches.
Then use the "search box" again to run an "&" search to further narrow the results of the stored search.
&/Admit_Accommodations_Yes_MCVSD=Yes

Note: If you run two "search box" searches from the main page, they will not narrow down previous, they run new search each time.
Same occurs with "stored search", each time a stored search is run, it will start fresh, and clear previous search results.


 

If there are any questions, please contact the Tech Group.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Need help from the Tech Group? Use the Online
MCVSD "Information Technology Help Request" form
https://www.mcvsd.org/techhelp/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

Back to the MCVSD Tech Tips site