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 Name Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AGENCY_ADDRESS Agency Address Address type associated with this agency. VARCHAR2(63)

FRBGRNT

FRBGRNT_AGENCY_ADDR_CODE

AGENCY_ADDRESS_SEQUENCE_NUMBER Agency Address Sequence Number Sequence number associated with this address type to uniquely identify the address. NUMBER

FRBGRNT

FRBGRNT_AGENCY_ADDR_SEQ_NUM

AGENCY_COMMITMENT_AMOUNT Agency Commitment Amount Maximum amount of money the agency commits to the grant. Informational only. NUMBER

FRBGRNT

FRBGRNT_MAX_FUNDING_AMT

AGENCY_CONTACT Agency Contact Name of the person to contact at the agency. VARCHAR2(63)

FRBGRNT

FRBGRNT_AGENCY_CONTACT

AGENCY_EMAIL Agency Email Email address for the agency contact. VARCHAR2(255)

FRBGRNT

FRBGRNT_AGENCY_EMAIL

AGENCY_ID Agency ID System generated or manually assigned id to uniquely identify an agency. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

AGENCY_NAME Agency Name Name of the agency. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_PHONE_TYPE Agency Phone Type Phone type associated with this agency. VARCHAR2(63)

FRBGRNT

FRBGRNT_AGENCY_PHONE_TYPE

AGENCY_TELEPHONE_SEQ_NUMBER Agency Telephone Sequence Number Sequence number associated with this phone type to uniquely identify the phone number. NUMBER

FRBGRNT

FRBGRNT_AGENCY_TELE_SEQNO

AGENCY_UID Agency UID System generated unique internal identification number assigned to this organization entity. NUMBER

FRBGRNT

FRBGRNT_AGENCY_PIDM

ALTERNATE_STATUS_DESC Alternate Status Description Alternate status description. VARCHAR2(255)

FRBGRNT

FRBGRNT_ALTERNATE_STATUS_DESC

BILLED_AR_ACCOUNT 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

BILLED_AR_ACCOUNT_DESC Billed Ar Account Description Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

BUDGET_PERIOD_END_DATE 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 Budget Period Start Date Start date of the budget for this fund and grant. DATE

FRVFUND

FRVFUND_BUDG_PRD_START_DATE

CASH_RECEIPT_BANK Cash Receipt Bank User defined bank code used on all cash transactions in grant billing. VARCHAR2(63)

FTVFUND

FTVFUND_CASH_RECEIPT_BANK_CODE

CASH_RECEIPT_BANK_DESC Cash Receipt Bank Description Name of the cash receipt bank code used for grant billing. VARCHAR2(255)

GXVBANK

GXVBANK_ACCT_NAME

CASH_RECEIPT_BANK_ID Cash Receipt Bank ID ID of the bank where the installment has accounts. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

CASH_RECEIPT_BANK_NAME Cash Receipt Bank Name Name of the banking institution where the installment has accounts. VARCHAR2(255)

GXVBANK

SPRIDEN

GXVBANK_ACCT_NAME

SPRIDEN_LAST_NAME

CASH_RECEIPT_BANK_UID Cash Receipt Bank UID The internal identification number of the bank where the installment has accounts. NUMBER

GXVBANK

GXVBANK_BANK_CODE_PIDM

CATEGORY Category Identifies sponsored programs category. Examples, federal, non-federal. VARCHAR2(63)

FRBGRNT

FRBGRNT_CATEGORY

CATEGORY_DESC Category Description Grant category description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

CHART_OF_ACCOUNTS Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS_COST 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

CHART_OF_ACCOUNTS_COST_DESC Chart Of Accounts Cost Description Chart of accounts extracted description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_COST_STATUS Chart Of Accounts Cost Status Status of the chart of accounts cost. VARCHAR2(63)

FTVCOAS

FTVCOAS_STATUS_IND

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Status of the chart of account. VARCHAR2(63)

FTVCOAS

FTVCOAS_STATUS_IND

CONSTRUCTION_PLANT_FUND 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

CONSTRUCTION_PLANT_FUND_DESC Construction Plant Fund Description Retrieved description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CONSTR_IN_PROGR_ACCOUNT Constr IN Progr Account User defined account where the construction in progress is capitalized. Informational only. VARCHAR2(63)

FTVFUND

FTVFUND_ACCT_CODE_CIP

CONSTR_IN_PROGR_ACCOUNT_DESC Constr IN Progr Account Description Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CONSTR_PROJECT_COMPLETE_DATE Constr Project Complete Date Construction project completion date. Informational only. DATE

FTVFUND

FTVFUND_PROJ_COMPLETE_DATE

