Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_ADDRESS

Description Source composite view contains all address information ether it is current or inactive for the person or organization entity.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADDRESS_END_DATE   Calendar date when this address becomes inactive. DATE  

SPRADDR

SPRADDR_TO_DATE

ADDRESS_SEQ_NO   Sequence used to identify different addresses within the same address type. NUMBER(2)  

SPRADDR

SPRADDR_SEQNO

ADDRESS_SOURCE   The source or means by which this address detail was received (notified by addressee, room assignment, etc.) VARCHAR2(4)  

SPRADDR

SPRADDR_ASRC_CODE

ADDRESS_SOURCE_DESC   Description of the address source. VARCHAR2(30)  

STVASRC

STVASRC_DESC

ADDRESS_START_DATE   Calendar date when this address became active. DATE  

SPRADDR

SPRADDR_FROM_DATE

ADDRESS_STATUS_IND   Indicates the address information is active or inactive. VARCHAR2(1)  

SPRADDR

SPRADDR_STATUS_IND

ADDRESS_TAX_ID   The tax identification number for the entity associated with this address. VARCHAR2(15)  

SPRADDR

SPRADDR_GST_TAX_ID

ADDRESS_TYPE   Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(2)  

SPRADDR

SPRADDR_ATYP_CODE

ADDRESS_TYPE_DESC   Address type description. VARCHAR2(30)  

STVATYP

STVATYP_DESC

CARRIER_ROUTE   Address carrier route. VARCHAR2(4)  

SPRADDR

SPRADDR_CARRIER_ROUTE

CITY City Address city, town or municipality. VARCHAR2(50)  

SPRADDR

SPRADDR_CITY

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

SPRADDR

SPRADDR_CORRECTION_DIGIT

COUNTY_CODE   Address county code. VARCHAR2(5)  

SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC   County name for the address. VARCHAR2(30)  

STVCNTY

STVCNTY_DESC

CURRENT_DATE   System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

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

SPRADDR

SPRADDR_DELIVERY_POINT

DOMAIN_VALUE   Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)  

NA

NA

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)  

STVSTAT

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(6)  

FUNCTION

F_EPSCCODE

ENRL_PLANNING_SERVICE_DESC   Enrollment planning service description. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

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

SPRADDR

SPRADDR_PIDM

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

SPRADDR

SPRADDR_HOUSE_NUMBER

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

STVSTAT

STVSTAT_IPEDS_CDE

MAILING_ADDRESS   Complete address concatenated for mailing purposes in a typical North American format. VARCHAR2(438)  

NA

NA

MAILING_ADDRESS_COUNTY   Complete address concatenated for mailing purposes using the county in place of the state/province field. VARCHAR2(438)  

NA

NA

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

NA

NA

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

NA

NA

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

SPRADDR

SPRADDR_NATN_CODE

NATION_DESC   Address nation/country description. VARCHAR2(30)  

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_SCOD_CODE_ISO   International Standards Organization (ISO) Code associated with the nation code. VARCHAR2(3)  

STVNATN

STVNATN_SCOD_CODE_ISO

POSTAL_CODE Postal Code Address postal code. VARCHAR2(30)  

SPRADDR

SPRADDR_ZIP

PREFERRED_ADDRESS_IND   Indicates whether this active address is the person or entity's preferred address. VARCHAR2(1)  

FUNCTION

GOKODSF.F_PREFERRED_ADDRESS_IND

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

SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC   State/province name. VARCHAR2(30)  

STVSTAT

STVSTAT_DESC

STREET_LINE1 Street Line 1 First line of the address. VARCHAR2(75)  

SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE2 Street Line 2 Second line of the address. VARCHAR2(75)  

SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE3 Street Line 3 Third line of the address. VARCHAR2(75)  

SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE4 Street Line 4 Fourth line of the address. VARCHAR2(75)  

SPRADDR

SPRADDR_STREET_LINE4

ZONE_VALUE   Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA



Ver: