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

SGHE Enterprise Data Warehouse EDW Source: FACULTY

Source Column Local Source Target Type Target Target Column Local Target
FACULTY_MEMBER_CATEGORY NO

DIMENSION TABLE

WDT_EMPLOYEE

FACULTY_MEMBER_CATEGORY

NO

FACULTY_MEMBER_CATEGORY_DESC NO

DIMENSION TABLE

WDT_EMPLOYEE

WDT_EMPLOYEE

FACULTY_MEMBER_CATEGORY_SD

FACULTY_MEMBER_CATEGORY_LD

NO

NO

HOME_COLLEGE NO

DIMENSION TABLE

WDT_INSTRUCTOR

HOME_COLLEGE

NO

HOME_COLLEGE_DESC NO

DIMENSION TABLE

WDT_INSTRUCTOR

WDT_INSTRUCTOR

HOME_COLLEGE_LD

HOME_COLLEGE_SD

NO

NO

HOME_DEPARTMENT NO

DIMENSION TABLE

WDT_INSTRUCTOR

HOME_DEPARTMENT

NO

HOME_DEPARTMENT_DESC NO

DIMENSION TABLE

WDT_INSTRUCTOR

WDT_INSTRUCTOR

HOME_DEPARTMENT_LD

HOME_DEPARTMENT_SD

NO

NO

PERSON_UID NO

DIMENSION TABLE

WDT_INSTRUCTOR

INSTRUCTOR_UID

NO

TENURE NO

DIMENSION TABLE

WDT_EMPLOYEE

TENURE

NO

TENURE_DESC NO

DIMENSION TABLE

WDT_EMPLOYEE

WDT_EMPLOYEE

TENURE_LD

TENURE_SD

NO

NO



Ver: 3.1