Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACCOUNT		Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(6)		FGBGENL	FGBGENL_ACCT_CODE
ACCOUNT_DESC		Account code description or title.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_STATUS		Current status of the associated account.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
BEGINNING_BALANCE		Calculated beginning balance amount for general ledger.	NUMBER		FUNCTION	FOKODSF.F_CALC_GL_ACTIVITY
CHART_OF_ACCOUNTS		Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)		FGBGENL	FGBGENL_COAS_CODE
CHART_OF_ACCOUNTS_DESC		Chart of accounts code description or title.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_STATUS		Extracted current status of the associated chart of accounts.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
CURRENT_ACTUAL		Calculated current general ledger actual amount.	NUMBER		CALCULATION	FGBGENL_SUM_PERIODIC_DR-FGBGENL_SUM_PERIODIC_CR
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ENDING_BALANCE		Calculated ending balance amount for general ledger.	NUMBER		FUNCTION	FOKODSF.F_CALC_GL_ACTIVITY
FISCAL_PERIOD		Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.	VARCHAR2(2)		FGBGENL	FGBGENL_PERIOD
FISCAL_YEAR		Unique identifier or code for the fiscal year.	VARCHAR2(4)		FUNCTION	FOFYCNV
FUND		Unique fiscal entity code.	VARCHAR2(6)		FGBGENL	FGBGENL_FUND_CODE
FUND_DESC		Description or title of the associated fund.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
FUND_STATUS		Extracted current status of the associated fund.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
SUM_PERIODIC_CREDITS	Sum Periodic Credits	Sum of all general ledger credit transactions for a given period of time.	NUMBER(17,2)		FGBGENL	FGBGENL_SUM_PERIODIC_CR
SUM_PERIODIC_DEBITS	Sum Periodic Debits	Sum of all general ledger debit transactions for a given period of time.	NUMBER(17,2)		FGBGENL	FGBGENL_SUM_PERIODIC_DR
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: