Penn Computing

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

V_TERM Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Academic_Year

Indexed - no
Format - Varchar2(16)
May be Null? Y

The Academic Year the term falls within. Source field: STVTERM_ACYR_CODE

Activity_Date

Indexed - no
Format - Date
May be Null? N

The last date any part of this record was updated in the source. Source field: STVTERM_ACTIVITY_DATE

Finaid_End_Period

Indexed - no
Format - Number
May be Null? Y

Financial aid award period end. Source field: STVTERM_FA_END_PERIOD

Finaid_Period

Indexed - no
Format - Number
May be Null? Y

Financial aid beginning award period. Source field: STVTERM_FA_PERIOD

Finaid_Proc_Year

Indexed - no
Format - Varchar2(4)
May be Null? Y

Financial Aid processing start and end years, for example 2019-2020 would be FINAID PROC YEAR 1920. Source field: STVTERM_FA_PROC_YR

Finaid_Summer_Ind

Indexed - no
Format - Varchar2(1)
May be Null? Y

Summer term indicator for financial aid. Source field: STVTERM_FA_SUMMER_IND

Finaid_Term

Indexed - no
Format - Varchar2(1)
May be Null? Y

Financial Aid Award Term associated with this Academic Term. Source field: STVTERM_FA_TERM

Housing_End_Date

Indexed - no
Format - Date
May be Null? Y

The last day of housing for this term. Source field: STVTERM_HOUSING_END_DATE

Housing_Start_Date

Indexed - no
Format - Date
May be Null? Y

Thr first day housing starts for this term. Source field: STVTERM_HOUSING_START_DATE

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date of the latest refresh of this warehouse table

Term_Code

Indexed - no
Format - Varchar2(6)
May be Null? N

Code for the academic Term. Source field: STVTERM_CODE

Term_Desc

Indexed - no
Format - Varchar2(30)
May be Null? Y

Text description of the term code. Source field: STVTERM_DESC

Term_End_Date

Indexed - no
Format - Date
May be Null? Y

The last day of the term. Source field: STVTERM_END_DATE

Term_Start_Date

Indexed - no
Format - Date
May be Null? Y

The first day of the term. Source field: STVTERM_START_DATE

Term_Type

Indexed - no
Format - Varchar2(2)
May be Null? Y

Code for the term type. Source field: STVTERM_TRMT_CODE

V_TERM 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