ADDRESS Table - Data Element Index . Tables and Data Elements . Student Records Data Home . Data Warehouse Home

ADDRESS Table

(dwadmin.address)

Explanation

Provides mailing addresses for students in the PERSON_ALL_V table. Each address has an Address_Type which indicates its purpose or use.
The following addresses are available: B (Diploma address), C (Current address), L (Local address), P (Permanent address) and T (Learning From address). A student may have several addresses, though only one of each type.

The current mailing address (Address_Type = 'C') is computed from other addresses: Permanent, Local and Learning From. It contains the most appropriate address for the time of year, class of student, effective dates of addresses, etc. Use the current address to reach students except when you have a clear reason to use another address type. See the section on Address_Type in ADDRESS table data element index for more details about how current mailing address is calculated.

Common Uses

• Retrieving the best current mailing address for students by matching on PennID and selecting only those addresses where ADDRESS_TYPE is 'C'. ("Send this survey to students our our department, and I'd like it to get there quickly, rather than going to their parents first.")
• Identifying students in a particular dorm. ("This mailing is for all students in the graduate towers.")
• Selecting students by the state of their permanent address, that is, with ADDRESS_TYPE equal to 'P'. ("Who are the students from Mississippi this term?")

Cautions

• A student is not guaranteed to have an address of any particular ADDRESS_TYPE.
• The Data Warehouse does not contain a student's emergency address.
• The Data Warehouse does not contain the addresses of students' parents or guardians.
• Requests looking at more than one ADDRESS_TYPE at a time will make for difficult queries. An example is "Find students who have a local address and a permanent address with matching state." In Business Objects, this can be accomplished with a union query.
• Regardless of the values found in the Restrict flags: based on current Directory rules, all student local and permanent addresses, email addresses, and phone numbers are restricted from being released outside of the University. Student contact information may be used internally for the purposes of conducting University business only.
• While SSN is part of the key, it is not visable to most queries and users. Use PennID for identification of individuals in this table. Joins in the Business Objects universes are done on PennID, instead of SSN.

ADDRESS Table - Data Element Index . Tables and Data Elements . Student Records Data Home . Data Warehouse Home