Penn Computing

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

V_TERM table

(dwngss.v_term)

Explanation

This is a validation table, containing the codes and descriptions for academic terms in Pennant. The V_TERM table also contains the start and end dates for each term.

Source

The warehouse V_TERM 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_STVTERM.

 

Primary Key Indexed Data Elements Related Tables
TERM_CODE

ST_TERM, ST_ADVISOR, ST_ATTRIBUTE, ST_COHORT, ST_ENROLLMENT, ST_ENRLMNT_ATTR, ST_ENRLMNT_LEVEL, ST_HOLD, ST_DEGREE_TERM, ST_MAJOR_MINOR, CRSE_SECTION, CRSE_SECT_INSTRUCTOR, CRSE_SECT_MEETING, CRSE_SECT_OVERRIDE, CRSE_SECT_SCHED_WITH, COURSE

Cautions and notes

V_TERM 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