Banner EDW Source: ADVISOR

	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
ACADEMIC_PERIOD	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_PERIOD	ADVISOR	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD	ADVISOR ADVISOR	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	ADVISOR	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD	ADVISOR ADVISOR	NO NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	ADVISOR	NO
ADVISOR_TYPE	NO	DIMENSION TABLE	WDT_ADVISOR	ADVISOR_TYPE	ADVISOR	NO
ADVISOR_TYPE_DESC	NO	DIMENSION TABLE	WDT_ADVISOR WDT_ADVISOR	ADVISOR_TYPE_LD ADVISOR_TYPE_SD	ADVISOR ADVISOR	NO NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	ADVISOR	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_SD MULTI_SOURCE_LD	ADVISOR ADVISOR	NO NO
PRIMARY_ADVISOR_IND	NO	FACT TABLE	WFT_ADVISOR	PRIMARY_ADVISOR_IND	ADVISOR	NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	ADVISOR	NO

Ver: 9.0