PowerSchool Race and Ethnicity Export
·1 min
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:
- Are you Hispanic or Latino?
- 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:
- If you are Hispanic or Latino, you fall into that bucket
- If you pick only one race, you fall into that race bucket
- 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.