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.

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