Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ADDRESS_PREFERRED

Description Contains all preferred addresses and the associated primary active telephone data for an entity/person, institution, or organization.
Key & Frequency One row per entity per address type per address sequence number.
Recommended Search Columns ENTITY_UID
ENTITY_UID, ADDRESS_TYPE

Target Column Business Definition Database Data Type Source Name Source Column
ADDRESS_SEQ_NUMBER Sequence used to identify different addresses within the same address type. NUMBER

SPRADDR

SPRADDR_SEQNO

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 Organization-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

EDI_EQUIVALENT EDI equivalent code used for electronic transfer of state or province or nation information. This might be used on transcripts for the person, vendor invoice, etc. VARCHAR2(2)

STVNATN

STVSTAT

STVNATN_EDI_EQUIV

STVSTAT_EDI_EQUIV

ENRL_PLANNING_SERVICE Enrollment planning service code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research. VARCHAR2(63)

FUNCTION

F_EPSCCODE

ENRL_PLANNING_SERVICE_DESC Enrollment planning service description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

SPRADDR

SPRIDEN

SPRADDR_PIDM

SPRIDEN_PIDM

FEDERAL_REPORTING_CODE Government determined code for the reporting state/province codes. VARCHAR2(5)

STVSTAT

STVSTAT_IPEDS_CDE

GEOGRAPHIC_REGION_COUNT Count of geographic regions associated with an address record. NUMBER

FUNCTION

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

ID Person's or organization's current identification number. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

MAILING_ADDRESS Mailing address formatted as a typical North American address. VARCHAR2(438)

FUNCTION

GOKODSF.F_FORMAT_MAILING_ADDRESS

MAILING_ADDRESS_COUNTY Mailing address formatted as a typical but including county name. VARCHAR2(438)

FUNCTION

GOKODSF.F_FORMAT_MAILING_ADDRESS

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

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NATION_EDI_EQUIVALENT EDI equivalent code used for electronic transfer of country information. This might be used on transcripts for the person, vendor invoice, etc. VARCHAR2(2)

STVNATN

STVNATN_EDI_EQUIV

NATION_ISO_CODE Three character International Standards Organization (ISO) Code associated with the nation code. VARCHAR2(3)

STVNATN

STVNATN_SCOD_CODE_ISO

PHONE_AREA Phone area. VARCHAR2(63)

SPRTELE

SPRTELE_PHONE_AREA

PHONE_COMMENT Free form comments related to this phone number. VARCHAR2(255)

SPRTELE

SPRTELE_COMMENT

PHONE_EXT Phone extension. VARCHAR2(63)

SPRTELE

SPRTELE_PHONE_EXT

PHONE_INTL_ACCESS Free form number to store the international number associated with the person's address. VARCHAR2(16)

SPRTELE

SPRTELE_INTL_ACCESS

PHONE_NUMBER Phone number. VARCHAR2(63)

SPRTELE

SPRTELE_PHONE_NUMBER

PHONE_NUMBER_COMBINED All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension. VARCHAR2(63)

CALCULATION

SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT

PHONE_PRIMARY_IND Primary indicator to denote primary telephone numbers based on telephone types. VARCHAR2(1)

SPRTELE

SPRTELE_PRIMARY_IND

PHONE_SEQ_NUMBER Sequence number associated with this specific phone type for this person. NUMBER

SPRTELE

SPRTELE_SEQNO

PHONE_STATUS_IND Status that indicates active or inactive for the telephone. VARCHAR2(1)

SPRTELE

SPRTELE_STATUS_IND

PHONE_TYPE Type of telephone information such as home phone, emergency contact. VARCHAR2(63)

SPRTELE

SPRTELE_TELE_CODE

PHONE_TYPE_DESC Telephone number type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PHONE_UNLIST_IND Specifies if the phone number is to be unlisted. VARCHAR2(1)

SPRTELE

SPRTELE_UNLIST_IND

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)

NA

NA



Ver: 8.0