Banner EDW Source: GRANT_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	GRANT AND PROJECT	NO
ACCOUNT_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LD ACCOUNT_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ACCOUNT_DESC_1	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_1_SD ACCOUNT_LEVEL_1_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ACCOUNT_DESC_2	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_2_SD ACCOUNT_LEVEL_2_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ACCOUNT_DESC_3	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_3_SD ACCOUNT_LEVEL_3_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ACCOUNT_DESC_4	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_4_LD ACCOUNT_LEVEL_4_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ACCOUNT_LEVEL_1	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_1	GRANT AND PROJECT	NO
ACCOUNT_LEVEL_2	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_2	GRANT AND PROJECT	NO
ACCOUNT_LEVEL_3	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_3	GRANT AND PROJECT	NO
ACCOUNT_LEVEL_4	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_4	GRANT AND PROJECT	NO
ACCOUNT_POOL	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_POOL	GRANT AND PROJECT	NO
ACCOUNT_POOL_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_POOL_SD ACCOUNT_POOL_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ACCOUNT_TYPE_DESC_1	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_1_SD ACCOUNT_TYPE_LEVEL_1_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ACCOUNT_TYPE_DESC_2	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_2_SD ACCOUNT_TYPE_LEVEL_2_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ACCOUNT_TYPE_LEVEL_1	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_1	GRANT AND PROJECT	NO
ACCOUNT_TYPE_LEVEL_2	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_2	GRANT AND PROJECT	NO
CHART_OF_ACCOUNTS	NO	DIMENSION TABLE	WDT_CHART	CHART_OF_ACCOUNTS	GRANT AND PROJECT	NO
CHART_OF_ACCOUNTS_DESC	NO	DIMENSION TABLE	WDT_CHART WDT_CHART	CHART_OF_ACCOUNTS_SD CHART_OF_ACCOUNTS_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
CURR_ACCOUNTED_BUDGET	NO	FACT TABLE	WFT_GRANT_AND_PROJECT	FISCAL_YEAR_TOTAL_BUDGET	GRANT AND PROJECT	NO
CURR_ADOPTED_BUDGET	NO	FACT TABLE	WFT_GRANT_AND_PROJECT	FISCAL_YEAR_ADOPTED_BUDGET	GRANT AND PROJECT	NO
CURR_BUDGET_ADJUSTMENTS	NO	FACT TABLE	WFT_GRANT_AND_PROJECT	CURRENT_PERIOD_BUDGET_ADJUST	GRANT AND PROJECT	NO
FISCAL_PERIOD	NO	DIMENSION TABLE	WDT_TIME	FISCAL_PERIOD	GRANT AND PROJECT	NO
FISCAL_YEAR	NO	DIMENSION TABLE	WDT_TIME	FISCAL_YEAR	GRANT AND PROJECT	NO
FUNCTION	NO	FACT TABLE	WFT_GRANT_AND_PROJECT WFT_GRANT_AND_PROJECT WFT_GRANT_AND_PROJECT WFT_GRANT_AND_PROJECT WFT_GRANT_AND_PROJECT WFT_GRANT_AND_PROJECT WFT_GRANT_AND_PROJECT WFT_GRANT_AND_PROJECT	LIFE_TO_DATE_ENCUMBRANCES LIFE_TO_DATE_BUDGET_TOTAL LIFE_TO_DATE_DIRECT_REVENUE LIFE_TO_DATE_INDIRECT_COSTS LIFE_TO_DATE_MEMO_COSTS LIFE_TO_DATE_DIRECT_EXPEND LIFE_TO_DATE_ACTIVITY LIFE_TO_DATE_RESERVATIONS	GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT	NO NO NO NO NO NO NO NO
FUND	NO	DIMENSION TABLE	WDT_FUND	FUND	GRANT AND PROJECT	NO
FUND_DESC	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LD FUND_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
FUND_DESC_1	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_1_SD FUND_LEVEL_1_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
FUND_DESC_2	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_2_LD FUND_LEVEL_2_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
FUND_DESC_3	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_3_SD FUND_LEVEL_3_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
FUND_DESC_4	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_4_SD FUND_LEVEL_4_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
FUND_DESC_5	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_5_SD FUND_LEVEL_5_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
FUND_LEVEL_1	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_1	GRANT AND PROJECT	NO
FUND_LEVEL_2	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_2	GRANT AND PROJECT	NO
FUND_LEVEL_3	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_3	GRANT AND PROJECT	NO
FUND_LEVEL_4	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_4	GRANT AND PROJECT	NO
FUND_LEVEL_5	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_5	GRANT AND PROJECT	NO
FUND_TYPE_DESC_1	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_TYPE_LEVEL_1_SD FUND_TYPE_LEVEL_1_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
FUND_TYPE_DESC_2	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_TYPE_LEVEL_2_SD FUND_TYPE_LEVEL_2_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
FUND_TYPE_LEVEL_1	NO	DIMENSION TABLE	WDT_FUND	FUND_TYPE_LEVEL_1	GRANT AND PROJECT	NO
FUND_TYPE_LEVEL_2	NO	DIMENSION TABLE	WDT_FUND	FUND_TYPE_LEVEL_2	GRANT AND PROJECT	NO
GRANT_ID	NO	FACT TABLE	WFT_GRANT_AND_PROJECT	GRANT_ID	GRANT AND PROJECT	NO
INTERNAL_ACCOUNT_TYPE	NO	DIMENSION TABLE	WDT_ACCOUNT	INTERNAL_ACCOUNT_TYPE	GRANT AND PROJECT	NO
INTERNAL_ACCOUNT_TYPE_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	INTERNAL_ACCOUNT_TYPE_SD INTERNAL_ACCOUNT_TYPE_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ORGANIZATION_CODE	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_CODE	GRANT AND PROJECT	NO
ORGANIZATION_DESC	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_CODE_SD ORGANIZATION_CODE_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ORGANIZATION_DESC_1	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_1_LD ORGANIZATION_LEVEL_1_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ORGANIZATION_DESC_2	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_2_LD ORGANIZATION_LEVEL_2_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ORGANIZATION_DESC_3	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_3_SD ORGANIZATION_LEVEL_3_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ORGANIZATION_DESC_4	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_4_LD ORGANIZATION_LEVEL_4_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ORGANIZATION_DESC_5	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_5_SD ORGANIZATION_LEVEL_5_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ORGANIZATION_DESC_6	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_6_SD ORGANIZATION_LEVEL_6_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ORGANIZATION_DESC_7	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_7_LD ORGANIZATION_LEVEL_7_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ORGANIZATION_DESC_8	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_8_LD ORGANIZATION_LEVEL_8_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ORGANIZATION_LEVEL_1	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_1	GRANT AND PROJECT	NO
ORGANIZATION_LEVEL_2	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_2	GRANT AND PROJECT	NO
ORGANIZATION_LEVEL_3	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_3	GRANT AND PROJECT	NO
ORGANIZATION_LEVEL_4	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_4	GRANT AND PROJECT	NO
ORGANIZATION_LEVEL_5	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_5	GRANT AND PROJECT	NO
ORGANIZATION_LEVEL_6	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_6	GRANT AND PROJECT	NO
ORGANIZATION_LEVEL_7	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_7	GRANT AND PROJECT	NO
ORGANIZATION_LEVEL_8	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_8	GRANT AND PROJECT	NO
PROGRAM	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM	GRANT AND PROJECT	NO
PROGRAM_DESC	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LD PROGRAM_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
PROGRAM_DESC_1	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LEVEL_1_SD PROGRAM_LEVEL_1_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
PROGRAM_DESC_2	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LEVEL_2_LD PROGRAM_LEVEL_2_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
PROGRAM_DESC_3	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LEVEL_3_LD PROGRAM_LEVEL_3_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
PROGRAM_DESC_4	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LEVEL_4_LD PROGRAM_LEVEL_4_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
PROGRAM_DESC_5	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LEVEL_5_LD PROGRAM_LEVEL_5_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
PROGRAM_LEVEL_1	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM_LEVEL_1	GRANT AND PROJECT	NO
PROGRAM_LEVEL_2	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM_LEVEL_2	GRANT AND PROJECT	NO
PROGRAM_LEVEL_3	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM_LEVEL_3	GRANT AND PROJECT	NO
PROGRAM_LEVEL_4	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM_LEVEL_4	GRANT AND PROJECT	NO
PROGRAM_LEVEL_5	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM_LEVEL_5	GRANT AND PROJECT	NO

Ver: 9.0