Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

CEN_STDT_STUDENT_TERM Table

(dwadmin.cen_stdt_student_term view)

Explanation

This is a view of the TX_STDT_TERM table. It contains the rows for the "C" extract, which comes from the Student Term Extract tape as of the Census Date (defined as one week after the close of the drop period for the term). Summary data about a student's progress towards earning a degree and participation in certain programs. Contains one record for each term for which the student has data. Since the Census Date is prior to the completion of coursework for the term, those data elements which reflect work completed in the course section are necessarily null.

Common Uses

 

Primary Key Indexed Data Elements Related Tables
TERM, SSN ACADEMIC_STATUS ACAD_PGMS_IN_RESIDENCE CEN_STDT_ATHLETIC CEN_STDT_BIO CEN_STDT_ACADEMIC_PROGRAM CEN_STDT_ENROLLMENT STUDENT_TERM

Cautions

  • DO NOT CONFUSE this and its related tables with CENSUS_TERM. These tables use "CEN" to refer to the Census Date, as of which reporting is done for the Federal government. CENSUS_TERM, in contrast, refers to the University Census, a periodic report of every employee of the University.
  • SSN reflects the student SSN during the particular term. If a student has had a change of SSN, older term records will be stored under the old SSN while newer term records will be stored under the new SSN.
CEN STDT STUDENT TERM Table - Data Element Index . Tables and Data Elements . Student 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