Reporting View Target: PERSON

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PERSON_ADDRESS

Description Contains information used to add an address to a report or print an address label using an institution defined selection hierarchy for the address types possible for the person. Since the main purpose of this reporting view is to support correspondence, only persons who are not deceased will appear in this reporting view. Persons that do not have any of the address types lised in the hierarchy will not have a record with that ADDRESS_RULE value.
Key & Frequency One row per person per address rule.
Recommended Search Columns PERSON_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ADDRESS_NUMBER Address Number Sequence used to identify different addresses within the same address type. NUMBER
SPRADDR

SPRADDR_SEQNO

ADDRESS_RULE Address Rule Institution profile defined display rule determines which address displays for this person or entity. VARCHAR2(30)
MGRSDAX

MGRSDAX_INTERNAL_CODE

ADDRESS_TYPE Address Type Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(63)
SPRADDR

SPRADDR_ATYP_CODE

ADDRESS_TYPE_DESC Address Type Description Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

CARRIER_ROUTE Carrier Route Address carrier route. VARCHAR2(4)
SPRADDR

SPRADDR_CARRIER_ROUTE

CITY City Address city, town or municipality. VARCHAR2(63)
SPRADDR

SPRADDR_CITY

CORRECTION_DIGIT Correction Digit Correction digit associated with the address for bar code mailing. NUMBER
SPRADDR

SPRADDR_CORRECTION_DIGIT

COUNTY County County for this address. VARCHAR2(63)
SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County Description County name for the address. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DELIVERY_POINT Delivery Point Delivery point associated with the address for barcode mailings. NUMBER
SPRADDR

SPRADDR_DELIVERY_POINT

ID ID Person's identification number used to access the records associated with the person. VARCHAR2(63)
SPRIDEN

SPRIDEN_ID

MAILING_FORMAL Mailing Formal Mailing address formatted as a typical North American address with formal name. VARCHAR2(695)
FUNCTION

F_FORMAT_MAILING_ADDRESS

MAILING_FORMAL_COUNTY Mailing Formal County Mailing address formatted as a typical but including county name and formal name. VARCHAR2(695)
FUNCTION

F_FORMAT_MAILING_ADDRESS

MAILING_INFORMAL Mailing Informal Mailing address formatted as a typical North American address with informal name. VARCHAR2(695)
FUNCTION

F_FORMAT_MAILING_ADDRESS

MAILING_INFORMAL_COUNTY Mailing Informal County Mailing address formatted as a typical but including county name and formal name. VARCHAR2(695)
FUNCTION

F_FORMAT_MAILING_ADDRESS

MAILING_NAME_FORMAL Mailing Name Formal Person's formal current full name for a mailing address label. VARCHAR2(255)
FUNCTION

GOKODSF.F_FORMAT_PREFERRED_NAME

MAILING_NAME_INFORMAL Mailing Name Informal Person's current informal name for a mailing address label. VARCHAR2(255)
FUNCTION

GOKODSF.F_FORMAT_PREFERRED_NAME

MAILING_NAME_PREFERRED Mailing Name Preferred Person's preferred name for a mailing address label. VARCHAR2(255)
FUNCTION

GOKODSF.F_FORMAT_PREFERRED_NAME

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NATION Nation Nation/country code associated with the address. VARCHAR2(63)
SPRADDR

SPRADDR_NATN_CODE

NATION_DESC Nation Description Address nation/country description. VARCHAR2(255)
STVNATN

STVNATN_NATION

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER
SPBPERS

SPBPERS_PIDM

POSTAL_CODE Postal Code Address postal code. VARCHAR2(63)
SPRADDR

SPRADDR_ZIP

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

STATE_PROVINCE State Province State or province associated with this address. VARCHAR2(63)
SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC State Province Description State/province name. VARCHAR2(255)
STVSTAT

STVSTAT_DESC

STREET_LINE1 Street Line 1 First line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE2 Street Line 2 Second line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE3 Street Line 3 Third line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE4 Street Line 4 Fourth line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE4

Ver: 9.0

Description	Contains information used to add an address to a report or print an address label using an institution defined selection hierarchy for the address types possible for the person. Since the main purpose of this reporting view is to support correspondence, only persons who are not deceased will appear in this reporting view. Persons that do not have any of the address types lised in the hierarchy will not have a record with that ADDRESS_RULE value.
Key & Frequency	One row per person per address rule.
Recommended Search Columns	PERSON_UID

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_NUMBER	Address Number	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO
ADDRESS_RULE	Address Rule	Institution profile defined display rule determines which address displays for this person or entity.	VARCHAR2(30)	MGRSDAX	MGRSDAX_INTERNAL_CODE
ADDRESS_TYPE	Address Type	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	SPRADDR	SPRADDR_ATYP_CODE
ADDRESS_TYPE_DESC	Address Type Description	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CARRIER_ROUTE	Carrier Route	Address carrier route.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE
CITY	City	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CORRECTION_DIGIT	Correction Digit	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT
COUNTY	County	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC	County Description	County name for the address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DELIVERY_POINT	Delivery Point	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT
ID	ID	Person's identification number used to access the records associated with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
MAILING_FORMAL	Mailing Formal	Mailing address formatted as a typical North American address with formal name.	VARCHAR2(695)	FUNCTION	F_FORMAT_MAILING_ADDRESS
MAILING_FORMAL_COUNTY	Mailing Formal County	Mailing address formatted as a typical but including county name and formal name.	VARCHAR2(695)	FUNCTION	F_FORMAT_MAILING_ADDRESS
MAILING_INFORMAL	Mailing Informal	Mailing address formatted as a typical North American address with informal name.	VARCHAR2(695)	FUNCTION	F_FORMAT_MAILING_ADDRESS
MAILING_INFORMAL_COUNTY	Mailing Informal County	Mailing address formatted as a typical but including county name and formal name.	VARCHAR2(695)	FUNCTION	F_FORMAT_MAILING_ADDRESS
MAILING_NAME_FORMAL	Mailing Name Formal	Person's formal current full name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MAILING_NAME_INFORMAL	Mailing Name Informal	Person's current informal name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MAILING_NAME_PREFERRED	Mailing Name Preferred	Person's preferred name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NATION	Nation	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_DESC	Nation Description	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SPBPERS	SPBPERS_PIDM
POSTAL_CODE	Postal Code	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
STATE_PROVINCE	State Province	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State Province Description	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STREET_LINE1	Street Line 1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE4	Street Line 4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4