Banner EDW Source: OPERATING_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	OPERATING LEDGER	NO
ACCOUNT_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_SD ACCOUNT_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
ACCOUNT_DESC_1	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_1_SD ACCOUNT_LEVEL_1_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
ACCOUNT_DESC_2	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_2_SD ACCOUNT_LEVEL_2_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
ACCOUNT_DESC_3	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_3_LD ACCOUNT_LEVEL_3_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
ACCOUNT_DESC_4	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_4_SD ACCOUNT_LEVEL_4_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
ACCOUNT_LEVEL_1	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_1	OPERATING LEDGER	NO
ACCOUNT_LEVEL_2	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_2	OPERATING LEDGER	NO
ACCOUNT_LEVEL_3	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_3	OPERATING LEDGER	NO
ACCOUNT_LEVEL_4	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_4	OPERATING LEDGER	NO
ACCOUNT_POOL	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_POOL	OPERATING LEDGER	NO
ACCOUNT_POOL_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_POOL_SD ACCOUNT_POOL_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
ACCOUNT_TYPE_DESC_1	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_1_LD ACCOUNT_TYPE_LEVEL_1_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
ACCOUNT_TYPE_DESC_2	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_2_LD ACCOUNT_TYPE_LEVEL_2_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
ACCOUNT_TYPE_LEVEL_1	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_1	OPERATING LEDGER	NO
ACCOUNT_TYPE_LEVEL_2	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_2	OPERATING LEDGER	NO
ACTIVITY	NO	DIMENSION TABLE	WDT_FINANCE_ACTIVITY	ACTIVITY	OPERATING LEDGER	NO
ACTIVITY_DESC	NO	DIMENSION TABLE	WDT_FINANCE_ACTIVITY WDT_FINANCE_ACTIVITY	ACTIVITY_LD ACTIVITY_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	OPERATING LEDGER	NO
CHART_OF_ACCOUNTS	NO	DIMENSION TABLE	WDT_CHART	CHART_OF_ACCOUNTS	OPERATING LEDGER	NO
CHART_OF_ACCOUNTS_DESC	NO	DIMENSION TABLE	WDT_CHART WDT_CHART	CHART_OF_ACCOUNTS_LD CHART_OF_ACCOUNTS_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
CURR_ADOPTED_BUDGET	NO	FACT TABLE	WFT_OPERATING_LEDGER WFT_OPERATING_LEDGER WFT_GRANT_AND_PROJECT	CURRENT_PERIOD_ADOPTED_BUDGET FISCAL_YEAR_ADOPTED_BUDGET CURRENT_PERIOD_ADOPTED_BUDGET	OPERATING LEDGER OPERATING LEDGER GRANT AND PROJECT	NO NO NO
CURR_BUDGET_ADJUSTMENTS	NO	FACT TABLE	WFT_OPERATING_LEDGER WFT_OPERATING_LEDGER	QTR_TO_DATE_BUDGET_ADJUST CURRENT_PERIOD_BUDGET_ADJUST	OPERATING LEDGER OPERATING LEDGER	NO NO
CURR_BUDGET_RESERVATION	NO	FACT TABLE	WFT_OPERATING_LEDGER WFT_OPERATING_LEDGER	QTR_TO_DATE_RESERVATIONS CURRENT_PERIOD_RESERVATIONS	OPERATING LEDGER OPERATING LEDGER	NO NO
CURR_ENCUMBRANCES	NO	FACT TABLE	WFT_OPERATING_LEDGER WFT_OPERATING_LEDGER	CURRENT_PERIOD_ENCUMBRANCES QTR_TO_DATE_ENCUMBRANCES	OPERATING LEDGER OPERATING LEDGER	NO NO
CURR_YEAR_TO_DATE_ACTIVITY	NO	FACT TABLE	WFT_OPERATING_LEDGER WFT_OPERATING_LEDGER	QTR_TO_DATE_ACTIVITY CURRENT_PERIOD_ACTIVITY	OPERATING LEDGER OPERATING LEDGER	NO NO
FISCAL_YEAR	NO	DIMENSION TABLE	WDT_TIME	FISCAL_YEAR	OPERATING LEDGER	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 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 WFT_GRANT_AND_PROJECT	CURRENT_PERIOD_RESERVATIONS YTD_RESERVATIONS YTD_ENCUMBRANCES YTD_MATCHING_COSTS CURRENT_PERIOD_INDIRECT_COSTS CURRENT_PERIOD_MEMO_COSTS YTD_MEMO_COSTS CURRENT_PERIOD_MATCHING_COSTS YTD_DIRECT_REVENUE CURRENT_PERIOD_ACTIVITY CURRENT_PERIOD_DIRECT_EXPEND CURRENT_PERIOD_ENCUMBRANCES YTD_ACTIVITY CURRENT_PERIOD_DIRECT_REVENUE YTD_DIRECT_EXPEND YTD_BUDGET_TOTAL YTD_INDIRECT_COSTS	GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT 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 NO NO NO NO NO NO NO NO NO
FUND	NO	DIMENSION TABLE	WDT_FUND	FUND	OPERATING LEDGER	NO
FUND_DESC	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LD FUND_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
FUND_DESC_1	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_1_LD FUND_LEVEL_1_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
FUND_DESC_2	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_2_SD FUND_LEVEL_2_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
FUND_DESC_3	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_3_LD FUND_LEVEL_3_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
FUND_DESC_4	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_4_LD FUND_LEVEL_4_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
FUND_DESC_5	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_LEVEL_5_SD FUND_LEVEL_5_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
FUND_LEVEL_1	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_1	OPERATING LEDGER	NO
FUND_LEVEL_2	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_2	OPERATING LEDGER	NO
FUND_LEVEL_3	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_3	OPERATING LEDGER	NO
FUND_LEVEL_4	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_4	OPERATING LEDGER	NO
FUND_LEVEL_5	NO	DIMENSION TABLE	WDT_FUND	FUND_LEVEL_5	OPERATING LEDGER	NO
FUND_TYPE_DESC_1	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_TYPE_LEVEL_1_SD FUND_TYPE_LEVEL_1_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
FUND_TYPE_DESC_2	NO	DIMENSION TABLE	WDT_FUND WDT_FUND	FUND_TYPE_LEVEL_2_LD FUND_TYPE_LEVEL_2_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
FUND_TYPE_LEVEL_1	NO	DIMENSION TABLE	WDT_FUND	FUND_TYPE_LEVEL_1	OPERATING LEDGER	NO
FUND_TYPE_LEVEL_2	NO	DIMENSION TABLE	WDT_FUND	FUND_TYPE_LEVEL_2	OPERATING LEDGER	NO
INTERNAL_ACCOUNT_TYPE	NO	DIMENSION TABLE	WDT_ACCOUNT	INTERNAL_ACCOUNT_TYPE	OPERATING LEDGER	NO
INTERNAL_ACCOUNT_TYPE_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	INTERNAL_ACCOUNT_TYPE_SD INTERNAL_ACCOUNT_TYPE_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
LOCATION	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION	LOCATION	OPERATING LEDGER	NO
LOCATION_DESC	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION WDT_FINANCE_LOCATION	LOCATION_LD LOCATION_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
LOCATION_DESC_1	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION WDT_FINANCE_LOCATION	LOCATION_LEVEL_1_LD LOCATION_LEVEL_1_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
LOCATION_DESC_2	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION WDT_FINANCE_LOCATION	LOCATION_LEVEL_2_SD LOCATION_LEVEL_2_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
LOCATION_DESC_3	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION WDT_FINANCE_LOCATION	LOCATION_LEVEL_3_SD LOCATION_LEVEL_3_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
LOCATION_DESC_4	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION WDT_FINANCE_LOCATION	LOCATION_LEVEL_4_LD LOCATION_LEVEL_4_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
LOCATION_DESC_5	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION WDT_FINANCE_LOCATION	LOCATION_LEVEL_5_LD LOCATION_LEVEL_5_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
LOCATION_LEVEL_1	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION	LOCATION_LEVEL_1	OPERATING LEDGER	NO
LOCATION_LEVEL_2	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION	LOCATION_LEVEL_2	OPERATING LEDGER	NO
LOCATION_LEVEL_3	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION	LOCATION_LEVEL_3	OPERATING LEDGER	NO
LOCATION_LEVEL_4	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION	LOCATION_LEVEL_4	OPERATING LEDGER	NO
LOCATION_LEVEL_5	NO	DIMENSION TABLE	WDT_FINANCE_LOCATION	LOCATION_LEVEL_5	OPERATING LEDGER	NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	OPERATING LEDGER	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_SD MULTI_SOURCE_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
NUMBER	NO	FACT TABLE	WFT_OPERATING_LEDGER	FINANCE_ACTIVITY_KEY	OPERATING LEDGER	NO
ORGANIZATION_CODE	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_CODE	OPERATING LEDGER	NO
ORGANIZATION_DESC	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_CODE_LD ORGANIZATION_CODE_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
ORGANIZATION_DESC_1	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_1_LD ORGANIZATION_LEVEL_1_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
ORGANIZATION_DESC_2	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_2_LD ORGANIZATION_LEVEL_2_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
ORGANIZATION_DESC_3	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_3_LD ORGANIZATION_LEVEL_3_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
ORGANIZATION_DESC_4	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_4_LD ORGANIZATION_LEVEL_4_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
ORGANIZATION_DESC_5	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_5_SD ORGANIZATION_LEVEL_5_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
ORGANIZATION_DESC_6	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_6_SD ORGANIZATION_LEVEL_6_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
ORGANIZATION_DESC_7	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_7_LD ORGANIZATION_LEVEL_7_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
ORGANIZATION_DESC_8	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_8_SD ORGANIZATION_LEVEL_8_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
ORGANIZATION_LEVEL_1	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_1	OPERATING LEDGER	NO
ORGANIZATION_LEVEL_2	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_2	OPERATING LEDGER	NO
ORGANIZATION_LEVEL_3	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_3	OPERATING LEDGER	NO
ORGANIZATION_LEVEL_4	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_4	OPERATING LEDGER	NO
ORGANIZATION_LEVEL_5	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_5	OPERATING LEDGER	NO
ORGANIZATION_LEVEL_6	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_6	OPERATING LEDGER	NO
ORGANIZATION_LEVEL_7	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_7	OPERATING LEDGER	NO
ORGANIZATION_LEVEL_8	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_8	OPERATING LEDGER	NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	OPERATING LEDGER	NO
PROGRAM	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM	OPERATING LEDGER	NO
PROGRAM_DESC	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LD PROGRAM_SD	OPERATING LEDGER OPERATING LEDGER, RECEIVABLE REVENUE	NO NO
PROGRAM_DESC_1	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LEVEL_1_LD PROGRAM_LEVEL_1_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
PROGRAM_DESC_2	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LEVEL_2_LD PROGRAM_LEVEL_2_SD	OPERATING LEDGER OPERATING LEDGER	NO NO
PROGRAM_DESC_3	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LEVEL_3_SD PROGRAM_LEVEL_3_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
PROGRAM_DESC_4	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LEVEL_4_SD PROGRAM_LEVEL_4_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
PROGRAM_DESC_5	NO	DIMENSION TABLE	WDT_PROGRAM WDT_PROGRAM	PROGRAM_LEVEL_5_SD PROGRAM_LEVEL_5_LD	OPERATING LEDGER OPERATING LEDGER	NO NO
PROGRAM_LEVEL_1	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM_LEVEL_1	OPERATING LEDGER	NO
PROGRAM_LEVEL_2	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM_LEVEL_2	OPERATING LEDGER	NO
PROGRAM_LEVEL_3	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM_LEVEL_3	OPERATING LEDGER	NO
PROGRAM_LEVEL_4	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM_LEVEL_4	OPERATING LEDGER	NO
PROGRAM_LEVEL_5	NO	DIMENSION TABLE	WDT_PROGRAM	PROGRAM_LEVEL_5	OPERATING LEDGER	NO
SUM_ADOPTED_BUDGET	NO	FACT TABLE	WFT_OPERATING_LEDGER	CURRENT_YTD_ADOPTED_BUDGET	OPERATING LEDGER	NO
SUM_BUDGET_ADJUSTMENTS	NO	FACT TABLE	WFT_OPERATING_LEDGER	CURRENT_YTD_BUDGET_ADJUST	OPERATING LEDGER	NO
SUM_BUDGET_RESERVATION	NO	FACT TABLE	WFT_OPERATING_LEDGER	CURRENT_YTD_RESERVATIONS	OPERATING LEDGER	NO
SUM_ENCUMBRANCES	NO	FACT TABLE	WFT_OPERATING_LEDGER	CURRENT_YTD_ENCUMBRANCES	OPERATING LEDGER	NO
SUM_REMAINING_BALANCE	NO	FACT TABLE	WFT_OPERATING_LEDGER	CURRENT_YTD_REMAINING_BALANCE	OPERATING LEDGER	NO
SUM_YEAR_TO_DATE_ACTIVITY	NO	FACT TABLE	WFT_OPERATING_LEDGER	CURRENT_YTD_ACTIVITY	OPERATING LEDGER	NO

Ver: 9.0