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

SGHE Enterprise Data Warehouse EDW Source: OPERATING_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

WDT_ACCOUNT

ACCOUNT_SD

ACCOUNT_LD

NO

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

WDT_ACCOUNT

ACCOUNT_LEVEL_2_LD

ACCOUNT_LEVEL_2_SD

NO

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

ADMINISTRATIVE_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

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_PERIOD_ACTIVITY NO        
CURR_PERIOD_BUDGET_ADJUST NO        
CURR_PERIOD_ENCUMBRANCES NO        
CURR_PERIOD_RESERVATION 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

FISCAL_YEAR_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

FISCAL_YEAR_LD

FISCAL_YEAR_SD

NO

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

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

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

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

PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

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

QTR_TO_DATE_ACTIVITY NO        
QTR_TO_DATE_BUDGET_ADJUST NO        
QTR_TO_DATE_ENCUMBRANCES NO        
QTR_TO_DATE_RESERVATION NO        
QUARTER_1 NO        
SUM_ADOPTED_BUDGET NO        
SUM_BUDGET_ADJUST NO        
SUM_BUDGET_RESERVATION NO        
SUM_ENCUMBRANCES NO        
SUM_REMAINING_BALANCE NO        
SUM_YTD_ACTIVITY NO        


Ver: 3.1