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	GENERAL LEDGER
BEGINNING_BALANCE	Balance for the general ledger at the beginning of the fiscal year. This is the fiscal period '00' starting balance.	NUMBER	GENERAL_LEDGER	BEGINNING_BALANCE	NO	NO	GENERAL LEDGER
CHART_KEY	Key for the chart dimension	NUMBER	ETL GENERATED	NA	NO	NO	GENERAL LEDGER
CURRENT_PERIOD_ACTIVITY	Sum of the actual activity in the general ledger for the fiscal period.	NUMBER	GENERAL_LEDGER	SUM_PERIODIC_ACTIVITY	NO	NO	GENERAL LEDGER
CURRENT_PERIOD_CREDITS	Sum of all the credits made to the general ledger in this fiscal period.	NUMBER	GENERAL_LEDGER	SUM_PERIODIC_CREDITS	NO	NO	GENERAL LEDGER
CURRENT_PERIOD_DEBITS	Sum of all the debits made to the general ledger in this fiscal period.	NUMBER	GENERAL_LEDGER	SUM_PERIODIC_DEBITS	NO	NO	GENERAL LEDGER
CURRENT_YEAR_ACTIVITY	Total activity of debits minus credits in the general ledger through the end of this fiscal period.	NUMBER	GENERAL_LEDGER	SUM_YEAR_ACTIVITY	NO	NO	GENERAL LEDGER
CURRENT_YEAR_CREDITS	Sum of all the credits made to the general ledger for the fiscal year through this fiscal period.	NUMBER	GENERAL_LEDGER	SUM_YEAR_CREDITS	NO	NO	GENERAL LEDGER
CURRENT_YEAR_DEBITS	Sum of all the debits made to the general ledger for the fiscal year through this fiscal period.	NUMBER	GENERAL_LEDGER	SUM_YEAR_DEBITS	NO	NO	GENERAL LEDGER
ENDING_BALANCE	Ending balance for the general ledger as of this fiscal period. Beginning balance plus the debits to date minus the credits to date. Any debits and credits after this fiscal period are included in the current year amounts but not in the ending balance.	NUMBER	GENERAL_LEDGER	END_BALANCE	NO	NO	GENERAL LEDGER
FUND_KEY	Key for the fund dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GENERAL LEDGER
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GENERAL LEDGER
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	GENERAL LEDGER
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	GENERAL LEDGER
TIME_KEY	Key for the time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GENERAL LEDGER
YTD_ACTIVITY	Total activity of debits minus credits in the general ledger for the fiscal year but only through the current fiscal period.	NUMBER	GENERAL_LEDGER	YTD_ACTIVITY	NO	NO	GENERAL LEDGER
YTD_CREDITS	Sum of the year to date credits made to the general ledger for the fiscal year without consideration for the current fiscal period.	NUMBER	GENERAL_LEDGER	YTD_CREDITS	NO	NO	GENERAL LEDGER
YTD_DEBITS	Sum of the year to date debits made to the general ledger for the fiscal year without consideration for the current fiscal period.	NUMBER	GENERAL_LEDGER	YTD_DEBITS	NO	NO	GENERAL LEDGER

Ver: 8.1