Missing Speech Language Pathology Credential Data

The Campus Data Warehouse team is aware of a problem in production where Speech Language Pathology data is not appearing on the dashboards. We are currently working on a solution.

This issue is being worked on in ITSR#23481488.

Ticket: 23481488  Service: Report a Problem / Computer Software/Application Problem Date created: Wed 10/16/24 9:29 AM Pacific Daylight Time Title: ERS Dashboards: Missing Speech Language Pathology Credential Data ERS Credential > Missing Speech Language Pathology Credential Data Across ERS dashboards, the relatively new Speech-Language Pathology program credential is not being reflected in the dashboards (impacts both Oracle and new QuickSight dashboards). We need to figure out why the existing Oracle dashboard did not update so that the logic can be updated and fixed in QuickSight as well. Speech Language Pathology, code: 912 Most records appear as "-" for Credential Waiver Group and "Not Applicable" for Credential and Subject Matter Waiver Desc on the existing Oracle ERSS dashboard. See existing Jira issue: https://csu-dw-modernization.atlassian.net/browse/CDM-5249  Comment from Simon: A brief look into this yesterday with Sathyan's help, we determined that the cause is most likely a source data issue in ERS Student staging table leaving ERSS.CSU_CO_CRED_WV_CD with blank values, potentially due to the key change in COSAR_26 - CO added the NAME field to the key. Once the ERS Student data issue is fixed ODI ETL will run without error, but results may be inconsistent. The fix (in ODI and in AWS) to handle the COSAR key change is to rank PS_CSU_CO_COSAR_26 Requested by: Michael Dorsch Created by: Michael Dorsch on Wed 10/16/24 9:29 AM Pacific Daylight Time