Penn Computing

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

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

ST_DEGREE_OUTCOME 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