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

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

BEGINNING_BALANCE 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

END_BALANCE 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

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

PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO

QUARTER_1 NO        
SUM_PERIODIC_ACTIVITY NO        
SUM_PERIODIC_CREDITS NO        
SUM_PERIODIC_DEBITS NO        
SUM_YEAR_ACTIVITY NO        
SUM_YEAR_CREDITS NO        
SUM_YEAR_DEBITS NO        
YTD_ACTIVITY NO        
YTD_CREDITS NO        
YTD_DEBITS NO        


Ver: 3.1