Penn Computing

University of Pennsylvania
Penn Computing << go backback

STUDENT TERM Table - Data Element Index . Tables and Data Elements . Student Records Data Home . Data Warehouse Home

STUDENT TERM Table

(dwadmin.student_term)

Explanation

Contains data about students that is independent of the degree(s) they are pursuing, such as dissertation status, honor rolls and ROTC participation. A record exists for each term a student has enrollments or is on leave.

Common Uses

  • Finding students on dissertation status for a particular term. ("Give me a list of all students working on a dissertation for the Spring of 1997.")
  • Listing honor roll and dean's list students. ("Who are the students on Dean's List for Fall 1996?")
  • Listing active students during a term, without regard to the degrees they pursued, including those on leave. ("Send this mailing to all students."
  • Counting all students at Penn without counting a student twice if that student is pursuing two degrees. ("Give me a head count of Penn students for Spring 1997.")
Primary Key Indexed Data Elements Related Tables
SSN, TERM ACADEMIC_STATUS, ACAD_PGMS_IN_RESIDENCE ATHLETIC, CEN_STDT_STUDENT_TERM, PERSON_ALL_V

Cautions

  • Term Records exist even if a student is on leave. Students who are on leave will have a "Y" in the Leave_Flag column.
  • Some values in Student Term are 'starting point' records, rather than 'term specific' records. See explanation in the Data Element Index for Honors_Program.
  • While SSN is part of the key, it is not visable to most queries and users. Use PennID for identification of individuals in this table. Joins in the Business Objects universes are done on PennID, instead of SSN.
  • Because it does not have degree information, this table does not contain the "DP_Link_ID" which identifies a student's unique degree pursual. Thus joins from this table to Degree_Pursual or Degree_Term can result in more than one row per person, unless the query specifies which degrees are desired, using the other tables.

STUDENT TERM Table - Data Element Index . Tables and Data Elements . Student Records Data 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