Resolved: Wrong Academic Plan Effective Date for ERSx
A fix for the Academic Plan effective dates at census has been applied to Institution Summary [i.e. Retention and Graduation] dashboards in Campus Data Warehouse production. This fix adjusts Academic Plan at Matriculation data that changed after census snapshots to their status as of census of their matriculation term where possible. This resolves many of the discrepancies on the Retention and Graduation dashboards between the Major Concentration (e.g. College Description/Major Long Description at Matriculation) and Academic Plan (e.g. Academic Plan Owner/Academic Plan at Matriculation) fields.
A fix for the Academic Plan effective dates at census has been applied to ERS Student [i.e. Enrollment (Census)] dashboards in Campus Data Warehouse production. This fix adjusts Academic Plan data that changed after census snapshots to their status as of census where possible. This resolves many of the discrepancies on the Enrollment (Census) dashboards between the Major Concentration (e.g. College Description/Major Long Description) and Academic Plan (e.g. Academic Plan Owner/Academic Plan) fields.
A small number of differences remains due to discrepancies where Major Concentration was incorrectly set, and some Academic Plan records cannot be corrected due to removed or otherwise missing data in the source (OASIS) after census (e.g. a student was removed after census). A small number of records also have discrepancies in the Academic Careers in the Enrollment (Census) captures, and our data warehouse developers are continuing to work on that issue. Additional updates will be provided as the Academic Career discrepancies are resolved. In addition, downstream data models such as Institution Summary (Retention and Graduation) are still pending correction.
October 13, 2025
Academic program and Academic plans have the wrong effective date when integrated with the various ERSx data models (e.g. Applicant, Student, etc.)
As a result, Academic Program and Academic Plan fields on the dashboard may reflect changes to these fields beyond the snapshot date of the various ERSx datasets. For example, when we load the self-support census merge into the data models, students that changed their Academic Program or Academic Plan after census may appear in a different program or plan than they were in at Census.
The Data Warehouse team is working on reviewing and updating the logic to use the snapshot date rather than the sysdate or load date
GC0006593 - Campus Data Warehouse - Wrong Academic Plan Eff Dt for ERSx
Review and update SQL code so the academic program/plan are integrated with ERSx as of the snapshot date (not sysdate or load date). These appear to be in the ERSx integration FS files.