Calculation for UM_ETHNIC_GRP_DESC field

 

WARNING: Field Name Definitions are Linked to the UMS Data Cookbook - this requires a University of Maine System ID and password

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.

Detailed Information 

This calculation follows the logic for the IPEDS definition.

For more information, see the Ethnicity definition in the UMS 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

Environment

  • PeopleSoft Campus Solutions
Submit an Inquiry or Request to DARTS Print Article

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)