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

SGHE Enterprise Data Warehouse EDW Source: ORGANIZATION_HIERARCHY

Source Column Local Source Target Type Target Target Column Local Target
ORGANIZATION_DESC_1 NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_LEVEL_1_SD

ORGANIZATION_LEVEL_1_LD

NO

NO

ORGANIZATION_DESC_2 NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_LEVEL_2_SD

ORGANIZATION_LEVEL_2_LD

NO

NO

ORGANIZATION_DESC_3 NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_LEVEL_3_LD

ORGANIZATION_LEVEL_3_SD

NO

NO

ORGANIZATION_DESC_4 NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_LEVEL_4_LD

ORGANIZATION_LEVEL_4_SD

NO

NO

ORGANIZATION_DESC_5 NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_LEVEL_5_LD

ORGANIZATION_LEVEL_5_SD

NO

NO

ORGANIZATION_DESC_6 NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_LEVEL_6_LD

ORGANIZATION_LEVEL_6_SD

NO

NO

ORGANIZATION_DESC_7 NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_LEVEL_7_LD

ORGANIZATION_LEVEL_7_SD

NO

NO

ORGANIZATION_DESC_8 NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_LEVEL_8_SD

ORGANIZATION_LEVEL_8_LD

NO

NO

ORGANIZATION_LEVEL_1 NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_LEVEL_1

NO

ORGANIZATION_LEVEL_2 NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_LEVEL_2

NO

ORGANIZATION_LEVEL_3 NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_LEVEL_3

NO

ORGANIZATION_LEVEL_4 NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_LEVEL_4

NO

ORGANIZATION_LEVEL_5 NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_LEVEL_5

NO

ORGANIZATION_LEVEL_6 NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_LEVEL_6

NO

ORGANIZATION_LEVEL_7 NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_LEVEL_7

NO

ORGANIZATION_LEVEL_8 NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_LEVEL_8

NO

ORGANIZATION_POOL NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_POOL

NO

ORGANIZATION_POOL_DESC NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_POOL_LD

ORGANIZATION_POOL_SD

NO

NO



Ver: 3.1