Update 3/25/2026:
The Admissions-related dashboards based on the Admissions Funnel dataset have been updated with the renaming of Legacy Race / Ethnicity fields and the addition of IPEDS Race / Ethnicity fields. The IPEDS Race / Ethnicity and IPEDS Underrepresented Minority (URM) fields have replaced the Legacy Race / Ethnicity (pre-2026) and Legacy Underrepresented Minority (pre-2026) filters in the Controls dropdowns at the top of each dashboard. Both the IPEDS and Legacy fields are available in the Group Breakdowns, but the Legacy fields will not have data for 2026 Fall applicants.
Additional dashboards will be updated with these changes in the coming months, and we will share updates as these changes are available in the Campus Data Warehouse.
11/3/2025:
Dashboard changes for the default Race / Ethnicity displayed on data visualizations are coming soon to Campus Data Warehouse.
With the deprecation of CSU Race Reporting Category collection by the Chancellor's Office on October 1, 2025, we will be replacing the default Race / Ethnicity displayed on the various overview dashboards to use the existing IPEDS Race / Ethnicity (IPEDS Race/Ethnicity Reporting Category).
New IPEDS Underrepresented Minority (URM) and IPEDS Race / Ethnicity (Federal) fields will be created using IPEDS Race / Ethnicity.
In addition, the current field names will change to reflect the deprecation of the CSU Race/Ethnicity Reporting Category & Ethnic Code fields.
Current Field Name | Planned New Field Name | Logical Source | Data Availability |
Race / Ethnicity | Legacy Race / Ethnicity (pre-2026) | CSU Race/Ethnicity Reporting Category & Ethnic Code (Old) | Stops collecting data for new applicants as of October 1, 2025 |
Underrepresented Minority Description | Legacy Underrepresented Minority (pre-2026) | CSU Race/Ethnicity Reporting Category & Ethnic Code (Old) | Stops collecting data for new applicants as of October 1, 2025 |
Race / Ethnicity (Federal) | Legacy Race / Ethnicity (Federal) (pre-2026) | CSU Race/Ethnicity Reporting Category & Ethnic Code (Old) | Stops collecting data for new applicants as of October 1, 2025 |
IPEDS Race/Ethnicity Reporting Category | IPEDS Race / Ethnicity | IPEDS Race/Ethnicity Reporting Category | Available for applicants beginning in 2009 |
[new field] | IPEDS Underrepresented Minority (URM) | IPEDS Race/Ethnicity Reporting Category | Available for applicants beginning in 2009 |
[new field] | IPEDS Race / Ethnicity (Federal) | IPEDS Race/Ethnicity Reporting Category | Available for applicants beginning in 2009 |
Ongoing updates will be shared via the Campus Data Warehouse Updates blog as the dashboard changes are made available in Campus Data Warehouse production.
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)