V_MAJOR_MINOR column definitions . Pennant Student Records Home . Data Warehouse Home

V_MAJOR_MINOR table

(dwngss.v_major_minor)

Explanation

This is a validation table, containing the values and descriptions for the codes used for Majors and major Concentrations, and for Minors.

Source

The warehouse V_MAJOR_MINOR table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source table is SATURN_STVMAJR.

Cautions and notes

• This is a list of valid values table. For Concentrations, this table will indicate all of the valid values that can be used. See table V_CONCENTRATION for the curriculum rules associated with Concentrations, i.e., which majors a concentration can be used with.
• In the source Banner system, Majors, Minors and Concentrations are referred to as "Field of Study." A student can have multiple fields of study associated with a single degree or program. If the student is in multiple concurrent degrees or programs, each degree or program can have its own associated fields of study.
• Every curriculum (degree or program) must have at least one Major, even if that major code translates into "undecided" or "no major."
• In the Wharton School, the term "Concentration" is typicaly used instead of "Major." However, Wharton students' concentrations are stored in the Major fields in the source system, and as such, are found in the Major columns in the tables that hold major, minor, and concentration data. For example, a student with a degree of BS and major of MGMT will display on a Wharton transcript as "Bachelor of Science in Economics with a concentration in Management" -- but in the underlying data, the MGMT code is a Major code.
• Major codes rarely change, but when they do, it is useful to know what the old code was.

V_MAJOR_MINOR column definitions . Pennant Student Records Home . Data Warehouse Home