ERS dashboards > Race 4 - American Indian category inconsistencies

The Campus Data Warehouse team is aware of issues with the Race 4 - American Indian category fields across all ERS-based dashboards in production. The issue may impact other race categories as well. We are currently working on troubleshooting. 
 

Ticket: 22661543 
Date created: Mon 5/13/24 3:43 PM Pacific Daylight Time
Service: Report a Problem / Computer Software/Application Problem

Update: Post to CDW Updates

Title: RACE004 inconsistent between front-end & back-end

Transferring Jira ticket for post MTP

The assumed criteria may no longer work for new tribal codes. 
This needs further investigation. May impact the other races as well. 

Here's the RPD join 

from 
     W_SIA_TERM_D T377 /* Dim_W_SIA_TERM_D_Term */ ,
     WC_CSU_RACE_DTL_D T1184 /* Dim_WC_CSU_RACE_DTL_D_RACE004_AMIND */ ,
     WC_CSU_SCHOLAR_ACDMC_MD T744 /* Dim_WC_CSU_SCHOLAR_ACDMC_MD */ ,
     WC_CSU_SNAPSHOT_D T688 /* Dim_WC_CSU_SNAPSHOT_D */ ,
     WC_CSU_ERSS_F T874 /* Fact_WC_CSU_ERSS_F */ 
where  ( T377.ROW_WID = T874.TERM_WID and T688.ROW_WID = T874.CSU_SNAPSHOT_WID and T744.ROW_WID = T874.CSU_SCHLR_ACAD_MINI_WID and T688.CSU_SNPSHT_TYPE_DESCR = 'Census Snapshot' and T874.CSU_RACE004_AMIND_WID = T1184.ROW_WID and substr(T1184.CSU_RACE_CODE , 1 , 2) = '04' and (T377.ACAD_YR in ('2022', '2023')) and (T744.OBI_STUDENT_FUND_TYPE_DESCR in ('Self Support', 'State Support')) and (case  when T744.OBI_STUDENT_FUND_TYPE_DESCR = 'Self Support' then 'Y' else 'N' end  in ('Y') or case  when T744.OBI_STUDENT_FUND_TYPE_DESCR = 'State Support' then 'Y' else 'N' end  in ('Y')) and (substr(T377.X_TERM_DESCR , 6 , 10) in ('Fall', 'Spring', 'Summer', 'Winter')) ) ),
SAWITH1 AS (select count(distinct case D1.c13 when 1 then D1.c12 else NULL end ) as c1,

Mapping tables need to be review
PS_CSU_ETHNIC_MAP
PS_CSU_MLT_RACE_MP

Requested by: Sathyan Sundaram
Created by: Sathyan Sundaram on Mon 5/13/24 3:43 PM Pacific Daylight Time