Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_GRANT

Description Source composite view contains grants and their associated information.

Target Column Business Definition Database Data Type Source Name Source Column
AGENCY_ADDRESS Address type associated with this agency. VARCHAR2(2)

FRBGRNT

FRBGRNT_AGENCY_ADDR_CODE

AGENCY_ADDRESS_SEQUENCE_NUMBER Sequence number associated with this address type to uniquely identify the address. NUMBER(2)

FRBGRNT

FRBGRNT_AGENCY_ADDR_SEQ_NUM

AGENCY_COMMITMENT_AMOUNT Maximum amount of money the agency commits to the grant. Informational only. NUMBER(17,2)

FRBGRNT

FRBGRNT_MAX_FUNDING_AMT

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

FRBGRNT

FRBGRNT_AGENCY_CONTACT

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

FRBGRNT

FRBGRNT_AGENCY_EMAIL

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

FRBGRNT

FRBGRNT_AGENCY_PHONE_TYPE

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

FRBGRNT

FRBGRNT_AGENCY_TELE_SEQNO

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

FRBGRNT

FRBGRNT_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

ALTERNATE_STATUS_DESC Alternate status description. VARCHAR2(35)

FRBGRNT

FRBGRNT_ALTERNATE_STATUS_DESC

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

FRBGRNT

FRBGRNT_CATEGORY

CATEGORY_DESC Grant category description. VARCHAR2(35)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

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

FRBGRNT

FRBGRNT_COAS_CODE_IC_CS

CHART_OF_ACCOUNTS_COST_DESC Chart of accounts extracted description or title. VARCHAR2(35)

FTVCOAS

FTVCOAS_TITLE

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

FUNCTION

F_GET_FINANCE_DESC

COST_SHARE_BASE Code defines the base information for cost share calculations. VARCHAR2(6)

FRBGRNT

FRBGRNT_BASI_CODE_CS

COST_SHARE_BASE_DESC Cost share base description. VARCHAR2(35)

FRVBASI

FRVBASI_DESC

COST_SHARE_CHARGE Code defines account's and percentage of the charge. VARCHAR2(6)

FRBGRNT

FRBGRNT_CSTA_CODE_CHARGE

COST_SHARE_CHARGE_DESC Cost share charge description. VARCHAR2(35)

FRVCSTA

FRVCSTA_DESC

COST_SHARE_DISTRIBUTION Code defines the account distribution for indirect cost. VARCHAR2(6)

FRBGRNT

FRBGRNT_CSTD_CODE_DISTR

COST_SHARE_DISTRIBUTION_DESC Cost share distribution description. VARCHAR2(35)

FRVCSTD

FRVCSTD_DESC

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

FRBGRNT

FRBGRNT_CSTR_CODE_RATE

COST_SHARE_RATE_DESC Cost share rate description. VARCHAR2(35)

FRVCSTR

FRVCSTR_DESC

CUMULATIVE_AMOUNT Cumulative funding amount of the grant, received from the agency to date. Informational only. NUMBER(17,2)

FRBGRNT

FRBGRNT_CUM_FUNDING_AMT

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

NA

SYSDATE

CURRENT_YEAR_AMOUNT Current year funding amount of the grant, committed by the agency. Informational only. NUMBER(17,2)

FRBGRNT

FRBGRNT_CURRENT_FUNDING_AMT

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

NA

NA

EXPENDITURE_END_DATE Ending period date for expenditure activity. DATE

FRBGRNT

FRBGRNT_EXPEND_END_DATE

FEDERAL_IDENTIFICATION This is the CFDA code. VARCHAR2(12)

FRBGRNT

FRBGRNT_CFDA_INTERNAL_ID_NO

FEDERAL_IDENTIFICATION_DESC Description of the CFDA code.  

FRVCFDA

FRVCFDA_TITLE

FEDERAL_IDENTIFICATION_UID Identifies the CFDA number.  

FRBGRNT

FRBGRNT_CFDA_INTERNAL_ID_NO

FIELD_OF_SCIENCE Field of science. VARCHAR2(0)

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

FRBGRNT

FRBGRNT_CODE

GRANT_TYPE Grant type code to reflect if this is a grant, contract, cooperative agreement, etc. VARCHAR2(2)

FRBGRNT

FRBGRNT_GRANT_TYPE

GRANT_TYPE_DESC Retrieved description for grant type. VARCHAR2(35)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

FRBGRNT

FRBGRNT_BASI_CODE_IC

INDIRECT_COST_BASE_DESC Indirect cost base code description. VARCHAR2(35)

FRVBASI

FRVBASI_DESC

INDIRECT_COST_CHARGE Code identifies the account's and the percentage of the charge. VARCHAR2(6)

FRBGRNT

FRBGRNT_INDA_CODE_CHARGE

INDIRECT_COST_CHARGE_DESC Indirect cost charge description. VARCHAR2(35)

FRVINDA

FRVINDA_DESC

INDIRECT_COST_DISTRIBUTION Code identifies the accounting distribution for indirect cost. VARCHAR2(6)

FRBGRNT

FRBGRNT_INDD_CODE_DISTR

INDIRECT_COST_DISTRIB_DESC Indirect cost distribution description. VARCHAR2(35)

FRVINDD

FRVINDD_DESC

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

FRBGRNT

FRBGRNT_INDR_CODE_RATE

INDIRECT_COST_RATE_DESC Indirect cost rate code description. VARCHAR2(35)

FRVINDR

FRVINDR_DESC

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

FRVPMSC

FRVPMSC_LOC_NO

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

FRRGLOC

FRRGLOC_LOCN_CODE

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

FUNCTION

F_GET_FINANCE_DESC

LONG_TITLE Grant description or title. VARCHAR2(256)

FRBGRNT

FRBGRNT_LONG_TITLE

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)

FRRGLOC

FRRGLOC_LOCN_RESEARCH_IND

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

FRBGBIL

FRBGBIL_PMSC_CODE

PAYMENT_MANAGEMENT_SYS_DESC Payment management system description. VARCHAR2(35)

FRVPMSC

FRVPMSC_DESC

PRINCIPAL_INVESTIGATOR_TITLE Official position/title that belongs to the principal investigator. VARCHAR2(35)

FRRGRPI

FRRGRPI_TITLE

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

FRBGRNT

FRBGRNT_PI_PIDM

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

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

FRBPROP

FRBPROP_TITLE

RELATED_GRANT Grant code of a prior defined grant used to copy data from into this grant. VARCHAR2(9)

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

NA

NA

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

FRBGRNT

FRBGRNT_ORGN_CODE_RESP_OFFICE

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

FUNCTION

F_GET_FINANCE_DESC

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

FUNCTION

F_GET_FINANCE_STATUS

SHORT_TITLE Grant description or title. VARCHAR2(35)

FRBGRNT

FRBGRNT_TITLE

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

FRBGRNT

FRBGRNT_SPONSOR_ID

STATUS Status code of the grant. VARCHAR2(2)

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

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

FUNCTION

F_GET_FISCAL_PERIOD

STATUS_FISCAL_YEAR Calculated using the status date. VARCHAR2(4)

FUNCTION

FOFYCNV

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

FRBGRNT

FRBGRNT_SUB_CATEGORY

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

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

NA

NA

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

NA

NA



Ver: 8.0