User Tools

Site Tools


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 [2018/04/04 13:16]
lokes
powerschool:powerschool:studentsearches [2024/03/01 13:49] (current)
lokes
Line 1: Line 1:
 ====== Student Searches ====== ====== 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 **[[:List Results|here]]** to list the students or export the list to a Microsoft Excel document. +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 **[[:List Results|here]]** to list the students or export the list to a Microsoft Excel document. 
-{{ :powerschool:powerschool:student_search.png |}}+ 
 +Each Search command line is broken into 3 parts: 
 +  - Field Name 
 +  - Comparator 
 +  - Search Argument 
 + 
 +**Example: **//last_name contains okes// 
 +          (1)      (2)     (3) 
 + 
 +{{:powerschool:powerschool:student_search.png}}\\
  
 Various PowerSchool Student Searches are listed in this attached document. Various PowerSchool Student Searches are listed in this attached document.
Line 15: Line 24:
 **Birthday Search**\\ **Birthday Search**\\
 ***birthday = today** - Finds all students whose birthday is today, matching only month and day.\\ ***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/@** - Finds all students whose birthday is May 1 of any yearfor any specified date.\\ 
-***birthday >= 3/1/@*birthday <= 3/31/@** - Finds all students whose birthday is in the month of March.\\ +***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/2000** - 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.\\ 
- +\\ 
-**Bus Search**\\+**Bus Search** (customized for WCS)\\
 **bus_am1=100** - Finds all students that ride bus 100 in the morning during the initial run.\\ **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_am2=100** - Finds all students that transfer to bus 100 in the morning.\\
Line 31: Line 38:
 ***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_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.\\ ***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.\\
 +***has_not_completed = xxxx** - Students who have not completed a course number, xxxx- Selects those students who do not have any entries for course xxxx on their 'historical grades' screen. Give a specific course number including the letters with the numbers. For example, 6120B.\\
 +***has_not_completed=6120B;*has_not_completed=6120;*has_not_completed=6120SB;*has_not_completed=6120S;grade=12** - Senior students that haven't taken the specific versions of Personal Finance\\
  
 **Credit Hours**\\ **Credit Hours**\\
Line 55: Line 64:
 **/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>=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\\  **/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**\\ **Disadvantaged**\\
Line 66: Line 78:
 **S_VA_STU_X.Early_College_Scholar_ProgCode=1** - Students that completed program agreement\\ **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 **S_VA_STU_X.Early_College_Scholar_ProgCode=2** - Students that earned a certificate
 +
 +**EL Services**\\
 +**S_VA_STU_X.ESL_Code=1** - Current students receiving EL or ESL Services\\
  
 **Email Search**\\ **Email Search**\\
Line 74: Line 89:
 **ecntX_email = <specific email address>**  (where X is 1, 2, 3, 4, or 5)\\ **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.\\ 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**\\ **Enrollment Search**\\
Line 83: Line 102:
  
 **Foster Care**\\ **Foster Care**\\
-**S_VA_STU_X.Foster_Care_Flag_TF=true** +**S_VA_STU_X.Foster_Care_Flag_TF=true** - Returns active students marked with the flag to indicate in Foster Care 
-**VA_FosterCare#** - 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**\\ **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#;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 **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**\\ **Health**\\
Line 99: Line 124:
 If you know an attendance date, you can find anyone that attended a WCS school after 8/13/2008.\\ 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. ***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 Search**\\
Line 116: Line 144:
  
 **Permission to Attend Search**\\ **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\\+**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.\\ **Phone Number Search**\\ - Phone Number Search - Use the Custom Reports. Click [[powerschool:[[.:powerschool:phonenumbersearch|here]] for instructions.\\
Line 122: Line 150:
 **PK Funding**\\ **PK Funding**\\
 **/entrydate >=8/10/2016; S_VA_STU_X.PK_Experience_Code=3** - Lists students coded with VPI 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**\\ **Schedules**\\
Line 136: Line 170:
 **/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.\\ **/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**\\+**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]] For search tips related to the state data fields used for the Student Data Collections, go to [[powerschool:powerschool:statereports]]
  
powerschool/powerschool/studentsearches.1522862172.txt.gz · Last modified: 2018/04/04 13:16 by lokes