Relationship_59

MD_CarlTerm (Shortcut)

MD_CarlTerm_SurrogateKey

Relationship_61

MD_DistroGroup (Shortcut)

MD_DistroGroup_SurrogateKey

VMF_DistroGroup

VMF_DISTROGROUP

MD_CarlTerm_SurrogateKey

<None>

numeric

MD_Course_SurrogateKey

<None>

numeric

MF_DistroGroup_AuditKey

DW_AuditKey

bigint

MD_Sect_SurrogateKey

<None>

numeric

MD_DistroGroup_SurrogateKey

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

<None>

numeric

MF_DistroGroup_Count

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.

<None>

int

MF_DistroGroup_Timestamp

<None>

timestamp

RELATIONSHIP_60_FK

FALSE

FALSE

FALSE

TRUE

FALSE

MF_DistroGroup

RELATIONSHIP_60_FK

FALSE

FALSE

FALSE

TRUE

FALSE

MF_DistroGroup

Identifier_1