Degree Description Discrepencies

----- Original Message -----

The Campus Data Warehouse team is aware of a problem in production where Degree Description data vary slightly compared with the data in our legacy data warehouse. This is impacting various dashboards. We are currently working on a solution.

This issue is being worked on in ITSR#23481415.

Ticket: 23481415  Service: Report a Problem / Computer Software/Application Problem Date created: Wed 10/16/24 9:23 AM Pacific Daylight Time Title: ERS Student Dashboards: Degree Description P2 ERS Student > Enrollment (Census) Terms Detail > Multilevel Crosstab Table > Degree Description (fix globally) Degree Description values for groups do not align between QuickSight and Oracle. See the original Jira issue: https://csu-dw-modernization.atlassian.net/browse/CDM-5160 Latest comment from Sathyan: maybe I'm misreading the code: It looks like they are bringing the most-recent plan, regardless of term. in both of these examples, the student changed plans (degree description is derived from plan). we should be bringing the max plan effdt before end of term date, max effseq, min plan sequence are we doing max prog/plan effdt vs sysdate in ODI? Requested by: Michael Dorsch Created by: Michael Dorsch on Wed 10/16/24 9:23 AM Pacific Daylight Time