| 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: SHRDGDH_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: SHRDGDH_COMMENCE_PRT_IND. |
| Dept_Honor_Code Indexed - yes
Format - Varchar2(6)
May be Null? Y | Code for the Departmental honor for a student. Source field: SHRDFDH_HOND_CODE. Source validation table: STVHOLD. Warehouse validation table: V_DEG_DEPT_HONORS. |
| Dept_Honor_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the code in Dept_Honor_Code. |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number. Sourde field: SPRIDEN_ID. |
| Pidm Indexed - yes
Format - Number
May be Null? Y | Banner internal identification number. Source field: SHRDGDH_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 | Sequence number associated with students degree. Source field: SHRDGDH_DGMR_SEQ_NO. |
| St_Dept_Honor_Pk Indexed - yes
Format - Varchar2(16)
May be Null? N | internal warehouse primary key: based on PIDM, DGMR_SEQ_NO and HOND_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: SHRDGDH_TRANSC_PRT_IND. |
