Penn Computing

University of Pennsylvania
Penn Computing << go backback

PRESENT_PERIOD Table - Data Element Index . Tables and Data Elements . Student Data Home . Data Warehouse Home

PRESENT PERIOD Table

(dwadmin.present_period)

Explanation

There is always only one row in the Present Period table. All data values in this table are based on the Current System Date; the table contains the Fiscal and Academic time periods associated with "today's date." This is particularly useful if you would like your queries to always use a standard time reference, such as the Current Academic Term.

Common Uses

  • Make a query condition where Term = Current Academic Term
  • Find the associated Fiscal Year for today's date.
  • Find a previous or coming time period, in relation to the current time period ("Find the Academic Term that was two terms prior to the current term.")
Primary Key Indexed Data Elements Related Tables
    COURSE_SECTION, ENROLLMENT_ALL_V

 

PRESENT_PERIOD Table - Data Element Index . Tables and Data Elements . Student Data 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