Target Column	Business Definition	Database Data Type	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_PERIOD_STATUS	Extracted status of the accounting period which indicates ability to accept posting activity.	VARCHAR2(1)	FUNCTION	F_GET_FSPD_STATUS
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 of all general ledger credit transactions for a given period of time.	NUMBER(17,2)	FGBGENL	FGBGENL_SUM_PERIODIC_CR
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: 8.1