User Tools

Site Tools


powerschool:powerschool:studentsearches

This is an old revision of the document!


Student Searches

At times, finding a set of students with specific criteria is helpful. The following student searches can be performed on the PowerSchool start page. Multiple searches can be combined by adding a semicolon(;) between the search strings. Click here to list the students or export the list to a Microsoft Excel document.

Each Search command line is broken into 3 parts:

  1. Field Name
  2. Comparator
  3. Search Argument

Example: last_name contains okes

        (1)      (2)     (3)


Various PowerSchool Student Searches are listed in this attached document. various_powerschool_searches.docx

Alert Search
alert_medical# - Finds all students with a medical alert.
alert_other# - Finds all students with an other alert.
alert_guardian# - Finds all students with a guardian alert.
alert_discipline# - Finds all students with a discipline alert.

Birthday Search
*birthday = today - Finds all students whose birthday is today, matching only month and day.
*birthday = 5/1/@ - Finds all students whose birthday is May 1 of any year, for any specified date.
*birthday>=09/01;birthday⇐09/30 - Finds all the students whose birthday is in the month of September of any year.
NO LONGER WORKING-*birthday >= 5/1/99; *birthday ⇐ 5/31/99
NO LONGER WORKING-Birthdays - Finds all students whose birthday is in the current month.
/DOB=03/01/1995 - Finds all students whose birthday is specified date.
DOB<06/01/2001 - Finds all students who will turn 18 by the last day of school. Change the date accordingly.

Bus Search (customized for WCS)
bus_am1=100 - Finds all students that ride bus 100 in the morning during the initial run.
bus_am2=100 - Finds all students that transfer to bus 100 in the morning.
bus_pm1=100 - Finds all students that ride bus 100 in the afternoon during the initial run.
bus_pm2=100 - Finds all students that transfer to bus 100 in the afternoon.

Course Search
*has_completed_course = 9500 - Students who have completed a course - Select those students who have at least one entry of course 9500 on their 'historical grades' screen.
*has_not_completed = 9500 - Students who have not completed a course - Selects those students who do not have any entries for course 9500 on their 'historical grades' screen.

Credit Hours
*cumulative_credit_hours < 16 - Students with X amount of credits - Selects those students with fewer than 16 overall credit hours on their historical grades screen.
*number_of_classes < 6 - Students with X number of classes - Selects those students currently enrolled in fewer than 6 classes another example: *number_of_classes # 8 those students enrolled in less than or more than 8 classes.
*hours_requested < 7.5 - Requested Credit Hours - Students who have requested less than 7.5 credit hours.

Chromebooks
Typically the Toggle key has a value 0/1 or False/True. In this example, look at the full field name from the "View Field List." chromebook_fee and purchased_chromebook_insurance are the actual variable names to search.

chromebook_fee#1 - lists ACTIVE students that did NOT pay the fee
UNFORTUNATELY, the chromebook_fee=0 does not work as expected. The zero value is tricky and can be interpreted as a blank; therefore, using #1 is a better search in PowerSchool.

chromebook_fee=1 - lists ACTIVE students that paid the fee
grade_level=9; purchased_chromebook_insurance#1 - lists ACTIVE 9th grade students that did NOT purchase the insurance

purchased_chromebook_insurance=1 - lists currently ACTIVE students that purchased the insurance
/purchased_chromebook_insurance=1 - lists ACTIVE and INACTIVE students that purchased the insurance

Diploma
/S_VA_STU_X.Diploma_Type=3;S_VA_STU_X.Graduation_Date#;entrydate>=XX/XX/XXXX (where XX/XX/XXXX is the first day of school) - Students that earned an Applied Studies Diploma
/S_VA_STU_X.Diploma_Type=3;S_VA_STU_X.Graduation_Date#;entrydate>=08/10/2016;S_VA_STU_X.Primary_Disability_Code# - Special Ed Students that earned an Applied Studies Diploma

Directory Opt Out
Grade_Level=11;directory_opt_out= - Lists the students for the Military Recruitment Directory

Disadvantaged
/S_VA_STU_X.Disadvantaged_TF=true;entrydate>=XX/XX/XXXX (where XX/XX/XXXX is the first day of school)

Drop-outs
/exitcode contains W8; entrydate >= 8/10/2015; exitdate ⇐ 5/20/16
NOTE: Use the appropriate year in your search

Early College Scholars
S_VA_STU_X.Early_College_Scholar_ProgCode=1 - Students that completed program agreement
S_VA_STU_X.Early_College_Scholar_ProgCode=2 - Students that earned a certificate

