September 2022 Release Notes

BI Releases

Title Description/Details
25 institutional data products Publication and modification review and processing

Data Warehouse Updates

Title Description/Details
Bursar Assessed Tuition fix to end of year process Fields Career, Career Descr, and Account Type were not being retained on the final end-of-year run. The End of Year process worktable was updated to retain those three fields and the end of year process instances were reloaded for 2020, 2021, and 2022
Lumen Course remove fields from 3 Dimensions Changes have been made to the file sent from CourseLeaf nightly and certain information is not longer sent resulting in the following field to be removed:

  • LUMEN_CRSE_BASIC_INFO_DIM: Remove ENROLL_INFO
  • LUMEN_CRSE_DESIGNATION_DIM: Remove SUSTAINABILITY_ATTRIBUTE; Remove SUSTAINABILITY_RATIONALE
  • LUMEN_COURSE_PROPOSALS (uses above DIMs): Remove ENROLL_INFO; Remove SUSTAINABILITY_ATTRIBUTE
ACADEMIC_DEPARTMENT – Add 2 new fields to the view in Snowflake Add the following two fields to DM.ACADEMIC_DEPARTMENT view on BAGP after the TERM_DESCR.: TERM_BEGIN__DATE and DEPARTMENT_EFFDT
Lumen Course Learning Outcomes – 10 missing outcomes There were/are missing course ids in the file coming from CourseLeaf nightly (TCFDB). A workaround was done to pull the course ID in from the Course Dim when this happens.
Skip to content