Penn Computing

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

V_STDNT_STATUS Table - Data Element Index

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

Data element Definition
Activity_Date

Indexed - no
Format - Date
May be Null? Y

Last date the record was entered or updated in the source.

Source: SATURN_STVSTST.STVSTST_ACTIVITY_DATE

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date this table in the warehouse was last refreshed.

Stdnt_Status_Code

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

Code for the Student Status: AS, AL, IG, IW, etc.

Source: SATURN_STVSTST.STVSTST_CODE

Stdnt_Status_Desc

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

Descriptive text title of the Student Status: Active Student, Active on Leave, Inactive Graduated, etc.

Source: SATURN_STVSTST.STVSTST_DESC

V_STDNT_STATUS 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