Target Column	Business Definition	Database Data Type	Source Name	Source Column
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
BILLED_AR_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
BUDGET_PERIOD_END_DATE	End date of the budget for this fund and grant.	DATE	FRVFUND	FRVFUND_BUDG_PRD_END_DATE
BUDGET_PERIOD_START_DATE	Start date of the budget for this fund and grant.	DATE	FRVFUND	FRVFUND_BUDG_PRD_START_DATE
CASH_RECEIPT_BANK	User defined bank code used on all cash transactions in grant billing.	VARCHAR2(2)	FTVFUND	FTVFUND_CASH_RECEIPT_BANK_CODE
CASH_RECEIPT_BANK_DESC	Name of the cash receipt bank code used for grant billing.	VARCHAR2(35)	GXVBANK	GXVBANK_ACCT_NAME
CASH_RECEIPT_BANK_UID	The internal identification number of the cash receipt bank for this fund.	NUMBER(8)	GXVBANK	GXVBANK_BANK_CODE_PIDM
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
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
CONSTRUCTION_PLANT_FUND_DESC	Retrieved description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
CONSTR_IN_PROGR_ACCOUNT	User defined account where the construction in progress is capitalized. Informational only.	VARCHAR2(6)	FTVFUND	FTVFUND_ACCT_CODE_CIP
CONSTR_IN_PROGR_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
CONSTR_PROJECT_COMPLETE_DATE	Construction project completion date. Informational only.	DATE	FTVFUND	FTVFUND_PROJ_COMPLETE_DATE
CONSTR_PROJECT_DESC	Construction project description.	VARCHAR2(35)	FTVFUND	FTVFUND_PROJ_DESC
CONSTR_PROJECT_END_DATE	Construction project end date. Informational only.	DATE	FTVFUND	FTVFUND_PROJ_END_DATE_CONP
CONSTR_PROJECT_FMGR_UID	Internally generated by the system to uniquely identify the person or entity.	NUMBER(8)	FTVFUND	FTVFUND_FMGR_CODE_PIDM_CONP
CONSTR_PROJECT_NUMBER	User defined number assigned to a construction project.	VARCHAR2(15)	FTVFUND	FTVFUND_CONP_PROJ_NUM
CONSTR_PROJECT_START_DATE	Construction project start date. Informational only.	DATE	FTVFUND	FTVFUND_PROJ_START_DATE_CONP
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
ESTIMATED_CUM_COST_AMOUNT	Value of the estimated total cost of the construction project.	NUMBER(17,2)	FTVFUND	FTVFUND_CUM_COST_AMT
FUND	Unique fiscal entity code.	VARCHAR2(6)	FTVFUND	FTVFUND_FUND_CODE
FUND_BANK	User-defined value which is used for identification purposes on all cash transactions.	VARCHAR2(2)	FTVFUND	FTVFUND_BANK_CODE
FUND_BANK_DESC	The name of the banking institution where the installment has accounts.		GXVBANK	GXVBANK_ACCT_NAME
FUND_BANK_UID	The internal identification number of the bank where the installment has accounts.		GXVBANK	GXVBANK_BANK_CODE_PIDM
FUND_COST_SHARE_BASE	Code defines the base information for cost share calculations.	VARCHAR2(6)	FRVFUND	FRVFUND_BASI_CODE_CS
FUND_COST_SHARE_BASE_DESC	Cost share code extracted description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC
FUND_COST_SHARE_CHARGE	Code defines account's and percentage of the charge.	VARCHAR2(6)	FRVFUND	FRVFUND_CSTA_CODE_CHARGE
FUND_COST_SHARE_CHARGE_DESC	Cost share credit code description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC
FUND_COST_SHARE_DISTRIB	Code defines the account distribution for indirect cost.	VARCHAR2(6)	FRVFUND	FRVFUND_CSTD_CODE_DISTR
FUND_COST_SHARE_DISTRIB_DESC	Cost share distribution code extracted description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC
FUND_COST_SHARE_RATE	Cost chart rate for this grant fund.	VARCHAR2(6)	FRVFUND	FRVFUND_CSTR_CODE_RATE
FUND_COST_SHARE_RATE_DESC	Cost share rate code description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC
FUND_DESC	Fund code description or title.	VARCHAR2(35)	FTVFUND	FTVFUND_TITLE
FUND_EXPENDITURE_END_DATE	Ending period date for expenditure activity.	DATE	FTVFUND	FTVFUND_EXPEND_END_DATE
FUND_INDIRECT_COST_BASE	Code used to define indirect cost calculations.	VARCHAR2(6)	FRVFUND	FRVFUND_BASI_CODE_IC
FUND_INDIRECT_COST_BASE_DESC	Indirect cost base code description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC
FUND_INDIRECT_COST_CHARGE	Code identifies the account's and the percentage of the charge.	VARCHAR2(6)	FRVFUND	FRVFUND_INDA_CODE_CHARGE
FUND_INDIRECT_COST_CHARGE_DESC	Indirect cost charge code description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC
FUND_INDIRECT_COST_DISTRI	Code identifies the accounting distribution for indirect cost.	VARCHAR2(6)	FRVFUND	FRVFUND_INDD_CODE_DISTR
FUND_INDIRECT_COST_DISTRI_DESC	Indirect cost distribution description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC
FUND_INDIRECT_COST_RATE	Indirect cost rate percentage for the grant fund.	VARCHAR2(6)	FRVFUND	FRVFUND_INDR_CODE_RATE
FUND_INDIRECT_COST_RATE_DESC	Indirect cost rate code description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC
FUND_PREDECESSOR	Next prior level fund associated with the fund code used to build a hierarchy.	VARCHAR2(6)	FTVFUND	FTVFUND_FUND_CODE_PRED
FUND_PREDECESSOR_DESC	Associated fund description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
FUND_STATUS	Current status of the associated fund.	VARCHAR2(1)	FTVFUND	FTVFUND_STATUS_IND
FUND_TERMINATION_DATE	Date when the fund is no longer in effect.	DATE	FTVFUND	FTVFUND_TERM_DATE
FUND_TYPE	Code that classifies a fiscal entity.	VARCHAR2(2)	FTVFUND	FTVFUND_FTYP_CODE
FUND_TYPE_DESC	Fund type code description or title.	VARCHAR2(35)	FTVFTYP	FTVFTYP_TITLE
GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(9)	FTVFUND	FTVFUND_GRNT_CODE
MAXIMUM_CONSTR_PROJECT_AMOUNT	Value of estimated funding for this construction project.	NUMBER(17,2)	FTVFUND	FTVFUND_MAX_CONSTR_AMT
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
PROJECT_CLOSE_IND	Determines if the construction project is closed. Informational only.	VARCHAR2(1)	FTVFUND	FTVFUND_CLOSE_PROJ_IND
PROPOSAL	Proposal submitted to the agency that has now been awarded this grant.	VARCHAR2(9)	FTVFUND	FTVFUND_PROP_CODE
PROPOSAL_LONG_TITLE	Long description or title of the grant proposal.	VARCHAR2(256)	FRBPROP	FRBPROP_LONG_TITLE
PROPOSAL_SHORT_TITLE	Short description or title of the grant proposal.	VARCHAR2(35)	FRBPROP	FRBPROP_TITLE
REVENUE_ACCRUAL_ACCOUNT	Revenue account code for this fund used for revenue recognition.	VARCHAR2(6)	FTVFUND	FTVFUND_ACCT_CODE_REV
REVENUE_ACCRUAL_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
SOURCE_FUND	Identification of the source of funds for the construction project. Informational only.	VARCHAR2(6)	FTVFUND	FTVFUND_FUND_CODE_SOURCE
SOURCE_FUND_DESC	Retrieves description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
UNBILLED_ACCRUAL_ACCOUNT	Unbilled accrual account for this fund used for revenue recognition.	VARCHAR2(6)	FTVFUND	FTVFUND_ACCT_CODE_ACCR
UNBILLED_ACCRUAL_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
WITHHOLDING_AMOUNT	Amount to withhold from the billed agency.	NUMBER(17,2)	FRVFUND	FRVFUND_WITHHOLDING_AMT
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
WITHHOLDING_AR_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
WITHHOLDING_PERCENT	Percent of the amount to be debited to the withholding receivable account for each bill generated.	NUMBER(7, 4)	FRVFUND	FRVFUND_WITHHOLDING_PERCENT
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