Penn Computing

University of Pennsylvania
Penn Computing << go backback
STUDENTS Table   Tables and Data Elements   Tuition Distribution Home   Data Warehouse Home

Student Table - Data Element Index

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

Student Data

  • Dual Degree Code
  • Dual Degree Concat
  • Dual Degree Desc
  • Home School Code
  • Home School Concat
  • Home School Desc
  • Joint Degree Code
  • Joint Degree Concat
  • Joint Degree Desc
  • Student Name
  • Student PennID
  • Student's Primary Instructional Program Student's Secondary Instructional Program


    Data element

    Definition

    CER RCR Column

    Indexed - no
    Format - varchar2 (3)
    May be null? no

    A derived value, used to identify Student's Academic Divisions, for backward compatibility to the Course Enrollment and Registered Credit Reports.

    Concentration

    Indexed - no
    Format - varchar2 (3)
    May be null? yes

    The 3-character concentration code used on a student's Degree_Term record in SRS. Concentration is only stored for the Primary Instructional Program.

    See Concentration in the Student Warehouse for more information.

    Concentration Concat

    Indexed - no
    Format - varchar2 (60)
    May be null? yes

    The concatenation of the Concentration Code and the Concentration Desc

    Concentration Desc

    Indexed - no
    Format - varchar2 (50)
    May be null? yes

    The description of the Concentration Code from the SRS Data Dictionary.

    See Concentration in the Student Warehouse for more information.

    Dual Degree Code

    Indexed - no
    Format - char (1)
    May be null? no

    The 1-character code on the Student's Degree Term record indicating Dual Degree status. If a student does not have a Dual Degree status, then a "." will appear.

    See Dual Degree Type in the Student Warehouse for more information.

    Dual Degree Concat

    Indexed - no
    Format - char (6)
    May be null? no

    The Dual Degree Code concatenated to the Dual Degree description.

    Dual Degree Desc

    Indexed - no
    Format - char (4)
    May be null? no

    The description of the Dual Degree Code from the SRS Data Dictionary.

    See Dual Degree Type in the Student Warehouse for more information.

    Home School Code

    Indexed - no
    Format - varchar2 (2)
    May be null? no

    The 2-character code used by Tuition Distribution to designate the Home School of a Student.

    Home School may be different from the Primary Instructional Program School only when the Student is enrolled in a Joint Degree Program. The Joint Degree Flag will trigger a split in Home School ownership as defined by the Registrar and both Schools administering the Joint Degree Program.

    Home School Concat

    Indexed - no
    Format - varchar2 ()
    May be null? no

    The Home School Code concatenated to the Home School Description.

    Home School Desc

    Indexed - no
    Format - varchar2 (4)
    May be null? no

    The Description of the Home School Code, as stored in the SCHOOL table in the Data Warehouse.

    Joint Degree Code

    Indexed - no
    Format - char (9)
    May be null? yes

    The 1-character Joint Degree Flag as stored on the Student's Degree Term record. The Joint Degree Flag may be found in the Degree Term table in the Student Data Collection.

    There are only four (4) defined Joint Degree Programs at Penn which affect tuition distribution. These Joint Degree codes are H,I,M, and B. The percentage splits are defined in a control table administered by Student Financial Services.

    Joint Degree Concat

    Indexed - no
    Format - char (1)
    May be null? yes

    The Joint Degree Flag concatenated to the Joint Degree Description.

    Joint Degree Desc

    Indexed - yes
    Format - char (3)
    May be null? yes

    The description of the Joint Degree Code, as stored in the Joint Degree table in the Student Data Warehouse.

    Instructional Program

    Indexed - yes
    Format - varchar (13)
    May be null? yes

    The Instructional Program is the concatenation of the Student's Division, Degree, Major and Special Program Code. This combination helps to determine under which Type of Program the Student will be classified and how tuition will be calculated and distributed. Example: GASPHDANTH

    Primary Programs are identified by querying Degree Term and Major Minor Term for degree_order = 1, major_minor_order = 1, and major_minor_type = M. The Primary Program is used to bill the student and to receive the tuition distribution for the Home School.

    Secondary Programs use degree_order = 2, major_minor_order = 1, and major_minor_type = M. Secondary Programs have no bearing on Billing or Tuition Distribution.

    Instructional Program Desc

    Indexed - no
    Format - varchar (6)
    May be null? yes

    There are four (4) types of Instructional Programs.

    • Traditional Undergraduate Programs
    • Ph.D. Programs
    • Professional and Other Degree Programs
    • Study Abroad and Non-Degree Programs

    Instr Prog School

    Indexed - no
    Format - char (2)
    May be null? no

    This is the 2-character School Code loaded from the Degree_Term table.

    Inst Prog Schl Concat

    Indexed - no
    Format - char (40)
    May be null? no

    This is the School Code concatenated to the School description.

    Instr Prog School Desc

    Indexed - no
    Format - char (40)
    May be null? no

    The School description loaded from the School table.

    Instr Prog Division

    Indexed - no
    Format - char (3)
    May be null? no

    The 3-character Division code, loaded from the DEGREE_TERM table.

    See Division from the Student Data Warehouse for more information

    Instr Prog Div Concat

    Indexed - no
    Format - char (45)
    May be null? no

    The Division Code concatenated to the Division Description

    Instr Prog Division Desc

    Indexed - no
    Format - char(35)
    May be null? no

    The Division description loaded from the DIVISION table in the Warehouse.

    See Division from the Student Data Warehouse for more information

    Instr Prog Degree

    Indexed - no
    Format - char (3)
    May be null? no

    The 3-character Degree code loaded from the DEGREE_TERM table.

    See Degree in Student Data Warehouse for more information.

    Instr Prog Degree Concat

    Indexed - no
    Format - char (50)
    May be null? no

    The Degree code concatenated to the Degree Description.

    Instr Prog Degree Desc

    Indexed - no
    Format - varchar2 (50)
    May be null? no

    The Degree Description loaded from the DEGREE table in the Data Warehouse.

    See Degree in Student Data Warehouse for more information.

    Instr Prog Major

    Indexed - no
    Format - char (4)
    May be null? no

    The Major_Minor code loaded from the Major_Minor_Term table in the Data Warehouse.

    See Major in Student Data Warehouse for more information.

    Instr Prog Major Concat

    Indexed - no
    Format - varchar2 (30)
    May be null? no

    The Major code concatenated to the Major description.

    Instr Prog Major Desc

    Indexed - no
    Format - char (30)
    May be null? no

    The description of the Major_Minor code, as loaded from the MAJOR table in the Data Warehouse.

    See Major in Student Data Warehouse for more information.

    Instr Prog Special Program

    Indexed - no
    Format - char (3)
    May be null? yes

    The Special Program code loaded from the Degree_Term table in the Data Warehouse.

    See Special Program in the Student Data Warehouse for more information.

    Instr Prog SpecProg Concat

    Indexed - no
    Format - char (40)
    May be null? yes

    The Special Program code concatenated to the Special Program description.

    Instr Prog SpecProg Desc

    Indexed - no
    Format - char (40)
    May be null? yes

    The description of the Special Program Code, loaded from the Special Program table in the Data Warehouse.

    See Special Program in the Student Data Warehouse for more information.

    Taxable Status

    Indexed - no
    Format - char (20)
    May be null? no

    The description of whether an Instructional Program will have the University Tuition (Tax) applied to the collected deferred income or not. University Tuition is 20% of the collected income.

    Values: Taxable or Non-Taxable

    Student Name

    Indexed - no
    Format - char (50)
    May be null? no

    The Student's Name loaded from the Person table.

    Student PennID

    Indexed - no
    Format - char (8)
    May be null? yes

    The Student's Penn ID loaded from the Person table.

    The 8-digit identification number assigned to the employee by the Penn Community system. For example: 77777777. No two persons have the same Penn_ID. Only persons affiliated with the University will be assigned a Penn_ID.

    STUDENTS Table   Tables and Data Elements   Tuition Distribution 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