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

SGHE Enterprise Data Warehouse EDW Source: EMPLOYEE

Source Column Local Source Target Type Target Target Column Local Target
ADMINISTRATIVE_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

NO

CURRENT_HIRE_DATE NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

CALENDAR_YEAR

CALENDAR_MONTH

NO

NO

EEO_SKILL NO

DIMENSION TABLE

WDT_EMPLOYEE

EMPLOYEE_EEO_SKILL

NO

EEO_SKILL_DESC NO

DIMENSION TABLE

WDT_EMPLOYEE

WDT_EMPLOYEE

EMPLOYEE_EEO_SKILL_LD

EMPLOYEE_EEO_SKILL_SD

NO

NO

EMPLOYEE_CLASS NO

DIMENSION TABLE

WDT_EMPLOYEE

EMPLOYEE_CLASS

NO

EMPLOYEE_CLASS_LONG_DESC NO

DIMENSION TABLE

WDT_EMPLOYEE

EMPLOYEE_CLASS_LD

NO

EMPLOYEE_CLASS_SHORT_DESC NO

DIMENSION TABLE

WDT_EMPLOYEE

EMPLOYEE_CLASS_SD

NO

EMPLOYEE_GROUPING NO

DIMENSION TABLE

WDT_EMPLOYEE

EMPLOYEE_GROUPING

NO

EMPLOYEE_GROUPING_DESC NO

DIMENSION TABLE

WDT_EMPLOYEE

WDT_EMPLOYEE

EMPLOYEE_GROUPING_LD

EMPLOYEE_GROUPING_SD

NO

NO

EMPLOYEE_STATUS NO

DIMENSION TABLE

WDT_EMPLOYEE

EMPLOYEE_STATUS

NO

EMPLOYEE_STATUS_DESC NO

DIMENSION TABLE

WDT_EMPLOYEE

WDT_EMPLOYEE

EMPLOYEE_STATUS_LD

EMPLOYEE_STATUS_SD

NO

NO

FULL_OR_PART_TIME_IND NO

DIMENSION TABLE

WDT_EMPLOYEE

WDT_EMPLOYEE

WDT_EMPLOYEE

EMPLOYEE_TIME_STATUS_LD

EMPLOYEE_TIME_STATUS

EMPLOYEE_TIME_STATUS_SD

NO

NO

NO

FUNCTION NO

DIMENSION TABLE

WDT_EMPLOYEE

WDT_HR_APPLICANT

FACULTY_STAFF_IND

CURRENT_EMPLOYEE_IND

NO

NO

HOME_ORGANIZATION NO

DIMENSION TABLE

WDT_ADMINISTRATION

HOME_ORGANIZATION

NO

HOME_ORGANIZATION_CHART NO

DIMENSION TABLE

WDT_ADMINISTRATION

HOME_ORGANIZATION_CHART

NO

HOME_ORGANIZATION_CHART_DESC NO

DIMENSION TABLE

WDT_ADMINISTRATION

WDT_ADMINISTRATION

HOME_ORGANIZATION_CHART_LD

HOME_ORGANIZATION_CHART_SD

NO

NO

HOME_ORGANIZATION_DESC NO

DIMENSION TABLE

WDT_ADMINISTRATION

WDT_ADMINISTRATION

HOME_ORGANIZATION_LD

HOME_ORGANIZATION_SD

NO

NO

MULTI_SOURCE NO

DIMENSION TABLE

WDT_MULTI_SOURCE

MULTI_SOURCE

NO

MULTI_SOURCE_DESC NO

DIMENSION TABLE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

MULTI_SOURCE_LD

MULTI_SOURCE_SD

NO

NO

PERSON_UID NO        
PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO



Ver: 3.1