Penn Computing

University of Pennsylvania
Penn Computing << go backback

CEN STDT BIO Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

CEN_STDT_BIO Table

Explanation

This is a view of the TX_STDT_BIO 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). Demographic and identifying data about the student which does not change often. Contains one record for each term for which the student has data.

Common Uses

 

Primary Key Indexed Data Elements Related Tables
TERM, SSN SRS_PREVIOUS_ID VISA SRS_ETHNICITY COUNTRY_OF_CITIZENSHIP STATE_OF_RESIDENCY FRATERNITY_SORORITY CEN_STDT_ADDRESS CEN_STDT_STUDENT_TERM PERSON_ALL_V

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 BIO Table . 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