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 ADDRESSES:

Table: ADDRESSES - Address Type

Short Description: Past and Current addresses

Long Description: Contains various addresses for students and parents. Defaults to current date but does save history.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
ADDRESS_TYPE	Address Types (common) are HOME (permanent) and MAIL (local)
EFFDT	Date the data or action takes effect
EFF_STATUS	Active or inactive as of effective date
ADDRESS1	Address Line 1
ADDRESS2	Address Line 2
ADDRESS3	Address Line 3
ADDRESS4	Address Line 4
CITY	City
STATE	State
POSTAL	Postal Code
COUNTRY	Country
COUNTY	County

Criteria Notes:

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

Join to this table to pull addresses.

Addresses are routinely marked as Inactive. To pull active addresses: EFF_STATUS = A

International addresses use the 4 address lines, and DO NOT use City, St and Postal.

To pull permanent: ADDRESS_TYPE = HOME

To pull local: ADDRESS_TYPE = MAIL

You will lose students in the pull if they do not have a current active address for the type queried.

Related Tables: ADDRESSES4_VW  COUNTRY_TBL  STATE_TBL  U_CC_PDATA_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.