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

SGHE Banner Operational Data Store
Reporting View Target: GRANT_VIEW

Description Contains information defining the grant itself. The principal investigator, federal ID, sponsor number, agency and agency information with hierachy data, various amounts, responsible organization with hierarchy data, various dates, letter of credit number, payment management system code, location, type of grant, indirect cost and cost share codes.
Key & Frequency One row per grant ID.
Recommended Search Columns GRANT_ID
AGENCY_UID
AGENCY_UID_LEVEL_1
AGENCY_UID_LEVEL_2
AGENCY_UID_LEVEL_3
AGENCY_UID_LEVEL_4
CHART_OF_ACCOUNTS
CHART_OF_ACCOUNTS, LOCATION

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Organization-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_ID_LEVEL_1 Agency ID Level 1 Agency's identification number level 1. VARCHAR2(63)  

SPRIDEN

SPRIDEN_ID

AGENCY_ID_LEVEL_2 Agency ID Level 2 Agency's identification number level 2. VARCHAR2(63)  

SPRIDEN

SPRIDEN_ID

AGENCY_ID_LEVEL_3 Agency ID Level 3 Agency's identification number level 3. VARCHAR2(63)  

SPRIDEN

SPRIDEN_ID

AGENCY_ID_LEVEL_4 Agency ID Level 4 Agency's identification number level 4. VARCHAR2(63)  

SPRIDEN

SPRIDEN_ID

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

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_1 Agency Name Level 1 Agency name level 1. VARCHAR2(63)  

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_2 Agency Name Level 2 Agency name level 2. VARCHAR2(63)  

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_3 Agency Name Level 3 Agency name level 3. VARCHAR2(63)  

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_4 Agency Name Level 4 Agency name level 4. VARCHAR2(63)  

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

AGENCY_UID_LEVEL_1 Agency UID Level 1 Extracted agency system generated identification number hierarchy level 1. NUMBER  

FUNCTION

F_AGCY_HIER

AGENCY_UID_LEVEL_2 Agency UID Level 2 Extracted agency system generated identification number hierarchy level 2. NUMBER  

FUNCTION

F_AGCY_HIER

AGENCY_UID_LEVEL_3 Agency UID Level 3 Extracted agency system generated identification number hierarchy level 3. NUMBER  

FUNCTION

F_AGCY_HIER

AGENCY_UID_LEVEL_4 Agency UID Level 4 Extracted agency system generated identification number hierarchy level 4. NUMBER  

FUNCTION

F_AGCY_HIER

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

FRBGRNT

FRBGRNT_ALTERNATE_STATUS_DESC

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)  

FRBGRNT

FRBGRNT_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 accounts. VARCHAR2(63)  

FTVCOAS

FTVCOAS_STATUS_IND

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

EFFORT_CERTIFICATION_REQ_IND Effort Certification Requirements Indicator Indicates whether effort certification is required with this grant. VARCHAR2(1)  

FRBGRNT

FRBGRNT_EFF_CERT_REQUIRED_IND

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

FRBGRNT

FRBGRNT_EXPEND_END_DATE

FEDERAL_AGENCY_NAME Federal Agency Name Federal agency name associated with the Catalog of Federal Domestic Assistance code. VARCHAR2(255)  

FRVCFDA

FRVCFDA_FEDERAL_AGENCY_NAME

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_STATUS Federal ID Status Catalog of Federal Domestic Assistance status. VARCHAR2(63)  

FRVCFDA

FRVCFDA_STATUS

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

FIELD_OF_SCIENCE Field Of Science Field of science. VARCHAR2(63)  

NA

NA

FISCAL_REPORTING_DATE Fiscal Reporting Date Fiscal reporting date of the grant. DATE  

NA

NA

GRANT_ACTIVITY_DATE Grant Activity Date Date record was inserted or updated. DATE  

FRBGRNT

FRBGRNT_ACTIVITY_DATE

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

FRBGRNT

FRBGRNT_CODE

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

GRANT_USER_ID Grant User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)  

FRBGRNT

FRBGRNT_USER_ID

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

LETTER_OF_CREDIT_NUMBER Letter Of Credit Number Actual letter of credit number associated to the payment management system code. VARCHAR2(63)  

FRVPMSC

FRVPMSC_LOC_NO

LOCATION Location Identification accounting code of the physical location the grant has been assigned to. VARCHAR2(63)  

FRRGLOC

FRRGLOC_LOCN_CODE

LOCATION_DESC Location Description Extracted description or title of the associated location. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

LOCATION_STATUS Location Status Status of the location. VARCHAR2(63)  

FTVLOCN

FTVLOCN_STATUS_IND

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

FRBGRNT

FRBGRNT_LONG_TITLE

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

ON_OFF_CAMPUS On Off Campus Where Grant research is being performed. Either On Campus, Off campus or both. VARCHAR2(63)  

FRRGLOC

FRRGLOC_LOCN_RESEARCH_IND

