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/17 12:46] lokes |
powerschool:powerschool:studentsearches [2024/03/01 13:49] (current) lokes |
||
---|---|---|---|
Line 26: | Line 26: | ||
***birthday = 5/1/@** - Finds all students whose birthday is May 1 of any year, for any specified date.\\ | ***birthday = 5/1/@** - Finds all students whose birthday is May 1 of any year, for any specified date.\\ | ||
***birthday> | ***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< | **DOB< | ||
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 78: | 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 86: | 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 95: | 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 111: | 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 128: | 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 134: | Line 150: | ||
**PK Funding**\\ | **PK Funding**\\ | ||
**/ | **/ | ||
+ | |||
+ | **Pre-Registration**\\ | ||
+ | **/ | ||
+ | |||
+ | **Primary Nighttime Residential Code**\\ | ||
+ | **/ | ||
**Schedules**\\ | **Schedules**\\ | ||
Line 148: | 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, | ||