Native Language Field

rowenaz
Journeyman

Native Language Field

I would like to run a report/query that would pull up the names of any students who do not have English listed as the native language.  I can go into the search field, and put in:

S_STU_X.native_language

and I've tried  

S_STU_X.native_language>001

in my PowerSchool 001 is English, but no results.  

and

S_STU_X.native_language#001

but I get nothing. 

Any suggestions?

Thank you.

1 Reply
rowenaz
Journeyman

Okay I figured it out on my own.

It's this:

StudentCoreFields.primary_language>001

This gives all the students who have another language other than English (which is represented in CT by 001) and includes anyone regardless if they were ever receiving additional English Language Services.  So it gives EVERY STUDENT who has additional languages in their homes.