This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
powerschool:powerschool:studentsearches [2018/09/04 16:43] 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 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: | Each Search command line is broken into 3 parts: | ||
Line 8: | Line 8: | ||
- Search Argument | - Search Argument | ||
- | **Example: | + | **Example: **// |
- | (1) | + | (1) (2) (3) |
- | {{: | + | {{: |
Various PowerSchool Student Searches are listed in this attached document. | Various PowerSchool Student Searches are listed in this attached document. | ||
Line 24: | 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 >= 3/1/@; *birthday <= 3/31/@** - Finds all students whose birthday is in the month of March.\\ | + | ***birthday> |
- | NO LONGER WORKING-***birthday >= 5/1/99; *birthday <= 5/ | + | |
- | NO LONGER WORKING-**Birthdays** - Finds all students whose birthday is in the current month.\\ | + | |
**/ | **/ | ||
- | **DOB< | + | **DOB< |
+ | \\ | ||
**Bus Search** (customized for WCS)\\ | **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.\\ | ||
Line 40: | 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 ' | ***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 64: | Line 64: | ||
**/ | **/ | ||
**/ | **/ | ||
+ | |||
+ | **Directory Opt Out**\\ | ||
+ | **Grade_Level=11; | ||
**Disadvantaged**\\ | **Disadvantaged**\\ | ||
Line 75: | 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 83: | Line 89: | ||
**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 92: | Line 102: | ||
**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**\\ | **GATE**\\ | ||
- | **/ | + | **/ |
**S_VA_STU_X.Gifted_Code# | **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**\\ | **Health**\\ | ||
Line 108: | Line 124: | ||
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 125: | 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: | **Phone Number Search**\\ - Phone Number Search - Use the Custom Reports. Click [[powerschool: | ||
Line 131: | Line 150: | ||
**PK Funding**\\ | **PK Funding**\\ | ||
**/ | **/ | ||
+ | |||
+ | **Pre-Registration**\\ | ||
+ | **/ | ||
+ | |||
+ | **Primary Nighttime Residential Code**\\ | ||
+ | **/ | ||
**Schedules**\\ | **Schedules**\\ | ||
Line 145: | Line 170: | ||
**/ | **/ | ||
- | **State Related Searches**\\ | + | **Zip**\\ |
+ | **zip not in 24210, | ||
+ | |||
+ | |||
+ | ===== 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, | ||