To find students who have a red code on their PowerSchool student header line, look for the red code below.

Foster: (updated by Vanessa Alvarado’s department)

Find students with the red Fos: U_STUDENTSUSERFIELDS.FOSTER=1

Homeless: (red H)

Find Homeless students: Start Page > Special Functions > CALPADS Student Program Enrollments > Click on blue Display on the Homeless Program line

EL: (English Learner)

Find students with the red EL-1 (or 2,3,4): U_STUDENTSUSERFIELDS.ELPAC in 1,2,3,4 Find students with the red EL-R (Reclassified): U_STUDENTSUSERFIELDS.ELPAC=R Find students with the red EL-F (Fluent): U_STUDENTSUSERFIELDS.ELPAC=F

Find students with the red EL-P (Pending): U_STUDENTSUSERFIELDS.ELPAC=P Find students with the red EL-I (Intermediate): U_STUDENTSUSERFIELDS.ELPAC=I Find students with the red EL-N (Novice): U_STUDENTSUSERFIELDS.ELPAC=N

Find students with the red EL-C (CELDT Only): U_STUDENTSUSERFIELDS.ELPAC=C

NOTE: School staff should enter P (Pending) if any other language other than English is specified on the Home Language Survey. This will let Language Assessment know to get their EL code from CALPADS OR test the student if they aren’t in CALPADS.

Start Page > Special Functions > CALPADS Special Program Enrollments > click on DISPLAY for desired group:

1. LIP - Developmental Bilingual Program
2. LIP - Dual-Language Immersion Program
3. LIP - Heritage or Indigenous Language
4. LIP - Newcomer Program (Various Models)
5. LIP - One-Way Immersion Program
6. LIP - Structured English Immersion Program or other predominantly English Language Instructional Models
7. LIP - Transitional Bilingual Program
8. LIP - Parent Opted Out of EL Program

COSTS: (Connecting Our Students To School - State & Federal Projects) Find students with the red COSTS: U_StudentsUserFields.COSTS=1

SST: (Student Study Team-Student Services):

Find students with the red SST : U_StudentsUserFields.SST=1

AI: (Enrolled in American Indian Program-entered by American Indian Program staff) Find students with the red AI: U_StudentsUserFields.aiprogram=1

Special Ed: (Student with IEP/ISP – entered by Special Ed dept) Find students with the red SP: U_StudentsUserFields.speced=1

Migrant:  (Migrant Program)

Find students with the red MIG:  U_StudentsUserFields.migrant=1

Find students with the CALPADS Migrant program record: S_CA_STU_X.MigrantEd=1 OR Start Page > Special Functions > CALPADS Special Program Enrollments > click on DISPLAY for (135) Title I Part C Migrant

504:  (504 Accommodation Plan)

Find students with the red 504: U_StudentsUserFields.c_504=1

Find students with the CALPADS 504 program record: S_CA_STU_X.SpEd504=1 OR Start Page > Special Functions > CALPADS Special Program Enrollments > click on DISPLAY for (101) 504 Accommodation Plan

SAR: (Student Attendance Review) Used to be SART & SARB Find SART students: U_StudentsUserFields.SAR=1

Find SARB students: U_StudentsUserFields.SAR=2

Find students in Court Process (CP): U_StudentsUserFields.SAR=3

Find all (SART, SARB, Court Process): U_StudentsUserFields.SAR in 1,2,3

Independent Study 15+ days this school year: (This field will be reset at the end of June each year.) Find students who have not been on Independent Study this year: U_StudentsUserFields.IndStudy15 =

Find students who are currently on IS contract 1-14 school days this year: U_StudentsUserFields.IndStudy15 = IS Find students who are currently on IS contract for 15+ days this year: U_StudentsUserFields.IndStudy15 = I15 Find students who were on IS contract for 1-14 days this year, but not currently on IS contract:

U_StudentsUserFields.IndStudy15 = N<15 Find students who were on IS contract for 15+ days this year, but not currently on IS contract:

U_StudentsUserFields.IndStudy15 = N>15

Tier2 or Tier3 in student header: Based on data inside the students Intervention plan. This is not a field that can be searched. Use the VUSD Reports > Intervention Plan Viewer Tier 2 or Intervention Plan Viewer Tier 3 to search for students.

SSIP Tier 2 / Tier 3: Based on information entered into the SSID field. (NOT associated with the red Tier2 or Tier3 in the student header) (Replaced BESST [Behavior Engagement Student Support Team] codes 11/20/20)

Find students with SSIP Tier 2 OR Tier 3: U_StudentsUserFields.SSIP in 2, 3 Find students with SSIP Tier2: U_StudentsUserFields.SSIP=2

Find students with SIP Tier3: U_StudentsUserFields.SSIP=3

Psych Tier 2 / Tier 3: Based on information entered into the Psych_Tier field. (NOT associated with the red Tier2 or Tier3 in the student header)

Find students with Psych Tier 2 OR Tier 3: U_StudentsUserFields.psych_tier in 2, 3 Find students with Psych Tier 2: U_StudentsUserFields.psych_tier=2

Find students with Psych Tier 3: U_StudentsUserFields.psych_tier=3

