Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: FRBGRNT Finance Reporting View Meta Data Reports
Banner Operational Data Store Reporting View Source: FRBGRNT - NULL

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
FRBGRNT_ACTIVITY_DATE FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_ACTIVITY_DATE

NO

 
FRBGRNT_AGENCY_ADDR_CODE FTMAGCY NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

AGENCY_ADDRESS

AGENCY_ADDRESS

NO

NO

NA
FRBGRNT_AGENCY_ADDR_SEQ_NUM FTMAGCY NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

AGENCY_ADDRESS_SEQUENCE_NUMBER

AGENCY_ADDRESS_SEQUENCE_NUMBER

NO

NO

NA
FRBGRNT_AGENCY_CONTACT FTMAGCY NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

AGENCY_CONTACT

AGENCY_CONTACT

NO

NO

NA
FRBGRNT_AGENCY_EMAIL FTMAGCY NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

AGENCY_EMAIL

AGENCY_EMAIL

NO

NO

NA
FRBGRNT_AGENCY_PHONE_TYPE FTMAGCY NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

AGENCY_PHONE_TYPE

AGENCY_PHONE_TYPE

NO

NO

NA
FRBGRNT_AGENCY_PIDM NA NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

AGENCY_UID

AGENCY_UID

NO

NO

NA
FRBGRNT_AGENCY_TELE_SEQNO FTMAGCY NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

AGENCY_TELEPHONE_SEQ_NUMBER

AGENCY_TELEPHONE_SEQ_NUMBER

NO

NO

NA
FRBGRNT_ALTERNATE_STATUS_DESC FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

ALTERNATE_STATUS_DESC

ALTERNATE_STATUS_DESC

NO

NO

NA
FRBGRNT_BASI_CODE_CS FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

COST_SHARE_BASE

COST_SHARE_BASE

NO

NO

NA
FRBGRNT_BASI_CODE_IC FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

INDIRECT_COST_BASE

INDIRECT_COST_BASE

NO

NO

NA
FRBGRNT_CATEGORY FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

CATEGORY

CATEGORY

NO

NO

NA
FRBGRNT_CFDA_INTERNAL_ID_NO FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

FEDERAL_IDENTIFICATION_UID

FEDERAL_IDENTIFICATION_UID

NO

NO

NA
FRBGRNT_COAS_CODE FRAGRNT NO

REPORTING VIEW

GRANT_PERSONNEL

GRANT_VIEW

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

NO

NO

NA
FRBGRNT_COAS_CODE_IC_CS FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

CHART_OF_ACCOUNTS_COST

CHART_OF_ACCOUNTS_COST

NO

NO

NA
FRBGRNT_CODE FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

GRANT_ATTRIBUTES

GRANT_TEXT

GRANT_FUND_SLOT

GRANT_ID

GRANT_ID

GRANT_ID

GRANT_ID

GRANT_ID

NO

NO

NO

NO

NO

NA
FRBGRNT_CSTA_CODE_CHARGE FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

COST_SHARE_CHARGE

COST_SHARE_CHARGE

NO

NO

NA
FRBGRNT_CSTD_CODE_DISTR FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

COST_SHARE_DISTRIBUTION

COST_SHARE_DISTRIBUTION

NO

NO

NA
FRBGRNT_CSTR_CODE_RATE FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

COST_SHARE_RATE

COST_SHARE_RATE

NO

NO

NA
FRBGRNT_CUM_FUNDING_AMT FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

CUMULATIVE_AMOUNT

CUMULATIVE_AMOUNT

NO

NO

NA
FRBGRNT_CURRENT_FUNDING_AMT FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

PROPOSAL

CURRENT_YEAR_AMOUNT

CURRENT_YEAR_AMOUNT

GRANT_AWARD_AMOUNT

NO

NO

NO

NA
FRBGRNT_EFF_CERT_REQUIRED_IND FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

EFFORT_CERTIFICATION_REQ_IND

NO

 
FRBGRNT_EXPEND_END_DATE FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

EXPENDITURE_END_DATE

EXPENDITURE_END_DATE

NO

NO

