APDB HEGIS Campus Description Displays Not Applicable for Some Codes

The Campus Data Warehouse team is aware of a problem with the "HEGIS Campus Description" field on the Academic Planning Database (APDB) dashboards in production. Some HEGIS Codes are showing "Not Applicable" instead of their appropriate Descriptions from the source. We are currently working on a solution. 

This issue is being worked on in ITSR# 24115822. Date reported: Mon 3/3/25 2:40 PM Pacific Standard Time. 

Ticket number: 24115822 Ticket created: Mon 3/3/25 2:33 PM Pacific Standard Time Ticket title: APDB Hegis Logic producing not applicable when value exists in source Hegis Campus Description is showing Not Applicable for Hegis codes that exist in COSAR_06  There is a code bug in the ETL logic for the Course Hegis dimension the case statement should use the value from COSAR_06 if hegis code is NOT NULL only go to COSAR_34 if the value cannot be found in COSAR_06 inserting NOT should fix the issue