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

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

REPORTING VIEW

GRANT_VIEW

GRANT_ACTIVITY_DATE

 
FRBGRNT_AGENCY_ADDR_CODE FTMAGCY

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

AGENCY_ADDRESS

AGENCY_ADDRESS

NA
FRBGRNT_AGENCY_ADDR_SEQ_NUM FTMAGCY

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

AGENCY_ADDRESS_SEQUENCE_NUMBER

AGENCY_ADDRESS_SEQUENCE_NUMBER

NA
FRBGRNT_AGENCY_CONTACT FTMAGCY

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

AGENCY_CONTACT

AGENCY_CONTACT

NA
FRBGRNT_AGENCY_EMAIL FTMAGCY

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

AGENCY_EMAIL

AGENCY_EMAIL

NA
FRBGRNT_AGENCY_PHONE_TYPE FTMAGCY

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

AGENCY_PHONE_TYPE

AGENCY_PHONE_TYPE

NA
FRBGRNT_AGENCY_PIDM NA

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

AGENCY_UID

AGENCY_UID

NA
FRBGRNT_AGENCY_TELE_SEQNO FTMAGCY

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

AGENCY_TELEPHONE_SEQ_NUMBER

AGENCY_TELEPHONE_SEQ_NUMBER

NA
FRBGRNT_ALTERNATE_STATUS_DESC FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

ALTERNATE_STATUS_DESC

ALTERNATE_STATUS_DESC

NA
FRBGRNT_BASI_CODE_CS FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

COST_SHARE_BASE

COST_SHARE_BASE

NA
FRBGRNT_BASI_CODE_IC FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

INDIRECT_COST_BASE

INDIRECT_COST_BASE

NA
FRBGRNT_CATEGORY FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

CATEGORY

CATEGORY

NA
FRBGRNT_CFDA_INTERNAL_ID_NO FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

FEDERAL_IDENTIFICATION_UID

FEDERAL_IDENTIFICATION_UID

NA
FRBGRNT_COAS_CODE FRAGRNT

REPORTING VIEW

GRANT_PERSONNEL

GRANT_VIEW

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

NA
FRBGRNT_COAS_CODE_IC_CS FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

CHART_OF_ACCOUNTS_COST

CHART_OF_ACCOUNTS_COST

NA
FRBGRNT_CODE FRAGRNT

REPORTING VIEW

GRANT_FUND_SLOT

GRANT_TEXT

GRANT_VIEW

GRANT_ATTRIBUTES

GRANT_FUND

GRANT_ID

GRANT_ID

GRANT_ID

GRANT_ID

GRANT_ID

NA
FRBGRNT_CSTA_CODE_CHARGE FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

COST_SHARE_CHARGE

COST_SHARE_CHARGE

NA
FRBGRNT_CSTD_CODE_DISTR FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

COST_SHARE_DISTRIBUTION

COST_SHARE_DISTRIBUTION

NA
FRBGRNT_CSTR_CODE_RATE FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

COST_SHARE_RATE

COST_SHARE_RATE

NA
FRBGRNT_CUM_FUNDING_AMT FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

CUMULATIVE_AMOUNT

CUMULATIVE_AMOUNT

NA
FRBGRNT_CURRENT_FUNDING_AMT FRAGRNT

REPORTING VIEW

PROPOSAL

GRANT_FUND

GRANT_VIEW

GRANT_AWARD_AMOUNT

CURRENT_YEAR_AMOUNT

CURRENT_YEAR_AMOUNT

NA
FRBGRNT_EFF_CERT_REQUIRED_IND FRAGRNT

REPORTING VIEW

GRANT_VIEW

EFFORT_CERTIFICATION_REQ_IND

 
FRBGRNT_EXPEND_END_DATE FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

EXPENDITURE_END_DATE

EXPENDITURE_END_DATE

NA
FRBGRNT_GRANT_TYPE FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

GRANT_TYPE

