Banner EDW Source: SPORT

	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	ATHLETIC	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD	ATHLETIC ATHLETIC	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	ATHLETIC	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD	ATHLETIC ATHLETIC	NO NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	ATHLETIC	NO
ATHLETIC_ACADEMIC_ELIGIBLE	NO	DIMENSION TABLE	WDT_ATHLETIC	ATHLETIC_ACADEMIC_ELIGIBLE	ATHLETIC	NO
ATHLETIC_AID_IND	NO	DIMENSION TABLE	WDT_ATHLETIC	ATHLETIC_AID_IND	ATHLETIC	NO
ELIGIBILITY	NO	DIMENSION TABLE	WDT_ATHLETIC	ATHLETIC_ELIGIBILITY	ATHLETIC	NO
ELIGIBILITY_DESC	NO	DIMENSION TABLE	WDT_ATHLETIC WDT_ATHLETIC	ATHLETIC_ELIGIBILITY_LD ATHLETIC_ELIGIBILITY_SD	ATHLETIC ATHLETIC	NO NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	ATHLETIC	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_LD MULTI_SOURCE_SD	ATHLETIC ATHLETIC	NO NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	ATHLETIC	NO
SEASONS_COMPETITION_AVAILABLE	NO	FACT TABLE	WFT_ATHLETIC	SEASONS_COMPETITION_AVAILABLE	ATHLETIC	NO
SEASONS_COMPETITION_REMAINING	NO	FACT TABLE	WFT_ATHLETIC	SEASONS_COMPETITION_REMAINING	ATHLETIC	NO
SEASONS_COMPETITION_USED	NO	FACT TABLE	WFT_ATHLETIC	SEASONS_COMPETITION_USED	ATHLETIC	NO
SPORT_STATUS	NO	DIMENSION TABLE	WDT_ATHLETIC	ATHLETIC_SPORT_STATUS	ATHLETIC	NO
SPORT_STATUS_DESC	NO	DIMENSION TABLE	WDT_ATHLETIC WDT_ATHLETIC	ATHLETIC_SPORT_STATUS_LD ATHLETIC_SPORT_STATUS_SD	ATHLETIC ATHLETIC	NO NO

Ver: 9.0