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

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 Definition Database Data Type Source Name Source Column Local Source Local Target
ADDRESS_END_DATE Calendar date when this address becomes inactive. DATE

SPRADDR

SPRADDR_TO_DATE

NO

NO
ADDRESS_SEQ_NO Sequence used to identify different addresses within the same address type. NUMBER

SPRADDR

SPRADDR_SEQNO

NO

NO
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

NO

NO
ADDRESS_SOURCE_DESC Description of the address source. VARCHAR2(30)

STVASRC

STVASRC_DESC

NO

NO
ADDRESS_START_DATE Calendar date when this address became active. DATE

SPRADDR

SPRADDR_FROM_DATE

NO

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

SPRADDR

SPRADDR_STATUS_IND

NO

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

SPRADDR

SPRADDR_GST_TAX_ID

NO

NO
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

NO

NO
ADDRESS_TYPE_DESC Address type description. VARCHAR2(30)

STVATYP

STVATYP_DESC

NO

NO
CARRIER_ROUTE Address carrier route. VARCHAR2(4)

SPRADDR

SPRADDR_CARRIER_ROUTE

NO

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

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_CODE Address county code. VARCHAR2(5)

SPRADDR

SPRADDR_CNTY_CODE

NO

NO
COUNTY_DESC County name for the address. VARCHAR2(30)

STVCNTY

STVCNTY_DESC

NO

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

NA

SYSDATE

NO

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

SPRADDR

SPRADDR_DELIVERY_POINT

NO

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

NA

NA

NO

NO
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

NO

NO
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

NO

NO
ENRL_PLANNING_SERVICE_DESC Enrollment planning service description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

SPRADDR

SPRADDR_PIDM

NO

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

SPRADDR

SPRADDR_HOUSE_NUMBER

NO

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

STVSTAT

STVSTAT_IPEDS_CDE

NO

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

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

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

SPRADDR

SPRADDR_NATN_CODE

NO

NO
NATION_DESC Address nation/country description. VARCHAR2(30)

STVNATN

STVNATN_NATION

NO

NO
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

NO

NO
NATION_SCOD_CODE_ISO International Standards Organization (ISO) Code associated with the nation code. VARCHAR2(3)

STVNATN

STVNATN_SCOD_CODE_ISO

NO

NO
POSTAL_CODE Address postal code. VARCHAR2(30)

SPRADDR

SPRADDR_ZIP

NO

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

FUNCTION

GOKODSF.F_PREFERRED_ADDRESS_IND

NO

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

SPRADDR

SPRADDR_STAT_CODE

NO

NO
STATE_PROVINCE_DESC State/province name. VARCHAR2(30)

STVSTAT

STVSTAT_DESC

NO

NO
STREET_LINE1 First line of the address. VARCHAR2(75)

SPRADDR

SPRADDR_STREET_LINE1

NO

NO
STREET_LINE2 Second line of the address. VARCHAR2(75)

SPRADDR

SPRADDR_STREET_LINE2

NO

NO
STREET_LINE3 Third line of the address. VARCHAR2(75)

SPRADDR

SPRADDR_STREET_LINE3

NO

NO
STREET_LINE4 Fourth line of the address. VARCHAR2(75)

SPRADDR

SPRADDR_STREET_LINE4

NO

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

NA

NA

NO

NO


Ver: