MF_MajorCount

Fact

Bridge table linking degree students to majors. Grain is per student per major. If a student changes majors, we take the most recent one here. Students may, of course, have multiple majors.

Useful for Common Data Set reporting, which requires that we report student counts (as a percentage of the whole) by major, for the top majors. In order to do this, we need data structures that can accommodate the many-to-many relationship between students and majors. This fact table, in conjunction with degree-student and major tables, can accommodate the many-to-many relationship. So also can academic record cubes that are implemented, in part, using this table.