Reporting View Target: ADDRESS

Go To View:	RETURN TO BANNER ODS META DATA 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, ADDRESS_TYPE
ADDRESS_TYPE
ENTITY_UID, PHONE_TYPE, PHONE_SEQ_NUMBER
ENTITY_UID, PHONE_PRIMARY_IND, PHONE_SEQ_NUMBER

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

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

SPRADDR_SEQNO

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

COUNTRY_CODE Country Code Country code associated with the persons address. VARCHAR2(4)
SPRTELE

SPRTELE_CTRY_CODE_PHONE

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

EDI_EQUIVALENT 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 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 Enrl Planning Service Description Enrollment planning service description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

ENTITY_UID 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 Federal Reporting Code Government determined code for the reporting state/province codes. VARCHAR2(5)
STVSTAT

STVSTAT_IPEDS_CDE

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

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

HOUSE_NUMBER House Number House number associated with the persons address. VARCHAR2(63)
SPRADDR

SPRADDR_HOUSE_NUMBER

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

SPRIDEN_ID

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

GOKODSF.F_FORMAT_MAILING_ADDRESS

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

GOKODSF.F_FORMAT_MAILING_ADDRESS

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

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

MGKFUNC.F_GET_PERSON_INFO

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

NATION_EDI_EQUIVALENT 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 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 Phone area. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_AREA

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

SPRTELE_COMMENT

PHONE_EXT Phone Extension Phone extension. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_EXT

PHONE_INTL_ACCESS 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 Phone number. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

PHONE_NUMBER_COMBINED 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 Phone Primary Indicator Primary indicator to denote primary telephone numbers based on telephone types. VARCHAR2(1)
SPRTELE

SPRTELE_PRIMARY_IND

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

SPRTELE_SEQNO

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

SPRTELE_STATUS_IND

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

SPRTELE_TELE_CODE

PHONE_TYPE_DESC Phone Type Description Telephone number type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

PHONE_UNLIST_IND Phone Unlist Indicator Specifies if the phone number is to be unlisted. VARCHAR2(1)
SPRTELE

SPRTELE_UNLIST_IND

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 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, ADDRESS_TYPE ADDRESS_TYPE ENTITY_UID, PHONE_TYPE, PHONE_SEQ_NUMBER ENTITY_UID, PHONE_PRIMARY_IND, PHONE_SEQ_NUMBER

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_SEQ_NUMBER	Address Sequence Number	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO
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
COUNTRY_CODE	Country Code	Country code associated with the persons address.	VARCHAR2(4)	SPRTELE	SPRTELE_CTRY_CODE_PHONE
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
EDI_EQUIVALENT	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	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	Enrl Planning Service Description	Enrollment planning service description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ENTITY_UID	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	Federal Reporting Code	Government determined code for the reporting state/province codes.	VARCHAR2(5)	STVSTAT	STVSTAT_IPEDS_CDE
GEOGRAPHIC_REGION_COUNT	Geographic Region Count	Count of geographic regions associated with an address record.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS
HOUSE_NUMBER	House Number	House number associated with the persons address.	VARCHAR2(63)	SPRADDR	SPRADDR_HOUSE_NUMBER
ID	ID	Person's or organization's current identification number.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
MAILING_ADDRESS	Mailing Address	Mailing address formatted as a typical North American address.	VARCHAR2(438)	FUNCTION	GOKODSF.F_FORMAT_MAILING_ADDRESS
MAILING_ADDRESS_COUNTY	Mailing Address County	Mailing address formatted as a typical but including county name.	VARCHAR2(438)	FUNCTION	GOKODSF.F_FORMAT_MAILING_ADDRESS
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
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
NATION_EDI_EQUIVALENT	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	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	Phone area.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_AREA
PHONE_COMMENT	Phone Comment	Free form comments related to this phone number.	VARCHAR2(255)	SPRTELE	SPRTELE_COMMENT
PHONE_EXT	Phone Extension	Phone extension.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_EXT
PHONE_INTL_ACCESS	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	Phone number.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
PHONE_NUMBER_COMBINED	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	Phone Primary Indicator	Primary indicator to denote primary telephone numbers based on telephone types.	VARCHAR2(1)	SPRTELE	SPRTELE_PRIMARY_IND
PHONE_SEQ_NUMBER	Phone Sequence Number	Sequence number associated with this specific phone type for this person.	NUMBER	SPRTELE	SPRTELE_SEQNO
PHONE_STATUS_IND	Phone Status Indicator	Status that indicates active or inactive for the telephone.	VARCHAR2(1)	SPRTELE	SPRTELE_STATUS_IND
PHONE_TYPE	Phone Type	Type of telephone information such as home phone, emergency contact.	VARCHAR2(63)	SPRTELE	SPRTELE_TELE_CODE
PHONE_TYPE_DESC	Phone Type Description	Telephone number type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PHONE_UNLIST_IND	Phone Unlist Indicator	Specifies if the phone number is to be unlisted.	VARCHAR2(1)	SPRTELE	SPRTELE_UNLIST_IND
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