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. |