Table MD_Major

Card of table MD_Major

Name

MD_Major

Dimensional Type

Dimension

Comment

Academic major dimension. Cf. MD_Concentration.


Check constraint name of the table MD_Major

CKT_MD_MAJOR


List of incoming references of the table MD_Major

Name

Child Table

Foreign Key Columns

Relationship_92

MF_MajorCount

MD_Major_SurrogateKey


List of diagrams containing the table MD_Major

Name

DimsAcademicRecordDiagram


List of columns of the table MD_Major

Name

Comment

Domain

Data Type

Length

MD_Major_SurrogateKey

 

<None>

numeric

 

MD_Major_Abbreviation

Abbreviation for major. An unknown major will be coded as '????'.

DW_Colleague5CharCode

char(5)

5

MD_Major_Name

 

DW_CodeDescLong

varchar(64)

64

MD_Major_CIPCode

CIP code for major. Used to convert majors to a portable, cross-institutional format defined by the US federal government.

The purpose of the Classification of Instructional Programs (CIP) is to provide a taxonomic scheme that will support the accurate tracking, assessment, and reporting of fields of study and program completions activity. CIP was originally developed by the U.S. Department of Education's National Center for Education Statistics (NCES) in 1980, with revisions occurring in 1985 and 1990. The 2000 edition (CIP-2000) is the third revision of the taxonomy and presents an updated taxonomy of instructional program classifications and descriptions.

Not all majors at Carleton will have CIP codes, and the CIP codes may change over time.

<None>

varchar(12)

12

MD_Major_AuditKey

 

DW_AuditKey

bigint

 

MD_Major_Timestamp

 

<None>

timestamp

 


List of indexes of the table MD_Major

Name

Unique

Cluster

Primary

Foreign Key

Alternate Key

Table

MD_MAJOR_PK

TRUE

TRUE

TRUE

FALSE

FALSE

MD_Major

MD_MAJOR_AK

TRUE

FALSE

FALSE

FALSE

TRUE

MD_Major


List of keys of the table MD_Major

Name

Identifier_1

AltKey