|<< go back|
PRESENT_PERIOD table: information related to Pennant Student Records
Contains exactly one row, identifying the current academic term, the next and previous academic terms based on the current term, and current time periods in various Penn systems.
Queries and integration scripts that need to always pull data from the current term (or a term related to the current term) should join to PRESENT_PERIOD rather than hard-coding the term into the script.
The warehouse PRESENT_PERIOD table is refreshed nightly via a job that pulls data from the BEN, HCM, and other systems as well as Banner data via the ODS.
Questions about this page? Email us at email@example.com
|Information Systems and Computing|
University of Pennsylvania