July 15, 2016

PowerSchool Race and Ethnicity Export

In PowerSchool, we use the federal race/ethnicity designations. This is the same way the feds handle disaggregating races/ethnicity when doing reports.

This is a quick rundown of how it works. It’s a two part question:

  1. Are you Hispanic or Latino?
  2. Pick all the races that apply:
    • American Indian or Alaskan Native
    • Asian
    • Black or African American
    • White
    • Native Hawaiian or Pacific Islander

When you sort people into the ‘buckets’ for reporting, they can fall into these seven categories:

  • Hispanic or Latino
  • American Indian or Alaskan Native
  • Asian
  • Black or African American
  • White
  • Native Hawaiian or Pacific Islander
  • Multiple Races

These are the rules for sorting:

  1. If you are Hispanic or Latino, you fall into that bucket
  2. If you pick only one race, you fall into that race bucket
  3. If you pick multiple races, you fall into the ‘Multiple Races’ bucket

Export Code

The actual code that will return the bucket the student falls into is:

^(decode;^(FedEthnicity);1;Hispanic;^(decode;^(f.table_info;table=StudentRace;*studentid=^(id);fn=count;delim=);1;^(f.table_info;fn=value;table=Gen;field=Value;*cat=federalrace;*name=^(f.table_info;table=StudentRace;fn=value;field=RaceCD;dothisfor=all;*studentid=^(id));dothisfor=all);Multi))

All you need to do is copy/paste that entire line into a report or a quick export. It needs to be all on one line and is ok to word wrap.