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
Next revision Both sides next revision
powerschool:powerschool:studentsearches [2019/01/17 13:49]
lokes 		powerschool:powerschool:studentsearches [2020/02/18 09:56]
lokes
Line 41: Line 41:
 ***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 = 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 91: Line 92:
 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.\\
  
-**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: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. 
- 
-**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 [[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 
- 
-**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 [[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.txt · Last modified: 2024/03/01 13:49 by lokes

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki