Penn Computing

University of Pennsylvania
Penn Computing << go backback

CEN STDT ATHLETIC Table elements .Tables and Data Elements . Student Term Census Extract Data Home . Data Warehouse Home

CEN_STDT_ATHLETIC Table

Explanation

This is a view of the TX_STDT_ATHLETIC 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). Data showing athletic participation and eligibility. Contains one record for each team sport in which the student participated, for each term for which the student has data. It is possible for a student to have no records in this table for any term.

Common Uses

 

Primary Key Indexed Data Elements Related Tables
TERM, SSN ATHLETIC_SPORT ATHLETIC CEN_STDT_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 ATHLETIC Table elements . Tables and Data Elements . Student Term Census Extract 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