RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Operational Data Store
Composite View Target: AF_PROPOSAL

Description Source composite view contains information for each proposal.

Target Column Business Definition Database Data Type Source Name Source Column
AGENCY_UID System generated unique internal identification number assigned to this organization entity. NUMBER(8)

FRBPROP

FRBPROP_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

AWARD_DATE Extracts recorded date proposal was awarded the grant. DATE

FUNCTION

F_GET_STATUS_DATE

AWARD_FISCAL_PERIOD Extracts awarded fiscal period. VARCHAR2(2)

FUNCTION

F_GET_STATUS_INFO

AWARD_FISCAL_YEAR This is the Award Fiscal Year. In the Datamart this uses function f_get_status_info to get award fiscal year where status is A. VARCHAR2(4)

FUNCTION

FOFYCNV

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

FRBPROP

FRBPROP_CATEGORY

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

FRBPROP

FRBPROP_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

CURRENT_STATUS Current status of the proposal. VARCHAR2(2)

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

FUNCTION

F_GET_STATUS_INFO

DECLINE_FISCAL_YEAR This is the Decline Fiscal Year. In the Datamart this uses function f_get_status_info to get decline date where decline fiscal year is D. VARCHAR2(4)

FUNCTION

FOFYCNV

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

FEDERAL_IDENTIFICATION This is the CFDA code. VARCHAR2(12)

FRBPROP

FRBPROP_CFDA_INTERNAL_ID_NO

FEDERAL_IDENTIFICATION_DESC Description of the CFDA code.  

FRVCFDA

FRVCFDA_TITLE

FEDERAL_IDENTIFICATION_UID Identifies the CFDA number.  

FRBPROP

FRBPROP_CFDA_INTERNAL_ID_NO

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

FRBPROP

FRBPROP_GRNT_CODE

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

FRRPLOC

FRRPLOC_LOCN_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

NA

NA

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

NA

NA

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

FRRPLOC

FRRPLOC_LOCN_RESEARCH_IND

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

FRBPROP

FRBPROP_ORGN_CODE_RESP_OFFICE

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

FUNCTION

F_GET_FINANCE_DESC

ORIGINATION_DATE Extracted proposal origination date. DATE

FUNCTION

F_GET_STATUS_DATE

ORIGINATION_FISCAL_PERIOD Extracted proposal origination fiscal period. VARCHAR2(2)

FUNCTION

F_GET_STATUS_INFO

ORIGINATION_FISCAL_YEAR This is the Origination Fiscal Year. In the Datamart this uses function f_get_status_info to get origination fiscal year where status in N. VARCHAR2(4)

FUNCTION

FOFYCNV

PI_IND Principal investigator type. VARCHAR2(3)

FRRPRPI

FRRPRPI_ID_IND

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

FRBPROP

FRBPROP_PI_PIDM

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

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

FRBPROP

FRBPROP_TITLE

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

FRBPROP

FRBPROP_PROPOSAL_TYPE

PROPOSAL_TYPE_DESC Description of the proposal type.  

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

REQUESTED_AMOUNT Total proposed amount to the agency including direct and indirect costs. NUMBER(12, 2)

FRBPROP

FRBPROP_REQUESTED_AMT

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

FRBPROP

FRBPROP_SPONSOR_ID

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

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

FUNCTION

F_GET_STATUS_INFO

SUBMISSION_FISCAL_YEAR This is the Submission Fiscal Year. In the Datamart this uses function f_get_status_info to get submission fiscal year where status is S. VARCHAR2(4)

FUNCTION

FOFYCNV

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

NA

NA



Ver: 3.1