Dict-Physical

Table MF_Advisement

Card of table MF_Advisement

Name	MF_Advisement
Dimensional Type	Fact
Comment	Links academic advisors to the people they are advising with start/end dates. If this fact table is used for access-control/authorization purposes, it must be accessed via a view to which several things must be done: 1) The view must be limited to cases where the advisement start date is <= getdate() and the end date is >= getdate() 2) The view it must join to MD_DegreeStudent and MD_Employee by bringing in surrogate keys from those dimensions via a join (where the colleague IDs are the same) See VMF_AdvisementCurrent.

Check constraint name of the table MF_Advisement

CKT_MF_ADVISEMENT

List of outgoing references of the table MF_Advisement

Relationship_237

MD_AcademicProgram (Shortcut)

MD_Program_SurrogateKey

Relationship_240

MD_Date (Shortcut)

MD_Date_StartDate

Relationship_241

MD_Date (Shortcut)

MD_Date_EndDate

Relationship_242

MD_AdvisementType (Shortcut)

MD_AdviseType_SurrogateKey

List of diagrams containing the table MF_Advisement

StarsAcademicRecordDiagram

List of columns of the table MF_Advisement

MF_Advise_ID

Unique identifier in ERP system associated with an act of advisement.

DW_CodeDesc

varchar(32)

MF_Advise_CollIDEmp

DW_ColleagueID

char(7)

MF_Advise_CollIDDStu

DW_ColleagueID

char(7)

MD_Date_StartDate

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

DW_DateInteger

int

MD_Date_EndDate

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

DW_DateInteger

int

MD_AdviseType_SurrogateKey

<None>

numeric

MD_Program_SurrogateKey

<None>

numeric

MF_Advise_Count

<None>

int

MF_Advise_AuditKey