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
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