Penn Computing

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

STUDENT DEGREE TERM FLAT MV table

(dwngss_ps.st_degree_term_flat_mv)

Explanation

Contains one row per student per term. A student can be in multiple concurrent programs in a term, this information is flattend out between program 1, 2, 3, and 4. The primary program will show up as program 1. The subsequent program order is based on the degree order from DWNGSS_PS.ST_DEGREE_TERM.DEGREE_ORDER.

Source

The warehouse materialized view ST_DEGREE_TERM_FLAT_MV is refreshed once a day from existing warehouse tables. The source tables include DWNGSS_PS.ST_DEGREE_TERM, DWNGSS.V_TERM, DWNGSS_PS.ST_TERM, DWNGSS_PS.ST_MAJOR_MINOR, DWNGSS_PS.ST_DEGREE_OUTCOME, DWNGSS_PS.ST_ENROLLMENT.

Common Uses

  • Identify dual degree students, in a given term.
  • Find students who are in a specified program.

 

Primary Key Indexed Data Elements Related Tables

TERM
PENN_ID

ST_TERM
ST_DEGREE_TERML
ST_MAJOR_MINOR
ST_DEGREE_OUTCOME

Cautions and notes

  • Curriculum information in the source database is stored as "term-effective." In the warehouse, to facilitate reporting, curriculum information is stored term-by-term.
  • While each program has its own columns, please use caution when joining to other tables. In most cases, joining by PENN_ID and TERM will likely bring back the information needed. If you need to use DWLD_CURRIC_ID, remember that a student with mulitiple curriculums can appear with more than one DWLD_CURRIC_ID in one row within the MV. If you are making a join to a table that needs the DWLD_CURRIC_ID as part of the join, we suggest you use a join as follows a.DWLD_CURRIC_ID in (DWLD_CURRIC_ID_1, DWLD_CURRIC_ID_2, DWLD_CURRIC_ID_3, DWLD_CURRIC_ID_4). However, please be careful of how this type of join main cause duplication of output.
ST_DEGREE_TERM_FLAT_MV column definitions . Pennant Student Records 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