Penn Computing

University of Pennsylvania
Penn Computing << go backback
PRESENT_PERIOD Table . Pennant Student Records Home . Data Warehouse Home

PRESENT_PERIOD Table - Data Element Index for columns pertaining to Pennant Student Records

Current_Academic_Term

The Banner Term for the current academic term. This comes from a rules table (GENERAL.GTVSDAX) that is maintained by the Office of the University Registrar.

Penn divides the academic year into 3 terms or semesters: Fall, Spring, and Summer. Terms are designated by the 4-digit calendar year, followed by a term code. The Spring term code is 10, the Summer term code is 20, and the Fall term code is 30.

Current_Calendar_Month
 

The month (January through December) that the current system date falls within.

The Current_Calendar_Month will change on the first of each month.

Current_Calendar_Year

The calendar year that that current system date falls within. Calendar years begin on January 1st and end on December 31st.

Current_Day_of_Year The day of the calendar year that corresponds to the current system date. There are 365 days in the year, with the exception of leap years, which have 366.
Current_Fiscal_Year The fiscal year that the current system date falls within. Fiscal Years begin on July 1st and end on June 30th.
Current_System_Date Today's date. Based on Eastern Standard or Eastern Daylight Time.
Next_Academic_Term The Banner Term that follows the Current Academic Term.
Next_Next_Academic_Term The Banner Term that follows the Next Academic Term.
Previous_Academic_Term The Banner Term that preceded the Current Academic Term.
Previous_Previous_Academic_Term The Banner Term that preceded the Previous Academic Term.
Residence_Term The term used by the Residential System. Usually corresponds to the Current_Academic_Term.
Same_Acad_Term_Last_Year The term that corresponds to the Current Academic Term, in the previous year. For example, if the Current Academic Term is a Fall term, the Same Acad Term Last Year will be last year's Fall term.

 

PRESENT_PERIOD Table . 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