Email Search
GuardianEmail = <specific email address>
or
cntX_email = <specific email address> (where X is 1, 2, 3, 4, or 5)
or
ecntX_email = <specific email address> (where X is 1, 2, 3, 4, or 5)
Email Search - Returns a list of students with the specific email address listed in their contact information found in the specified field.

Enrollment Search
*not_enrolled_in_period=1 - Students not enrolled in a period - Selects those students not currently enrolled in a period 1 course.
*enrolled_in = 9500 - Students in a course - Selects those students enrolled in course 9500 in the current term.
*enrolled_in = 9500.08 - Students in a course and section - Selects those students enrolled in section 08 of course 9500.
*not_enrolled_in = 9500 - Students not in a course - Selects those students not currently enrolled in course 9500
*not_enrolled_in = 9500.08 - Students not in a course and section - Selects those students not currently enrolled in section 08 of course 9500.

Foster Care
S_VA_STU_X.Foster_Care_Flag_TF=true VA_FosterCare# - Returns active students marked with the flag to indicate in Foster Care

GATE
/S_VA_STU_X.Gifted_Code#;entrydate>=8/9/17 - Returns all GATE students that attended this school year
S_VA_STU_X.Gifted_Code# - Only returns currently active GATE students

Health
For searches on immunizations and other Health related information, go to PowerSchool Health Searches and Reports

Inactive Student Search
/*as_of = 9/15/98 - Active Students - Returns a list of all students who were 'active' on that day active meaning enrolled on or before and exited on or after.
/*as_of=1/1/2009;lastfirst contains Abelseth - Returns all the students with that name enrolled on the specified date.
/*as_of=1/1/2009;student_number=960905442 - Returns the student enrolled on the specified date with the specific student ID number.
If you know an attendance date, you can find anyone that attended a WCS school after 8/13/2008.
*as_of = mm/dd/yyyy;Last_Name = xxxxxx - Returns the previous year student with the specific last name. Useful when adding test scores. Where mm/dd/yyyy is a date that the student was enrolled at the school and xxxxxx is the students last name. It will bring up a list of students with that last name that was enrolled at the school on that date.

Period Search
^(*period_info;XX;teacher_name) - The XX would be the expression like 2(A) for 2nd hour
Displays the name of the teacher for the specified period
^(*period_info;XX;course_name) - Displays the name of the course for the specified period
^(*period_info;XX;course_number) - Displays the number of the course for the specified period
^(*period_info;XX;current_citizenship) - Displays the current citizenship grade for the specified period
^(*period_info;XX;current_grade;YY) - Displays the current grade for the specified period in the specified term
^(*period_info;XX;current_percent;YY) - Displays the current percentage grade for the specified period in the specified term
^(*period_info;XX;room) - Displays the room number for the specified period
^(*period_info;XX;section_number) - Displays the section number for the specified period
^(*period_info;XX;teacher_comment) - Displays any teacher comments for the specified period
^(*period_info;XX;teacher_i_<field name>) - This special _i_ version can pull any field from the teachers table.
Example: ^(*period_info;3(A);teacher_i_last_name)

Permission to Attend Search
PermAttend# - Displays the list of students marked on the Custom Screens - Important SASI Fields as Permission to Attend for Washington County Schools

Phone Number Search
- Phone Number Search - Use the Custom Reports. Click here for instructions.

PK Funding
/entrydate >=8/10/2016; S_VA_STU_X.PK_Experience_Code=3 - Lists students coded with VPI funding

Schedules
*number_of_classes=0 - Lists students without a schedule. Change 0 to any number of classes.

Special Ed Searches
VA_Primary_Dis_Code# - Finds all students in the Special Education program.
grade_level>=3;va_primary_dis_code# - Finds all students in 3, 4 and 5 grade with a Primary Disability
/VA_Primary_Dis_Code#;exitcode contains W8; entrydate >= 8/10/2015; exitdate ⇐ 5/20/16 - Finds SpEd dropouts
/entrydate >= 8/10/16; VA_Sp_Ed_Per>49 - Finds students with Special Ed Weekly Time Percentages of 50% and above

Transfers
entrydate>8/9/17 - Finds all of the students that have transferred in as of today's date. /exitdate>8/9/17; exitdate<6/1/18 - Finds all of the students that have transferred out during the school year. This search is useful for locating the transfer out date for the *as_of= search to see inactive students.

State Related Searches
For search tips related to the state data fields used for the Student Data Collections, go to State Reporting

To find a list of fields, click on the View Field List link from the Start Page:

Start typing any part of the field name and the options will be displayed.

powerschool/powerschool/studentsearches.1537202817.txt.gz · Last modified: 2018/09/17 12:46 by lokes