|
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
D a t a D i c t i o n a r y
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
This page was last updated on May 20, 2003.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|
|
