Go To View:  RETURN TO REPORTING VIEW 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 CHART_OF_ACCOUNTS, ORGANIZATION_CODE
AGENCY_UID
AGENCY_UID_LEVEL_1
AGENCY_UID_LEVEL_2
AGENCY_UID_LEVEL_3
AGENCY_UID_LEVEL_4
GRANT_ID

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

FRBGRNT

FRBGRNT_AGENCY_ADDR_CODE

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 Maximum amount of money the agency commits to the grant. Informational only. NUMBER

FRBGRNT

FRBGRNT_MAX_FUNDING_AMT

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

FRBGRNT

FRBGRNT_AGENCY_CONTACT

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

FRBGRNT

FRBGRNT_AGENCY_EMAIL

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

SPRIDEN

SPRIDEN_ID

AGENCY_ID_LEVEL_1 Agency's identification number level 1. VARCHAR2(9)

SPRIDEN

SPRIDEN_ID

AGENCY_ID_LEVEL_2 Agency's identification number level 2. VARCHAR2(9)

SPRIDEN

SPRIDEN_ID

AGENCY_ID_LEVEL_3 Agency's identification number level 3. VARCHAR2(9)

SPRIDEN

SPRIDEN_ID

AGENCY_ID_LEVEL_4 Agency's identification number level 4. VARCHAR2(9)

SPRIDEN

SPRIDEN_ID

AGENCY_NAME Name of the agency. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_1 Agency name level 1. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_2 Agency name level 2. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_3 Agency name level 3. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_4 Agency name level 4. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

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

FRBGRNT

FRBGRNT_AGENCY_PHONE_TYPE

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

FRBGRNT

FRBGRNT_AGENCY_TELE_SEQNO

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

FRBGRNT

FRBGRNT_AGENCY_PIDM

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

FUNCTION

F_AGCY_HIER

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

FUNCTION

F_AGCY_HIER

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

FUNCTION

F_AGCY_HIER

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

FUNCTION

F_AGCY_HIER

ALTERNATE_STATUS_DESC Alternate status description. VARCHAR2(255)

FRBGRNT

FRBGRNT_ALTERNATE_STATUS_DESC

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

FRBGRNT

FRBGRNT_CATEGORY

CATEGORY_DESC Grant category description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

FRBGRNT

FRBGRNT_COAS_CODE

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 extracted description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

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 code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Status of the chart of accounts. VARCHAR2(63)

FTVCOAS

FTVCOAS_STATUS_IND

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. VARCHAR2(255)

FRVBASI

FRVBASI_DESC

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. VARCHAR2(255)

FRVCSTA

FRVCSTA_DESC

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. VARCHAR2(255)

FRVCSTD

FRVCSTD_DESC

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

FRBGRNT

FRBGRNT_CSTR_CODE_RATE

COST_SHARE_RATE_DESC Cost share rate description. VARCHAR2(255)

FRVCSTR

FRVCSTR_DESC

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 funding amount of the grant, committed by the agency. Informational only. NUMBER

FRBGRNT

FRBGRNT_CURRENT_FUNDING_AMT

EXPENDITURE_END_DATE Ending period date for expenditure activity. DATE

FRBGRNT

FRBGRNT_EXPEND_END_DATE

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

FRVCFDA

FRVCFDA_CFDA_CODE

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

FRVCFDA

FRVCFDA_TITLE

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

FIELD_OF_SCIENCE Field of science. VARCHAR2(63)

NA

NA

FISCAL_REPORTING_DATE Fiscal reporting date of the grant. DATE

NA

NA

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

FRBGRNT

FRBGRNT_CODE

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 Retrieved description for grant type. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

FRBGRNT

FRBGRNT_BASI_CODE_IC

INDIRECT_COST_BASE_DESC Indirect cost base code description. VARCHAR2(255)

FRVBASI

FRVBASI_DESC

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 code description. VARCHAR2(255)

FRVINDA

FRVINDA_DESC

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. VARCHAR2(255)

FRVINDD

FRVINDD_DESC

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

FRBGRNT

FRBGRNT_INDR_CODE_RATE

INDIRECT_COST_RATE_DESC Indirect cost rate code description. VARCHAR2(255)

FRVINDR

FRVINDR_DESC

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

