Penn Computing

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

ST_INST_HONOR 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 latest date any part of this record was updated in the source. Source field: SHRDGIH_ACTIVITY_DATE

Commence_Print_Ind

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

Y indicates that this honor will print on the commencement report. See Cautions and Notes for this table. Source field: SHRDGIH_COMMENCE_PRT_IND.

Inst_Honor_Code

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

Institutional Honor Code. Institutional honor for a student. Source field: SHRDGIH_HONR_CODE. Source validation table: STVHONR. Warehouse validation table: V_INST_ACAD_HONORS.

Penn_Id

Indexed - yes
Format - Varchar2(9)
May be Null? Y

Penn's identity management system identification number. Source field: SPRIDEN_ID.

Pidm

Indexed - yes
Format - Number
May be Null? Y

Banner internal identification number of the student. Source field: SHRDGIH_PIDM.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

The latest date the table was refreshed in the warehouse

Seq_Num

Indexed - no
Format - Number
May be Null? Y

Degree Sequence Number. Sequence number associated with the students degree. Source field: SHRDGIH_DGMR_SEQ_NO

St_Inst_Honor_Pk

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

internal warehouse primary key: based on PIDM, DGMR_SEQ_NO and HONR_CODE

Transcript_Print_Ind

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

Y indicates that this honor will print on the transcript. See Cautions and Notes for this table. Source field: SHRDGIH_TRANSC_PRT_IND.

ST_INST_HONOR 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