Address Object

The Address object contains student address information. This object contains zero or more records for every person who has records in the Person object of the Student Data Warehouse. These records correspond to the Banner address types, mailing, permanent, contact/emergency, etc. Address records are only created for students with a NULL Deceased Flag in the Person object. Address records are created for students regardless of their Confidentiality Flag setting in the Person object; it is up to the user to filter out students with a Confidentiality Flag.

---

Warehouse ID

Warehouse identification code. A unique identifying value for all persons in the Student Data Warehouse.

Data Type: Number

Example: 123456

Source: derived

Address Code

Code denoting the type of address record. These codes are the standard Banner address type codes. The following codes are stored in the warehouse: MA (Mailing), PR (Permanent), CO (Contact/Emergency), CS (Supplemental Contact), BL (Alternate billing), GR (Alternate grade mailing), RD (RO Diploma Address).

Data Type: 2 Characters

Example: MA

Source: spraddr_atyp_code

Notes: Addresses are selected for the given PIDM with a null spraddr_status_ind, with the most recent spraddr_from_date, and with a spraddr_to_date that is later than the time of the data selection from Banner. If no 'MA' (Mailing) records exist for a given student, then the same criteria are used for records with a spraddr_atyp_code of 'PR' (Permanent), and an MA record is created using this address. If no 'PR' (Permanent) records exist for a given student, then the same criteria are used for records with a spraddr_atyp_code of 'MA', and a PR record is created using this address.

Address Desc

Description of Address Code.

Data Type: 30 Characters

Example: Mailing

Source: stvatyp_desc

Contact Code

Code denoting the type of contact for Address Code CO or CS. Valid codes are: M (Mother), F (Father), P (Parent), U (Guardian), S (Spouse/Significant Other), O (Other). Null for all addresses except CO and CS Address Codes.

Data Type: 1 Character

Example: M

Source: SORFOLK_RELT_CODE

Contact Desc

Description of Contact Code.

Data Type: 30 Characters

Example: Mother

Source: stvrelt_desc

FML Name

Mailing addressee's complete name in the form of "First Middle Last", preferred format for correspondence or mail addresses. This name is the student's name unless the Address Code is 'CO' or 'CS', in which case this name is the name of the contact.

Data Type: 60 Characters

Example: Beth Shara Smith

Source: derived

Notes: Derived by concatenating spriden_first_name, spriden_mi and spriden_last_name for students and derived by concatenating sorfolk_parent_first, sorfolk_parent_mi and sorfolk_parent_last for contact addresses.

Street 1

First line of street address.

Data Type: 30 Characters

Example: 234 N Harrison St

Source: spraddr_street_line1

Notes: Mail address is selected for the given PIDM with a spraddr_atyp_code of 'MA' and a null spraddr_status_ind, with the most recent spraddr_from_date, and with a spraddr_to_date that is later than the time of the data selection from Banner. If no 'MA' records exist, then the same criteria are used for records with a spraddr_atyp_code of 'PR'.

Street 2

Second line of street address.

Data Type: 30 Characters

Example: c/o John Smith

Source: spraddr_street_line2

City

City of this address.

Data Type: 20 Characters

Example: Tacoma

Source: spraddr_city

State

State code or Canadian province code of this address.

Data Type: 3 Characters

Example: WA

Source: spraddr_stat_code

Nation

Nation code of this address. Null if the address is a U.S. address.

Data Type: 30 Characters

Example: ATZ

Source: spraddr_natn_code

Val Table: Nation

Zip Code

ZIP code or foreign postal code of this address, includes the dash for ZIP+4 codes.

Data Type: 10 Characters

Example: 98366

Source: spraddr_zip

CSZ

Concatenation of "City, State Code Zip Code" of this address.

Data Type: 37 Characters

Example: Tacoma, WA 98366

Source: Derived

Area Code

Area code of telephone number associated with this address.

Data Type: 3 Characters

Example: 503

Source: sprtele_phone_area

Telephone

Prefix and extension number of telephone number associated with this address.

Data Type: 8 Characters

Example: 758-0011

Source: sprtele_phone_number

Full Telephone

Complete telephone number, including area code, prefix and extension. Created by appending Area Code and Telephone.

Data Type: 14 Characters

Example: (541) 758-0011

Source: derived

MA PR Address

This will be 'Y' if the address is MA or if the address is PR and there is no MA address.

Data Type: 1 Character

g Area Code and Telephone.

Example: (541) 758-0011

Source: derived

PR MA Address

Will be 'Y' if the address is PR or if the address is MA and there is no PR address for this person

Data Type: 1 Character

e and Telephone.

Example: (541) 758-0011

Source: derived

MA PR RD Address

Will be 'Y' if the address is MA, or if the address is PR and no MA exists, or if the address is RD and no MA or PR exists

Data Type: 1 Character

le: (541) 758-0011

Source: derived

RD PR MA Address

Will be 'Y' if the address is RD, or if the address is PR and no RD exists, or if the address is MA and no RD or PR exists

Data Type: 1 Character

le: (541) 758-0011

Source: derived