Dict-Physical

View VMF_DistroGroup

Card of view VMF_DistroGroup

Name	VMF_DistroGroup
Comment	See MF_DistroGroup. This fact-view is used to analyze section coverage of the various distro requirements.
Dimensional Type	Fact

SQL query of the view VMF_DistroGroup

SELECT
MD_Sect_SurrogateKey,
MD_CarlTerm_SurrogateKey,
MD_DistroGroup_SurrogateKey,
MD_Course_SurrogateKey,
MF_DistroGroup_Count
FROM
MF_DISTROGROUP

List of outgoing view references of the view VMF_DistroGroup

ViewReference_66

VMD_CarlTerm (Shortcut)

ViewReference_67

VMD_Section

ViewReference_68

VMD_Course

ViewReference_69

VMD_DistroGroup

List of referenced objects of the view VMF_DistroGroup

MF_DistroGroup

List of diagrams containing the view VMF_DistroGroup

ViewsAcademicRecordDiagram

List of permissions of the view VMF_DistroGroup

SELECT,VIEW DEFINITION

AcadRecordReader

List of view columns of the view VMF_DistroGroup

MD_Sect_SurrogateKey

numeric

MD_CarlTerm_SurrogateKey

numeric

MD_DistroGroup_SurrogateKey

numeric

Surrogate key identifier for distribution group (courses belong to one or more distro groups).

MD_Course_SurrogateKey

numeric

MF_DistroGroup_Count

int

Count of sections marked as fulfilling a particular distro group requirement in Colleague, by standard term (SU, FA, WI, SP).

Put differently, this attribute facilitates counting the number of terms in which a given section (or if aggregated, sections) that fulfill a particular distro group requirement are offered.

The grain here is term + section + distro group, and this is important, because a section may occur in multiple traditional terms (as often happens with off-campus programs), and a given section may also fulfill multiple distro requirements.

Home