How Standard IPEDS Filters & Exports are Calculated

Updated August 16, 2022 12:20

Expand-All Collapse-All

The standard exports and filters for IPEDS classification are calculated from three Slate-Standard fields and prompts: Citizenship, Race, and Hispanic. Since IPEDS doesn't consider the race or ethnicity of international students, all international students are given an IPEDS classification of Nonresident Alien, regardless of race or ethnicity.

Slate uses a SQL statement to calculate an applicant's IPEDS classification. In plain English, the steps of that statement are:

Field	Calculation
Citizenship	If the Citizenship Status = "FN" (Foreign National), then export "Nonresident Alien"
Hispanic	If the "Hispanic" field is set to "Yes", then export "Hispanic of any race"
Race	If the number of values in the "race" field is >1, then export "Two or more races" If they do not have any value for the "race" field then export "Race/Ethnicity Unknown" Finally, all that's left over are those applicants that have a single value in the "race" field, in which case just that value is exported.

Best Practice

Store raw data (Citizenship, Race, Hispanic), then use standard exports and filters to calculate the IPEDS classification.