Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	Estimated Cumulative 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_FUND_ACTIVITY_DATE	Grant Fund Activity Date	Date that information for this record in the table was entered or last updated.	DATE		FRVFUND	FRVFUND_ACTIVITY_DATE
GRANT_FUND_USER_ID	Grant Fund User ID	Unique identification code of the user who entered or last updated the grant fund.	VARCHAR2(30)		FRVFUND	FRVFUND_USER_ID
GRANT_ID		Unique user defined or system generated one-up number for this grant.	VARCHAR2(9)		FTVFUND	FTVFUND_GRNT_CODE
MAXIMUM_CONSTR_PROJECT_AMOUNT	Maximum Construction 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
MULTI_YEAR_ENCUMBRANCE_IND	Multi Year Encumbrance Indicator	Indicates whether multi-year labor encumbering is utilized with a fund/grant combination.	VARCHAR2(1)		FRVFUND	FRVFUND_ENC_MULT_YEAR_IND
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	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: