Penn Computing

University of Pennsylvania
Penn Computing << go backback

CEN STDT MAJOR MINOR Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

CEN_STDT_MAJOR_MINOR Table

Explanation

This is a view of the TX_STDT_MAJOR_MINOR table. It contains the rows for the "C" extract, which comes from the Student Term Extract tape as of the Census Date (defined as one week after the close of the drop period for the term). Majors, major concentrations, and minors. Contains one record for each student major and minor, for each term for which the student has data. Students without majors will still have a record in this table, with the major value being "UNDC." Students can have up to three majors and up to three minors per term.

Common Uses

 

Primary Key Indexed Data Elements Related Tables
TERM, SSN MAJOR, MINOR MAJOR_MINOR_TERM,
MAJOR

Cautions

  • DO NOT CONFUSE this and its related tables with CENSUS_TERM. These tables use "CEN" to refer to the Census Date, as of which reporting is done for the Federal government. CENSUS_TERM, in contrast, refers to the University Census, a periodic report of every employee of the University.
  • SSN reflects the student SSN during the particular term. If a student has had a change of SSN, older term records will be stored under the old SSN while newer term records will be stored under the new SSN.
  • The structure of this table is different from the MAJOR_MINOR table used in the nightly-loaded collection. In the census table, the student's major and minor for a given term are stored together in one row. If the student has a second major and/or second minor in that same term, that will be on a second row. If the student has a third major and/or a third minor in that same term, that will be on a third row. Use major_minor_order to determine whether the majors and minors are the student's primary (or second or third) program.

CEN STDT MAJOR MINOR Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

 


Questions about this page? Email us at da-staff@isc.upenn.edu

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