Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
BILLED_AR_ACCOUNT	User defined account code to hold billing receivables once the granting agency is billed.	VARCHAR2(6)	FRVFUND	FRVFUND_BILLED_AR_ACCT_CODE	NO	NO
BILLED_AR_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
BUDGET_PERIOD_END_DATE	End date of the budget for this fund and grant.	DATE	FRVFUND	FRVFUND_BUDG_PRD_END_DATE	NO	NO
BUDGET_PERIOD_START_DATE	Start date of the budget for this fund and grant.	DATE	FRVFUND	FRVFUND_BUDG_PRD_START_DATE	NO	NO
CASH_RECEIPT_BANK	User defined bank code used on all cash transactions in grant billing.	VARCHAR2(2)	FTVFUND	FTVFUND_CASH_RECEIPT_BANK_CODE	NO	NO
CASH_RECEIPT_BANK_DESC	Name of the cash receipt bank code used for grant billing.	VARCHAR2(35)	GXVBANK	GXVBANK_ACCT_NAME	NO	NO
CASH_RECEIPT_BANK_UID	The internal identification number of the cash receipt bank for this fund.	NUMBER	GXVBANK	GXVBANK_BANK_CODE_PIDM	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FTVFUND	FTVFUND_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CONSTRUCTION_PLANT_FUND	User identified fund where the asset resulting from the construction project is capitalized. Information only.	VARCHAR2(6)	FTVFUND	FTVFUND_FUND_CODE_PLANT_CONP	NO	NO
CONSTRUCTION_PLANT_FUND_DESC	Retrieved description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CONSTR_IN_PROGR_ACCOUNT	User defined account where the construction in progress is capitalized. Informational only.	VARCHAR2(6)	FTVFUND	FTVFUND_ACCT_CODE_CIP	NO	NO
CONSTR_IN_PROGR_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CONSTR_PROJECT_COMPLETE_DATE	Construction project completion date. Informational only.	DATE	FTVFUND	FTVFUND_PROJ_COMPLETE_DATE	NO	NO
CONSTR_PROJECT_DESC	Construction project description.	VARCHAR2(35)	FTVFUND	FTVFUND_PROJ_DESC	NO	NO
CONSTR_PROJECT_END_DATE	Construction project end date. Informational only.	DATE	FTVFUND	FTVFUND_PROJ_END_DATE_CONP	NO	NO
CONSTR_PROJECT_FMGR_UID	Internally generated by the system to uniquely identify the person or entity.	NUMBER	FTVFUND	FTVFUND_FMGR_CODE_PIDM_CONP	NO	NO
CONSTR_PROJECT_NUMBER	User defined number assigned to a construction project.	VARCHAR2(15)	FTVFUND	FTVFUND_CONP_PROJ_NUM	NO	NO
CONSTR_PROJECT_START_DATE	Construction project start date. Informational only.	DATE	FTVFUND	FTVFUND_PROJ_START_DATE_CONP	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
ESTIMATED_CUM_COST_AMOUNT	Value of the estimated total cost of the construction project.	NUMBER	FTVFUND	FTVFUND_CUM_COST_AMT	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	FTVFUND	FTVFUND_FUND_CODE	NO	NO
FUND_BANK	User-defined value which is used for identification purposes on all cash transactions.	VARCHAR2(2)	FTVFUND	FTVFUND_BANK_CODE	NO	NO
FUND_BANK_DESC	The name of the banking institution where the installment has accounts.		GXVBANK	GXVBANK_ACCT_NAME	NO	NO
FUND_BANK_UID	The internal identification number of the bank where the installment has accounts.		GXVBANK	GXVBANK_BANK_CODE_PIDM	NO	NO
FUND_COST_SHARE_BASE	Code defines the base information for cost share calculations.	VARCHAR2(6)	FRVFUND	FRVFUND_BASI_CODE_CS	NO	NO
FUND_COST_SHARE_BASE_DESC	Cost share code extracted description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_COST_SHARE_CHARGE	Code defines account's and percentage of the charge.	VARCHAR2(6)	FRVFUND	FRVFUND_CSTA_CODE_CHARGE	NO	NO
FUND_COST_SHARE_CHARGE_DESC	Cost share credit code description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_COST_SHARE_DISTRIB	Code defines the account distribution for indirect cost.	VARCHAR2(6)	FRVFUND	FRVFUND_CSTD_CODE_DISTR	NO	NO
FUND_COST_SHARE_DISTRIB_DESC	Cost share distribution code extracted description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_COST_SHARE_RATE	Cost chart rate for this grant fund.	VARCHAR2(6)	FRVFUND	FRVFUND_CSTR_CODE_RATE	NO	NO
FUND_COST_SHARE_RATE_DESC	Cost share rate code description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_DESC	Fund code description or title.	VARCHAR2(35)	FTVFUND	FTVFUND_TITLE	NO	NO
FUND_EXPENDITURE_END_DATE	Ending period date for expenditure activity.	DATE	FTVFUND	FTVFUND_EXPEND_END_DATE	NO	NO
FUND_INDIRECT_COST_BASE	Code used to define indirect cost calculations.	VARCHAR2(6)	FRVFUND	FRVFUND_BASI_CODE_IC	NO	NO
FUND_INDIRECT_COST_BASE_DESC	Indirect cost base code description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_INDIRECT_COST_CHARGE	Code identifies the account's and the percentage of the charge.	VARCHAR2(6)	FRVFUND	FRVFUND_INDA_CODE_CHARGE	NO	NO
FUND_INDIRECT_COST_CHARGE_DESC	Indirect cost charge code description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_INDIRECT_COST_DISTRI	Code identifies the accounting distribution for indirect cost.	VARCHAR2(6)	FRVFUND	FRVFUND_INDD_CODE_DISTR	NO	NO
FUND_INDIRECT_COST_DISTRI_DESC	Indirect cost distribution description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_INDIRECT_COST_RATE	Indirect cost rate percentage for the grant fund.	VARCHAR2(6)	FRVFUND	FRVFUND_INDR_CODE_RATE	NO	NO
FUND_INDIRECT_COST_RATE_DESC	Indirect cost rate code description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_PREDECESSOR	Next prior level fund associated with the fund code used to build a hierarchy.	VARCHAR2(6)	FTVFUND	FTVFUND_FUND_CODE_PRED	NO	NO
FUND_PREDECESSOR_DESC	Associated fund description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
FUND_STATUS	Current status of the associated fund.	VARCHAR2(1)	FTVFUND	FTVFUND_STATUS_IND	NO	NO
FUND_TERMINATION_DATE	Date when the fund is no longer in effect.	DATE	FTVFUND	FTVFUND_TERM_DATE	NO	NO
FUND_TYPE	Fund type code to be associated with the fund as defined by the institution.	VARCHAR2(2)	FTVFUND	FTVFUND_FTYP_CODE	NO	NO
FUND_TYPE_DESC	Fund type code description or title.	VARCHAR2(35)	FTVFTYP	FTVFTYP_TITLE	NO	NO
GRANT_FUND_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	FRVFUND	FRVFUND_ACTIVITY_DATE	NO	NO
GRANT_FUND_USER_ID	Unique identification code of the user who entered or last updated the grant fund.	VARCHAR2(30)	FRVFUND	FRVFUND_USER_ID	NO	NO
GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(9)	FTVFUND	FTVFUND_GRNT_CODE	NO	NO
MAXIMUM_CONSTR_PROJECT_AMOUNT	Value of estimated funding for this construction project.	NUMBER	FTVFUND	FTVFUND_MAX_CONSTR_AMT	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
MULTI_YEAR_ENCUMBRANCE_IND	Indicates whether multi-year labor encumbering is utilized with a fund/grant combination.	VARCHAR2(1)	FRVFUND	FRVFUND_ENC_MULT_YEAR_IND	NO	NO
PROJECT_CLOSE_IND	Determines if the construction project is closed. Informational only.	VARCHAR2(1)	FTVFUND	FTVFUND_CLOSE_PROJ_IND	NO	NO
PROPOSAL	Proposal submitted to the agency that has now been awarded this grant.	VARCHAR2(9)	FTVFUND	FTVFUND_PROP_CODE	NO	NO
PROPOSAL_LONG_TITLE	Long description or title of the grant proposal.	VARCHAR2(256)	FRBPROP	FRBPROP_LONG_TITLE	NO	NO
PROPOSAL_SHORT_TITLE	Short description or title of the grant proposal.	VARCHAR2(35)	FRBPROP	FRBPROP_TITLE	NO	NO
REVENUE_ACCRUAL_ACCOUNT	Revenue account code for this fund used for revenue recognition.	VARCHAR2(6)	FTVFUND	FTVFUND_ACCT_CODE_REV	NO	NO
REVENUE_ACCRUAL_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
SOURCE_FUND	Identification of the source of funds for the construction project. Informational only.	VARCHAR2(6)	FTVFUND	FTVFUND_FUND_CODE_SOURCE	NO	NO
SOURCE_FUND_DESC	Retrieves description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
UNBILLED_ACCRUAL_ACCOUNT	Unbilled accrual account for this fund used for revenue recognition.	VARCHAR2(6)	FTVFUND	FTVFUND_ACCT_CODE_ACCR	NO	NO
UNBILLED_ACCRUAL_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
WITHHOLDING_AMOUNT	Amount to withhold from the billed agency.	NUMBER	FRVFUND	FRVFUND_WITHHOLDING_AMT	NO	NO
WITHHOLDING_AR_ACCOUNT	User defined account code to hold withholding billing receivables once the granting agency is billed.	VARCHAR2(6)	FRVFUND	FRVFUND_WHOLDING_AR_ACCT_CODE	NO	NO
WITHHOLDING_AR_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
WITHHOLDING_PERCENT	Percent of the amount to be debited to the withholding receivable account for each bill generated.	NUMBER	FRVFUND	FRVFUND_WITHHOLDING_PERCENT	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: