Banner EDW Source: GENERAL_LEDGER

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

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ACCOUNT	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT	GENERAL LEDGER	NO
ACCOUNT_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LD ACCOUNT_SD	GENERAL LEDGER GENERAL LEDGER	NO NO
ACCOUNT_DESC_1	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_1_SD ACCOUNT_LEVEL_1_LD	GENERAL LEDGER GENERAL LEDGER	NO NO
ACCOUNT_DESC_2	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_2_LD ACCOUNT_LEVEL_2_SD	GENERAL LEDGER GENERAL LEDGER	NO NO
ACCOUNT_DESC_3	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_3_LD ACCOUNT_LEVEL_3_SD	GENERAL LEDGER GENERAL LEDGER	NO NO
ACCOUNT_DESC_4	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_4_SD ACCOUNT_LEVEL_4_LD	GENERAL LEDGER GENERAL LEDGER	NO NO
ACCOUNT_LEVEL_1	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_1	GENERAL LEDGER	NO
ACCOUNT_LEVEL_2	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_2	GENERAL LEDGER	NO
ACCOUNT_LEVEL_3	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_3	GENERAL LEDGER	NO
ACCOUNT_LEVEL_4	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_4	GENERAL LEDGER	NO
ACCOUNT_POOL	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_POOL	GENERAL LEDGER	NO
ACCOUNT_POOL_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_POOL_SD ACCOUNT_POOL_LD	GENERAL LEDGER GENERAL LEDGER	NO NO
ACCOUNT_TYPE_DESC_1	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_1_LD ACCOUNT_TYPE_LEVEL_1_SD	GENERAL LEDGER GENERAL LEDGER	NO NO
ACCOUNT_TYPE_DESC_2	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_2_LD ACCOUNT_TYPE_LEVEL_2_SD	GENERAL LEDGER GENERAL LEDGER	NO NO
ACCOUNT_TYPE_LEVEL_1	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_1	GENERAL LEDGER	NO
ACCOUNT_TYPE_LEVEL_2	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_2	GENERAL LEDGER	NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	GENERAL LEDGER	NO
BEGINNING_BALANCE	NO	FACT TABLE	WFT_GENERAL_LEDGER	BEGINNING_BALANCE	GENERAL LEDGER	NO
CHART_OF_ACCOUNTS	NO	DIMENSION TABLE	WDT_CHART	CHART_OF_ACCOUNTS	GENERAL LEDGER	NO
CHART_OF_ACCOUNTS_DESC	NO	DIMENSION TABLE	WDT_CHART WDT_CHART	CHART_OF_ACCOUNTS_LD CHART_OF_ACCOUNTS_SD	GENERAL LEDGER GENERAL LEDGER	NO NO
FISCAL_PERIOD	NO	DIMENSION TABLE	WDT_TIME	FISCAL_PERIOD	GENERAL LEDGER	NO
FISCAL_YEAR	NO	DIMENSION TABLE	WDT_TIME	FISCAL_YEAR	GENERAL LEDGER	NO
FUND	NO	DIMENSION TABLE	WDT_FUND	FUND	GENERAL LEDGER	NO
FUND_DESC	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LD FUND_SD	GENERAL LEDGER GENERAL LEDGER	NO NO
FUND_DESC_1	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_1_SD FUND_LEVEL_1_LD	GENERAL LEDGER GENERAL LEDGER	NO NO
FUND_DESC_2	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_2_LD FUND_LEVEL_2_SD	GENERAL LEDGER GENERAL LEDGER	NO NO
FUND_DESC_3	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_3_SD FUND_LEVEL_3_LD	GENERAL LEDGER GENERAL LEDGER	NO NO
FUND_DESC_4	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_4_SD FUND_LEVEL_4_LD	GENERAL LEDGER GENERAL LEDGER	NO NO
FUND_DESC_5	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_5_LD FUND_LEVEL_5_SD	GENERAL LEDGER GENERAL LEDGER	NO NO
FUND_LEVEL_1	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_1	GENERAL LEDGER	NO
FUND_LEVEL_2	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_2	GENERAL LEDGER	NO
FUND_LEVEL_3	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_3	GENERAL LEDGER	NO
FUND_LEVEL_4	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_4	GENERAL LEDGER	NO
FUND_LEVEL_5	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_5	GENERAL LEDGER	NO
FUND_TYPE_DESC_1	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_TYPE_LEVEL_1_SD FUND_TYPE_LEVEL_1_LD	GENERAL LEDGER GENERAL LEDGER	NO NO
FUND_TYPE_DESC_2	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_TYPE_LEVEL_2_SD FUND_TYPE_LEVEL_2_LD	GENERAL LEDGER GENERAL LEDGER	NO NO
FUND_TYPE_LEVEL_1	NO	DIMENSION TABLE	WDT_FUND	FUND_TYPE_LEVEL_1	GENERAL LEDGER	NO
FUND_TYPE_LEVEL_2	NO	DIMENSION TABLE	WDT_FUND	FUND_TYPE_LEVEL_2	GENERAL LEDGER	NO
INTERNAL_ACCOUNT_TYPE	NO	DIMENSION TABLE	WDT_ACCOUNT	INTERNAL_ACCOUNT_TYPE	GENERAL LEDGER	NO
INTERNAL_ACCOUNT_TYPE_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	INTERNAL_ACCOUNT_TYPE_LD INTERNAL_ACCOUNT_TYPE_SD	GENERAL LEDGER GENERAL LEDGER	NO NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	GENERAL LEDGER	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_SD MULTI_SOURCE_LD	GENERAL LEDGER GENERAL LEDGER	NO NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	GENERAL LEDGER	NO
SUM_PERIODIC_CREDITS	NO	FACT TABLE	WFT_GENERAL_LEDGER	CURRENT_PERIOD_CREDITS	GENERAL LEDGER	NO
SUM_PERIODIC_DEBITS	NO	FACT TABLE	WFT_GENERAL_LEDGER	CURRENT_PERIOD_DEBITS	GENERAL LEDGER	NO

Ver: 9.0