Banner EDW Source: CONSTITUENT

	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
FUNCTION	NO	DIMENSION TABLE	WDT_HR_APPLICANT	ALUMNUS_IND	EMPLOYMENT APPLICATION	NO
PERSON_UID	NO	FACT TABLE	WFT_ADVANCEMENT_GIFT	ENTITY_UID	ADVANCEMENT GIFT	NO
PREF_CLASS	NO	DIMENSION TABLE	WDT_CONSTITUENT	PREFERRED_CLASS_YEAR	ADVANCEMENT GIFT	NO
PREF_CLASS_DESC	NO	DIMENSION TABLE	WDT_CONSTITUENT WDT_CONSTITUENT	PREFERRED_CLASS_YEAR_LD PREFERRED_CLASS_YEAR_SD	ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO
PREF_COLLEGE	NO	DIMENSION TABLE	WDT_CONSTITUENT	PREFERRED_COLLEGE	ADVANCEMENT GIFT	NO
PREF_COLLEGE_DESC	NO	DIMENSION TABLE	WDT_CONSTITUENT WDT_CONSTITUENT	PREFERRED_COLLEGE_SD PREFERRED_COLLEGE_LD	ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO

Ver: 9.0