Data Dictionary Keyword Search

This Data Dictionary contains student related Access.SMU database tables commonly used in the query tool. In the keyword search below you may enter the table name, field name, or the common name for the information you are seeking.

| List All Tables

Table Information for ADDRESSES4_VW:

Table: ADDRESSES4_VW - Addresses View for Curr EffDT

Short Description: View of current active addresses

Long Description: Only shows current active addresses. There is no history, effective date or status.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
ADDRESS_TYPE	Address Types (common) are HOME (permanent) and MAIL (local)
ADDRESS1	Address Line 1
ADDRESS2	Address Line 2
ADDRESS3	Address Line 3
ADDRESS4	Address Line 4
CITY	City
COUNTRY	Country
POSTAL	Postal, or zip, Code
STATE	State

Criteria Notes:

Record U_CC_PDATA_TBL is best for pulling addresses, except it updates nightly. Use this view or ADDRESSSES to include changes made today, or when you need an address other than HOME and MAIL.

This view has no effective date, makes outer joins easier. You have to outer join to this record or risk dropping people from the query.

A student with an inactive HOME address will not have a HOME address row on this view.

Related Tables: ADDRESSES  U_CC_PDATA_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.