Penn Computing

University of Pennsylvania
Penn Computing << go backback
ST_MAJOR_MINOR column definitions . Pennant Student Records Home . Data Warehouse Home




The student's majors and, where applicable the major concentrations, and also student's minors, if any. Majors, major concentrations, and minors are sometimes referred to as a student's "Field of Study". For traditional undergraduates, a field of study can change from term to term while they are still considered to be pursuing the same degree. For many graduate and professional students, the field of study defines their degree pursual so changing majors (i.e., changing Grad Group) is a more signficant change than it is for undergrads. See the Cautions and notes section.

A student must have at least one major associated with each curriculum record, even if that major is coded as UNDC (undecided) or NMAJ (No Major). A student can have multiple majors. A student can have one or more optional concentrations. A student can have one or more optional minors.

Majors, major concentrations, minors, and the curricula that they can be used with are all defined in rules tables in Banner. See the APPROVED_ACADEMIC_PROGRAM table for valid values.


The warehouse ST_MAJOR_MINOR table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The ODS source tables are UPENN_ODS.SATURN_SORLFOS. In the online Pennant system, the data about students' fields of study can be viewed on the SGASTDN form.

Common Uses

  • Find all students on in a specified major in a term.
  • Find all of the majors for students in a specified program.


Primary Key Indexed Data Elements Related Tables


Cautions and notes

  • There is a one-to-many relationship between ST_DEGREE_TERM and ST_MAJOR_MINOR. To facilitate reporting, the primary major only is stored in the ST_DEGREE_TERM table. This is useful if you are reporting on student curricula in a term, and you only need to see the primary major. However, if you are looking for people in a specific major, do not use the primary major in ST_DEGREE_TERM; look instead for the desired major code in ST_MAJOR_MINOR.
  • There is a one-to-many relationship between ST_TERM and ST_DEGREE_TERM and ST_MAJOR_MINOR. To facilitate reports, the primary division, primary degree, and primary major associated with that division and degree is stored in ST_TERM. If you are looking for a specific major, use ST_MAJOR_MINOR.
  • The MAJOR_MINOR_ORDER can change for any given major, from one term to the next.
  • A major code can, potentially, be used by different degrees. Do not use just the major to identify a degree pursual.
  • In Pennant Student Records, the MAJOR_MINOR_TYPE is spelled out: "MAJOR", "MINOR", or "CONCENTRATION" (not 'M' or 'N').
  • The student's level is not stored on the ST_MAJOR_MINOR table. See ST_DEGREE_TERM.
ST_HOLD column definitions . Pennant Student Records Home . Data Warehouse Home


Questions about this page? Email us at

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania