Created by Miki Yanagi, last modified on Nov 10, 2021

UM_ETHNIC_GRP_DESC is a field found in UM_STUD_CENS_VW and UM_STUD_EXT_VW. It is based on the fields in UM_STUD_EXTRACT table.

This calculation follows the logic for the IPEDS definition.

For more information, see the Ethnicity definition in the Data Dictionary.

Alias A is UM_STUD_EXTRACT
CASE
WHEN A.Citizenship_Status = '4' THEN 'Nonresident Alien'
WHEN A.Ethnic_Group = '3' THEN 'Hispanic/Latino'
WHEN A.Hisp_Latino = 'Y' THEN 'Hispanic/Latino'
WHEN A.Um_Multiple_Ethnic = 'Y' THEN '2 or More Races'
WHEN A.Ethnic_Group = '1' THEN 'White'
WHEN A.Ethnic_Group = '2' THEN 'Black/African American'
WHEN A.Ethnic_Group = '4' THEN 'Asian'
WHEN A.Ethnic_Group = '5' THEN 'American Indian/Alaska Native'
WHEN A.Ethnic_Group = '7' THEN 'Native Hawaiian/Pacific Islander'
WHEN A.Ethnic_Group = '6' THEN 'Unknown' ELSE 'Unknown'
END