Date
Attendees
Ariel Cassista - UMA Admissions / Target X
Jon Barker - USM Institutional Research, Analysis & Applications
- Janet Boucouvalas -SPC
- Michael Kelly- US IT Campus Solutions/ Target X
- Jami Holmes - UMF Admissions / Target X
- Barbara Castonguay - UMF Admissions / Target X
- Dina Goodwin - UMF Admissions / Target X
- Jessica Hunter - UM Admissions / Target X
- Bob Zuercher - System IR
Rachel Groenhout - DARTS
- Jeff Jensen - DARTS
- Pavan Narayanan - DARTS
- Miki Yanagi - DARTS
Goals
- Identify ethnicity fields each campus needs
- Is there a preference and/or need for multiple ethnicity to be displayed rather than a single (primary) ethnicity?
- If single ethnicity displayed, then:
- Gather suggestions for rules where student doesn't have PRIMARY_INDICATOR, is not Hispanic, and has multiple ethnicity
- Primary Indicator is not student self-identification (Janet)
Discussion items
List of Ethnicity fields:
- ETHNIC_GRP_CD - Ethnic Group
- ETHNIC_CATEGORY - Ethnic Category
- ETHNIC_GROUP - Ethnic Group
- HISP_LATINO - Person is Hispanic or Latino
- UM_ETH_GRP_DESCR - Ethnic Group Descr
- UM_ETHNIC_DESCR - Ethnic Description
- UM_MULTIPLE_ETHNIC - Multiple Ethnic Groups
Current Calculation:
| Scenario/ Fields in PS_UM_APPL_EXTRACT | ETHNIC_GRP_CD | ETHNIC_CATEGORY | ETHNIC_GROUP | HISP_LATINO | UM_ETH_GRP_DESCR | UM_ETHNIC_DESCR | UM_MULTIPLE_ETHNIC |
| ETHNIC_GROUP = '3' in PS_ETHNIC_GRP_TBL | from ETHNIC_GRP_CD in PS_DIVERS_ETHNIC when ETHNIC_GRP_CD <> 'NOTHIS' | from ETHNIC_CATEGORY in PS_ETHNIC_GRP_TBL | ETHNIC_GROUP = '3' in PS_ETHNIC_GRP_TBL | Y | XLATLONGNAME in PSXLATITEM where fieldname = 'ETHNIC_GROUP' and fieldvalue = 'ETHNIC_GROUP' value | DESCR50 from PS_ETHNIC_GRP_TBL | N |
| ETHNIC_GROUP <> '3' in PS_ETHNIC_GRP_TBL and PRIMARY_INDICATOR = 'Y' in PS_DIVERS_ETHNIC | from ETHNIC_GRP_CD inPS_DIVERS_ETHNIC when ETHNIC_GRP_CD <> 'NOTHIS' | from ETHNIC_CATEGORY in PS_ETHNIC_GRP_TBL | from ETHNIC_GROUP in PS_ETHNIC_GRP_TBL and PRIMARY_INDICATOR = 'Y' in PS_DIVERS_ETHNIC | N | XLATLONGNAME in PSXLATITEM where fieldname = 'ETHNIC_GROUP' and fieldvalue = 'ETHNIC_GROUP' value | DESCR50 from PS_ETHNIC_GRP_TBL | If sum of number of rows for ETHNIC_GROUP not in ( '3', '6') in PS_ETHNIC_GRP_TBL per EMPLID is greater than 1, then 'Y else 'N' |
| ETHNIC_GROUP <> '3' in PS_ETHNIC_GRP_TBL and PRIMARY_INDICATOR <> 'Y' in PS_DIVERS_ETHNIC for all rows for the same EMPLID | Random from ETHNIC_GRP_CD inPS_DIVERS_ETHNIC when ETHNIC_GRP_CD <> 'NOTHIS' | Random ETHNIC_CATEGORY infrom PS_ETHNIC_GRP_TBL | Random | N | XLATLONGNAME in PSXLATITEM where fieldname = 'ETHNIC_GROUP' and fieldvalue = 'ETHNIC_GROUP' value | Random from DESCR50 in PS_ETHNIC_GRP_TBL | If sum of number of row for ETHNIC_GROUP not in ( '3', '6') in PS_ETHNIC_GRP_TBL per EMPLID is greater than 1, then 'Y else 'N' |
If multiple ethnicity is the decision rather than selecting one of the ethnicities provided, this case statement replicates IPEDS rules:
UM_ETHNIC_GRP_DESC = 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
Action items
- Mike Kelly will investigate PRIMARY_INDICATOR field
- Jon Barker will gather opinions from USM Data Governance: use IPEDS ethnicity–not a single ethnicity....and, can this ethnicity be in student extract (added)?
- Jami Holmes will gather opinions from Admissions Group
USM prefers 'multiple ethnicity' over a hierarchy of single ethnicities to indicate 'primary'
- Janet Boucouvalas will gather information from Rosa / Enrollment Management Council: use IPEDS ethnicity