Race / Ethnicity Changes Coming to Campus Data Warehouse Dashboards
GC0002376 - Add URM grouping for IPEDS Race plus dashboard changes
With the deprecation of CSU Race Reporting Category collection by the Chancellor's Office on October 1, 2025, we need to change the default Race / Ethnicity on dashboards and add new groupings for Underrepresented Minority.
1. Census version (ERSA/ERSS/ERSC/ERSD/Term Comp/Deg Comp/Inst Summ/Adm Funnel/AF Aggregate)
to wcs_csu_ethnicity_d add a new column ipeds_unrp_mnrty_ind which is a rollup of csu_ipeds_race_cat
to populate use:
select
csu_ipeds_race_cat,
ipeds_unrp_mnrty_ind
from (
select
obi_fieldvalue csu_ipeds_race_cat,
obi_group_code ipeds_unrp_mnrty_ind,
row_number() over(partition by obi_grp_schema, obi_fieldvalue order by effdt desc) rank_nbr
from ps_obi_grp_map
where obi_grp_schema = 'URM_IPEDS'
)
where rank_nbr = 1
order by 1
;
for description column obi_unrp_mnrty_descr get from obi_fieldname = 'URM_IND' in ps_obi_xlatvalu_vw
map to SMTLs & datasets
2. Non-census version (FSSD/Term Enrollment/Class Enrollment)
** I believe this is already in there but verify the Glue code **
to wcs_person_d/WCS_L_DIVERS_ETHNIC_LOOKUP_TMP add a new column UNRP_MNRTY_IND which is a rollup of ethnic_group
to populate use:
select
ethnic_group,
UNRP_MNRTY_IND
from (
select
obi_fieldvalue ethnic_group,
obi_group_code UNRP_MNRTY_IND,
row_number() over(partition by obi_grp_schema, obi_fieldvalue order by effdt desc) rank_nbr
from ps_obi_grp_map
where obi_grp_schema = 'URM_SIA'
)
where rank_nbr = 1
order by 1
;
for description column UNRP_MNRTY_DESCR get from obi_fieldname = 'URM_IND' in ps_obi_xlatvalu_vw
map to SMTLs & datasets
3. Use IPEDS Race / Ethnicity where available as the default Race / Ethnicity on the various dashboards
[This ticket replaces TDx # 24019755)