Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

CEN_STDT_ADDRESS Table

Explanation

This is a view of the TX_STDT_ADDRESS 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). This table contains address data. This data should NOT be used for mailing. (See the ADDRESS Table instead.) Contains one record for each different address stored in SRS for each student for each term for which a student has data. Each address has an Address_Type which indicates its purpose or use. There are three types of address: Billing, Local and Permanent. A student may have one (and only one) of each address type, but need not have all three. It is possible for a student to have no address record for a term.

Common Uses

 

Primary Key Indexed Data Elements Related Tables
TERM, SSN, ADDRESS TYPE CITY, STATE ADDRESS, CEN_STDT_BIO

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.
  • Unlike the ADDRESS table, this table has no "Current" address type.
  • Unlike the ADDRESS table, this table has no name element. See the CEN_STDT_BIO 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 ADDRESS 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