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

SGHE Banner Operational Data Store
Reporting View Target: ORGANIZATION_ENTITY_ADDRESS

Description Contains information used to add a mailing address to a report or print a mailing label. Since the main purpose of this reporting view is to support correspondence, only persons who are not deceased will appear in this reporting view. All organizations and companies that are active will be selected for this reporting view.
Key & Frequency One row per entity per address rule..
Recommended Search Columns ENTITY_UID

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADDRESS_RULE Institution profile defined display rule determines which address displays for this person or entity.    

MGRSDAX

MGRSDAX_INTERNAL_CODE

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
CARRIER_ROUTE Address carrier route.    

SPRADDR

SPRADDR_CARRIER_ROUTE

 
CITY Address city, town or municipality.    

SPRADDR

SPRADDR_CITY

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

SPRADDR

SPRADDR_CORRECTION_DIGIT

 
COUNTY County for this address.    

SPRADDR

SPRADDR_CNTY_CODE

 
COUNTY_DESC County name for the address.    

FUNCTION

GOKODSF.F_GET_DESC

 
DELIVERY_POINT Delivery point associated with the address for barcode mailings.    

SPRADDR

SPRADDR_DELIVERY_POINT

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

SPBPERS

SPBPERS_PIDM

 
ID Organization's current identification number.    

SPRIDEN

SPRIDEN_ID

 
MAILING_ADDRESS Mailing address formatted as a typical North American address.    

FUNCTION

GOKODSF.F_FORMAT_MAILING_ADDRESS

 
MAILING_ADDRESS_COUNTY Mailing address formatted as a typical but including county name.    

FUNCTION

GOKODSF.F_FORMAT_MAILING_ADDRESS

 
MAILING_NAME_ORGANIZATION Name to be used for communication and correspondence with the entity.    

SPRIDEN

SPRIDEN_LAST_NAME

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

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
NATION Nation/country code associated with the address.    

SPRADDR

SPRADDR_NATN_CODE

 
NATION_DESC Address nation/country description.    

STVNATN

STVNATN_NATION

 
POSTAL_CODE Address postal code.    

SPRADDR

SPRADDR_ZIP

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
STATE_PROVINCE State or province associated with this address.    

SPRADDR

SPRADDR_STAT_CODE

 
STATE_PROVINCE_DESC State/province name.    

STVSTAT

STVSTAT_DESC

 
STREET_LINE1 First line of the address.    

SPRADDR

SPRADDR_STREET_LINE1

 
STREET_LINE2 Second line of the address.    

SPRADDR

SPRADDR_STREET_LINE2

 
STREET_LINE3 Third line of the address.    

SPRADDR

SPRADDR_STREET_LINE3

 
STREET_LINE4 Fourth line of the address.    

SPRADDR

SPRADDR_STREET_LINE4

 


Ver: 8.3