Penn Computing

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

V_ACADEMIC_STANDING Table - Data Element Index

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

Data element Definition
Academic_Standing_Code

Indexed - yes
Format - Varchar2(2)
May be Null? N

Code for the category of Academic Standing that the student is in. Source field: STVASTD_CODE

Academic_Standing_Desc

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

Text description of the Academic Standing Code. Source field: STVASTD_DESC

Activity_Date

Indexed - no
Format - Date
May be Null? Y

The latest date this record was updated in the source. Source field: STVASTD_ACTIVITY_DATE

Deans_List

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

Indicates whether the Academic Standing Code means the student will be placed on the Dean's List. Source field: STVASTD_DEANS_LIST_IND

Edi_Equiv

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

At Penn, this field is being used to identify whether the value was added manually or not. Values are: S - System, M - Manual
Source field: STVASTD_EDI_EQUIV

Max_Registration

Indexed - no
Format - Number
May be Null? Y

Indicates the maximum number of hours for which a student may register under the associated Academic Standing. Source field: STVASTD_MAX_REG_HOURS

Min_Registration

Indexed - no
Format - Number
May be Null? Y

Indicates the minimum number of hours for which a student may register under the associated Academic Standing. Source field: STVASTD_MIN_REG_HOURS

Probation_Ind

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

Identifies whether the Academic Standing Code indicates academic probation. 'Y' = academic probation. Source field: STVASTD_PROBATION_IND

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date of the latest refresh of this warehouse table

Registration_Prevented

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

Indicates whether the Academic Standing Code will prevent the student from registering for courses. 'Y' = prevent registration. Source field: STVASTD_PREVENT_REG_IND

V_ACADEMIC_STANDING 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