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 Definition Database Data Type Source Name Source Column
ADDRESS_NUMBER Sequence used to identify different addresses within the same address type. NUMBER

SPRADDR

SPRADDR_SEQNO

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

MGRSDAX

MGRSDAX_INTERNAL_CODE

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. VARCHAR2(255)

STVATYP

STVATYP_DESC

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

NA

NA

CARRIER_ROUTE Address carrier route. VARCHAR2(4)

SPRADDR

SPRADDR_CARRIER_ROUTE

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

SPRADDR

SPRADDR_CITY

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

SPRADDR

SPRADDR_CORRECTION_DIGIT

COUNTY County for this address. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County name for the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SPRADDR

SPRADDR_DELIVERY_POINT

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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 address formatted as a typical but including county name and formal name. VARCHAR2(695)

FUNCTION

F_FORMAT_MAILING_ADDRESS

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 address formatted as a typical but including county name and formal name. VARCHAR2(695)

FUNCTION

F_FORMAT_MAILING_ADDRESS

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 Person's current informal name for a mailing address label. VARCHAR2(255)

FUNCTION

GOKODSF.F_FORMAT_PREFERRED_NAME

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

FUNCTION

GOKODSF.F_FORMAT_PREFERRED_NAME

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

NA

NA

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

NA

NA

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

SPRADDR

SPRADDR_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(255)

STVNATN

STVNATN_NATION

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

SPBPERS

SPBPERS_PIDM

POSTAL_CODE Address postal code. VARCHAR2(63)

SPRADDR

SPRADDR_ZIP

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 or province associated with this address. VARCHAR2(63)

SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

STREET_LINE1 First line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE4



Ver: 8.5