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

Banner Operational Data Store
Reporting View Target: PROPOSAL

Description Contains proposal pre-award and grant award information. The principal investigator information, agency and agency information with hierarchy data, submission date, award/decline date, and responsible organization code.
Key & Frequency One row per grant proposal.
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
PROPOSAL_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_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(255)

SPRIDEN

SPRIDEN_LAST_NAME

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

SPRIDEN

SPRIDEN_LAST_NAME

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

SPRIDEN

SPRIDEN_LAST_NAME

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

SPRIDEN

SPRIDEN_LAST_NAME

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

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NUMBER Agency Number Agency's identification number. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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

FRBPROP

FRBPROP_AGENCY_PIDM

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

FUNCTION

FOKODSF.F_AGCY_HIER

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

FUNCTION

FOKODSF.F_AGCY_HIER

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

FUNCTION

FOKODSF.F_AGCY_HIER

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

FUNCTION

FOKODSF.F_AGCY_HIER

AWARD_DATE Award Date Extracts recorded date proposal was awarded the grant. DATE

FUNCTION

F_GET_STATUS_DATE

AWARD_FISCAL_PERIOD Award Fiscal Period Extracts awarded fiscal period. VARCHAR2(63)

FUNCTION

F_GET_STATUS_INFO

AWARD_FISCAL_YEAR Award Fiscal Year Extracts awarded fiscal year. VARCHAR2(63)

FUNCTION

FOFYCNV

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

FRBPROP

FRBPROP_CATEGORY

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

FRBPROP

FRBPROP_COAS_CODE

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

CURRENT_STATUS Current Status Current status of the proposal. VARCHAR2(63)

FRBPROP

FRBPROP_STATUS_CODE

CURRENT_STATUS_DATE Current Status Date Current status date of the proposal. DATE

FRBPROP

FRBPROP_STATUS_DATE

DECLINE_DATE Decline Date Recorded date that the award for the grant was declined. DATE

FUNCTION

F_GET_STATUS_DATE

DECLINE_FISCAL_PERIOD Decline Fiscal Period Extracted fiscal period in which the proposal was declined. VARCHAR2(63)

FUNCTION

F_GET_STATUS_INFO

DECLINE_FISCAL_YEAR Decline Fiscal Year Extracted fiscal year in which the proposal was declined. VARCHAR2(63)

FUNCTION

FOFYCNV

FEDERAL_IDENTIFICATION Federal ID Identifies the CFDA code. VARCHAR2(63)

FRBPROP

FRVCFDA

FRBPROP_CFDA_INTERNAL_ID_NO

FRVCFDA_CFDA_CODE

FEDERAL_IDENTIFICATION_DESC Federal ID Description Description of the CFDA code. VARCHAR2(255)

FRVCFDA

FRVCFDA_TITLE

FEDERAL_IDENTIFICATION_UID Federal ID UID Identifies the CFDA number. NUMBER

FRBPROP

FRBPROP_CFDA_INTERNAL_ID_NO

GRANT_AWARD_AMOUNT Grant Award Amount Grant award amount. NUMBER

FRBGRNT

FRBGRNT_CURRENT_FUNDING_AMT

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

FRBPROP

FRBPROP_GRNT_CODE

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

FRBGRNT

FRBGRNT_TITLE

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

FRRPLOC

FRRPLOC_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

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)

FRRPLOC

FRRPLOC_LOCN_RESEARCH_IND

ORGANIZATION_CODE Organization Code Identification accounting code used for the responsible department. VARCHAR2(63)

FRBPROP

FRBPROP_ORGN_CODE_RESP_OFFICE

ORGANIZATION_DESC Organization Description Extracted description or title associated with the organization code. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

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 Organization Status Status of the organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

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

ORIGINATION_DATE Origination Date Extracted proposal origination date. DATE

FUNCTION

F_GET_STATUS_DATE

ORIGINATION_FISCAL_PERIOD Origination Fiscal Period Extracted proposal origination fiscal period. VARCHAR2(63)

FUNCTION

F_GET_STATUS_INFO

ORIGINATION_FISCAL_YEAR Origination Fiscal Year Extracted proposal origination fiscal year. VARCHAR2(63)

FUNCTION

FOFYCNV

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PRINCIPAL_INVESTIGATOR_IND Principal Investigator Indicator Principal investigator type indicator. VARCHAR2(63)

FRRPRPI

FRRPRPI_ID_IND

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FRBPROP

FRBPROP_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

PROPOSAL_CODE Proposal Code User-defined or system assigned proposal identification code. VARCHAR2(63)

FRBPROP

FRBPROP_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

PROPOSAL_TYPE Proposal Type Determines type of proposal like project, grant, contract, cooperative agreement. VARCHAR2(63)

FRBPROP

FRBPROP_PROPOSAL_TYPE

PROPOSAL_TYPE_DESC Proposal Type Description Description of the proposal type. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

REQUESTED_AMOUNT Requested Amount Total proposed amount to the agency including direct and indirect costs. NUMBER

FRBPROP

FRBPROP_REQUESTED_AMT

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

FRBPROP

FRBPROP_SPONSOR_ID

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

FRBPROP

FRBPROP_SUB_CATEGORY

SUBMISSION_DATE Submission Date Extracts proposal submission date. DATE

FUNCTION

F_GET_STATUS_DATE

SUBMISSION_FISCAL_PERIOD Submission Fiscal Period Extracts proposal submission fiscal period. VARCHAR2(63)

FUNCTION

F_GET_STATUS_INFO

SUBMISSION_FISCAL_YEAR Submission Fiscal Year Extracts proposal submission fiscal year. VARCHAR2(63)

FUNCTION

FOFYCNV



Ver: 9.2