Dict-Physical

Table MD_Degree

Card of table MD_Degree

Name	MD_Degree
Dimensional Type	Dimension
Comment	Contains information on degrees - abbreviations, full names, and degree types. E.g., abbreviation, MDIV; full name, Master of Divinity; type, Theology. This table is actually used more for alumni and faculty than for internal degree audit purposes, although it's defined together with other academic-record dimensions in the data warehouse. It is populated from Colleague, specifically from information on faculty entered by the Dean of the College's office.

Check constraint name of the table MD_Degree

CKT_MD_DEGREE

List of incoming references of the table MD_Degree

Relationship_209

MF_AlumEducation

MD_Deg_SurrogateKey

List of diagrams containing the table MD_Degree

DimsAcademicRecordDiagram

List of columns of the table MD_Degree

MD_Deg_SurrogateKey

Internal unique degree identifier, used only in DW. Do not expose to users. They should use the degree abbreviation or name instead.

<None>

numeric

MD_Deg_Abbreviation

Code like PHD or MDIV. Uniquely identifies a degree.

DW_CodeDescShort

varchar(16)

16

MD_Deg_Name

Full degree name or description.

DW_CodeDescLong

varchar(64)

64

MD_Deg_Type

Type of degree, e.g., Associate, Bachelor, Theology.

DW_CodeDesc

varchar(32)

32

MD_Deg_AuditKey

DW_AuditKey

bigint

MD_Deg_Timestamp

<None>

timestamp

List of indexes of the table MD_Degree

MD_DEGREE_PK

TRUE

TRUE

TRUE

FALSE

FALSE

MD_DEGREE_AK

TRUE

FALSE

FALSE

FALSE

TRUE

List of keys of the table MD_Degree

Identifier_1

AltKey