Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACCOUNT_KEY	Key for the account dimension.	NUMBER	ETL GENERATED	NA	NO	NO	OPERATING LEDGER
CHART_KEY	Key for the chart dimension.	NUMBER	ETL GENERATED	NA	NO	NO	OPERATING LEDGER
CURRENT_PERIOD_ACTIVITY	Sum of the actual activity in the operating ledger for the fiscal period.	NUMBER	OPERATING_LEDGER	CURR_YEAR_TO_DATE_ACTIVITY	NO	NO	OPERATING LEDGER
CURRENT_PERIOD_ADOPTED_BUDGET	Adopted budget for this fiscal period.	NUMBER	OPERATING_LEDGER	CURR_ADOPTED_BUDGET	NO	NO	OPERATING LEDGER
CURRENT_PERIOD_BUDGET_ADJUST	Amount for the budget adjustments during this current fiscal period.	NUMBER	OPERATING_LEDGER	CURR_BUDGET_ADJUSTMENTS	NO	NO	OPERATING LEDGER
CURRENT_PERIOD_ENCUMBRANCES	Sum of the amounts encumbered or obligations against the operating ledger for the current fiscal period.	NUMBER	OPERATING_LEDGER	CURR_ENCUMBRANCES	NO	NO	OPERATING LEDGER
CURRENT_PERIOD_RESERVATIONS	Amount reserved or committed against the operating ledger for the current fiscal period.	NUMBER	OPERATING_LEDGER	CURR_BUDGET_RESERVATION	NO	NO	OPERATING LEDGER
CURRENT_YTD_ACTIVITY	Sum of the actual year to date activity in the operating ledger through the current fiscal period.	NUMBER	OPERATING_LEDGER	SUM_YEAR_TO_DATE_ACTIVITY	NO	NO	OPERATING LEDGER
CURRENT_YTD_ADOPTED_BUDGET	Adopted budget for the current fiscal year through the current fiscal period.	NUMBER	OPERATING_LEDGER	SUM_ADOPTED_BUDGET	NO	NO	OPERATING LEDGER
CURRENT_YTD_BUDGET_ADJUST	Sum for all the budget adjustments approved for the year through this fiscal period.	NUMBER	OPERATING_LEDGER	SUM_BUDGET_ADJUSTMENTS	NO	NO	OPERATING LEDGER
CURRENT_YTD_ENCUMBRANCES	Sum for all amounts encumbered or obligations against the budget for the year through this fiscal period.	NUMBER	OPERATING_LEDGER	SUM_ENCUMBRANCES	NO	NO	OPERATING LEDGER
CURRENT_YTD_REMAINING_BALANCE	Sum of the remaining adopted budget available after this fiscal period. The remaining balance will be the current year to date activity minus any additional encumbrances minus any additional commitments.	NUMBER	OPERATING_LEDGER	SUM_REMAINING_BALANCE	NO	NO	OPERATING LEDGER
CURRENT_YTD_RESERVATIONS	Sum for all amounts reserved or committed against the budget for the year through this fiscal period.	NUMBER	OPERATING_LEDGER	SUM_BUDGET_RESERVATION	NO	NO	OPERATING LEDGER
FISCAL_YEAR_ADOPTED_BUDGET	Adopted budget total amount for the year.	NUMBER	OPERATING_LEDGER	CURR_ADOPTED_BUDGET	NO	NO	OPERATING LEDGER
FISCAL_YEAR_BUDGET_ADJUST	Budget adjustments approved for the total adopted budget for the year.	NUMBER	FUNCTION	SUM(CASE WHEN (FISCAL_PERIOD ='13') THEN SUM_BUDGET_ADJUSTMENTS ELSE 0 END)	NO	NO	OPERATING LEDGER
FISCAL_YEAR_TOTAL_BUDGET	Current total budget amount for the year. This is the adopted budget plus all approved budget adjustments.	NUMBER	CALCULATION	SUM_ADOPTED_BUDGET + SUM_BUDGET_ADJUSTMENTS	NO	NO	OPERATING LEDGER
FUND_KEY	Key for the fund dimension.	NUMBER	ETL GENERATED	NA	NO	NO	OPERATING LEDGER
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	OPERATING LEDGER
ORGANIZATION_KEY	Key for the organization dimension.	NUMBER	ETL GENERATED	NA	NO	NO	OPERATING LEDGER
PROGRAM_KEY	Key for the program dimension.	NUMBER	ETL GENERATED	NA	NO	NO	OPERATING LEDGER
QTR_TO_DATE_ACTIVITY	Sum of the quarter actual activity in the operating ledger.	NUMBER	OPERATING_LEDGER	CURR_YEAR_TO_DATE_ACTIVITY	NO	NO	OPERATING LEDGER
QTR_TO_DATE_BUDGET_ADJUST	Sum of the budget adjustments recorded for the quarter (3 fiscal periods) activity.	NUMBER	OPERATING_LEDGER	CURR_BUDGET_ADJUSTMENTS	NO	NO	OPERATING LEDGER
QTR_TO_DATE_ENCUMBRANCES	Sum of the amounts encumbered or obligations against the operating ledger for the quarter (3 fiscal periods).	NUMBER	OPERATING_LEDGER	CURR_ENCUMBRANCES	NO	NO	OPERATING LEDGER
QTR_TO_DATE_RESERVATIONS	Sum of the amounts reserved or committed against the operating ledger for the quarter (3 fiscal periods).	NUMBER	OPERATING_LEDGER	CURR_BUDGET_RESERVATION	NO	NO	OPERATING LEDGER
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	OPERATING LEDGER
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	OPERATING LEDGER
TIME_KEY	Key for the time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	OPERATING LEDGER

Ver: 8.4.3