Dict-Physical

Table MD_InstructionalMethod

Card of table MD_InstructionalMethod

Name	MD_InstructionalMethod
Dimensional Type	Dimension
Comment	This dimension holds a list of instruction methods: Lecture, Dance, Independent Study, etc. It is used, e.g., to attach a method of instruction to specific course meeting times (so we can tell what spaces in what buildings are being used for what sorts of instruction). This dimension is not to be confused with individual "instructional method" attributes on, e.g., sections - which only indicate a primary method of instruction for a section. Note that this dimension includes a default-ish 'Unknown' instructional method, to make it possible, e.g., for us to join some row here to every row in the MF_SectionMeetsAt fact table.

Check constraint name of the table MD_InstructionalMethod

CKT_MD_INSTRUCTIONALMETHOD

List of incoming references of the table MD_InstructionalMethod

Relationship_82

MF_SectionMeetsAt

MD_InstMeth_SurrogateKey

List of diagrams containing the table MD_InstructionalMethod

DimsAcademicRecordDiagram

List of columns of the table MD_InstructionalMethod

MD_InstMeth_SurrogateKey

Unique identifier for instructional method. Used internally to the data warehouse. Generally should not be exposed to users, unless they are doing their own joining and querying.

<None>

numeric

MD_InstMeth_Abbreviation

Short name for an instructional method, e.g., DAN (Dance), IS (Independent Study).

DW_CodeDescShort

varchar(16)

MD_InstMeth_Name

Longer, human-usable name for an instructional method, e.g., Dance, Independent Study, Ensemble, Lecture.

DW_CodeDesc

varchar(32)

MD_InstMeth_AuditKey

DW_AuditKey