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

SGHE Enterprise Data Warehouse EDW Source: CONSTITUENT

Source Column Local Source Target Type Target Target Column Local Target
FUNCTION NO

DIMENSION TABLE

WDT_CONSTITUENT

WDT_CONSTITUENT

WDT_CONSTITUENT

WDT_HR_APPLICANT

WDT_CONSTITUENT

ENTITY_TYPE

ENTITY_TYPE_LD

ACTIVE_CONSTITUENT_IND

ALUMNUS_IND

ENTITY_TYPE_SD

NO

NO

NO

NO

NO

PERSON_UID NO        
PREF_CLASS NO

DIMENSION TABLE

WDT_CONSTITUENT

PREFERRED_CLASS_YEAR

NO

PREF_CLASS_DESC NO

DIMENSION TABLE

WDT_CONSTITUENT

WDT_CONSTITUENT

PREFERRED_CLASS_YEAR_SD

PREFERRED_CLASS_YEAR_LD

NO

NO

PREF_COLLEGE NO

DIMENSION TABLE

WDT_CONSTITUENT

PREFERRED_COLLEGE

NO

PREF_COLLEGE_DESC NO

DIMENSION TABLE

WDT_CONSTITUENT

WDT_CONSTITUENT

PREFERRED_COLLEGE_LD

PREFERRED_COLLEGE_SD

NO

NO



Ver: 3.1