FRVPMSC

FRVPMSC_LOC_NO

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

FRRGLOC

FRRGLOC_LOCN_CODE

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

FUNCTION

F_GET_FINANCE_DESC

LOCATION_STATUS Status of the location. VARCHAR2(63)

FTVLOCN

FTVLOCN_STATUS_IND

LONG_TITLE Grant long title or description. VARCHAR2(256)

FRBGRNT

FRBGRNT_LONG_TITLE

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

NA

NA

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

NA

NA

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 Retrieves description or title level 1 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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 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 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 System generated unique internal identification number assigned to the financial manager associated with this organization. NUMBER

FTVORGN

FTVORGN_FMGR_CODE_PIDM

ORGN_FMGR_CITY City associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_CITY

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

SPRADDR

SPRADDR_CNTY_CODE

ORGN_FMGR_COUNTY_DESC County address name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ORGN_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 Fund manager's last name or surname. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

ORGN_FMGR_MIDDLE_NAME Financial manager's middle name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

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

SPRADDR

SPRADDR_NATN_CODE

ORGN_FMGR_NATION_DESC Name of the nation. VARCHAR2(255)

STVNATN

STVNATN_NATION

ORGN_FMGR_POSTAL_CODE Address postal code. VARCHAR2(63)

SPRADDR

SPRADDR_ZIP

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

SPRADDR

SPRADDR_STAT_CODE

ORGN_FMGR_STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

ORGN_FMGR_STREET_LINE1 First line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE1

ORGN_FMGR_STREET_LINE2 Second line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE2

ORGN_FMGR_STREET_LINE3 Third line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE3

ORGN_FMGR_STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NA

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 system description. VARCHAR2(255)

FRVPMSC

FRVPMSC_DESC

PRINCIPAL_INVESTIGATOR_FNAME Current first name of the principal investigator. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

PRINCIPAL_INVESTIGATOR_LNAME Current last name of the principal investigator. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

PRINCIPAL_INVESTIGATOR_MNAME Current middle name of the principal investigator. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

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 Official position/title that belongs to the principal investigator. VARCHAR2(255)

FRRGRPI

FRRGRPI_TITLE

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

FRBGRNT

FRBGRNT_PI_PIDM

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 End date is the last day of the grant period. DATE

FRBGRNT

FRBGRNT_PROJECT_END_DATE

PROJECT_START_DATE Date the agency awarded the grant. DATE

FRBGRNT

FRBGRNT_PROJECT_START_DATE

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

FRBGRNT

FRBGRNT_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(255)

FRBPROP

FRBPROP_TITLE

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 reporting date of the grant. DATE

NA

NA

REPORTING_DATE Reporting date of the grant. DATE

NA

NA

REPORTING_QUARTER1 Reporting for quarter 1 amount. NUMBER

NA

NA

REPORTING_QUARTER2 Reporting for quarter 2 amount. NUMBER

NA

NA

REPORTING_QUARTER3 Reporting for quarter 3 amount. NUMBER

NA

NA

REPORTING_QUARTER4 Reporting for quarter 4 amount. NUMBER

NA

NA

RESEARCH_PURPOSE Purpose of the research. VARCHAR2(63)

NA

NA

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

FRBGRNT

FRBGRNT_ORGN_CODE_RESP_OFFICE

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

FUNCTION

F_GET_FINANCE_DESC

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

FUNCTION

F_GET_FINANCE_STATUS

SHORT_TITLE Grant short description. VARCHAR2(255)

FRBGRNT

FRBGRNT_TITLE

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

FRBGRNT

FRBGRNT_SPONSOR_ID

STATUS Grant status. The most common values are (Inactive or (Active. VARCHAR2(63)

FRBGRNT

FRBGRNT_STATUS_CODE

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

FRBGRNT

FRBGRNT_STATUS_DATE

STATUS_DESC Retrieved description for grant status. VARCHAR2(255)

FTVSDAT

FTVSDAT_TITLE

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

FUNCTION

F_GET_FISCAL_PERIOD

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

FUNCTION

FOFYCNV

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

FRBGRNT

FRBGRNT_SUB_CATEGORY

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

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

TYPE_OF_RESEARCH Type of research. VARCHAR2(63)

NA

NA



Ver: 8.1