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

SGHE Enterprise Data Warehouse EDW Source: GRANT_LEDGER

Source Column Local Source Target Type Target Target Column Local Target
ACCOUNT NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT

NO

ACCOUNT_DESC NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_SD

NO

ACCOUNT_DESC_1 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_LEVEL_1_LD

ACCOUNT_LEVEL_1_SD

NO

NO

ACCOUNT_DESC_2 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_LEVEL_2_SD

NO

ACCOUNT_DESC_3 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_LEVEL_3_SD

ACCOUNT_LEVEL_3_LD

NO

NO

ACCOUNT_DESC_4 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_LEVEL_4_LD

ACCOUNT_LEVEL_4_SD

NO

NO

ACCOUNT_LEVEL_1 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_LEVEL_1

NO

ACCOUNT_LEVEL_2 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_LEVEL_2

NO

ACCOUNT_LEVEL_3 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_LEVEL_3

NO

ACCOUNT_LEVEL_4 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_LEVEL_4

NO

ACCOUNT_POOL NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_POOL

NO

ACCOUNT_POOL_DESC NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_POOL_SD

ACCOUNT_POOL_LD

NO

NO

ACCOUNT_TYPE NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_TYPE

NO

ACCOUNT_TYPE_DESC NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_TYPE_SD

ACCOUNT_TYPE_LD

NO

NO

ACCOUNT_TYPE_DESC_1 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_TYPE_LEVEL_1_LD

ACCOUNT_TYPE_LEVEL_1_SD

NO

NO

ACCOUNT_TYPE_DESC_2 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_TYPE_LEVEL_2_LD

ACCOUNT_TYPE_LEVEL_2_SD

NO

NO

ACCOUNT_TYPE_LEVEL_1 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_TYPE_LEVEL_1

NO

ACCOUNT_TYPE_LEVEL_2 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_TYPE_LEVEL_2

NO

CHART_OF_ACCOUNTS NO

DIMENSION TABLE

WDT_CHART

CHART_OF_ACCOUNTS

NO

CHART_OF_ACCOUNTS_DESC NO

DIMENSION TABLE

WDT_CHART

WDT_CHART

CHART_OF_ACCOUNTS_LD

CHART_OF_ACCOUNTS_SD

NO

NO

CURR_ACCOUNTED_BUDGET NO        
CURR_ADOPTED_BUDGET NO        
CURR_BUDGET_ADJUST NO        
CURR_BUDGET_ADJUSTMENTS NO        
FISCAL_PERIOD NO

DIMENSION TABLE

WDT_TIME

FISCAL_PERIOD

NO

FISCAL_QUARTER NO

DIMENSION TABLE

WDT_TIME

FISCAL_QUARTER

NO

FISCAL_YEAR NO

DIMENSION TABLE

WDT_TIME

FISCAL_YEAR

NO

FUNCTION NO        
FUND NO

DIMENSION TABLE

WDT_FUND

FUND

NO

FUND_DESC NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_SD

FUND_LD

NO

NO

FUND_DESC_1 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_LEVEL_1_LD

FUND_LEVEL_1_SD

NO

NO

FUND_DESC_2 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_LEVEL_2_SD

FUND_LEVEL_2_LD

NO

NO

FUND_DESC_3 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_LEVEL_3_LD

FUND_LEVEL_3_SD

NO

NO

FUND_DESC_4 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_LEVEL_4_LD

FUND_LEVEL_4_SD

NO

NO

FUND_DESC_5 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_LEVEL_5_SD

FUND_LEVEL_5_LD

NO

NO

FUND_LEVEL_1 NO

DIMENSION TABLE

WDT_FUND

FUND_LEVEL_1

NO

FUND_LEVEL_2 NO

DIMENSION TABLE

WDT_FUND

FUND_LEVEL_2

NO

FUND_LEVEL_3 NO

DIMENSION TABLE

WDT_FUND

FUND_LEVEL_3

NO

FUND_LEVEL_4 NO

DIMENSION TABLE

WDT_FUND

FUND_LEVEL_4

NO

FUND_LEVEL_5 NO

DIMENSION TABLE

WDT_FUND

FUND_LEVEL_5

NO

FUND_TYPE NO

DIMENSION TABLE

WDT_FUND

FUND_TYPE

NO

FUND_TYPE_DESC NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_TYPE_LD

FUND_TYPE_SD

NO

NO

FUND_TYPE_DESC_1 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_TYPE_LEVEL_1_SD

FUND_TYPE_LEVEL_1_LD

NO

NO

FUND_TYPE_DESC_2 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_TYPE_LEVEL_2_LD

FUND_TYPE_LEVEL_2_SD

NO

NO

FUND_TYPE_LEVEL_1 NO

DIMENSION TABLE

WDT_FUND

FUND_TYPE_LEVEL_1

NO

FUND_TYPE_LEVEL_2 NO

DIMENSION TABLE

WDT_FUND

FUND_TYPE_LEVEL_2

NO

GRANT_ID NO        
INTERNAL_ACCOUNT_TYPE NO

DIMENSION TABLE

WDT_ACCOUNT

INTERNAL_ACCOUNT_TYPE

NO

INTERNAL_ACCOUNT_TYPE_DESC NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

INTERNAL_ACCOUNT_TYPE_LD

INTERNAL_ACCOUNT_TYPE_SD

NO

NO

LIFE_TO_DATE_MATCHING_COSTS NO        
ORGANIZATION_CODE NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_CODE

NO

ORGANIZATION_DESC NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_CODE_SD

ORGANIZATION_CODE_LD

NO

NO

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

PROGRAM NO

DIMENSION TABLE

WDT_PROGRAM

PROGRAM

NO

PROGRAM_DESC NO

DIMENSION TABLE

WDT_PROGRAM

WDT_PROGRAM

PROGRAM_LD

PROGRAM_SD

NO

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