CEN STDT ADDRESS Table .Tables and Data Elements . Student Term Census Extract 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"ensus 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: Diploma, 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

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 "Learning From" address type.
• Unlike the ADDRESS table, this table has no "Current" address type.
• Unlike the ADDRESS table, this table has no field for the student's Name. 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 Term Census Extract Data Home . Data Warehouse Home