CONSTR_PROJECT_DESC Constr Project Description Construction project description. VARCHAR2(255)

FTVFUND

FTVFUND_PROJ_DESC

CONSTR_PROJECT_END_DATE Constr Project End Date Construction project end date. Informational only. DATE

FTVFUND

FTVFUND_PROJ_END_DATE_CONP

CONSTR_PROJECT_FMGR_FIRST_NAME Construction Project Financial Manager First Name Extracted first name of the construction project manager. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

CONSTR_PROJECT_FMGR_ID Construction Project Financial Manager ID Extracted identification of the construction project manager. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

CONSTR_PROJECT_FMGR_LAST_NAME Construction Project Financial Manager Last Name Extracted last name of the construction project manager. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

CONSTR_PROJECT_FMGR_MID_NAME Construction Project Financial Manager Mid Name Extracted middle name of the construction project manager. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

CONSTR_PROJECT_FMGR_UID Constr Project Fmgr UID Internally generated by the system to uniquely identify the person or entity. NUMBER

FTVFUND

FTVFUND_FMGR_CODE_PIDM_CONP

CONSTR_PROJECT_NUMBER Constr Project Number User defined number assigned to a construction project. VARCHAR2(255)

FTVFUND

FTVFUND_CONP_PROJ_NUM

CONSTR_PROJECT_START_DATE Constr Project Start Date Construction project start date. Informational only. DATE

FTVFUND

FTVFUND_PROJ_START_DATE_CONP

COST_SHARE_BASE Cost Share Base Code defines the base information for cost share calculations. VARCHAR2(63)

FRBGRNT

FRBGRNT_BASI_CODE_CS

COST_SHARE_BASE_DESC Cost Share Base Description Cost share base description. VARCHAR2(255)

FRVBASI

FRVBASI_DESC

COST_SHARE_CHARGE Cost Share Charge Code defines account's and percentage of the charge. VARCHAR2(63)

FRBGRNT

FRBGRNT_CSTA_CODE_CHARGE

COST_SHARE_CHARGE_DESC Cost Share Charge Description Cost share charge description. VARCHAR2(255)

FRVCSTA

FRVCSTA_DESC

COST_SHARE_DISTRIBUTION Cost Share Distribution Code defines the account distribution for indirect cost. VARCHAR2(63)

FRBGRNT

FRBGRNT_CSTD_CODE_DISTR

COST_SHARE_DISTRIBUTION_DESC Cost Share Distribution Description Cost share distribution description. VARCHAR2(255)

FRVCSTD

FRVCSTD_DESC

COST_SHARE_RATE Cost Share Rate Cost share rate for this grant. VARCHAR2(63)

FRBGRNT

FRBGRNT_CSTR_CODE_RATE

COST_SHARE_RATE_DESC Cost Share Rate Description Cost share rate description. VARCHAR2(255)

FRVCSTR

FRVCSTR_DESC

CUMULATIVE_AMOUNT Cumulative Amount Cumulative funding amount of the grant, received from the agency to date. Informational only. NUMBER

FRBGRNT

FRBGRNT_CUM_FUNDING_AMT

CURRENT_YEAR_AMOUNT Current Year Amount Current year funding amount of the grant, committed by the agency. Informational only. NUMBER

FRBGRNT

FRBGRNT_CURRENT_FUNDING_AMT

ESTIMATED_CUM_COST_AMOUNT Estimated Cum Cost Amount Value of the estimated total cost of the construction project. NUMBER

FTVFUND

FTVFUND_CUM_COST_AMT

EXPENDITURE_END_DATE Expenditure End Date Ending period date for expenditure activity. DATE

FRBGRNT

FRBGRNT_EXPEND_END_DATE

FEDERAL_IDENTIFICATION Federal ID Identifies the Catalog of Federal Domestic Assistance code. VARCHAR2(63)

FRVCFDA

FRVCFDA_CFDA_CODE

FEDERAL_IDENTIFICATION_DESC Federal ID Description Description of the Catalog of Federal Domestic Assistance. VARCHAR2(255)

FRVCFDA

FRVCFDA_TITLE

FEDERAL_IDENTIFICATION_UID Federal ID UID System generated unique internal identification number assigned to the Catalog of Federal Domestic Assistance code. NUMBER

FRBGRNT

FRBGRNT_CFDA_INTERNAL_ID_NO

FUND Fund Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

FUND_BANK Fund Bank User-defined value which is used for identification purposes on all cash transactions. VARCHAR2(63)

FTVFUND

FTVFUND_BANK_CODE

