Banner EDW Source: ADDRESS

	RETURN TO BANNER EDW META DATA REPORTS LIST
	(Banner ODS Target Report)

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
CITY	NO	DIMENSION TABLE	WDT_POSTAL	CITY	PROSPECTIVE STUDENT	NO
COUNTY	NO	DIMENSION TABLE	WDT_POSTAL	COUNTY	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT	NO
COUNTY_DESC	NO	DIMENSION TABLE	WDT_POSTAL WDT_POSTAL	COUNTY_LD COUNTY_SD	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT	NO NO
NATION	NO	DIMENSION TABLE	WDT_POSTAL	NATION	ADMISSIONS RECRUITMENT	NO
NATION_DESC	NO	DIMENSION TABLE	WDT_POSTAL WDT_POSTAL	NATION_LD NATION_SD	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT	NO NO
POSTAL_CODE	NO	DIMENSION TABLE	WDT_POSTAL	POSTAL_CODE	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT	NO
STATE_PROVINCE	NO	DIMENSION TABLE	WDT_POSTAL	STATE_PROVINCE	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT	NO
STREET_LINE1	NO	DIMENSION TABLE	WDT_STREET_ADDRESS	STREET_LINE1	PROSPECTIVE STUDENT	NO
STREET_LINE2	NO	DIMENSION TABLE	WDT_STREET_ADDRESS	STREET_LINE2	PROSPECTIVE STUDENT	NO
STREET_LINE3	NO	DIMENSION TABLE	WDT_STREET_ADDRESS	STREET_LINE3	PROSPECTIVE STUDENT	NO
STREET_LINE4	NO	DIMENSION TABLE	WDT_STREET_ADDRESS	STREET_LINE4	PROSPECTIVE STUDENT	NO

Ver: 8.1