GRANT_TYPE

NA
FRBGRNT_GRNT_CODE_RELATED FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

RELATED_GRANT

RELATED_GRANT

NA
FRBGRNT_INDA_CODE_CHARGE FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

INDIRECT_COST_CHARGE

INDIRECT_COST_CHARGE

NA
FRBGRNT_INDD_CODE_DISTR FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

INDIRECT_COST_DISTRIBUTION

INDIRECT_COST_DISTRIBUTION

NA
FRBGRNT_INDR_CODE_RATE FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

INDIRECT_COST_RATE

INDIRECT_COST_RATE

NA
FRBGRNT_LONG_TITLE FRAGRNT

REPORTING VIEW

GRANT_ATTRIBUTES

GRANT_BILLING_DETAIL

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_VIEW

GRANT_APPLIED_PAYMENTS

GRANT_TEXT

GRANT_FUND

FIXED_ASSET_ITEM

LONG_TITLE

LONG_TITLE

LONG_TITLE

LONG_TITLE

LONG_TITLE

LONG_TITLE

GRANT_LONG_TITLE

GRANT_LONG_TITLE

NA
FRBGRNT_MAX_FUNDING_AMT FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

AGENCY_COMMITMENT_AMOUNT

AGENCY_COMMITMENT_AMOUNT

NA
FRBGRNT_ORGN_CODE_RESP_OFFICE FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

RESPONSIBLE_ORGANIZATION_CODE

RESPONSIBLE_ORGANIZATION_CODE

NA
FRBGRNT_PI_PIDM NA

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

PRINCIPAL_INVESTIGATOR_UID

PRINCIPAL_INVESTIGATOR_UID

NA
FRBGRNT_PROJECT_END_DATE FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

PROJECT_END_DATE

PROJECT_END_DATE

NA
FRBGRNT_PROJECT_START_DATE FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_FUND

PROJECT_START_DATE

PROJECT_START_DATE

NA
FRBGRNT_PROP_CODE FRAGRNT

REPORTING VIEW

GRANT_VIEW

PROPOSAL

NA
FRBGRNT_RCPT_SHARE_TOTAL FRAGRNT

REPORTING VIEW

GRANT_VIEW

TOTAL_RECIPIENT_SHARE_AMOUNT

 
FRBGRNT_SPONSOR_ID FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

SPONSOR_NUMBER

SPONSOR_NUMBER

NA
FRBGRNT_STATUS_CODE FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

STATUS

STATUS

NA
FRBGRNT_STATUS_DATE FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

STATUS_DATE

STATUS_DATE

NA
FRBGRNT_SUB_CATEGORY FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

SUBCATEGORY

SUBCATEGORY

NA
FRBGRNT_TERM_DATE FRAGRNT

REPORTING VIEW

GRANT_FUND

GRANT_VIEW

GRANT_TERMINATION_DATE

TERMINATION_DATE

NA
FRBGRNT_TITLE FRAGRNT

REPORTING VIEW

GRANT_DEFERRED_COST

GRANT_VIEW

GRANT_APPLIED_PAYMENTS

GRANT_EVENT

GRANT_PERSONNEL

GRANT_TEXT

FIXED_ASSET_ITEM

PROPOSAL

GRANT_FUND

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_BILLING_DETAIL

GRANT_ATTRIBUTES

GRANT_EVENT_STATUS

GRANT_SHORT_TITLE

SHORT_TITLE

SHORT_TITLE

GRANT_SHORT_TITLE

GRANT_SHORT_TITLE

SHORT_TITLE

GRANT_TITLE

GRANT_TITLE

GRANT_SHORT_TITLE

SHORT_TITLE

SHORT_TITLE

SHORT_TITLE

GRANT_SHORT_TITLE

NA
FRBGRNT_USER_ID FRAGRNT

REPORTING VIEW

GRANT_VIEW

GRANT_USER_ID

 


Ver: 9.0