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_CONSTITUENT WDT_CONSTITUENT WDT_CONSTITUENT WDT_CONSTITUENT WDT_HR_APPLICANT	ACTIVE_CONSTITUENT_IND ENTITY_TYPE ENTITY_TYPE_LD ENTITY_TYPE_SD ALUMNUS_IND	ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT EMPLOYMENT APPLICATION	NO NO NO NO 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_LD PREFERRED_COLLEGE_SD	ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO

Ver: 8.1