This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
powerschool:powerschool:studentsearches [2017/11/15 12:11] lokes |
powerschool:powerschool:studentsearches [2020/08/31 09:33] lokes |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Student Searches ====== | ====== 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(; | + | 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. | 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 year, for any specified date.\\ |
+ | ***birthday> | ||
NO LONGER WORKING-***birthday >= 5/1/99; *birthday <= 5/31/99**\\ | 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.\\ | NO LONGER WORKING-**Birthdays** - Finds all students whose birthday is in the current month.\\ | ||
**/ | **/ | ||
- | **/DOB< | + | **DOB< |
- | + | \\ | |
- | **Bus Search**\\ | + | **Bus Search** |
- | **busam1=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.\\ |
- | **busam2=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.\\ |
- | **buspm1=100** - Finds all students that ride bus 100 in the afternoon during the initial run.\\ | + | **bus_pm1=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.\\ | + | **bus_pm2=100** - Finds all students that transfer to bus 100 in the afternoon.\\ |
**Course Search**\\ | **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_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 = 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**\\ | **Credit Hours**\\ | ||
Line 35: | Line 47: | ||
***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.\\ | ***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. | ***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**\\ | **Diploma**\\ | ||
**/ | **/ | ||
**/ | **/ | ||
+ | |||
+ | **Directory Opt Out**\\ | ||
+ | **Grade_Level=11; | ||
**Disadvantaged**\\ | **Disadvantaged**\\ | ||
Line 50: | Line 80: | ||
**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 58: | Line 91: | ||
**ecntX_email = < | **ecntX_email = < | ||
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. | ||
**Enrollment Search**\\ | **Enrollment Search**\\ | ||
Line 67: | Line 104: | ||
**Foster Care**\\ | **Foster Care**\\ | ||
- | **S_VA_STU_X.Foster_Care_Flag_TF=true** | + | **S_VA_STU_X.Foster_Care_Flag_TF=true** |
- | **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 |
+ | |||
+ | **GATE**\\ | ||
+ | **/ | ||
+ | **S_VA_STU_X.Gifted_Code# | ||
+ | |||
+ | **Grade**\\ | ||
+ | **grade_level in 9,11** - Returns only the students in the 9th or 11th grades | ||
**Health**\\ | **Health**\\ | ||
Line 79: | Line 123: | ||
If you know an attendance date, you can find anyone that attended a WCS school after 8/ | If you know an attendance date, you can find anyone that attended a WCS school after 8/ | ||
***as_of = mm/ | ***as_of = mm/ | ||
+ | |||
+ | **Initial Primary Nighttime Residential Code**\\ | ||
+ | **/ | ||
**Period Search**\\ | **Period Search**\\ | ||
Line 96: | Line 143: | ||
**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: | **Phone Number Search**\\ - Phone Number Search - Use the Custom Reports. Click [[powerschool: | ||
Line 102: | Line 149: | ||
**PK Funding**\\ | **PK Funding**\\ | ||
**/ | **/ | ||
+ | |||
+ | **Pre-Registration**\\ | ||
+ | **/ | ||
+ | |||
+ | **Primary Nighttime Residential Code**\\ | ||
+ | **/ | ||
**Schedules**\\ | **Schedules**\\ | ||
Line 112: | Line 165: | ||
**/ | **/ | ||
+ | **Transfers**\\ | ||
+ | **entrydate> | ||
+ | **/ | ||
+ | |||
+ | **Zip**\\ | ||
+ | **zip not in 24210, | ||
+ | |||
+ | |||
+ | ===== State Related Searches ===== | ||
- | **State Related Searches**\\ | ||
For search tips related to the state data fields used for the Student Data Collections, | For search tips related to the state data fields used for the Student Data Collections, | ||