User Tools

Site Tools


powerschool:powerschool:studentsearches

Student Searches

At times, finding a set of students with a 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.

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, or any specified date.
*birthday >= 5/1/99; *birthday ⇐ 5/31/99
Birthdays - Finds all students whose birthday is in the current month.
DOB=03/01/1995 - Finds all students whose birthday is specified date.

Bus Search
busam1=100 - Finds all students that ride bus 100 in the morning during the initial run.
busam2=100 - Finds all students that transfer to bus 100 in the morning.
buspm1=100 - Finds all students that ride bus 100 in the afternoon during the initial run.
buspm2=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.

Disadvantaged
/VA_Disadvantaged#;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

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
VA_FosterCare# - Returns active students marked with the flag to indicate in Foster Care

Health
For searches on immunizations and other Health related information, go to Health 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

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.txt · Last modified: 2016/10/31 10:41 by lokes