Penn Computing

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

V_DEGREE_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? N

Last date the record was entered or updated in the source. Source field: STVDEGS_ACTIVITY_DATE

Award_Status_Ind

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

indicates whether the status can be associated with a Pending degree or an Awarded degree. Source field: STVDEGS_AWARD_STATUS_IND

Curriculum_Activity_Status

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

The curriculum activity status. Source field: STVDEGS_CACT_CODE

Curriculum_Status

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

The curriculum status associated with the degree status. Source field: STVDEGS_CSTS_CODE. See also the V_CURRICULUM_STATUS table.

Degree_Status_Code

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

Code for degree level that can be associated with a degree. Source field: STVDEGS_CODE

Degree_Status_Desc

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

Text description of the Degree Level Code. Source field: STVDEGS_DESC

Next_Degree_Status

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

The next logical degree status. Source field: STVDEGS_NEXT_STATUS

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date this table in the warehouse was last refreshed.

V_DEGREE_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