Majors, Options, Degrees and Certificates

Last Updated
08/12/2022
Description

This workbook allows users to view and search for currently active majors, options, degrees and certificates.

Report URL
https://tableau.wisconsin.edu/#/views/MajorsOptionsDegreesandCertificates/MajorsOptionsandDegrees
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/47006/versions/63803
Data Domain(s)
Student Record
Access Restrictions
Publicly Available
Data Source Information
InfoAccess, SIS
Data View Information
InfoAccess.UW.ACADEMIC_PLAN, InfoAccess.UW.ACADEMIC_SUBPLAN, SIS.PS.DEGREE_TBL
Update Schedule
Daily
Responsible Office
Office of the Registrar
Important Notes

Major, Options, and Degrees tab logic:

--Source: InfoAccess.UW.ACADEMIC_PLAN, InfoAccess.UW.ACADEMIC_SUBPLAN, SIS.PS.DEGREE_TBL

--Plan Type = MAJ

--Plan Status = Active

--Exclude Plans Codes that contain with '999' or '000'

--Exclude Plans with a Program of AMAG or AMAJ (To remove additional majors)

--Exclude Plan Descriptions that begin with 'Intended'

--Exclude Subplan Types of HON and TRK

Certificate tab logic:

--Source: InfoAccess.UW.ACADEMIC_PLAN

--Plan Type of CRT or CAP

--Plan Status = Active

Other notes:

--Major’s Options and Degree tab and Certificate tab are set to the current term, based on today's date

--Data Exporter tab includes the current term and one future term

--Data is refreshed nightly

Definitions

Name Functional Definition Data Domains
Term

A period of instruction: Fall, Spring, or Summer.

University of Wisconsin - Madison
School/College of Academic Plan

Indicates the school/college that has ownership of the academic plan.

Academic Planning, Student Record
Academic Plan Department/Academic Unit

Academic Department/Academic Unit having ownership of an academic plan. This is the academic unit that provides advising to students in the academic plan, initiates changes in the requirements of the academic plan, and controls admission to the plan (when admissions are selective).

Academic Planning, Student Record
Career (Academic Structure)

A broad grouping of students related to their degree objectives and admitting office. Used for tuition charges, awarding financial aid, grading scales and other operational functions.

Academic Planning, Student Record
Plan Code (Academic)

A code representing an approved academic offering such as a major, minor, or certificate within an academic career and program.

Academic Planning, Student Record
Academic Plan

An area of study--such as a major, minor, or certificate--that is within an academic career.

Academic Planning, Student Record
Transcript Description

The official description of the academic structure entity as it appears on the student transcript.

Academic Planning
Subplan Code (Academic Structure)

A code representing an approved curricular path option within an academic plan.

Academic Planning, Student Record
Academic Subplan

An academic subplan distinguishes a strand of activity within an academic plan or type of major. Can be a named option or honors in a major.

Academic Planning, Student Record
Subplan Type (Academic Structure)

A code indicating the type of subplan, related to the degree or credential awarded to students who complete it. OPT = named option, HON = Honors, TRK = Track.

Academic Planning, Student Record
Program (Academic Structure)

A group of academic plans that share characteristics within an academic group. Academic program code controls administrative functions such as min credits, max credits, tuition rates, academic standing, grading schemes, full-time/part-time standing, financial aid primacy number.

Academic Planning, Student Record
Academic Plan Group

A code assigned by UW-Madison for a major. The major may be offered across multiple degree levels and/or by multiple school or colleges.

Academic Planning, Student Record
Degree Code

A code corresponding to the name of the credential that is awarded upon completion of the plan. See DEGREE_TBL for list of values and descriptions.

Academic Planning
Academic Award Category

Indicates the level and type of award granted to a student who graduates in a given plan code. For example, Bachelor's, Master's, Research Doctorate, Clinical Doctorate, Undergraduate Certificate, Capstone Certificate.

Academic Planning, Student Record
Distance Education Program

An indicator of whether the plan or any of its subplans is approved for distance delivery as defined by the Higher Learning Commission where 50% or more of the required courses may be taken as distance-delivered courses where the vast majority of instruction and interaction occurs via electronic communication where instructors and students are physically separated from each other.

Academic Planning
Special Option Type

An indicator of whether the tuition paid by students in the plan flows to the general tuition pool (pooled tuition) or to the academic entity that owns the plan (non-pooled tuition).

Academic Planning
Educational Innovation Program

An indicator, assigned between 2011 and 2017, of whether the plan or any of its subplans is considered to meet the goals of Educational Innovation initiative.

Academic Planning
Non-Traditional Program

Program designed to meet the needs of non-traditional student audiences; has an applied, practice-oriented curriculum that is self-contained with a clear pathway with few electives or options; is offered in a modality that allows non-traditional audiences to attend (evening, weekend, distance, intensive, or some combination thereof); has a market demand and learning goals that are oriented to market considerations.

Academic Planning
STEM Flag

Plan codes that are institutionally defined as STEM (Science, Technology, Engineering, Math) for analytic purposes based on the plan's CIP code. The STEM assignment is made when the curriculum is focused on math, statistics, physical science, biological science, natural science, technology, and/or engineering principles. In almost all cases, the CIP code associated with plans will be in the following areas: 01, 03, 11, 14, 15, 26, 27, and 40.

Academic Planning
STEM-Opt Flag

Plan codes that meet the US Department of Homeland Security criteria of STEM for the purposes of the Optional Practical Training Program.

Academic Planning
Health Flag

Indicates whether the plan is institutionally defined as a Health program for analytic purposes in that its focus is on preparing students for work or research in health-related fields.

Academic Planning
Graduate School Flag (Plan)

An indicator used for analytic and operational purposes showing whether the Graduate School has governance responsibility for the plan.

Academic Planning
Graduate Research Scholar (GRS) Group

A code assigned by The Graduate School to plans (type MAJ) under its purview to indicate with which Graduate Research Scholars group the plan is associated. The Graduate Research Scholar (GRS) communities augment the standard curriculum with academic, social and professional development programming.

Academic Planning
Non-Admit Flag

An indicator of master's degree plans (MA or MS only) that do not directly admit students and are used for awarding of masters degrees to students admitted to research doctorate plans who complete significant requirements but will not complete the intended doctorate requirements.

Academic Planning
Minor Required Flag

An indicator that a PhD granting plan requires a minor.

Academic Planning
Disciplinary Division

The four divisions established on the basis of related subjects of teaching and research and are independent of colleges, schools, and departments, and include: Biological Sciences, Arts and Humanities, Physical Sciences, and Social Sciences.

Academic Planning, Employee Record
Plan Enrollment Category

An easily sortable numeric indicator of the level, career, and program of enrollment for students enrolled in the plan code useful for analytic and reporting purposes. Values are:
100 – Undergraduate
300 – Master’s
310 – Master’s of Public Health
320 – Master’s of Physician Assistant Studies
350 – Specialist
400 – Research Doctorate
510 – Law
520 – Medicine
530 – Pharmacy
540 – Veterinary Medicine
550 – Other Clinical Doctorate
600 – Undergraduate certificate
700 – Certificate for Non-Degree-seeking students
710 – Other Special Student (Non-certificate)
800 – Capstone Certificate
900 – Graduate Certificate

Academic Planning, Student Record