Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

Banner Operational Data Store
Reporting View Target: GRANT_FUND

Description Contains all fund information associated to a grant as well as the general grant information. Multiple funds can be associated to one grant at any one point in time and/or over a period of time. Also lists grant indirect cost and cost share codes versus fund indirect cost and cost share codes.
Key & Frequency One row per grant ID per chart of accounts per fund.
Recommended Search Columns CHART_OF_ACCOUNTS, FUND
GRANT_ID, CHART_OF_ACCOUNTS, FUND
AGENCY_UID
CHART_OF_ACCOUNTS, ORGANIZATION_CODE

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