Provide the background of this request.What events or discussions preceded this request? Have there been previous efforts related to this request? Are you working with a vendor already? What are the benefits of this initiative?
Enrollment of a single student in numerous curricula has become more commonplace particularly because of the expansion of certificate programs which encourage stacking towards masters degrees. The standard reporting views, particularly CSM Student Registered and CSM Student Registered Frz, include flattened data that supply fields for the primary and first secondary curricula of a single student by adding columns. In order to access additional curricula in those views, new sets of fields would need to be added for each additional curriculum level, but that is not a sustainable solution.
The proposed solution is to begin freezing the source curriculum data that feeds into CSM Student Registered. The delivered view Academic Study appears to be a good (if not the) starting point. It is worth noting that Academic Study itself is not usable for the purpose outlined by this project because it reflects the current state of curricula for past terms, which omits students who withdrew over the course of a term. Creating a frozen version of the curriculum records using the same schedule as CSM Student Registered will allow reporting on all curricula consistently at the same points in time.
Finally, in order to allow reporting on historical data from the proposed freeze table, those historical records can be recreated from the data already present in the CSM Student Registered Frz table.