Counseling Tier: Based on checkbox on the VUSD Custom Fields page: U_StudentsUserFields.coun = x (replace x with desired option 1, 2, 3)

SW (Social Worker) Tier: Based on checkbox on the VUSD Custom Fields page: U_StudentsUserFields.sw = x (replace x with desired option 1, 2, 3)

BIT (Behavior Intervention Tech) Tier: Based on checkbox on the VUSD Custom Fields page: U_StudentsUserFields.bit = x (replace x with desired option 1, 2, 3)

Handle With Care: (Special Ed Dept) Find students that have this symbol on their name line U_StudentsUserFields.handlewithcare=1

HEART: (Health Enrichment Academics Recreation Teamwork - Pro-Youth after school program) Find students in the HEART program: U_STUDENTSUSERFIELDS.HEART=1

GATE: (Gifted And Talented Education)

Find students in the VUSD GATE program: U_StudentsUserFields.GATE_Type#

Find students with specific GATE category (replace x with: D, E, L, M, P, S, T, V): U_StudentsUserFields.GATE_Type=x Find students with the CALPADS GATE designation: S_CA_STU_X.GATE=1

Academies: (High school academies)

Find students in an academy: U_StudentsUserFields.academy#

Find students in a specific academy: U_StudentsUserFields.academy=xxxx (replace xxxx with the academy abbreviation: AEAM, AOABST, AOE, AOFR, AOLJ, AOS, AG, AOCS, AOHS, BF, BMFA, CCRA, CCRM, CCRE, CCRHS, CCRECD, CCRFSH, CCRPSF, CCRPSL, FA, MAA, TLA, OL):

AVID

Find AVID students indicated by by performing the following search: U_StudentsUserFields.AVID=1

Please note, the AVID checkbox for this indicator must be checked in order for this search to work. Select Student> VUSD Custom Fields> AVID Check box

TK Student Search

Find students who qualify for TK this school year: DOB >= 09/02/2016; DOB <= 12/02/2016 (for the years in the dates, take the year school starts this school year and subtract 5. Ex: 2021-22 school year 2021-5=2016)

IntraDistrict Transfers:

Find students that have an IntraDistrict Transfer to a VUSD School: U_STUDENTSUSERFIELDS.INTRADISTRICTTRANSFERTOSCHOOL#

Find students that have an IntraDistrict Transfer Date to a VUSD School: U_STUDENTSUSERFIELDS.INTRADISTRICTTRANSFERDATE#

NOTE: When the student is no longer attending the school that they have an Intra District agreement for, you should blank out the IntraDistrict Transfer to School & Date, because it is no longer valid.

Next Year / Next School:

Find Active Students with blank Next Year Grade: Sched_NextYearGrade= Find Active Students with blank Next Year School: Next_School=

Pre-Registered Student searches:

Find Pre-Registered Students:  /Enroll_Status=-1

Find Students Pre-Registered for the 1st day of school: /Enroll_Status=-1; EntryDate=xx/xx/xxxx Note: Use 1st day of school for next year in place of xx/xx/xxxx.

The “/” symbol at the start of the search tells PowerSchool to look at Inactive & Preregistered students also.

Find Preregistered Students with blank Next Year Grade: /Enroll_Status=-1; Sched_NextYearGrade= Find Preregistered Students with blank Next Year School: /Enroll_Status=-1; Next_School=

Online Submission of data (example: Emergency Card, Registration data)

Students whose parents have not submitted yearly online data: U_StudentsUserFields.REG_USERCODE = Students whose parents have submitted yearly online data: U_StudentsUserFields.REG_USERCODE #

Race: Replace the xxx with the appropriate code:

Search for a single race code: RaceCode = xxx Search for multiple race codes: RaceCode in xxx, xxx, xxx, xxx

RaceCode & Race.FedCod e	Name
100	American Indian or Alaska Native
201	Chinese
202	Japanese
203	Korean
204	Vietnamese
205	Asian Indian
206	Laotian
207	Cambodian
208	Hmong
299	Other Asian

301	Hawaiian
302	Guamanian
303	Samoan
304	Tahitian
399	Other Pacific Islander
400	Filipino
600	Black or African American
700	White

Alerts & Icons

Discipline Alert:

Based on the Discipline Log entries converted from SASI prior to 2010-11. Search: Alert_Discipline#

Other Alert: 

Pop up window that displays data entered in the Other Information page. Search: Alert_Other# Example: “Ask caller for password to verify you are speaking with valid parent.”

Pop up window that displays emergency medical information the nurse has entered. Search: Alert_Medical#

Parent Guardian Alert:

Pop up window that displays data entered in the Guardian Alert on the Parents page. Search: Alert_Guardian#

Indicates student owes money (ex: fines, lost textbooks, lost uniforms). Search: *fee.fee_balance>0

Birthday alert:

Indicates student’s birthdate is within the next week on Admin pages. Click on candle to see the birthdate. Search using *Birthday function. Ex: *Birthday=today *Birthday=4/1 *birthday>=4/1;*birthday<=4/30

Pop up window that displays the classroom information for where the student is right now. It uses the bell schedule assigned on the calendar to determine where the student is.

Handle with Care icon:

Special Ed student that is fragile and needs additional care when dealing with them. This is entered by the Special Ed dept.