| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date this record was updated in the source. Source field: SHRDGMR_ACTIVITY_DATE. |
| Ay_Bulletin Indexed - no
Format - Varchar2(4)
May be Null? Y | Year of bulletin or catalog under which degree is being offered. Source field: SHRDGMR_ACYR_CODE_BULLETIN. |
| Campus Indexed - no
Format - Varchar2(3)
May be Null? Y | Campus offering the degree. PHL = Pennsylvania campus, SFO = West Coast campus, ONL = online. Source field: SHRDGMR_CAMP_CODE. Source validation table: STVCAMP. Warehouse validation table: V_CAMPUS. |
| Campus_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the CAMPUS code. Source: STVCAMP_DESC. See also V_CAMPUS. |
| Catalog_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Catalog term code. The term that identifies the curricular catalog against which the student was audited for graduation or degree requirements. Source field: SHRDGMR_TERM_CODE_CTLG_1. |
| Compl_Degree_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Term designated as the term in which graduate work must be completed. Source field: SHRDGMR_TERM_CODE_COMPLETED. |
| Concentration Indexed - no
Format - Varchar2(4)
May be Null? Y | Concentration associated with the primary major. Source field: SHRDGMR_MAJR_CODE_CONC_1. Source validation table: STVMAJR. Warehouse validation table: V_MAJOR_MINOR |
| Concentration_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the CONCENTRATION code. Source: STVMAJR_DESC. See also V_CONCENTRATION. |
| Coord_Multi_Degr Indexed - no
Format - Varchar2(10)
May be Null? Y | Indicates student is in a coordinated multiple degree program. Values like 'Z%' or null. |
| Coord_Multi_Degr_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the code in COHORT. Source: STVCHRT_DESC. See also V_COHORT. |
| Degree_Code Indexed - yes
Format - Varchar2(6)
May be Null? Y | The code for the degree the student is being awarded. Source field: SHRDGMR_DEGC_CODE. Source validation table: STVDEGC. Warehouse validation table: V_DEGREE. |
| Degree_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the DEGREE code. Source: STVDEGC_DESC. See also V_DEGREE. |
| Degree_Level Indexed - no
Format - Varchar2(2)
May be Null? Y | The level associated with the degree, for example: Bachelor, Master, Doctorate, Professional, etc. Note that this is similar but not the same field as Student_Level. Source field: SHRDGMR_DLEV_CODE. Source validation table: STVDLEV. Warehouse validation table: V_DEG_LEVEL |
| Degree_Level_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text desciption of the DEGREE_LEVEL code. Source: STVDLEV_DESC. See also V_DEGREE_LEVEL. |
| Degree_Seq_Num Indexed - no
Format - Number
May be Null? Y | Degree sequence number, used om Banner to link degrees received to the associated majors, concentrations, and minors. Source field: SHRDGMR_SEQ_NO. |
| Degree_Status Indexed - no
Format - Varchar2(2)
May be Null? Y | The status of the student's pursual toward the degree, for example: sought, pending, awarded. Source field: SHRDGMR_DEGS_CODE. Source validation table: STVDEGS. Warehouse validation table: V_DEGREE_STATUS. |
| Degree_Status_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the DEGREE_STATUS code. Source: STVDEGS_DESC. See also V_DEGREE_STATUS. |
| Degree_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term on the general student record when the degree information is defaulted. Source field: SHRDGMR_TERM_CODE_STUREC. |
| Division Indexed - yes
Format - Varchar2(2)
May be Null? Y | The code for the Penn academic division awarding the degree. Source field: SHRDGMR_COLL_CODE_1. Source validation table: STVCOLL. Warehouse validation table: V_DIVISION. |
| Division_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the DIVISION code. Source: STVCOLL_DESC. See also V_DIVISION. |
| Dual_Joint_Sub_Ind Indexed - no
Format - Varchar2(6)
May be Null? Y | Code for the type of multiple degree program. Source field: SHRDGMR_DEGC_CODE_DUAL. Source validation table: STVDEGC. Warehouse validation table: V_DEGREE |
| Dwld_Curric_Id Indexed - yes
Format - Number
May be Null? Y | Internal number, used only in Penn's Data Warehouse. This is not stored in the source, nor should it be stored in downstream systems. Its sole purpose is to link together the student's degree term rows that all belong to the same curriculum. |
| Fee_Date Indexed - no
Format - Date
May be Null? Y | Identifies the date the graduation fee was assessed. Source field: SHRDGMR_FEE_DATE. |
| Fee_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether a graduation fee has been assessed for this degree. Source field: SHRDGMR_FEE_IND |
| Graduation_Acad_Year Indexed - no
Format - Varchar2(4)
May be Null? Y | The academic year in which the student graduated. Source field: SHRDGMR_ACYR_CODE. |
| Graduation_Appl_Date Indexed - no
Format - Date
May be Null? Y | Date of degree application. Defaults to current date on entry of degree. SOurce field: SHRDGMR_APPL_DATE. |
| Graduation_Date Indexed - no
Format - Date
May be Null? Y | Graduation date. Source field: SHRDGMR_GRAD_DATE. |
| Graduation_Status Indexed - no
Format - Varchar2(3)
May be Null? Y | Graduation status code. Source field: SHRDGMR_GRST_CODE. Source validation table: STVGRST. Warehouse validation table: V_GRADUATION_STATUS. |
| Graduation_Status_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text describing the Graduation status code. Source: STVGRST_DESC. See also V_GRADUATION_STATUS. |
| Graduation_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term in which the student graduated. Source field: SHRDGMR_TERM_CODE_GRAD. |
| Major Indexed - no
Format - Varchar2(4)
May be Null? Y | Primary major associated with the degree received. Source field: SHRDGMR_MAJR_CODE_1. Source validation table: STVMAJR. Warehouse validation table, V_MAJOR_MINOR |
| Major_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the MAJOR code. Source: STVMAJR. See also V_MAJOR. |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | Penn's identity management system's identification number. Source field: SPRIDEN_ID. |
| Pidm Indexed - yes
Format - Number
May be Null? Y | Banner internal indentification number. Source field: SHRDGMR_PIDM. |
| Program_Code Indexed - yes
Format - Varchar2(12)
May be Null? Y | The code for the program associated with the degree the student is being awarded. Source field: SHRDGMR_PROGRAM. Source validation table: SMRPRLE. Warehouse validation table: V_PROGRAM. |
| Program_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the PROGRAM code. Source table: SMRPRLE. See also V_PROGRAM. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date the record was refreshed in the warehouse |
| School Indexed - no
Format - Varchar2(1)
May be Null? Y | School associated with the division of the student's degree. Source field: STVCOLL_DICD_CODE. |
| School_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | School name. Source: GTVDICD_DESC. See also V_SCHOOL. |
| Student_Level Indexed - yes
Format - Varchar2(2)
May be Null? Y | The student level to which the degree applies, for example: Undergraduate, Graduate/Research, Dental, Law, Medical, Vet, Professional. The student level drives what content will appear on a student's transcript. Students can be in multiple levels concurently, but each concurrent program is associated with a specific student level, and each degree outcome has one level. Source field: SHRDGMR_LEVL_CODE. Source validation table: STVLEVL. Warehouse validation table: V_STDNT_LEVEL |
| Student_Level_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text desciption of the STUDENT_LEVEL code. Source: STVLEVL_DESC. See also V_STDNT_LEVEL. |
| Study_Path_Seq_Num Indexed - no
Format - Number
May be Null? Y | This field is the key sequence of the study path of the learner curriculum the outcome curriculum originted from. Source field: STUDY_PATH_SEQ_NUM. |
| St_Degree_Outcome_Pk Indexed - yes
Format - Varchar2(80)
May be Null? N | Internal warehouse primary key, based on SHRDGMR_PIDM and SHRDGMR_SEQ_NO |
