Penn Computing

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

ST_ENROLLMENT Table - Data Element Index

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

  • Operative Credits
  • Operative Credits BU
  • Part_Of_Term
  • Part_Of_Term_Desc
  • Penn_Id
  • Pidm
  • Preq_Over_Ind
  • Previous_Grade
  • Primary_Student_Level
  • Quality_Points_Bu
  • Refresh_Date
  • Registered_Credit
  • Reg_Complete_Date
  • Reg_Credit_Bu
  • Reg_Seq_Num
  • Reg_Start_Date
  • Reg_Status
  • Reg_Status_Date
  • Reg_Status_Desc
  • Reg_Status_Category
  • Reg_Status_Category_Desc
  • Repeat_Course_Ind
  • Reported_Grade
  • Schedule_Type
  • Section_Id
  • Section_Number
  • Start_Date
  • Struct_Req_Detail_Id
  • Struct_Req_Id
  • Stsp_Key_Seqno
  • Studypath_Seq
  • St_Enrollment_Pk
  • Subject_Area
  • Term
  • Time_Over_Ind
  • Waived_Credits
  • Waived_Credits_Bu
  • Data element Definition
    Acad_Hist_Ind

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

    A Y/N flag indicating whether or not the record was sourced from Academic History or the current registration record. Academic History records come from SATURN_SHRTCKN. The current registrations come from SATURN_SFTSTCR.

    Acad_Hist_Seq_Num

    Indexed - no
    Format - Number
    May be Null? Y

    Banner internal sequence number, for academic history records only.

    Activity_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The latest activity date in the source tables. Source: SFRSTCR_ACTIVITY_DATE for current registrations, SHRTCKN_ACTIVITY_DATE for academic history.

    Add_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The date in which the student's enrollment in this course section was added. Will only be available for enrollment records in terms greate than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_ADD_DATE

    Appr_Over_Ind

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

    This field identifies the special approval override of this CRN. Will only be available for enrollment records in terms greater than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_APPR_OVER

    Audit_Ind

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

    Indicates the student is auditing the course, or, for academic history, received a grade of AUD (audit) for the course. Source: SFRSTCR_RSTS_CODE for current registrations, or SHRTCKG_GRDE_CODE_FINAL for academic history.

    Billing_Credits

    Indexed - no
    Format - Number
    May be Null? Y

    The billing credit hours for the course section, stored in Penn currency/native units, as determined by credit type. For academic history registrations, this field will be null.

    Billing_Credits_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The Billing credit hours associated with this CRN, stored in Banner units. For academic history registrations, this field will be null. Source: SFRSTCR_BILL_HR

    Operative Credits

    Indexed - no
    Format - Number
    May be Null? Y

    Operative Credits stored in native Penn currency. Operative credits are only found in the warehouse - this field is derived from the source Banner data:
    operative credit = registered credits unless registered credits are 0, in which case operative credit = billed credits.
    Can be used to identify courses in which the student is registered even if they are not receiving registration credit for the course, for example, people in dissertation courses, or people auditing a course.

    Operative Credits BU

    Indexed - no
    Format - Number
    May be Null? Y

    Operative Credits stored in Banner Units (BU). Operative credits are only found in the warehouse - this field is derived from the source Banner data:
    operative credits BU = registered credit BU unless registered credits are 0, in which case operative credit BU = billed credits BU.
    Can be used to identify courses in which the student is registered even if they are not receiving registration credit for the course, for example, people in dissertation courses, or people auditing a course.

    Block_Code

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

    definition tbd.

    Source: SFRSTCR_BLCK_CODE

    Block_Id

    Indexed - no
    Format - Number
    May be Null? Y

    definition tbd.

    Source: SFRSTCR_BRDH_SEQ_NUM

    Campus_Code

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

    The campus code of the course section in this term. Source: SFRSTCR_CAMP_CODE for current registrations, SHRTCKN_CAMP_CODE for academic history.

    Capc_Over_Ind

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

    This field identifies the capacity override of this CRN. Will only be available for enrollment records in terms greater than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_CAPC_OVER

    Clas_Over_Ind

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

    This field identifies the classification restriction override of this CRN. Will only be available for enrollment records in terms greater then or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_CLAS_OVER

    Coll_Over_Ind

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

    This field identifies the division restriction override of this CRN. Will only be available for enrollment records in terms greater than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_COLL_OVER

    Contact_Hours

    Indexed - no
    Format - Number
    May be Null? Y

    The contact hours for the student in the course section. Source: SSBSECT_CONT_HR for current registrations, SHRTCKN_CONT_HR for academic history.

    Corq_Over_Ind

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

    This field identifies the co-requisite override of this CRN. Will only be available for enrollment records in terms greater than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_CORQ_OVER

    Course_Comment

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

    definition tbd.

    Source: SHRTCKN_COURSE_COMMENT

    Course_Id

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

    The subject and course number presented together in one field. No extra spaces are added in-between subject and course number.

    Course_Number

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

    Number (stored as char) associated with the Subject, that identifies the course. Source field: SSBSECT_CRSE_NUMB for current enrollments, SHRTCKN_CRSE_NUMB for academic history.

    Credit_Type

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

    Identifies the Penn currency type used in this enrollment record. Penn courses can be CU (course units), SH (semester hours) or CR (credits).

    Note that Banner uses only one type of credit, that is the equivalent of CUs.

    CRN

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

    The internal course reference number associated with the course section. Source field: SFRSTCR_CRN for current enrollments, SHRTCKN_CRN for academic history.

    Crse_Title

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

    The title of the course.

    Source: SSBSECT_CRSE_TITLE for current registrations, SHRTCKN_CRSE_TITLE for academic history.

    Dupl_Over_Ind

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

    This field identifies the duplicate course override of this CRN. Will only be available for enrollment records in terms greater than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_DUPL_OVER

    Earned_Credit

    Indexed - no
    Format - Number
    May be Null? Y

    The earned credit hours for the course section, stored in Penn currency/native units, as determined by credit type. For current registrations, this field will be null.

    Earned_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The earned credit hours associated with this CRN, stored in Banner units. For current registrations, this field will be null. Source: SHRTCKG_CREDIT_HOURS

    End_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The section end date. Course sections are assigned dates based on the part of term in which the section is offered. Note that the full term is also identified as a part of term. Sections offered for the full term will have the term's end date. Sections offered for a part of term that is not the full term will have that specific part of term's end date. Source: SSBSECT_PTRM_END_DATE

    Gpa_Hours_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    GPA Hours associated with the Course section. Use to calculate course section GPA as SUM(Quality Points)/SUM(GPA Hours).

    Gradable_ind

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

    When the course section in which the student is enrolled has been set as "gradable" this field will be 'Y' and when the course section has been set as "not gradable" this field will be 'N.' When there is no associated course section record (as is the case for most enrollments prior to Summer 2022), this field will be null. Source: SSBSECT_GRADABLE_IND

    Grade

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

    The latest official grade associated with this enrollment in this course section. Source: SHRTCKG_GRDE_CODE_FINAL

    Grade_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The date the grade was assigned to the student's enrollment in this course section. Source: SHRTCKG_FINAL_GRDE_CHG_DATE

    Grade_Mode

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

    The grade mode that applies to this student's enrollment in this course section. Course sections can be offered for multiple grade modes (see the CRSE_SECT_GRADE_MODE table). When a student registers for a course section, they are presented with the grade modes available to them and they must select one, which is then stored on their enrollment record. It is possible for a grade mode to change. ST_ENROLLMENT only contains the latest Grade Mode for the student's enrollment in this course section. Source: SFRSTCR_GMOD_CODE for current registrations, SHRTCKG_GMOD_CODE for academic history.

    Source validation table: STVGMOD. Warehouse validation table: V_GRADE_MODE

    Grade_Mode_Desc

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

    Description of the Grade Mode code. Source: STVGMOD_DESC

    Grade_Points_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    Grade points associated with the Course section. Source: SHRGRDE_QUALITY_POINTS

    Incomplete_Extension_date

    Indexed - no
    Format - Date
    May be Null? Y

    The date by which the default final grade will be applied to academic history if coursework is still incomplete. Source: SHRTCKG_INCOMPLETE_EXT_DATE

    Levl_Over_Ind

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

    This field identifies the level restriction override of this CRN. Will only be available for enrollment records in terms greater than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_LEVL_OVER

    Link_Over_Ind

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

    This field identifies the section link override of this CRN. Will only be available for enrollment records in terms greater than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_LINK_OVER

    Long_Crse_Title

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

    The long course title associated with the section. Source: SSRSYLN_CRSE_LONG_TITLE for current registrations, SHRTCKN_LONG_COURSE_TITLE for academic history.

    Majr_Over_Ind

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

    This field identifies the major restriction override of this CRN. Will only be available for enrollment records in terms greater than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_MAJR_OVER

    Num_Extensions

    Indexed - no
    Format - Number
    May be Null? Y

    definition tbd.

    Source: SSBSECT_NUMBER_OF_EXTENTIONS for current registrations, SHRTCKN_NUMBER_OF_EXTENSIONS for academic history

    Part_Of_Term

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

    The part-of-term code associated with this Course Reference Number (CRN). Source field: SFRSTCR_PTRM_CODE for current enrollments, SHRTCKN_PTRM_CODE for academic history.

    Part_Of_Term_Desc

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

    Description of the part-of-term code. Source validation table: STVPTRM.

    Penn_Id

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

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

    Pidm

    Indexed - no
    Format - Number
    May be Null? Y

    Internal Identification Number of the student. Source: SFRSTCR_PIDM for current registrations, SHRTCKN_PIDM for academic history

    Preq_Over_Ind

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

    This field identifies the prerequisite override of this CRN. Will only be available for enrollment records in terms greater than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_PREQ_OVER

    Previous_Grade

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

    Previous grade for the Course section. The last grade change prior to the Reported_Grade. Source: SHRTCKG_GRDE_CODE_FINAL

    Primary_Student_Level

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

    Primary level to which this student's enrollment in this course section in this term applies. Note that once an enrollment has moved to academic history, it can be "pointed to" more than one level; see the ST_ENRLMNT_LEVEL table. Before it moves to academic history, it can only have one level. In ST_ENROLLMENT, the Primary_Student Level is either that one level for current registrations, or the level designated as the primary level for academic history records.

    Source: SFRSTCR_LEVL_CODE for current registrations, or, for academic history: SHRTCKL_LEVL_CODE where the associated SHRTCKL_PRIMARY_LEVL_IND='Y'

    Quality_Points_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    Quality points associated with the Course section, calculated as Quality_points*Earned_credits. Can be used to calculate course section GPA as SUM(Quality Points)/SUM(GPA Hours). Source: SHRGRDE_QUALITY_POINTS

    Refresh_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The latest date this warehouse table was refreshed.

    Registered_Credit

    Indexed - no
    Format - Number
    May be Null? Y

    The credit hours for the course section, stored in Penn currency/native units, as determined by credit type.

    Reg_Complete_Date

    Indexed - no
    Format - Date
    May be Null? Y

    defintion tbd.

    Source: SSBSECT_TO_DATE for current registrations, SHRTCKN_REG_COMPLETION_DATE for academic history.

    Reg_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The registered credit hours associated with this course section, stored in Banner units. Source: SFRSTCR_CREDIT_HR for current registrations, SHRTCKG_HOURS_ATTEMPTED for academic history.

    Reg_Seq_Num

    Indexed - no
    Format - Number
    May be Null? Y

    Internal source key, used to link to other registration and academic history tables. Source field: SFRSTCR_REG_SEQ for current enrollments. SHRTCKN_REG_SEQ for academic history.

    Reg_Start_Date

    Indexed - no
    Format - Date
    May be Null? Y

    definition tbd.

    Source: SSBSECT_FROM_DATE for current registrations, SHRTCKN_REG_START_DATE for academic history.

    Reg_Status

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

    The course section registration's latest status. Note that the status can indicate that student has dropped the course. See the validation table V_REG_STATUS for values, or see the Reg_Status_Desc column. The ST_ENROLLMENT table does not contain the full history of all registration status; it has the latest status. Source: SFRSTCR_RSTS_CODE. Source validation table: STVRSTS. Warehouse validation table: V_REG_STATUS.

    Reg_Status_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The date associated with the latest course registration status. Source: SFRSTCR_RSTS_DATE

    Reg_Status_Desc

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

    The description of the Reg_Status code. Source: STVRSTS_DESC

    Reg_Status_Category

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

    A categorization of the registrations status code, this field exists only in the Data Warehouse. Based on the associated value in the status lookup table (STVRSTS_VOICE_TYPE), the registration status category has values of R, D, or W.

    Reg_Status_Category_Desc

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

    Description of Reg_Status_Category. This field exists only in the Data Warehouse. The valid values and their descriptions are: R = Registered in course, D = Dropped course, W = Withdrew from course.

    Repeat_Course_Ind

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

    Used to flag student's enrollment as repeated for inclusion or exclusion in GPA calculation. (I)-include, (E)-exclude or (A)-exclude from earned hours but average into gpa. Will appear only on records from academic history. Source SHRTCKN_REPEAT_COURSE_IND

    Reported_Grade

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

    Reported grade for the Course section. Grade assigned to the section prior to pass/fail or assigned grade if not pass/fail. Source: SHRTCKG_GRDE_CODE_FINAL

    Schedule_Type

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

    The type of schedule for the course section, for example LEC, LAB, REC, SEM, etc. Source: SSBSECT_SCHD_CODE. Source validation table: STVSCHD. Warehouse validation table: V_SCHED_TYPE.

    Section_Id

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

    The subject, course number, and section number presented together in one field. No extra spaces are added in-between subject, course number, and section number.

    Section_Number

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

    The number (stored as char) for the specific Section. Source field: SSBSECT_SEQ_NUMB for current enrollments, SHRTCKN_SEQ_NUMB for academic history.

    Start_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The section start date. Course sections are assigned dates based on the part of term in which the section is offered. Note that the full term is also identified as a part of term. Sections offered for the full term will have the term's start date. Sections offered for a part of term that is not the full term will have that specific part of term's start date. Source: SSBSECT_PTRM_START_DATE

    Struct_Req_Detail_Id

    Indexed - no
    Format - Number
    May be Null? Y

    definition tbd.

    Source: SFRSTCR_STRD_SEQNO

    Struct_Req_Id

    Indexed - no
    Format - Number
    May be Null? Y

    defintion tbd.

    Source: SFRSTCR_STRH_SEQNO

    Stsp_Key_Seqno

    Indexed - no
    Format - Number
    May be Null? Y

    definition tbd.

    Source: SHRTCKN_STSP_KEY_SEQUENCE

    Studypath_Seq

    Indexed - no
    Format - Number
    May be Null? Y

    definition tbd.

    Source: SFRSTCR_STSP_KEY_SEQUENCE for current registrations, SHRTCKN_STSP_KEY_SEQUENCE for academic history

    St_Enrollment_Pk

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

    Internal warehouse primary key: PIDM, TERM_CODE, course CRN

    Subject_Area

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

    Code for the subject area of the course section. Source validation table: STVSUBJ. Warehouse validation table: V_SUBJECT.

    Term

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

    The registration term code. The registration term code. Source field: SFRSTCR_TERM_CODE for current enrollments, SHRTCKN_TERM_CODE for academic history.

    Time_Over_Ind

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

    This field identifies the time conflict override of this CRN. Will only be available for enrollment records in terms greater than or = 202220; terms prior to that do not have registration records, only academic history records. Source: SFRSTCR_TIME_OVER

    Waived_Credits

    Indexed - no
    Format - Number
    May be Null? Y

    The waived credit hours for the course section, stored in Penn currency/native units, as determined by credit type. For academic history registrations, this field will be null.

    Waived_Credits_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The Waived credit hours associated with this course section, stored in Banner units (BU). For academic history registrations, this field will be null. Source: SFRSTCR_WAIV_HR

    ST_ENROLLMENT 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