Knowledge Base

User Tools

Site Tools

You are here: Knowledge Base » PowerSchool » PowerSchool Information » Student Searches
powerschool:powerschool:studentsearches

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
powerschool:powerschool:studentsearches [2020/02/18 09:56]
lokes 		powerschool:powerschool:studentsearches [2024/03/01 13:49] (current)
lokes
Line 26: Line 26:
 ***birthday = 5/1/@** - Finds all students whose birthday is May 1 of any year, for any specified date.\\ ***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.\\ ***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=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.\\ **DOB<06/01/2001** - Finds all students who will turn 18 by the last day of school. Change the date accordingly.\\
Line 92: Line 90:
 Email Search - Returns a list of students with the specific email address listed in their contact information found in the specified field.\\ Email Search - Returns a list of students with the specific email address listed in their contact information found in the specified field.\\
  
 +**Entry Code**\\
 +**EntryCode # E119**\\
 +Please run this search at your school to get a list of students with potential Entry Code errors.  If you find that they did not attend school elsewhere in the current school year, before starting at your school, please change the Entry Code to E119. We will need confirmation of any corrections before submitting enrollment records to the VDOE to update STI's.
  
 +**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** - Returns active students marked with the flag to indicate in Foster Care
 +**S_VA_STU_X.Foster_Care_Flag_TF#true** - Returns active students not marked with the flag to indicate that they're in Foster Care
 +
 +**GATE**\\
 +**/S_VA_STU_X.Gifted_Code#;entrydate>=8/9/23** - Returns all GATE students that attended this school year\\
 +**S_VA_STU_X.Gifted_Code#** - Only returns currently active GATE students
 +
 +**Gifted Referral**\\
 +/S_VA_STU_X.Gifted_Referral_TF=1;entrydate>=8/9/23 - Returns all Gifted Referral students that attended anytime this school yearS_VA_STU_X.Gifted_Referral_TF=1 - Only returns currently active Gifted Referral students 
 +
 +**Grade**\\
 +**grade_level in 9,11** - Returns only the students in the 9th or 11th grades
 +
 +**Health**\\
 +For searches on immunizations and other Health related information, go to [[powerschool:powerschool:healthreports]]
 +
 +**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.
 +
 +**Initial Primary Nighttime Residential Code**\\
 +**/EntryDate >= 8/24/2020;S_VA_STU_X.Primary_Nighttime_Res_Code #** - Finds students enrolled in the 2020-21 school year that are marked with an Initial Primary Nighttime Residence Code. It will include no shows, if you've already withdrawn any students.
 +
 +**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**\\
 +**Perm_Attend#** - 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 [[powerschool:[[.:powerschool:phonenumbersearch|here]] for instructions.\\
 +
 +**PK Funding**\\
 +**/entrydate >=8/10/2016; S_VA_STU_X.PK_Experience_Code=3** - Lists students coded with VPI funding
 +
 +**Pre-Registration**\\
 +**/enroll_status=-1** - Lists all the students that have been Pre-Registered
 +
 +**Primary Nighttime Residential Code**\\
 +**/S_VA_STU_X.Primary_Nighttime_Res_Code#; entrydate >= 8/8/18** - Finds the annualized number of homeless students
 +
 +**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.\\
 +
 +**Zip**\\
 +**zip not in 24210,24211** - Finds all of the students out of the zip codes listed used to identify Out of Zone students
 +
 +
 +===== State Related Searches =====
 +
 +For search tips related to the state data fields used for the Student Data Collections, go to [[powerschool:powerschool:statereports]]
 +
 +__**To find a list of fields, click on the View Field List link from the Start Page:**__
 +{{:powerschool:powerschool:view_field_list.png}}
 +
 +Start typing any part of the field name and the options will be displayed.
 +{{:powerschool:powerschool:search_codes.png}}
powerschool/powerschool/studentsearches.1582037795.txt.gz · Last modified: 2020/02/18 09:56 by lokes

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki