Dict-Physical

Table MD_DistroGroup

Card of table MD_DistroGroup

Name	MD_DistroGroup
Dimensional Type	Dimension
Comment	Distribution group dimension (not to be confused with the MF_DistroGroup fact table). At Carleton, courses satisfy distribution ("distro") group requirements like MS (= Math and Science). A given course may satisfy multiple distro group requirements. Hence the distro groups need to be separated out into their own dimension. The relationship between course/section and distro group is many to many. If used to classify courses/sections, therefore, to be used in connection with a fact table (in particular, MF_DistroGroup, which is used as a many-to-many bridge between this table and MD_Section and MD_CarlTerm).

Check constraint name of the table MD_DistroGroup

CKT_MD_DISTROGROUP

List of incoming references of the table MD_DistroGroup

Relationship_61

MF_DistroGroup

MD_DistroGroup_SurrogateKey

List of referencing views of the table MD_DistroGroup

VMD_DistroGroup

VMD_DISTROGROUP

List of diagrams containing the table MD_DistroGroup

DimsAcademicRecordDiagram

List of columns of the table MD_DistroGroup

MD_DistroGroup_SurrogateKey

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

<None>

numeric

MD_DistroGroup_Abbreviation

The short name or code for a distro group in Colleague. Cf. the name (which is just a description in Colleague and is considered to be more volatile). An unknown distro group is recorded as '????'.

DW_Colleague5CharCode

char(5)

MD_DistroGroup_Name

The full name or description of a distro group in Colleague. Cf. the abbreviation (or code), which is really the primary key.

DW_CodeDescLong

varchar(64)

MD_DistroGroup_Is1998

Yes' if a distro requirement (or overlay) applies to the 'old' (2009-10 and previous) curriculum, catalog year 1998. 'No' otherwise.

DW_YesOrNoNOTNULL

char(3)

MD_DistroGroup_Is2010

'Yes' if a distro requirement (or overlay) applies to the 'new' (2010-11 and later) curriculum. 'No' otherwise.

DW_YesOrNoNOTNULL

char(3)

MD_DistroGroup_IsOverlay

In the 2010 curriculum, there are two classes of course 'types': distro groups and overlays. All are included in this table as 'distro groups' (since all map to the same underlying valcode table in Colleague). This attribute allows us to distinguish the two.

The value here will be 'Yes' for overlays and 'No' for regular distro groups.

DW_YesOrNoNOTNULL

char(3)

MD_DistroGroup_IsObsolete

'Yes' if a given attribute was used for a time, for a given curriculum (or catalog year), but was dropped. Technically, we'd like to preserve history here, and make this a type-II SCD, but the added complexity for reporting doesn't justify it.

This attribute should not normally be used.

DW_YesOrNoNOTNULL

char(3)

MD_DistroGroup_AuditKey

DW_AuditKey

bigint

MD_DistroGroup_Timestamp

<None>

timestamp