Dict-Physical

View VMD_Major

Card of view VMD_Major

Name	VMD_Major
Comment	See documentation on MD_Major in StarsAcademicRecord package. Used primarily with VMF_MajorCounts.
Dimensional Type	Dimension

SQL query of the view VMD_Major

select
MD_Major_SurrogateKey,
MD_Major_Abbreviation,
MD_Major_Name,
CASE
WHEN MD_Major_CIPCode IS NULL THEN '??'
WHEN CHARINDEX('.', MD_Major_CIPCode) <= 0 THEN '??'
ELSE RIGHT('00' + SUBSTRING(MD_Major_CIPCode, 1, CHARINDEX('.', MD_Major_CIPCode) - 1), 2)
END AS MD_Major_CIP2DigitGroup,
CASE
WHEN MD_Major_CIPCode IS NULL THEN '??.??'
WHEN CHARINDEX('.', MD_Major_CIPCode) <= 0 THEN '??.??'
ELSE RIGHT('00' + SUBSTRING(MD_Major_CIPCode, 1, CHARINDEX('.', MD_Major_CIPCode) + 2), 5)
END AS MD_Major_CIP4DigitGroup,
MD_Major_CIPCode,
CASE
WHEN MD_Major_CIPCode IS NULL THEN 'Unknown'
WHEN MD_Major_CIPCode = 'Unknown' THEN 'Unknown'
WHEN ISNUMERIC(SUBSTRING(MD_Major_CIPCODE, 1, 2)) = 0 THEN 'Error'
WHEN SUBSTRING(MD_Major_CIPCODE, 1, 2) IN ('03', '11', '26', '27', '40') THEN 'Yes'
ELSE 'No'
END AS MD_Major_IsSTEM
from
MD_Major

List of incoming view references of the view VMD_Major

ViewReference_104

VMF_MajorCount

ViewReference_104

VMF_MajorCount

List of shortcuts of the view VMD_Major

VMD_Major

VMD_MAJOR

View

ViewsAcademicRecord

List of diagrams containing the view VMD_Major

ViewsAcademicRecordDiagram

ViewsStudentDiagram

List of permissions of the view VMD_Major

SELECT,VIEW DEFINITION

AcadRecordReader

SELECT,VIEW DEFINITION

AcadRecordReader

List of view columns of the view VMD_Major

MD_Major_SurrogateKey

numeric

MD_Major_Abbreviation

char(5)

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

MD_Major_Name

varchar(64)

MD_MAJOR_CIP2DIGITGROUP

MD_MAJOR_CIP4DIGITGROUP

MD_Major_CIPCode

varchar(12)

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.

MD_MAJOR_ISSTEM