Penn Computing

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

V_DEG_DEPT_HONORS 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

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

Commence_Print

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

Indicates whether or not the honors should appear on the Commencement report. Source field: STVHOND_COMMENCE_PRT_IND.

Custom_Id

Indexed - no
Format - Number
May be Null? Y

Dept_Honors_Code

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

Code for a departmental honors that can be put on a student's academic history record. Source field: STVHOND_CODE.

Dept_Honors_Desc

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

Text description of the departmental honors. Source field: STVHOND_DESC.

Dept_Honors_Desc_Long

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

Custom long descriptive text of the department honors code. Source: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC

Long_Desc_End_Term

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

The latest term the long description for the code is in effect. Source field: UP_ST_UP_S_BANNER_LONG_DESC.END_TERM

Long_Desc_Start_Term

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

The earliest term the long description for the code was in effect. Source field: UP_ST_UP_S_BANNER_LONG_DESC.START_TERM.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date of the latest refresh of this warehouse table

Transcript_Print

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

Indicates whether or not the honors should appear on the student's transcript. Source field: STVHOND_TRANSC_PRT_IND.

V_Deg_Dept_Honors_Pk

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

internal warehouse primary key

V_DEG_DEPT_HONORS 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