ORGANIZATION_DESC_1 Organization Description 1 Retrieves description or title level 1 within this organization hierarchy. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_2 Organization Description 2 Retrieves description or title level 2 within this organization hierarchy. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_3 Organization Description 3 Retrieves description or title level 3 within this organization hierarchy. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_4 Organization Description 4 Retrieves description or title level 4 within this organization hierarchy. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_5 Organization Description 5 Retrieves description or title level 5 within this organization hierarchy. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_6 Organization Description 6 Retrieves description or title level 6 within this organization hierarchy. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_7 Organization Description 7 Retrieves description or title level 7 within this organization hierarchy. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_8 Organization Description 8 Retrieves description or title level 8 within this organization hierarchy. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_1 Organization Level 1 Retrieves level 1 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_2 Organization Level 2 Retrieves level 2 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_3 Organization Level 3 Retrieves level 3 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_4 Organization Level 4 Retrieves level 4 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_5 Organization Level 5 Retrieves level 5 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_6 Organization Level 6 Retrieves level 6 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_7 Organization Level 7 Retrieves level 7 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_8 Organization Level 8 Retrieves level 8 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_1 Organization Status 1 Retrieves status of level 1 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_2 Organization Status 2 Retrieves status of level 2 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_3 Organization Status 3 Retrieves status of level 3 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_4 Organization Status 4 Retrieves status of level 4 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_5 Organization Status 5 Retrieves status of level 5 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_6 Organization Status 6 Retrieves status of level 6 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_7 Organization Status 7 Retrieves status of level 7 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_8 Organization Status 8 Retrieves status of level 8 organization within this organization hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGN_FINANCIAL_MANAGER_ID Organization 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

ORGN_FINANCIAL_MANAGER_NAME Organization 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

ORGN_FINANCIAL_MANAGER_UID Organization Financial Manager UID System generated unique internal identification number assigned to the financial manager associated with this organization. NUMBER  

FTVORGN

FTVORGN_FMGR_CODE_PIDM

ORGN_FMGR_CITY Organization Fmgr City City associated with the address. VARCHAR2(63)  

SPRADDR

SPRADDR_CITY

ORGN_FMGR_COUNTY Organization Fmgr County County code associated with the address. VARCHAR2(63)  

SPRADDR

SPRADDR_CNTY_CODE

ORGN_FMGR_COUNTY_DESC Organization Fmgr County Description County address name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

ORGN_FMGR_MIDDLE_NAME Organization Fmgr Middle Name Financial manager's middle name. VARCHAR2(63)  

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

ORGN_FMGR_NATION Organization Fmgr Nation Nation code associated with the address. VARCHAR2(63)  

SPRADDR

SPRADDR_NATN_CODE

ORGN_FMGR_NATION_DESC Organization Fmgr Nation Description Name of the nation. VARCHAR2(255)  

STVNATN

STVNATN_NATION

ORGN_FMGR_POSTAL_CODE Organization Fmgr Postal Code Address postal code. VARCHAR2(63)  

SPRADDR

SPRADDR_ZIP

ORGN_FMGR_STATE_PROVINCE Organization Fmgr State Province State/Province code for the address. VARCHAR2(63)  

SPRADDR

SPRADDR_STAT_CODE

ORGN_FMGR_STATE_PROVINCE_DESC Organization Fmgr State Province Description State/province name. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

ORGN_FMGR_STREET_LINE1 Organization Fmgr Street Line 1 First line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE1

ORGN_FMGR_STREET_LINE2 Organization Fmgr Street Line 2 Second line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE2

ORGN_FMGR_STREET_LINE3 Organization Fmgr Street Line 3 Third line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE3

ORGN_FMGR_STREET_LINE4 Organization Fmgr Street Line 4 Fourth line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE4

PAYMENT_MANAGEMENT_SYS_CODE Payment Management Sys Code Unique identifier assigned as a payment management system code within grants, containing the letter of credit number and a amount limit that can be drawn on a letter of credit. VARCHAR2(63)  

FRBGBIL

FRBGBIL_PMSC_CODE

PAYMENT_MANAGEMENT_SYS_DESC Payment Management Sys Description Payment management system description. VARCHAR2(255)  

FRVPMSC

FRVPMSC_DESC

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

PRIN_INVESTIGATOR_EMAIL_ADDR Prin Investigator Email Address Principal investigator's email address. VARCHAR2(255)  

FRRGRPI

FRRGRPI_EMAIL

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_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)  

FRBGRNT

FRBGRNT_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

RENEWAL_REPORT_DATE Renewal Report Date Renewal reporting date of the grant. DATE  

NA

NA

REPORTING_DATE Reporting Date Reporting date of the grant. DATE  

NA

NA

REPORTING_QUARTER1 Reporting Quarter 1 Reporting for quarter 1 amount. NUMBER  

NA

NA

REPORTING_QUARTER2 Reporting Quarter 2 Reporting for quarter 2 amount. NUMBER  

NA

NA

REPORTING_QUARTER3 Reporting Quarter 3 Reporting for quarter 3 amount. NUMBER  

NA

NA

REPORTING_QUARTER4 Reporting Quarter 4 Reporting for quarter 4 amount. NUMBER  

NA

NA

RESEARCH_PURPOSE Research Purpose Purpose of the research. VARCHAR2(63)  

NA

NA

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

SHORT_TITLE Short Title Grant short description. VARCHAR2(255)  

FRBGRNT

FRBGRNT_TITLE

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

FRBGRNT

FRBGRNT_SPONSOR_ID

STATUS Status Grant status. The most common values are (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)  

FTVSDAT

FTVSDAT_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

TERMINATION_DATE 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

TOTAL_RECIPIENT_SHARE_AMOUNT Total Recipient Share Amount Total recipient portion includes all matching and cost sharing provided by the recipients and third-party providers to meet the level required by the Federal agency. NUMBER  

FRBGRNT

FRBGRNT_RCPT_SHARE_TOTAL

TYPE_OF_RESEARCH Type Of Research Type of research. VARCHAR2(63)  

NA

NA



Ver: 9.0