NA
FRBGRNT_GRANT_TYPE FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

GRANT_TYPE

GRANT_TYPE

NO

NO

NA
FRBGRNT_GRNT_CODE_RELATED FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

RELATED_GRANT

RELATED_GRANT

NO

NO

NA
FRBGRNT_INDA_CODE_CHARGE FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

INDIRECT_COST_CHARGE

INDIRECT_COST_CHARGE

NO

NO

NA
FRBGRNT_INDD_CODE_DISTR FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

INDIRECT_COST_DISTRIBUTION

INDIRECT_COST_DISTRIBUTION

NO

NO

NA
FRBGRNT_INDR_CODE_RATE FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

INDIRECT_COST_RATE

INDIRECT_COST_RATE

NO

NO

NA
FRBGRNT_LONG_TITLE FRAGRNT NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

FIXED_ASSET_ITEM

GRANT_APPLIED_PAYMENTS

GRANT_VIEW

GRANT_BILLING_DETAIL

GRANT_FUND

GRANT_TEXT

GRANT_ATTRIBUTES

LONG_TITLE

GRANT_LONG_TITLE

LONG_TITLE

LONG_TITLE

LONG_TITLE

GRANT_LONG_TITLE

LONG_TITLE

LONG_TITLE

NO

NO

NO

NO

NO

NO

NO

NO

NA
FRBGRNT_MAX_FUNDING_AMT FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

AGENCY_COMMITMENT_AMOUNT

AGENCY_COMMITMENT_AMOUNT

NO

NO

NA
FRBGRNT_ORGN_CODE_RESP_OFFICE FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

RESPONSIBLE_ORGANIZATION_CODE

RESPONSIBLE_ORGANIZATION_CODE

NO

NO

NA
FRBGRNT_PI_PIDM NA NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

PRINCIPAL_INVESTIGATOR_UID

PRINCIPAL_INVESTIGATOR_UID

NO

NO

NA
FRBGRNT_PROJECT_END_DATE FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

PROJECT_END_DATE

PROJECT_END_DATE

NO

NO

NA
FRBGRNT_PROJECT_START_DATE FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

PROJECT_START_DATE

PROJECT_START_DATE

NO

NO

NA
FRBGRNT_PROP_CODE FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

PROPOSAL

NO

NA
FRBGRNT_RCPT_SHARE_TOTAL FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

TOTAL_RECIPIENT_SHARE_AMOUNT

NO

 
FRBGRNT_SPONSOR_ID FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

SPONSOR_NUMBER

SPONSOR_NUMBER

NO

NO

NA
FRBGRNT_STATUS_CODE FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

STATUS

STATUS

NO

NO

NA
FRBGRNT_STATUS_DATE FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

STATUS_DATE

STATUS_DATE

NO

NO

NA
FRBGRNT_SUB_CATEGORY FRAGRNT NO

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

SUBCATEGORY

SUBCATEGORY

NO

NO

NA
FRBGRNT_TERM_DATE FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

TERMINATION_DATE

GRANT_TERMINATION_DATE

NO

NO

NA
FRBGRNT_TITLE FRAGRNT NO

REPORTING VIEW

GRANT_ATTRIBUTES

GRANT_BILLING_DETAIL

GRANT_FUND

GRANT_VIEW

GRANT_APPLIED_PAYMENTS

PROPOSAL

GRANT_PERSONNEL

GRANT_EVENT_STATUS

GRANT_DEFERRED_COST

GRANT_EVENT

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_TEXT

FIXED_ASSET_ITEM

SHORT_TITLE

SHORT_TITLE

GRANT_SHORT_TITLE

SHORT_TITLE

SHORT_TITLE

GRANT_TITLE

GRANT_SHORT_TITLE

GRANT_SHORT_TITLE

GRANT_SHORT_TITLE

GRANT_SHORT_TITLE

SHORT_TITLE

SHORT_TITLE

GRANT_TITLE

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NA
FRBGRNT_USER_ID FRAGRNT NO

REPORTING VIEW

GRANT_VIEW

GRANT_USER_ID

NO

 


Ver: 9.2