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

SGHE Enterprise Data Warehouse EDW Source: PROGRAM_HIERARCHY

Source Column Local Source Target Type Target Target Column Local Target
B_PROGRAM_DESC NO

DIMENSION TABLE

WDT_PROGRAM

PROGRAM_SD

NO

PROGRAM_DESC_1 NO

DIMENSION TABLE

WDT_PROGRAM

WDT_PROGRAM

PROGRAM_LEVEL_1_LD

PROGRAM_LEVEL_1_SD

NO

NO

PROGRAM_DESC_2 NO

DIMENSION TABLE

WDT_PROGRAM

WDT_PROGRAM

PROGRAM_LEVEL_2_SD

PROGRAM_LEVEL_2_LD

NO

NO

PROGRAM_DESC_3 NO

DIMENSION TABLE

WDT_PROGRAM

WDT_PROGRAM

PROGRAM_LEVEL_3_LD

PROGRAM_LEVEL_3_SD

NO

NO

PROGRAM_DESC_4 NO

DIMENSION TABLE

WDT_PROGRAM

WDT_PROGRAM

PROGRAM_LEVEL_4_LD

PROGRAM_LEVEL_4_SD

NO

NO

PROGRAM_DESC_5 NO

DIMENSION TABLE

WDT_PROGRAM

WDT_PROGRAM

PROGRAM_LEVEL_5_LD

PROGRAM_LEVEL_5_SD

NO

NO

PROGRAM_LEVEL_1 NO

DIMENSION TABLE

WDT_PROGRAM

PROGRAM_LEVEL_1

NO

PROGRAM_LEVEL_2 NO

DIMENSION TABLE

WDT_PROGRAM

PROGRAM_LEVEL_2

NO

PROGRAM_LEVEL_3 NO

DIMENSION TABLE

WDT_PROGRAM

PROGRAM_LEVEL_3

NO

PROGRAM_LEVEL_4 NO

DIMENSION TABLE

WDT_PROGRAM

PROGRAM_LEVEL_4

NO

PROGRAM_LEVEL_5 NO

DIMENSION TABLE

WDT_PROGRAM

PROGRAM_LEVEL_5

NO



Ver: 3.1