Penn Computing

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

Course Table - Data Element Index

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

Course Section Data

  • Section ID
  • Subject Area
  • Subject Area Concat
  • Subject Area Desc
  • Course Number
  • Section Number
  • Activity Type
  • Section School
  • Section School Concat
  • Section School Desc
  • Section Division
  • Section Division Concat
  • Section Division Desc
  • Section Department
  • Course_Admin_Code
  • Course_Admin_Desc
  • Xlist
  • Xlist Primary
  • Section Title
  • Session Code
  • Session Desc
  • Teaching School Data


    Data element

    Definition

    Activity Type

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

    The 3-character Activity code used in the COURSE_SECTION record in SRS.

    Course Number

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

    The 3-digit Course Number on the COURSE_SECTION record.

    Section Department

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

    The 4-character SRS Department on the COURSE_SECTION record.

    Section Division

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

    The 3-character Division code, denoting the administrative division offering the course. Note the difference from Teaching School Section Division

    Section Division Concat

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

    The Section Division code concatenated with the Division description

    Section Division Desc

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

    The description of the Section Division, loaded from the Division table.

    Section ID

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

    The Section ID is composed of Subject Area-Course Number-Section Number. This data loaded from Course_Section.

    Section Number

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

    The 3-digit Section Number of the Section ID.

    Section School

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

    The 2-character Section School from the COURSE_SECTION table

    Section School Concat

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

    The Section School code concatenated with the description.

    Section School Desc

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

    The description of the Section School.

    Section Title

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

    The Title of the Course Section, loaded from the COURSE_SECTION table.

    Session Code

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

    A Session Code which differentiates between the NULL value in SRS Fall/Spring sessions and the NULL value in Summer.

    Values:

    • 1=First Session
    • 2=Second Session
    • .=Summer 12-week
    • F=Regular Semester

    Session Desc

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

    The description of the Session Code.

    Subject Area

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

    The 4-character Subject Area of the Course.

    Subject Area Concat

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

    The Subject Area concatenated with the Subject Area Description.

    Subject Area Desc

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

    The description of Subject Area loaded from Subject_AREA in the Data Warehouse.

    Teaching School Code

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

    The 2-character Teaching School values are loaded from the COURSE_SECTION_TUIT_SCHOOL table, which in turn is loaded from the SRS Screen 132. There are a maximum of 13 distinct Teaching Schools, including PV for Provost courses.

    Teaching School Concat

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

    The Teaching School code concatenated with the description.

    Teaching School Desc

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

    The Teaching School description loaded from the SCHOOL table.

    Teaching School Section Division

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

    The Teaching School Section Division is only populated when the Section Division of a course contains either CGS and SS. This ensures that the Tuition Distribution process routes the income directly to those two financial centers.

    Teaching School Division Concat

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

    The Teaching School Section Division code concatenated with the description.

    Teaching Schl Section Division Desc

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

    The Teaching School Division description, loaded from Division table .

    Xlist

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

    The Xlist Flag denotes crosslisting.

    Values:

    • NULL = No crosslisting
    • P = Primary crosslisting
    • S = Secondary crosslisting

    Xlist Primary

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

    The Primary Crosslisted Section ID for this course section. If there is no crosslisting, then the Xlist Primary will be the same value as Section ID

    Course_Admin_Code

    This code is loaded from the EAS Credit Factor code field in SRS Course Inventory when the data value doesn’t start with 0.  The field is used to identify administrative sub-units within a school that have budgetary and academic responsibility for courses. This is most notably used in Schools which in all courses are one subject area, (i.e. NURS, EDUC).  School of Arts and Sciences is using the field to identify groups of courses. 

    The data for this field is entered on Screen 125.  Schools may request codes from the registrar, using the convention of the first digit representing their budget range, ie. SAS is using the 2s, Nursing uses 6s.  Using letters and numbers for the second position, a school can identify up to 36 administrative divisions.

    Course_Admin_Desc The descriptive name associated with the Course Admin Code.
    COURSES 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