PRESENT_PERIOD column definitions . Pennant Student Records Home . Data Warehouse Home

PRESENT_PERIOD table: information related to Pennant Student Records

(dwadmin.present_period)

Explanation

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.

Common uses

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.

Source

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.

PRESENT_PERIOD column definitions . Pennant Student Records Home . Data Warehouse Home