Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE 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 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_ID_LEVEL_1 Agency's identification number level 1. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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

SPRIDEN

SPRIDEN_ID

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

SPRIDEN

SPRIDEN_ID

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

SPRIDEN

SPRIDEN_ID

AGENCY_NAME Name of the agency. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_1 Agency name level 1. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_2 Agency name level 2. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_3 Agency name level 3. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NAME_LEVEL_4 Agency name level 4. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

AGENCY_NUMBER Agency's identification number. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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

FRBPROP

FRBPROP_AGENCY_PIDM

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

FUNCTION

FOKODSF.F_AGCY_HIER

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

FUNCTION

FOKODSF.F_AGCY_HIER

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

FUNCTION

FOKODSF.F_AGCY_HIER

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

FUNCTION

FOKODSF.F_AGCY_HIER

AWARD_DATE Extracts recorded date proposal was awarded the grant. DATE

FUNCTION

F_GET_STATUS_DATE

AWARD_FISCAL_PERIOD Extracts awarded fiscal period. VARCHAR2(63)

FUNCTION

F_GET_STATUS_INFO

AWARD_FISCAL_YEAR Extracts awarded fiscal year. VARCHAR2(63)

FUNCTION

FOFYCNV

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

FRBPROP

FRBPROP_CATEGORY

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

CURRENT_STATUS Current status of the proposal. VARCHAR2(63)

FRBPROP

FRBPROP_STATUS_CODE

CURRENT_STATUS_DATE Current status date of the proposal. DATE

FRBPROP

FRBPROP_STATUS_DATE

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

FUNCTION

F_GET_STATUS_DATE

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

FUNCTION

F_GET_STATUS_INFO

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

FUNCTION

FOFYCNV

FEDERAL_IDENTIFICATION Identifies the CFDA code. VARCHAR2(63)

FRBPROP

FRVCFDA

FRBPROP_CFDA_INTERNAL_ID_NO

FRVCFDA_CFDA_CODE

FEDERAL_IDENTIFICATION_DESC Description of the CFDA code. VARCHAR2(255)

FRVCFDA

FRVCFDA_TITLE

FEDERAL_IDENTIFICATION_UID Identifies the CFDA number. NUMBER

FRBPROP

FRBPROP_CFDA_INTERNAL_ID_NO

GRANT_AWARD_AMOUNT Grant award amount. NUMBER

FRBGRNT

FRBGRNT_CURRENT_FUNDING_AMT

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

FRBPROP

FRBPROP_GRNT_CODE

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

FRBGRNT

FRBGRNT_TITLE

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

FRRPLOC

FRRPLOC_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

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)

FRRPLOC

FRRPLOC_LOCN_RESEARCH_IND

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

FRBPROP

FRBPROP_ORGN_CODE_RESP_OFFICE

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

FUNCTION

F_GET_FINANCE_DESC

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

FTVORGN

FTVORGN_STATUS_IND

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

ORIGINATION_DATE Extracted proposal origination date. DATE

FUNCTION

F_GET_STATUS_DATE

ORIGINATION_FISCAL_PERIOD Extracted proposal origination fiscal period. VARCHAR2(63)

FUNCTION

F_GET_STATUS_INFO

ORIGINATION_FISCAL_YEAR Extracted proposal origination fiscal year. VARCHAR2(63)

FUNCTION

FOFYCNV

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PRINCIPAL_INVESTIGATOR_IND Principal investigator type indicator. VARCHAR2(63)

FRRPRPI

FRRPRPI_ID_IND

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FRBPROP

FRBPROP_PI_PIDM

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

NA

NA

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

FRBPROP

FRBPROP_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

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

FRBPROP

FRBPROP_PROPOSAL_TYPE

PROPOSAL_TYPE_DESC Description of the proposal type. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

FRBPROP

FRBPROP_REQUESTED_AMT

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

FRBPROP

FRBPROP_SPONSOR_ID

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

FRBPROP

FRBPROP_SUB_CATEGORY

SUBMISSION_DATE Extracts proposal submission date. DATE

FUNCTION

F_GET_STATUS_DATE

SUBMISSION_FISCAL_PERIOD Extracts proposal submission fiscal period. VARCHAR2(63)

FUNCTION

F_GET_STATUS_INFO

SUBMISSION_FISCAL_YEAR Extracts proposal submission fiscal year. VARCHAR2(63)

FUNCTION

FOFYCNV



Ver: 8.1