Reporting View Target: ORGANIZATION_ENTITY

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

Banner Operational Data Store
Reporting View Target: ORGANIZATION_ENTITY_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 organization entity. All organizations and companies that are active will be selected for this reporting view unless they 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 entity per address rule.
Recommended Search Columns ENTITY_UID

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target

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

MGRSDAX_INTERNAL_CODE

NO
NO

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

NO
NO

ADDRESS_TYPE_DESC Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

NO
NO

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

NA

NO
NO

CARRIER_ROUTE Address carrier route. VARCHAR2(4)
SPRADDR

SPRADDR_CARRIER_ROUTE

NO
NO

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

SPRADDR_CITY

NO
NO

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

SPRADDR_CORRECTION_DIGIT

NO
NO

COUNTY County for this address. VARCHAR2(63)
SPRADDR

SPRADDR_CNTY_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

SPRADDR_DELIVERY_POINT

NO
NO

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

SPBPERS_PIDM

NO
NO

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

SPRIDEN_ID

NO
NO

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

GOKODSF.F_FORMAT_MAILING_ADDRESS

NO
NO

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

GOKODSF.F_FORMAT_MAILING_ADDRESS

NO
NO

MAILING_NAME_ORGANIZATION Name to be used for communication and correspondence with the entity. VARCHAR2(63)
SPRIDEN

SPRIDEN_LAST_NAME

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

SPRADDR_NATN_CODE

NO
NO

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

STVNATN_NATION

NO
NO

POSTAL_CODE Address postal code. VARCHAR2(63)
SPRADDR

SPRADDR_ZIP

NO
NO

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

NA

NO
NO

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

SPRADDR_STAT_CODE

NO
NO

STATE_PROVINCE_DESC State/province name. VARCHAR2(255)
STVSTAT

STVSTAT_DESC

NO
NO

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

SPRADDR_STREET_LINE1

NO
NO

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

SPRADDR_STREET_LINE2

NO
NO

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

SPRADDR_STREET_LINE3

NO
NO

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

SPRADDR_STREET_LINE4

NO
NO

Ver: 9.2

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 organization entity. All organizations and companies that are active will be selected for this reporting view unless they 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 entity per address rule.
Recommended Search Columns	ENTITY_UID

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDRESS_RULE	Institution profile defined display rule determines which address displays for this person or entity.	VARCHAR2(30)	MGRSDAX	MGRSDAX_INTERNAL_CODE	NO	NO
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	NO	NO
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
CITY	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
COUNTY	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
COUNTY_DESC	County name for the address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT	NO	NO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	SPBPERS	SPBPERS_PIDM	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
MAILING_ADDRESS	Mailing address formatted as a typical North American address.	VARCHAR2(503)	FUNCTION	GOKODSF.F_FORMAT_MAILING_ADDRESS	NO	NO
MAILING_ADDRESS_COUNTY	Mailing address formatted as a typical but including county name.	VARCHAR2(503)	FUNCTION	GOKODSF.F_FORMAT_MAILING_ADDRESS	NO	NO
MAILING_NAME_ORGANIZATION	Name to be used for communication and correspondence with the entity.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NATION	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO