Penn Computing

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

ST_DEGREE_PURSUAL Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Acad_Prog_Type

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

The category of academic program that the student is pursuing.
Academic Program Types include:

  • Certificate and Non-Degree Program
  • Non-Credit Programs and Affiliated Students
  • PhD and Research Masters
  • Professional and Other degree Program
  • Traditional Undergraduate

  • Source: SORXREF_BANNER_VALUE where program code = SORXREF_EDI_VALUE and SORXREF_XLBL_CODE = 'AC_PG_TY'

    Acad_Prog_Type_Desc

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

    Description of the Acad_Prog_Type_Code. Source: SORXREF_DESC

    Activity_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The latest date the record was updated in the source. Source field: SORLCUR_ACTIVITY_DATE.

    Attempted_Credit

    Indexed - no
    Format - Number
    May be Null? Y

    Hours attempted for courses taken internally at Penn, for the specified level of the degree pursual, in native Penn currency. When the credit type = 'CU', the ATTEMPTED_CREDIT will be the same as the ATTEMPTED_CREDIT_BU.

    Attempted_Credit_BU

    Indexed - no
    Format - Number
    May be Null? Y

    Hours attempted for courses taken internally at Penn, for the specified level of the degree pursual, in Banner Units (BU). Note that ST_DEGREE_PURSUAL only shows the attempted credits that have rolled to academic history. Courses in which the student is actively enrolled in the current term, that have not yet rolled to academic history, are not included in the Attempted Credit BU in the ST_DEGREE_PURSUAL. (Note that this is different from the Term Attempted Credit BU found in the ST_DEGREE_TERM table).
    Source field: SHRLGPA-HOURS_ATTEMPTED where the gpa type in the source = 'I'

    Campus

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

    Campus code of the curriculum related to the degree being pursued. Source field: SORLCUR_CAMP_CODE. Source validation table: STVCAMP. Warehouse validation table: V_CAMPUS.

    Campus_Desc

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

    Text description of the CAMPUS code.

    Classification

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

    The student's latest classification for the level of the degree pursual. Calculated from the student's completed credits, based on classification rules. Uses function: UPENN_ODS.F_CLASS_CODE

    Classification_Desc

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

    Description of the Classification code. Source: SATURN_STVCLAS

    Concentration

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

    First concentration code attached to the primary major (at the most recent term). Source field: SORLFOS_MAJR_CODE where the LFST code is CONCEN for the row associated with the major code in the MAJOR column. For all of the students' majors and concentrations, see the table ST_MAJOR_MINOR.

    Concentration_Desc

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

    Text description of the first concentration description attached to the primary major (at the most recent term)

    Credential_Ind

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

    Indicates whether the academic program in the degree pursual leads to the awarding of a credential (a credential can be a certificate or a degree). Source: SORXREF_EDI_QLFR

    Credit_Type

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

    Calculated based on the student's school in this curriculum. Identifies the Penn course currency. All courses in Banner will be stored in Banner units, but Penn recognizes different currencies: CU (credit unit), CR (credits, used by Dental School) and SH (semester hours, used by Law School) 1 CU = 1 Banner unit 6 CR = 1 Banner unit 3 SH = 1 Banner unit

    Curric_On_Leave

    Indexed - no
    Format - Char
    May be Null? Y

    Indicates whether the student is currently on leave from the curriculum in this degree pursual. Derived from SORLCUR_LEAV_CODE for the most recent term of the degree pursual.

    Degree_Desc

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

    Text description of the DEGREE_PURSUED code. Source: STVDEGC_DESC

    Degree_Level

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

    The level associated with the degree code. Source field: STVDEGC_DLEV_CODE

    Degree_Level_Desc

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

    Text describing the value in DEGREE_LEVEL. Source field: STVDLEV_DESC

    Degree_Pursued

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

    Code for the degree being pursued. Source field: SORLCUR_DEGC_CODE. Source validation table: STVDEGC. Warehouse validation table: V_DEGREE.

    Degree_Seeking_Ind

    Indexed - no
    Format - Char
    May be Null? Y

    For degree pursuals that will result in the granting of a credential, this field indicates whether that is a Penn degree. Derived from SORXREF_EDI_QLFR and SORXREF_BANNER_VALUE.

    Dissertation_Terms

    Indexed - no
    Format - Number
    May be Null? Y

    The number of terms a student has been on dissertation, including terms in-residence and disseratation abroad. Source: Calculated from the SSGRSATT table where SGRSATT_ATTS_CODE = 'UNDS'

    Dissertation_Terms_Abroad

    Indexed - no
    Format - Number
    May be Null? Y

    The number of terms a student has been on disseration abroad.

    Dissertation_Terms_In_Res

    Indexed - no
    Format - Number
    May be Null? Y

    DO NOT USE. This column is not being calculated and the associated object has been removed from the BusObj Universe.

    Division

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

    Division code of the curriculum related to the degree being pursued. Source field: SORLCUR_COLL_CODE. Source validation table: STVCOLL. Warehouse validation table: V_DIVISION.

    Division_Desc

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

    Text description of the DIVISION code.

    Dwld_Curric_Id

    Indexed - yes
    Format - Number
    May be Null? Y

    Data Warehouse internal identifier for a unique curriculum for a student, based on Penn's business rules for the definition of "degree pursual." This field does not exist in the Banner source database, nor should it be used outside of warehouse queries. It is calculated as part of the data load, and can change, so should not ever be used as a static data point.

    Earned_Credit

    Indexed - no
    Format - Number
    May be Null? Y

    Hours earned for courses taken internally at Penn, for the specified level of the degree pursual, in native Penn currency. When the credit type = 'CU' the EARNED_CREDIT will be the same as the EARNED_CREDIT_BU.

    Earned_Credit_BU

    Indexed - no
    Format - Number
    May be Null? Y

    Hours earned for courses taken internally at Penn, for the specified level of the degree pursual, in Banner Units (BU). Source field: SHRLGPA_HOURS_EARNED where the gpa type in the source = 'I'.

    Admit Term

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

    The earliest admit term for the curriculum. Source field: SORLCUR_TERM_CODE_ADMIT

    Entry_Action

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

    The earliest admit code for the specific curriculum. Source field: SORLCUR_ADMT_CODE. Source validation table: STVADMT. Warehouse validation table: V_ADMIT_TYPE.

    Entry_Action_Desc

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

    Description of the code in Entry_Action. Source: STVADMT_DESC

    Entry_Term

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

    The earliest term for the curriculum that does not have an exit action of Cancel or Defer. Source field is SORLCUR_TERM_CODE.

    Exit_Action

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

    Any exit from the curriculum (leave, withdraw, drop, etc.) that is not a graduation. Source field: SORLCUR_LEAV_CODE. Source validation table: STVLEAV. Warehouse validation table: V_EXIT_ACTION.

    Exit_Action_Desc

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

    Description of the code in Exit_Action. Source: STVLEAV_DESC

    Exit_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The most recent date the student exited from the curriculum (excluding graduation). Source field: SORLCUR_LEAV_FROM_DATE. Can be null, for some exit actions.

    Exit_Reason

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

    Code for the reason the student exited. Exit action reason comes from a materialized view: GYVSDED, which is sourced from the Banner table GORSDAV.

    Exit_Reason_Desc

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

    Text description of the Exit Reason code. Source: STVWRSN_DESC. Warehouse validation table: V_EXIT_ACTION_REASON

    Exit_Term

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

    The most recent term the student exited from the curriculum (excluding graduation). Source: derived from SORLCUR_LEAV_FROM_DATE. Can be null, for some exit actions.

    Exit_Discovery_Date

    Indexed - no
    Date
    May be Null? Y

    This date identifies when a student's leave is discovered (not the same as when the student starts their leave.) Discovery date in the ST_DEGREE_PURSUAL table is for the most recent separation from the university. Discovery date comes from a materialized view: GYVSDED, which is sourced from the Banner table GORSDAV.

    Exp_Grad_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The latest expected graduation date for the division, degree, level, program. Source field: SORLCUR_EXP_GRAD_DATE.

    Exp_Grad_Term

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

    The term in which the student expects to graduate. Derived from the source field: SORLCUR_EXP_GRAD_DATE

    Exp_Return_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The expected return date, if the student has exited. Note: a terminal exit, such as a drop or withdraw, will have a "to" date that is the max date in the source system. Source field: SORLCUR_LEAV_TO_DATE.

    Exp_Return_Term

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

    The expected return term, if the student has exited. Source: derived from SORLCUR_LEAV_TO_DATE. Can be null, for some exit actions.

    GPA

    Indexed - no
    Format - Number
    May be Null? Y

    GPA for the level, for courses taken at Penn. Source field: SHRLGPA_GPA for gpa type 'I'

    GPA_Hours

    Indexed - no
    Format - Number
    May be Null? Y

    Hours earned that are included in the GPA calculation, for courses taken internally at Penn, for the specified level of the degree pursual, in native Penn currency. When the credit type = 'CU' the GPA_HOURS will be the same as the GPA_HOURS_BU.

    GPA_Hours_BU

    Indexed - no
    Format - Number
    May be Null? Y

    Hours earned that are included in the GPA calculation, for courses taken internally at Penn, for the specified level of the degree pursual, in Banner Units (BU). Source field: SHRLGPA_HOURS_EARNED where the gpa type in the source = 'I'.

    Graduation_Acad_Year

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

    The academic year in which the student graduated. Source field: SHRDGMR_ACYR_CODE

    Graduation_Date

    Indexed - no
    Format - Date
    May be Null? Y

    Date on which the student graduated, derived from SHRDGMR_TERM_CODE_GRAD

    Graduation_Term

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

    The term in which the student graduated. Source field: SHRDGMR_TERM_CODE_GRAD

    Last_Degree_Term

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

    The last term record for which the student had any activity in the source student curriculum table. Derived from SORLCUR_TERM_CODE.

    Last_Enrolled_Term

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

    The latest term record for the curriculum in which the student is or was enrolled in courses.

    Last_Enrolled_Term_Status

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

    The enrollment status for the student in their last_enrolled_term

    Last_Enrolled_Term_Status_Desc

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

    Text description of the Last Enrolled Term Status

    Major

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

    Primary Major code for most recent term. Source field: SORLFOS_MAJR_CODE where the LFST code is MAJOR and the record is the lowest priority number for all majors for the student in the term. For all of the students' majors, see the table ST_MAJOR_MINOR.

    Major_Desc

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

    Text description for the MAJOR code. Note: this is the student's primary major.

    Penn Classification

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

    The student attribute that identifies an undergraduate student's classification, which can be different from the system-calculated classification. Source: SGRSATT_ATTS_CODE where SGRSATT_ATTS_CODE like 'PC%'

    Penn Classification Desc

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

    Description of the code in Penn Classification.

    Penn_Id

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

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

    PhD_Curric_Count

    Indexed - no
    Format - Number
    May be Null? Y

    Count of the number of degree pursual records that a student has, where the degree pursued is a PhD.

    PhD_Masters_Curric_Id

    Indexed - no
    Format - Number
    May be Null? Y

    Internal sequence number of the research master's degree related to the PHD degree, when the PHD and research masters are in the same division and same major/grad group.

    PhD_Start_Of_Program

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

    Where applicable: the earliest admit term for the research masters program associated with a PHD program, if the masters started first. Derived from the source field: SORLUR_TERM_CODE.

    PhD_Terms

    Indexed - no
    Format - Number
    May be Null? Y

    The number of terms a student has the degree of PhD in their curriculum. This number does not include the terms they were pursuing a research masters, and it does not include Summer terms. To get that total including research masters, use the PHD_START_OF_PROGRAM to get a count of terms from that starting point to the current term.

    Pidm

    Indexed - yes
    Format - Number
    May be Null? Y

    Internal indentification number. Source field: SORLCUR_PIDM

    Program_Code

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

    Program code of the curriculum related to the degree being pursued. Source field: SORLCUR_PROGRAM. Source validation table: SMRPRLE. Warehouse validation table: V_PROGRAM.

    Program_Desc

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

    Text description of the PROGRAM code.

    Program_End_Term

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

    The term in which the student completed a certificate program, or successfully completed any other program from which there is no degree granted. Source field: SORLCUR_TERM_CODE for exit actions that indicate an end of program.

    Quality_Points

    Indexed - no
    Format - Number
    May be Null? Y

    Quality Points for courses taken internally at Penn, for the level of the degree pursual, in native Penn currency. When the credit type = 'CU' the QUALITY_POINTS will be the same as the QUALITY_POINTS_BU.

    Quality_Points_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    Quality Points for courses taken internally at Penn, for the level of the degree pursual, using Banner Units. Source field: SHRLGPA_QUALITY_POINTS where the gpa type in the source = 'I'

    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(4)
    May be Null? Y

    School code of the curriculum related to the degree being pursued. Source field: SORLCUR_DICD_CODE. Source validation table: GTVDICD. Warehouse validation table: V_SCHOOL.

    School_Desc

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

    Text description of the SCHOOL code.

    Student_Level

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

    Student's level code in this curriculum. Source field: SORLCUR_LEVL_CODE.

    Student_Level_Desc

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

    Description of the code in Student_Level. Source: STVLEVL_DESC

    St_Degree_Pursual_Pk

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

    internal warehouse primary key, based on SORLCUR_PIDM and DWLD_CURRIC_ID

    Transfer_Credit

    Indexed - no
    Format - Number
    May be Null? Y

    Hours earned for courses transferred in from an external institution, for the specified level of the degree pursual, in native Penn currency. When the credit type = 'CU', the TRANSFER_CREDIT will be the same as the TRANSFER_CREDIT_BU.

    Transfer_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    Hours earned for courses transferred in from an external institution, for the specified level of the degree pursual, in Banner Units (BU). Source field: SHRLGPA_HOURS_EARNED where the gpa type in the source = 'T'.

    ST_DEGREE_PURSUAL 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