Penn Computing

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

Metrics Table - Data Element Index

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

Metrics Data

  • Weighted Course Unit
  • Headcount
  • Penn ID Count
  • Applied Home $
  • Applied Teaching $
  • Applied University Tax $
  • Applied Total
  • Billed Home $
  • Billed Teaching $
  • Billed Univesity Tax $
  • Billed Total


  • Data element

    Definition

    Applied Home $

    Indexed - no
    Format - number
    May be null? no

    Applied Home $ uses Paid Applied Tuition, and is the net paid cash amount assigned to the Home School of the Student.

    Calculating Home $ is a two step process.

    1. The Weighted Course Unit is multiplied by the Tuition Export Rate for the Primary Instructional Program of this Student. (applied export rate * weighted course unit)
    2. The resulting number is then multiplied by either 20% for taxable instructional programs or 25% for non-taxable programs.

    See also Applied Tuition and Billed Export Rate in the TD_INSTR_PROGRAM_TUITION_FACT table.

    Applied Teaching $

    Indexed - no
    Format - number
    May be null? no

    Applied Teaching $ uses Paid Applied Tuition.

    Calculating Teaching $ is a two step process.

    1. The Weighted Course Unit is multiplied by the Tuition Export Rate for the Primary Instructional Program of this Student.
    2. The resulting number is then multiplied by either 60% for taxable instructional programs or 75% for non-taxable programs.

    Applied University Tax $

    Indexed - no
    Format - number
    May be null? no

    Applied University Tax $ uses Paid Applied Tuition.

    Calculating Tax $ is a two step process.

    1. The Weighted Course Unit is multiplied by the Tuition Export Rate for the Primary Instructional Program of this Student.
    2. The resulting number is then multiplied by either 20% for taxable instructional programs or 0% for non-taxable programs.

    Applied Total $

    Indexed - no
    Format - number
    May be null? no

    The Applied Total $ adds the Applied Home, Teaching, and Tax values into one result.

     

    Billed Home $

    Indexed - no
    Format - number
    May be null? no

    Billed Home $ uses Billed Tuition.

    Calculating Home $ is a two step process.

    1. The Weighted Course Unit is multiplied by the Tuition Export Rate for the Primary Instructional Program of this Student.
    2. The resulting number is then multiplied by either 20% for taxable instructional programs or 25% for non-taxable programs.

    Billed Teaching $

    Indexed - no
    Format - number
    May be null? no

    Billed Teaching $ uses Billed Tuition.

    Calculating Teaching $ is a two step process.

    1. The Weighted Course Unit is multiplied by the Tuition Export Rate for the Primary Instructional Program of this Student.
    2. The resulting number is then multiplied by either 60% for taxable instructional programs or 75% for non-taxable programs.

    Billed University Tax $

    Indexed - no
    Format - number
    May be null? no

    Billed University Tax $ uses Billed Tuition.

    Calculating Tax $ is a two step process.

    1. The Weighted Course Unit is multiplied by the Tuition Export Rate for the Primary Instructional Program of this Student.
    2. The resulting number is then multiplied by either 20% for taxable instructional programs or 0% for non-taxable programs.

    Billed Total $

    Indexed - no
    Format - number
    May be null? no

    The Billed Total $ adds the Billed Home, Teaching, and Tax values into one result.

     

    Headcount

    Indexed - no
    Format - number (5,4)
    May be null? no

    Headcount is solely used for the Course Enrollment Report. It reflects one student in one course in one term. This field should not be used to count unique students.

    Penn ID Count

    Indexed - no
    Format - number
    May be null? no

    Counts Distinct Penn ID

    Weighted Course Unit

    Indexed - no
    Format - number (7,4)
    May be null? no

    The course unit weighted for the dissertation and masters courses. After the course weight is applied, then the Joint Degree percentages, Teaching School percentages, and Instructor Load percentages are applied.

     

    Weighted Course Unit originates as the Registered Credit in the Enrollment table. The value of the Registered Credit is adjusted (weighted) by the type of credit and if the credit was a dissertation or masters course.

    Semester Hours (SH) are converted to Course Units (CU) by dividing their value by 3. Credit Hours (CR) are converted to Course Units (CU) by dividing their value by 6.

    Dissertation Credits (Activity Type DIS/DAB) are evaluated on the following scale:
    For 995 (PHD Dissertation) courses:
    Education: If Dissertation Terms Greater Than 10, then CU * 0.15
    AN,AS,DM,FA,LW,MD,SW,VM,WH: If Diss Terms Greater Than 5, then CU * 0.15
    Otherwise, CU * 0.67

    For 990 (Masters Thesis) Courses:
    CU * 0.15

    METRICS 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