Race and Ethnicity Code for Queries

Race and Ethnicity Code for Queries


Kudos to Roger
This code auto fills the Ethnicity column with MULT for students with multiple races.

CASE when s.fedethnicity = 0 then
    CASE
           WHEN s.id in (
                 select studentid
                 from studentrace
                 group by studentid
                 having count(*) >1
               
                )  THEN 'MULT'
            ELSE sr.racecd          
            END
           
       ELSE 'LAT'
       END

Also, there should be an inner join added for studentrace <--> student tables:
inner join studentrace sr on s.id = sr.studentid


    • Related Articles

    • Ethnicity and Race - How it Works

      From this article.  Query Code for Ethnicity PowerSchool has four ways to record a students Race/Ethnicity The Federal Ethnicity Field The District Race Code System The Federal Race Categories System The Scheduling/Reporting Ethnicity Field   The ...

    • Ethnicity and Race Searches

      From this article.  Use Race.Fed to search for students or staff based on federal race, using the federal category description. Race.Fed = (T) Test Race Race.Fed = Vampire Race.Fed = Vampire Slayer Use RaceCode to search for students or staff based ...

    • US Department of Education's Guidance on Race/Ethnicity

      Selecting an Ethnicity If, in prior records, an individual has indicated that he or she was Hispanic, then the ethnicity question is answered. Your job is to observe and select a racial category. Many Hispanic individuals consider “Hispanic” as their ...

    • Ecollect Race/Ethnicity Email With PS Support

      On Wed, Jun 10, 2020 at 10:50 AM "Matthew Peery" <support@powerschool.com<mailto:support@powerschool.com>> <support@powerschool.com<mailto:support@powerschool.com>> wrote: Hi Gloria, The most recent release of Ecollect includes an updated and ...

    • Reports for Special Services

       The following reports are available under the Special Services category in SQL Reports Child Count Active students with IEP Entry Code is "CF", and Exit Date is not null student#, Last Name, First Name, Gender, Race, DOB, School, Entry Date, Exit ...