This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
powerschool:powerschool:studentsearches [2020/02/18 09:58] lokes created |
powerschool:powerschool:studentsearches [2023/11/06 09:07] 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(; | ||
+ | |||
+ | Each Search command line is broken into 3 parts: | ||
+ | - Field Name | ||
+ | - Comparator | ||
+ | - Search Argument | ||
+ | |||
+ | **Example: **// | ||
+ | (1) (2) (3) | ||
+ | |||
+ | {{: | ||
+ | |||
+ | Various PowerSchool Student Searches are listed in this attached document. | ||
+ | {{: | ||
+ | |||
+ | **Alert Search**\\ | ||
+ | **alert_medical# | ||
+ | **alert_other# | ||
+ | **alert_guardian# | ||
+ | **alert_discipline# | ||
+ | |||
+ | **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> | ||
+ | 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< | ||
+ | \\ | ||
+ | **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 ' | ||
+ | ***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 ' | ||
+ | ***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 ' | ||
+ | ***has_not_completed=6120B; | ||
+ | |||
+ | **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/ | ||
+ | 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# | ||
+ | UNFORTUNATELY, | ||
+ | |||
+ | **chromebook_fee=1** - lists ACTIVE students that paid the fee\\ | ||
+ | **grade_level=9; | ||
+ | |||
+ | **purchased_chromebook_insurance=1** - lists currently ACTIVE students that purchased the insurance\\ | ||
+ | **/ | ||
+ | |||
+ | |||
+ | **Diploma**\\ | ||
+ | **/ | ||
+ | **/ | ||
+ | |||
+ | **Directory Opt Out**\\ | ||
+ | **Grade_Level=11; | ||
+ | |||
+ | **Disadvantaged**\\ | ||
+ | **/ | ||
+ | |||
+ | **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 | ||
+ | |||
+ | **EL Services**\\ | ||
+ | **S_VA_STU_X.ESL_Code=1** - Current students receiving EL or ESL Services\\ | ||
+ | |||
+ | **Email Search**\\ | ||
+ | **GuardianEmail = < | ||
+ | or \\ | ||
+ | **cntX_email = < | ||
+ | or\\ | ||
+ | **ecntX_email = < | ||
+ | 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. | ||
+ | |||
+ | **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# | ||
+ | |||
+ | **GATE**\\ | ||
+ | **/ | ||
+ | **S_VA_STU_X.Gifted_Code# | ||
+ | |||
+ | **Gifted Referral**\\ | ||
+ | / | ||
+ | |||
+ | **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, | ||
+ | |||
+ | **Inactive Student Search**\\ | ||
+ | **/*as_of = 9/15/98** - Active Students - Returns a list of all students who were ' | ||
+ | **/ | ||
+ | **/ | ||
+ | If you know an attendance date, you can find anyone that attended a WCS school after 8/ | ||
+ | ***as_of = mm/ | ||
+ | |||
+ | **Initial Primary Nighttime Residential Code**\\ | ||
+ | **/ | ||
+ | |||
+ | **Period Search**\\ | ||
+ | **^(*period_info; | ||
+ | Displays the name of the teacher for the specified period\\ | ||
+ | **^(*period_info; | ||
+ | **^(*period_info; | ||
+ | **^(*period_info; | ||
+ | **^(*period_info; | ||
+ | **^(*period_info; | ||
+ | specified term\\ | ||
+ | **^(*period_info; | ||
+ | **^(*period_info; | ||
+ | **^(*period_info; | ||
+ | **^(*period_info; | ||
+ | **Example: | ||
+ | |||
+ | **Permission to Attend Search**\\ | ||
+ | **Perm_Attend# | ||
+ | |||
+ | **Phone Number Search**\\ - Phone Number Search - Use the Custom Reports. Click [[powerschool: | ||
+ | |||
+ | **PK Funding**\\ | ||
+ | **/ | ||
+ | |||
+ | **Pre-Registration**\\ | ||
+ | **/ | ||
+ | |||
+ | **Primary Nighttime Residential Code**\\ | ||
+ | **/ | ||
+ | |||
+ | **Schedules**\\ | ||
+ | ***number_of_classes=0** - Lists students without a schedule. Change 0 to any number of classes. | ||
+ | |||
+ | **Special Ed Searches**\\ | ||
+ | **VA_Primary_Dis_Code# | ||
+ | **grade_level> | ||
+ | **/ | ||
+ | **/ | ||
+ | |||
+ | **Transfers**\\ | ||
+ | **entrydate> | ||
+ | **/ | ||
+ | |||
+ | **Zip**\\ | ||
+ | **zip not in 24210, | ||
+ | |||
+ | |||
+ | ===== State Related Searches ===== | ||
+ | |||
+ | For search tips related to the state data fields used for the Student Data Collections, | ||
+ | |||
+ | __**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. | ||
+ | {{: |