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	GRANT AND PROJECT
CHART_KEY	Key for the chart dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
CURRENT_PERIOD_ACTIVITY	Sum of the actual activity in the operating ledger for the fiscal period.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
CURRENT_PERIOD_ADOPTED_BUDGET	Current period adopted budget for this account.	NUMBER	OPERATING_LEDGER	CURR_ADOPTED_BUDGET	NO	NO	GRANT AND PROJECT
CURRENT_PERIOD_BUDGET_ADJUST	Amount for the budget adjustments during this current fiscal period.	NUMBER	GRANT_LEDGER	CURR_BUDGET_ADJUSTMENTS	NO	NO	GRANT AND PROJECT
CURRENT_PERIOD_DIRECT_EXPEND	Current period direct expenditures for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
CURRENT_PERIOD_DIRECT_REVENUE	Current period direct revenue for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
CURRENT_PERIOD_ENCUMBRANCES	Sum of the amounts encumbered or obligations against the operating ledger for the current fiscal period.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
CURRENT_PERIOD_INDIRECT_COSTS	Current period indirect costs for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
CURRENT_PERIOD_MATCHING_COSTS	Current period matching costs for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
CURRENT_PERIOD_MEMO_COSTS	Amount of cost share that been calculated for the grant and cost share rate code using the memo rate.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
CURRENT_PERIOD_RESERVATIONS	Amount reserved or committed against the operating ledger for the current fiscal period.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
FISCAL_YEAR_ADOPTED_BUDGET	Adopted budget total amount for the year.	NUMBER	GRANT_LEDGER	CURR_ADOPTED_BUDGET	NO	NO	GRANT AND PROJECT
FISCAL_YEAR_BUDGET_ADJUST	Budget adjustments approved for the total adopted budget for the year.	NUMBER	FUNCTION	SUM(NVL(CURR_BUDGET_ADJUSTMENTS, 0))	NO	NO	GRANT AND PROJECT
FISCAL_YEAR_TOTAL_BUDGET	Current total budget amount for the year. This is the adopted budget plus all approved budget adjustments.	NUMBER	GRANT_LEDGER	CURR_ACCOUNTED_BUDGET	NO	NO	GRANT AND PROJECT
FUND_KEY	Key for the fund dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
GRANT_DEMOGRAPHIC_KEY	Key for the grant demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
GRANT_ID	User-defined or system assigned grant unique identification code.	VARCHAR2(63)	GRANT_LEDGER	GRANT_ID	NO	NO	GRANT AND PROJECT
GRANT_TYPE_KEY	Key for the grant type dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
LIFE_TO_DATE_ACTIVITY	Life-to-date actuals for this account.	NUMBER	GRANT_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
LIFE_TO_DATE_BUDGET_TOTAL	Total life-to-date budget for this account.	NUMBER	GRANT_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
LIFE_TO_DATE_DIRECT_EXPEND	Total life-to-date direct expenditures for this account.	NUMBER	GRANT_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
LIFE_TO_DATE_DIRECT_REVENUE	Life-to-date direct revenue for this account.	NUMBER	GRANT_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
LIFE_TO_DATE_ENCUMBRANCES	Life-to-date encumbrances for this account.	NUMBER	GRANT_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
LIFE_TO_DATE_INDIRECT_COSTS	Total inception to date year to date activity that has been used to calculate the indirect cost amount for the grant and account.	NUMBER	GRANT_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
LIFE_TO_DATE_MATCHING_COSTS	Life-to-date matching costs for this account.	NUMBER	FUNCTION	SUM(NVL(GL.SUM_YEAR_TO_DATE_ACTIVITY,0))	NO	NO	GRANT AND PROJECT
LIFE_TO_DATE_MEMO_COSTS	Life-to-date memo costs for this account.	NUMBER	GRANT_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
LIFE_TO_DATE_RESERVATIONS	Life-to-date reservations for this account.	NUMBER	GRANT_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
ORGANIZATION_KEY	Key for the organization dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
PROGRAM_KEY	Key for the program dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
TIME_KEY	Key for the time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT
YTD_ACTIVITY	Year-to-date actuals for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
YTD_BUDGET_TOTAL	Year-to-date budget for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
YTD_DIRECT_EXPEND	Year-to-date direct expenditures for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
YTD_DIRECT_REVENUE	Year-to-date direct revenue for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
YTD_ENCUMBRANCES	Year-to-date encumbrances for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
YTD_INDIRECT_COSTS	Exceeded indirect cost memo amount over the maximum indirect cost memo amount.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
YTD_MATCHING_COSTS	Year-to-date matching costs for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
YTD_MEMO_COSTS	Amount of indirect cost that been calculated for the grant and indirect cost rate code using the memo rate.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT
YTD_RESERVATIONS	Year-to-date reservation for this account.	NUMBER	OPERATING_LEDGER	FUNCTION	NO	NO	GRANT AND PROJECT

Ver: 9.0