Class Enrollment Duplicate Records Due to FSSD Integration Skewing Aggregate Metrics

The Campus Data Warehouse team is aware of a problem in production where some metrics on the Grades dashboards are inflated slightly due to duplicate records in the dataset. We are currently working on a solution. 

This issue is being worked on in ITSR# 24073974. 

Ticket: 24073974  Date created: Fri 2/21/25 4:42 PM Pacific Standard Time Service: Report a Problem / Computer Software/Application Problem Title: Class Enrollment Duplicate Records Due to FSSD Integration Skewing Aggregate Metrics Duplicate records in the Class Enrollment dataset are skewing aggregate metrics across Grades, Courses, and Faculty Student Success dashboards in Campus Data Warehouse. An initial review of a sample of the records being double counted suggests this is a result of FSSD integration into Class Enrollment. Aggregate metrics such as Total Enrollment, Students Graded, Students with DFW Count/Percentage, Course GPAs, and others are impacted by the duplications. For an example of some duplicate records (Unification Ids), see the attached Excel (does not include all occurrences). Requested by: Michael Dorsch Created by: Michael Dorsch on Fri 2/21/25 4:42 PM Pacific Standard Time