Ethnicity and Race Searches

Ethnicity and Race Searches

From this article. 

  1. 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
  2. Use RaceCode to search for students or staff based on race, using the federal race code.
    • RaceCode = TE
    • RaceCode = T
    • RaceCode = #@#
    • RaceCode =  T1
    • RaceCode =  T2
  3. Compound Related Searches may be compiled in the query format below:
    • RaceCode = T1;in (T) Test Race
    • RaceCode = T1;not in Vampire
    • RaceCode = T2;not in Vampire
    • RaceCode = TE;in (T) Test Race
    • RaceCode = AG;in Vampire
  4. Use Race.FedCode to search for students or staff based on federal race, using the federal category code.
    • Race.FedCode = T
    • Race.FedCode = VP
    • Race.FedCode = VS
  5. Use Race to search for students or staff based on race, using the district race code description.
    • Race =  Test Race Code
    • Race =  Test Race
    • Race =  #@#
    • Race =  (T1) Test One
    • Race =  (T2) Test One
  6. Use FedRaceDecline to search for students or staff based on race, using the federal race code indicated by students or staff indicating one or more races specified (0) of declining to specify race (1).
    • FedRaceDecline = 1 or 0
  7. Use to search for students or staff based on ethnicity, using the federal ethnicity code indicated by students or staff answering, “Are you Hispanic or Latino?” 1 = Yes, 0 = No, and 2 = Declined to answer.
    • FedEthnicity = 1 for yes 0 for no and 2 decline to answer

    • 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 ...

    • Race and Ethnicity Code for Queries

      Race/Ethnicity - How it Works 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                 ...

    • 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 ...

    • 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 ...

    • Special Search Codes for the Start Page

      On the Start page, you can search for more than just a name or number. The following has some common scenarios which you can use for other searches.  From the PowerSchool Community. Enrolled in Course.Section Format: ...