Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AGENCY_ADDRESS	Address type associated with this agency.	VARCHAR2(63)	FRBGRNT	FRBGRNT_AGENCY_ADDR_CODE	NO	NO
AGENCY_ADDRESS_SEQUENCE_NUMBER	Sequence number associated with this address type to uniquely identify the address.	NUMBER	FRBGRNT	FRBGRNT_AGENCY_ADDR_SEQ_NUM	NO	NO
AGENCY_COMMITMENT_AMOUNT	Maximum amount of money the agency commits to the grant. Informational only.	NUMBER	FRBGRNT	FRBGRNT_MAX_FUNDING_AMT	NO	NO
AGENCY_CONTACT	Name of the person to contact at the agency.	VARCHAR2(63)	FRBGRNT	FRBGRNT_AGENCY_CONTACT	NO	NO
AGENCY_EMAIL	Email address for the agency contact.	VARCHAR2(255)	FRBGRNT	FRBGRNT_AGENCY_EMAIL	NO	NO
AGENCY_ID	System generated or manually assigned id to uniquely identify an agency.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
AGENCY_NAME	Name of the agency.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
AGENCY_PHONE_TYPE	Phone type associated with this agency.	VARCHAR2(63)	FRBGRNT	FRBGRNT_AGENCY_PHONE_TYPE	NO	NO
AGENCY_TELEPHONE_SEQ_NUMBER	Sequence number associated with this phone type to uniquely identify the phone number.	NUMBER	FRBGRNT	FRBGRNT_AGENCY_TELE_SEQNO	NO	NO
AGENCY_UID	System generated unique internal identification number assigned to this organization entity.	NUMBER	FRBGRNT	FRBGRNT_AGENCY_PIDM	NO	NO
ALTERNATE_STATUS_DESC	Alternate status description.	VARCHAR2(255)	FRBGRNT	FRBGRNT_ALTERNATE_STATUS_DESC	NO	NO
BILLED_AR_ACCOUNT	User defined account code to hold billing receivables once the granting agency is billed.	VARCHAR2(63)	FRVFUND	FRVFUND_BILLED_AR_ACCT_CODE	NO	NO
BILLED_AR_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(255)	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(63)	FTVFUND	FTVFUND_CASH_RECEIPT_BANK_CODE	NO	NO
CASH_RECEIPT_BANK_DESC	Name of the cash receipt bank code used for grant billing.	VARCHAR2(255)	GXVBANK	GXVBANK_ACCT_NAME	NO	NO
CASH_RECEIPT_BANK_ID	ID of the bank where the installment has accounts.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
CASH_RECEIPT_BANK_NAME	Name of the banking institution where the installment has accounts.	VARCHAR2(255)	GXVBANK SPRIDEN	GXVBANK_ACCT_NAME SPRIDEN_LAST_NAME	NO NO	NO
CASH_RECEIPT_BANK_UID	The internal identification number of the bank where the installment has accounts.	NUMBER	GXVBANK	GXVBANK_BANK_CODE_PIDM	NO	NO
CATEGORY	Identifies sponsored programs category. Examples, federal, non-federal.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CATEGORY	NO	NO
CATEGORY_DESC	Grant category description.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_COST	Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment specifically pertaining to Indirect cost and cost share codes.	VARCHAR2(63)	FRBGRNT	FRBGRNT_COAS_CODE_IC_CS	NO	NO
CHART_OF_ACCOUNTS_COST_DESC	Chart of accounts extracted description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CHART_OF_ACCOUNTS_COST_STATUS	Status of the chart of accounts cost.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CHART_OF_ACCOUNTS_STATUS	Status of the chart of account.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND	NO	NO
CONSTRUCTION_PLANT_FUND	User identified fund where the asset resulting from the construction project is capitalized. Information only.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE_PLANT_CONP	NO	NO
CONSTRUCTION_PLANT_FUND_DESC	Retrieved description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CONSTR_IN_PROGR_ACCOUNT	User defined account where the construction in progress is capitalized. Informational only.	VARCHAR2(63)	FTVFUND	FTVFUND_ACCT_CODE_CIP	NO	NO
CONSTR_IN_PROGR_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(255)	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(255)	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_FIRST_NAME	Extracted first name of the construction project manager.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
CONSTR_PROJECT_FMGR_ID	Extracted identification of the construction project manager.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
CONSTR_PROJECT_FMGR_LAST_NAME	Extracted last name of the construction project manager.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
CONSTR_PROJECT_FMGR_MID_NAME	Extracted middle name of the construction project manager.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	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(255)	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
COST_SHARE_BASE	Code defines the base information for cost share calculations.	VARCHAR2(63)	FRBGRNT	FRBGRNT_BASI_CODE_CS	NO	NO
COST_SHARE_BASE_DESC	Cost share base description.	VARCHAR2(255)	FRVBASI	FRVBASI_DESC	NO	NO
COST_SHARE_CHARGE	Code defines account's and percentage of the charge.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CSTA_CODE_CHARGE	NO	NO
COST_SHARE_CHARGE_DESC	Cost share charge description.	VARCHAR2(255)	FRVCSTA	FRVCSTA_DESC	NO	NO
COST_SHARE_DISTRIBUTION	Code defines the account distribution for indirect cost.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CSTD_CODE_DISTR	NO	NO
COST_SHARE_DISTRIBUTION_DESC	Cost share distribution description.	VARCHAR2(255)	FRVCSTD	FRVCSTD_DESC	NO	NO
COST_SHARE_RATE	Cost share rate for this grant.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CSTR_CODE_RATE	NO	NO
COST_SHARE_RATE_DESC	Cost share rate description.	VARCHAR2(255)	FRVCSTR	FRVCSTR_DESC	NO	NO
CUMULATIVE_AMOUNT	Cumulative funding amount of the grant, received from the agency to date. Informational only.	NUMBER	FRBGRNT	FRBGRNT_CUM_FUNDING_AMT	NO	NO
CURRENT_YEAR_AMOUNT	Current year funding amount of the grant, committed by the agency. Informational only.	NUMBER	FRBGRNT	FRBGRNT_CURRENT_FUNDING_AMT	NO	NO
ESTIMATED_CUM_COST_AMOUNT	Value of the estimated total cost of the construction project.	NUMBER	FTVFUND	FTVFUND_CUM_COST_AMT	NO	NO
EXPENDITURE_END_DATE	Ending period date for expenditure activity.	DATE	FRBGRNT	FRBGRNT_EXPEND_END_DATE	NO	NO
FEDERAL_IDENTIFICATION	Identifies the Catalog of Federal Domestic Assistance code.	VARCHAR2(63)	FRVCFDA	FRVCFDA_CFDA_CODE	NO	NO
FEDERAL_IDENTIFICATION_DESC	Description of the Catalog of Federal Domestic Assistance.	VARCHAR2(255)	FRVCFDA	FRVCFDA_TITLE	NO	NO
FEDERAL_IDENTIFICATION_UID	System generated unique internal identification number assigned to the Catalog of Federal Domestic Assistance code.	NUMBER	FRBGRNT	FRBGRNT_CFDA_INTERNAL_ID_NO	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE	NO	NO
FUND_BANK	User-defined value which is used for identification purposes on all cash transactions.	VARCHAR2(63)	FTVFUND	FTVFUND_BANK_CODE	NO	NO
FUND_BANK_DESC	The name of the banking institution where the installment has accounts.	VARCHAR2(255)	GXVBANK	GXVBANK_ACCT_NAME	NO	NO
FUND_BANK_ID	ID of the bank where the installment has accounts.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
FUND_BANK_NAME	Name of the banking institution where the installment has accounts.	VARCHAR2(255)	GXVBANK SPRIDEN	GXVBANK_ACCT_NAME SPRIDEN_LAST_NAME	NO NO	NO
FUND_BANK_UID	The internal identification number of the bank where the installment has accounts.	NUMBER	GXVBANK	GXVBANK_BANK_CODE_PIDM	NO	NO
FUND_COST_SHARE_BASE	Code defines the base information for cost share calculations.	VARCHAR2(63)	FRVFUND	FRVFUND_BASI_CODE_CS	NO	NO
FUND_COST_SHARE_BASE_DESC	Cost share code extracted description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_COST_SHARE_CHARGE	Code defines account's and percentage of the charge.	VARCHAR2(63)	FRVFUND	FRVFUND_CSTA_CODE_CHARGE	NO	NO
FUND_COST_SHARE_CHARGE_DESC	Cost share credit code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_COST_SHARE_DISTRIB	Code defines the account distribution for indirect cost.	VARCHAR2(63)	FRVFUND	FRVFUND_CSTD_CODE_DISTR	NO	NO
FUND_COST_SHARE_DISTRIB_DESC	Cost share distribution code extracted description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_COST_SHARE_RATE	Cost chart rate for this grant fund.	VARCHAR2(63)	FRVFUND	FRVFUND_CSTR_CODE_RATE	NO	NO
FUND_COST_SHARE_RATE_DESC	Cost share rate code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_DESC	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE	NO	NO
FUND_EXPENDITURE_END_DATE	Ending period date for expenditure activity.	DATE	FTVFUND	FTVFUND_EXPEND_END_DATE	NO	NO
FUND_FINANCIAL_MANAGER_ID	System generated or manually assigned ID that uniquely identifies the financial manager.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID	NO NO	NO
FUND_FINANCIAL_MANAGER_NAME	Combination of the person's last name, first name, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
FUND_FINANCIAL_MANAGER_UID	System generated, unique, internal identification number assigned to the financial manager associated with this fund.	NUMBER	FTVFUND	FTVFUND_FMGR_CODE_PIDM	NO	NO
FUND_FMGR_CITY	City associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
FUND_FMGR_COUNTY	County code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
FUND_FMGR_COUNTY_DESC	County address name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_FMGR_FIRST_NAME	Financial manager's first or given name.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_FIRST_NAME	NO NO	NO
FUND_FMGR_LAST_NAME	Fund manager's last name or surname.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME	NO NO	NO
FUND_FMGR_MIDDLE_NAME	Financial manager's middle name.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_MI	NO NO	NO
FUND_FMGR_NATION	Nation code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
FUND_FMGR_NATION_DESC	Name of the nation.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
FUND_FMGR_POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
FUND_FMGR_STATE_PROVINCE	State/Province code for the address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
FUND_FMGR_STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
FUND_FMGR_STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
FUND_FMGR_STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
FUND_FMGR_STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
FUND_FMGR_STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO
FUND_INDIRECT_COST_BASE	Code used to define indirect cost calculations.	VARCHAR2(63)	FRVFUND	FRVFUND_BASI_CODE_IC	NO	NO
FUND_INDIRECT_COST_BASE_DESC	Indirect cost base code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_INDIRECT_COST_CHARGE	Code identifies the account's and the percentage of the charge.	VARCHAR2(63)	FRVFUND	FRVFUND_INDA_CODE_CHARGE	NO	NO
FUND_INDIRECT_COST_CHARGE_DESC	Indirect cost charge code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_INDIRECT_COST_DISTRI	Code identifies the accounting distribution for indirect cost.	VARCHAR2(63)	FRVFUND	FRVFUND_INDD_CODE_DISTR	NO	NO
FUND_INDIRECT_COST_DISTRI_DESC	Indirect cost distribution description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_INDIRECT_COST_RATE	Indirect cost rate percentage for the grant fund.	VARCHAR2(63)	FRVFUND	FRVFUND_INDR_CODE_RATE	NO	NO
FUND_INDIRECT_COST_RATE_DESC	Indirect cost rate code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_PREDECESSOR	Next prior level fund associated with the fund code used to build a hierarchy.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE_PRED	NO	NO
FUND_PREDECESSOR_DESC	Associated fund description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
FUND_STATUS	Current status of the associated fund.	VARCHAR2(63)	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(63)	FTVFUND	FTVFUND_FTYP_CODE	NO	NO
FUND_TYPE_DESC	Fund type code description or title.	VARCHAR2(255)	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(63)	FRVFUND	FRVFUND_USER_ID	NO	NO
GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CODE	NO	NO
GRANT_LONG_TITLE	Grant long title or description.	VARCHAR2(256)	FRBGRNT	FRBGRNT_LONG_TITLE	NO	NO
GRANT_SHORT_TITLE	Shortened name or title for the grant.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE	NO	NO
GRANT_TERMINATION_DATE	Date when this grant is no longer in effect. The time between the project end date and termination date defines the trail out period.	DATE	FRBGRNT	FRBGRNT_TERM_DATE	NO	NO
GRANT_TYPE	Grant type code to reflect if this is a grant, contract, cooperative agreement, etc.	VARCHAR2(63)	FRBGRNT	FRBGRNT_GRANT_TYPE	NO	NO
GRANT_TYPE_DESC	Retrieved description for grant type.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
INDIRECT_COST_BASE	Code used to define indirect cost calculations.	VARCHAR2(63)	FRBGRNT	FRBGRNT_BASI_CODE_IC	NO	NO
INDIRECT_COST_BASE_DESC	Indirect cost base code description.	VARCHAR2(255)	FRVBASI	FRVBASI_DESC	NO	NO
INDIRECT_COST_CHARGE	Code identifies the account's and the percentage of the charge.	VARCHAR2(63)	FRBGRNT	FRBGRNT_INDA_CODE_CHARGE	NO	NO
INDIRECT_COST_CHARGE_DESC	Indirect cost charge code description.	VARCHAR2(255)	FRVINDA	FRVINDA_DESC	NO	NO
INDIRECT_COST_DISTRIBUTION	Code identifies the accounting distribution for indirect cost.	VARCHAR2(63)	FRBGRNT	FRBGRNT_INDD_CODE_DISTR	NO	NO
INDIRECT_COST_DISTRIB_DESC	Indirect cost distribution description.	VARCHAR2(255)	FRVINDD	FRVINDD_DESC	NO	NO
INDIRECT_COST_RATE	Indirect cost rate percentage for this grant.	VARCHAR2(63)	FRBGRNT	FRBGRNT_INDR_CODE_RATE	NO	NO
INDIRECT_COST_RATE_DESC	Indirect cost rate code description.	VARCHAR2(255)	FRVINDR	FRVINDR_DESC	NO	NO
MAXIMUM_CONSTR_PROJECT_AMOUNT	Value of estimated funding for this construction project.	NUMBER	FTVFUND	FTVFUND_MAX_CONSTR_AMT	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	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
PRINCIPAL_INVESTIGATOR_FNAME	Current first name of the principal investigator.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME	NO NO	NO
PRINCIPAL_INVESTIGATOR_ID	Current identification number of the principal investigator.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID	NO NO	NO
PRINCIPAL_INVESTIGATOR_LNAME	Current last name of the principal investigator.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_FIRST_NAME	NO NO	NO
PRINCIPAL_INVESTIGATOR_MNAME	Current middle name of the principal investigator.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_MI	NO NO	NO
PRINCIPAL_INVESTIGATOR_NAME	Combination of the person's last name, first name, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PRINCIPAL_INVESTIGATOR_TITLE	Official position/title that belongs to the principal investigator.	VARCHAR2(255)	FRRGRPI	FRRGRPI_TITLE	NO	NO
PRINCIPAL_INVESTIGATOR_UID	System internally generated id to uniquely identify the principal investigator for this grant.	NUMBER	FRBGRNT	FRBGRNT_PI_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROJECT_CLOSE_IND	Determines if the construction project is closed or not. Informational only.	VARCHAR2(63)	FTVFUND	FTVFUND_CLOSE_PROJ_IND	NO	NO
PROJECT_END_DATE	End date is the last day of the grant period.	DATE	FRBGRNT	FRBGRNT_PROJECT_END_DATE	NO	NO
PROJECT_START_DATE	Date the agency awarded the grant.	DATE	FRBGRNT	FRBGRNT_PROJECT_START_DATE	NO	NO
PROPOSAL	Proposal submitted to the agency that has now been awarded this grant.	VARCHAR2(63)	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(255)	FRBPROP	FRBPROP_TITLE	NO	NO
RELATED_GRANT	Grant code of a prior defined grant used to copy data from into this grant.	VARCHAR2(63)	FRBGRNT	FRBGRNT_GRNT_CODE_RELATED	NO	NO
RESPONSIBLE_ORGANIZATION_CODE	Organization code of the responsible administrative office for this grant.	VARCHAR2(63)	FRBGRNT	FRBGRNT_ORGN_CODE_RESP_OFFICE	NO	NO
RESPONSIBLE_ORGANIZATION_DESC	Retrieved description or title of the associated organization.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
RESPONSIBLE_ORGN_STATUS	Current status of the associated organization.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
REVENUE_ACCRUAL_ACCOUNT	Revenue account code for this fund used for revenue recognition.	VARCHAR2(63)	FTVFUND	FTVFUND_ACCT_CODE_REV	NO	NO
REVENUE_ACCRUAL_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
SOURCE_FUND	Identification of the source of funds for the construction project. Informational only.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE_SOURCE	NO	NO
SOURCE_FUND_DESC	Retrieve description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
SPONSOR_NUMBER	Sponsor agency's reference number.	VARCHAR2(63)	FRBGRNT	FRBGRNT_SPONSOR_ID	NO	NO
STATUS	Status of the grant, with most common values as Inactive or Active.	VARCHAR2(63)	FRBGRNT	FRBGRNT_STATUS_CODE	NO	NO
STATUS_DATE	Last date a status change occurred for this grant.	DATE	FRBGRNT	FRBGRNT_STATUS_DATE	NO	NO
STATUS_DESC	Retrieved description for grant status.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
STATUS_FISCAL_PERIOD	Extracted fiscal period in which the last status date occurred.	VARCHAR2(63)	FUNCTION	F_GET_FISCAL_PERIOD	NO	NO
STATUS_FISCAL_YEAR	Extracted fiscal year in which the last status date occurred.	VARCHAR2(63)	FUNCTION	FOFYCNV	NO	NO
SUBCATEGORY	Sub category code for grant and proposal classification such as corporation, foundation, state, etc.	VARCHAR2(63)	FRBGRNT	FRBGRNT_SUB_CATEGORY	NO	NO
SUBCATEGORY_DESC	Retrieved description for grant or proposal sub category.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
UNBILLED_ACCRUAL_ACCOUNT	Unbilled accrual account for this fund used for revenue recognition.	VARCHAR2(63)	FTVFUND	FTVFUND_ACCT_CODE_ACCR	NO	NO
UNBILLED_ACCRUAL_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(255)	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(63)	FRVFUND	FRVFUND_WHOLDING_AR_ACCT_CODE	NO	NO
WITHHOLDING_AR_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(255)	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

Ver: 9.2