Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

CEN_STDT_ENROLLMENT Table

Explanation

This is a view of the TX_STDT_ENROLLMENT 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). Credit, course section and other data about a student's enrollment in a course section. Contains one record for each enrollment in a course section for which a student was registered, for each term for which the student has data.

Grade, earned credit and other data related to the completion of an enrollment are not available from this view because the timing of the creation of the Extract Tape precludes it. Use the table for course section-taking analysis, for example, instead of for grade analysis, then.

Unlike ENROLLMENT_ALL_V, CEN_STDT_ENROLLMENT uses PROGRAM_POINTER to indicate which APS the enrollment counts towards, and CAREER_POINTERs indicate that the enrollment counts towards another APS after the fact. There is no ASSIGNMENT table to link the enrollment to a degree.

Common Uses

 

Primary Key Indexed Data Elements Related Tables
TERM, SSN,SECTION_ID   CEN_STDT_STUDENT_TERM CEN_COURSE_SECTION ENROLLMENT_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.
  • Because the Census Date occurs at a point in the term before grades are awarded, this view will not have any grades; all grade elements will be null. This supports analyses of course section enrollment histories, grade options, enrollment sequencing and the like, but not grade analyses. (See the ENROLLMENT_ALL_V Table.)
  • 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 ENROLLMENT Table . 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