FUND_BANK_DESC Fund Bank Description The name of the banking institution where the installment has accounts. VARCHAR2(255)

GXVBANK

GXVBANK_ACCT_NAME

FUND_BANK_ID Fund Bank ID ID of the bank where the installment has accounts. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

FUND_BANK_NAME Fund Bank Name Name of the banking institution where the installment has accounts. VARCHAR2(255)

GXVBANK

SPRIDEN

GXVBANK_ACCT_NAME

SPRIDEN_LAST_NAME

FUND_BANK_UID Fund Bank UID The internal identification number of the bank where the installment has accounts. NUMBER

GXVBANK

GXVBANK_BANK_CODE_PIDM

FUND_COST_SHARE_BASE Fund Cost Share Base Code defines the base information for cost share calculations. VARCHAR2(63)

FRVFUND

FRVFUND_BASI_CODE_CS

FUND_COST_SHARE_BASE_DESC Fund Cost Share Base Description Cost share code extracted description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FUND_COST_SHARE_CHARGE Fund Cost Share Charge Code defines account's and percentage of the charge. VARCHAR2(63)

FRVFUND

FRVFUND_CSTA_CODE_CHARGE

FUND_COST_SHARE_CHARGE_DESC Fund Cost Share Charge Description Cost share credit code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FUND_COST_SHARE_DISTRIB Fund Cost Share Distribution Code defines the account distribution for indirect cost. VARCHAR2(63)

FRVFUND

FRVFUND_CSTD_CODE_DISTR

FUND_COST_SHARE_DISTRIB_DESC Fund Cost Share Distribution Description Cost share distribution code extracted description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FUND_COST_SHARE_RATE Fund Cost Share Rate Cost chart rate for this grant fund. VARCHAR2(63)

FRVFUND

FRVFUND_CSTR_CODE_RATE

FUND_COST_SHARE_RATE_DESC Fund Cost Share Rate Description Cost share rate code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FUND_DESC Fund Description Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

FUND_EXPENDITURE_END_DATE Fund Expenditure End Date Ending period date for expenditure activity. DATE

FTVFUND

FTVFUND_EXPEND_END_DATE

FUND_FINANCIAL_MANAGER_ID 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

FUND_FINANCIAL_MANAGER_NAME 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

FUND_FINANCIAL_MANAGER_UID 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

FUND_FMGR_CITY Fund Fmgr City City associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_CITY

FUND_FMGR_COUNTY Fund Fmgr County County code associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

FUND_FMGR_COUNTY_DESC Fund Fmgr County Description County address name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FUND_FMGR_FIRST_NAME Fund Fmgr First Name Financial manager's first or given name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

FUND_FMGR_LAST_NAME Fund Fmgr Last Name Fund manager's last name or surname. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

FUND_FMGR_MIDDLE_NAME Fund Fmgr Middle Name Financial manager's middle name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

FUND_FMGR_NATION Fund Fmgr Nation Nation code associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_NATN_CODE

FUND_FMGR_NATION_DESC Fund Fmgr Nation Description Name of the nation. VARCHAR2(255)

STVNATN

STVNATN_NATION

FUND_FMGR_POSTAL_CODE Fund Fmgr Postal Code Address postal code. VARCHAR2(63)

SPRADDR

SPRADDR_ZIP

FUND_FMGR_STATE_PROVINCE Fund Fmgr State Province State/Province code for the address. VARCHAR2(63)

SPRADDR

SPRADDR_STAT_CODE

FUND_FMGR_STATE_PROVINCE_DESC Fund Fmgr State Province Description State/province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

FUND_FMGR_STREET_LINE1 Fund Fmgr Street Line 1 First line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE1

FUND_FMGR_STREET_LINE2 Fund Fmgr Street Line 2 Second line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE2

FUND_FMGR_STREET_LINE3 Fund Fmgr Street Line 3 Third line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE3

FUND_FMGR_STREET_LINE4 Fund Fmgr Street Line 4 Fourth line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE4

FUND_INDIRECT_COST_BASE Fund Indirect Cost Base Code used to define indirect cost calculations. VARCHAR2(63)

FRVFUND

FRVFUND_BASI_CODE_IC

FUND_INDIRECT_COST_BASE_DESC Fund Indirect Cost Base Description Indirect cost base code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FUND_INDIRECT_COST_CHARGE Fund Indirect Cost Charge Code identifies the account's and the percentage of the charge. VARCHAR2(63)

FRVFUND

FRVFUND_INDA_CODE_CHARGE

