Reporting View Target: ADDRESS_DATES

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

SGHE Banner Operational Data Store
Reporting View Target: ADDRESS_DATES_KSU

Description Contains all active addresses for an entity/person, institution, or organization where the start date or the end date is not null.
Key & Frequency One row per entity per address type per address number per address start date and address end date where the start date or the end date is not null.
Recommended Search Columns ENTITY_UID, ADDRESS_TYPE, ADDRESS_START_DATE, ADDRESS_END_DATE

Target Column Business Definition Database Data Type Source Name Source Column

ADDRESS_END_DATE Calendar date when this address becomes inactive. DATE
SPRADDR

SPRADDR_TO_DATE

ADDRESS_NUMBER Sequence used to identify different addresses within the same address type. NUMBER
SPRADDR

SPRADDR_SEQNO

ADDRESS_START_DATE Calendar date when this address became active. DATE
SPRADDR

SPRADDR_FROM_DATE

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

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

SPRIDEN_PIDM

Ver: 8.4.1

Description	Contains all active addresses for an entity/person, institution, or organization where the start date or the end date is not null.
Key & Frequency	One row per entity per address type per address number per address start date and address end date where the start date or the end date is not null.
Recommended Search Columns	ENTITY_UID, ADDRESS_TYPE, ADDRESS_START_DATE, ADDRESS_END_DATE

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_END_DATE	Calendar date when this address becomes inactive.	DATE	SPRADDR	SPRADDR_TO_DATE
ADDRESS_NUMBER	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO
ADDRESS_START_DATE	Calendar date when this address became active.	DATE	SPRADDR	SPRADDR_FROM_DATE
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
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	SPRIDEN	SPRIDEN_PIDM