FUND_INDIRECT_COST_CHARGE_DESC Fund Indirect Cost Charge Description Indirect cost charge code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FUND_INDIRECT_COST_DISTRI Fund Indirect Cost Distribution Code identifies the accounting distribution for indirect cost. VARCHAR2(63)

FRVFUND

FRVFUND_INDD_CODE_DISTR

FUND_INDIRECT_COST_DISTRI_DESC Fund Indirect Cost Distribution Description Indirect cost distribution description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FUND_INDIRECT_COST_RATE Fund Indirect Cost Rate Indirect cost rate percentage for the grant fund. VARCHAR2(63)

FRVFUND

FRVFUND_INDR_CODE_RATE

FUND_INDIRECT_COST_RATE_DESC Fund Indirect Cost Rate Description Indirect cost rate code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FUND_PREDECESSOR Fund Predecessor Next prior level fund associated with the fund code used to build a hierarchy. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE_PRED

FUND_PREDECESSOR_DESC Fund Predecessor Description Associated fund description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

FUND_STATUS Fund Status Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

FUND_TERMINATION_DATE Fund Termination Date Date when the fund is no longer in effect. DATE

FTVFUND

FTVFUND_TERM_DATE

FUND_TYPE Fund Type Fund type code to be associated with the fund as defined by the institution. VARCHAR2(63)

FTVFUND

FTVFUND_FTYP_CODE

FUND_TYPE_DESC Fund Type Description Fund type code description or title. VARCHAR2(255)

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(63)

FRVFUND

FRVFUND_USER_ID

GRANT_ID Grant ID Unique user defined or system generated one-up number for this grant. VARCHAR2(63)

FRBGRNT

FRBGRNT_CODE

GRANT_LONG_TITLE Grant Long Title Grant long title or description. VARCHAR2(256)

FRBGRNT

FRBGRNT_LONG_TITLE

GRANT_SHORT_TITLE Grant Short Title Shortened name or title for the grant. VARCHAR2(255)

FRBGRNT

FRBGRNT_TITLE

GRANT_TERMINATION_DATE 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

GRANT_TYPE Grant Type Grant type code to reflect if this is a grant, contract, cooperative agreement, etc. VARCHAR2(63)

FRBGRNT

FRBGRNT_GRANT_TYPE

GRANT_TYPE_DESC Grant Type Description Retrieved description for grant type. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

INDIRECT_COST_BASE Indirect Cost Base Code used to define indirect cost calculations. VARCHAR2(63)

FRBGRNT

FRBGRNT_BASI_CODE_IC

INDIRECT_COST_BASE_DESC Indirect Cost Base Description Indirect cost base code description. VARCHAR2(255)

FRVBASI

FRVBASI_DESC

INDIRECT_COST_CHARGE Indirect Cost Charge Code identifies the account's and the percentage of the charge. VARCHAR2(63)

FRBGRNT

FRBGRNT_INDA_CODE_CHARGE

INDIRECT_COST_CHARGE_DESC Indirect Cost Charge Description Indirect cost charge code description. VARCHAR2(255)

FRVINDA

FRVINDA_DESC

INDIRECT_COST_DISTRIBUTION Indirect Cost Distribution Code identifies the accounting distribution for indirect cost. VARCHAR2(63)

FRBGRNT

FRBGRNT_INDD_CODE_DISTR

INDIRECT_COST_DISTRIB_DESC Indirect Cost Distribution Description Indirect cost distribution description. VARCHAR2(255)

FRVINDD

FRVINDD_DESC

INDIRECT_COST_RATE Indirect Cost Rate Indirect cost rate percentage for this grant. VARCHAR2(63)

FRBGRNT

FRBGRNT_INDR_CODE_RATE

INDIRECT_COST_RATE_DESC Indirect Cost Rate Description Indirect cost rate code description. VARCHAR2(255)

FRVINDR

FRVINDR_DESC

MAXIMUM_CONSTR_PROJECT_AMOUNT Maximum Constr Project Amount Value of estimated funding for this construction project. NUMBER

FTVFUND

FTVFUND_MAX_CONSTR_AMT

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

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

PRINCIPAL_INVESTIGATOR_FNAME Principal Investigator First Name Current first name of the principal investigator. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

PRINCIPAL_INVESTIGATOR_ID Principal Investigator ID Current identification number of the principal investigator. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

PRINCIPAL_INVESTIGATOR_LNAME Principal Investigator Last Name Current last name of the principal investigator. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

PRINCIPAL_INVESTIGATOR_MNAME Principal Investigator Middle Name Current middle name of the principal investigator. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

PRINCIPAL_INVESTIGATOR_NAME 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

PRINCIPAL_INVESTIGATOR_TITLE Principal Investigator Title Official position/title that belongs to the principal investigator. VARCHAR2(255)

FRRGRPI

FRRGRPI_TITLE

PRINCIPAL_INVESTIGATOR_UID Principal Investigator UID System internally generated id to uniquely identify the principal investigator for this grant. NUMBER

FRBGRNT

FRBGRNT_PI_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

PROJECT_CLOSE_IND Project Close Indicator Determines if the construction project is closed or not. Informational only. VARCHAR2(63)

FTVFUND

FTVFUND_CLOSE_PROJ_IND

PROJECT_END_DATE Project End Date End date is the last day of the grant period. DATE

FRBGRNT

FRBGRNT_PROJECT_END_DATE

PROJECT_START_DATE Project Start Date Date the agency awarded the grant. DATE

FRBGRNT

FRBGRNT_PROJECT_START_DATE

PROPOSAL Proposal Proposal submitted to the agency that has now been awarded this grant. VARCHAR2(63)

FTVFUND

FTVFUND_PROP_CODE

PROPOSAL_LONG_TITLE Proposal Long Title Long description or title of the grant proposal. VARCHAR2(256)

FRBPROP

FRBPROP_LONG_TITLE

PROPOSAL_SHORT_TITLE Proposal Short Title Short description or title of the grant proposal. VARCHAR2(255)

FRBPROP

FRBPROP_TITLE

RELATED_GRANT Related Grant Grant code of a prior defined grant used to copy data from into this grant. VARCHAR2(63)

FRBGRNT

FRBGRNT_GRNT_CODE_RELATED

RESPONSIBLE_ORGANIZATION_CODE Responsible Organization Code Organization code of the responsible administrative office for this grant. VARCHAR2(63)

FRBGRNT

FRBGRNT_ORGN_CODE_RESP_OFFICE

RESPONSIBLE_ORGANIZATION_DESC Responsible Organization Description Retrieved description or title of the associated organization. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

RESPONSIBLE_ORGN_STATUS Responsible Organization Status Current status of the associated organization. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

REVENUE_ACCRUAL_ACCOUNT Revenue Accrual Account Revenue account code for this fund used for revenue recognition. VARCHAR2(63)

FTVFUND

FTVFUND_ACCT_CODE_REV

REVENUE_ACCRUAL_ACCOUNT_DESC Revenue Accrual Account Description Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

SOURCE_FUND Source Fund Identification of the source of funds for the construction project. Informational only. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE_SOURCE

SOURCE_FUND_DESC Source Fund Description Retrieve description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

SPONSOR_NUMBER Sponsor Number Sponsor agency's reference number. VARCHAR2(63)

FRBGRNT

FRBGRNT_SPONSOR_ID

STATUS Status Status of the grant, with most common values as Inactive or Active. VARCHAR2(63)

FRBGRNT

FRBGRNT_STATUS_CODE

STATUS_DATE Status Date Last date a status change occurred for this grant. DATE

FRBGRNT

FRBGRNT_STATUS_DATE

STATUS_DESC Status Description Retrieved description for grant status. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

STATUS_FISCAL_PERIOD Status Fiscal Period Extracted fiscal period in which the last status date occurred. VARCHAR2(63)

FUNCTION

F_GET_FISCAL_PERIOD

STATUS_FISCAL_YEAR Status Fiscal Year Extracted fiscal year in which the last status date occurred. VARCHAR2(63)

FUNCTION

FOFYCNV

SUBCATEGORY Subcategory Sub category code for grant and proposal classification such as corporation, foundation, state, etc. VARCHAR2(63)

FRBGRNT

FRBGRNT_SUB_CATEGORY

SUBCATEGORY_DESC Subcategory Description Retrieved description for grant or proposal sub category. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

UNBILLED_ACCRUAL_ACCOUNT Unbilled Accrual Account Unbilled accrual account for this fund used for revenue recognition. VARCHAR2(63)

FTVFUND

FTVFUND_ACCT_CODE_ACCR

UNBILLED_ACCRUAL_ACCOUNT_DESC Unbilled Accrual Account Description Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

WITHHOLDING_AMOUNT Withholding Amount Amount to withhold from the billed agency. NUMBER

FRVFUND

FRVFUND_WITHHOLDING_AMT

WITHHOLDING_AR_ACCOUNT 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

WITHHOLDING_AR_ACCOUNT_DESC Withholding Ar Account Description Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

WITHHOLDING_PERCENT Withholding Percent Percent of the amount to be debited to the withholding receivable account for each bill generated. NUMBER

FRVFUND

FRVFUND_WITHHOLDING_PERCENT



Ver: 9.2