RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FRBGRNT Finance Composite View Reports
SGHE Operational Data Store Composite View Source: FRBGRNT

Source Column Source Form Target Type Target Target Column Calculation Formula
FRBGRNT_AGENCY_ADDR_CODE FTMAGCY COMPOSITE VIEW

AF_GRANT

AGENCY_ADDRESS

NA
FRBGRNT_AGENCY_ADDR_SEQ_NUM FTMAGCY COMPOSITE VIEW

AF_GRANT

AGENCY_ADDRESS_SEQUENCE_NUMBER

NA
FRBGRNT_AGENCY_CONTACT FTMAGCY COMPOSITE VIEW

AF_GRANT

AGENCY_CONTACT

NA
FRBGRNT_AGENCY_EMAIL FTMAGCY COMPOSITE VIEW

AF_GRANT

AGENCY_EMAIL

NA
FRBGRNT_AGENCY_PHONE_TYPE FTMAGCY COMPOSITE VIEW

AF_GRANT

AGENCY_PHONE_TYPE

NA
FRBGRNT_AGENCY_PIDM NA COMPOSITE VIEW

AF_GRANT

AGENCY_UID

NA
FRBGRNT_AGENCY_TELE_SEQNO FTMAGCY COMPOSITE VIEW

AF_GRANT

AGENCY_TELEPHONE_SEQ_NUMBER

NA
FRBGRNT_ALTERNATE_STATUS_DESC FRAGRNT COMPOSITE VIEW

AF_GRANT

ALTERNATE_STATUS_DESC

NA
FRBGRNT_BASI_CODE_CS FRAGRNT COMPOSITE VIEW

AF_GRANT

COST_SHARE_BASE

NA
FRBGRNT_BASI_CODE_IC FRAGRNT COMPOSITE VIEW

AF_GRANT

INDIRECT_COST_BASE

NA
FRBGRNT_CATEGORY FRAGRNT COMPOSITE VIEW

AF_GRANT

CATEGORY

NA
FRBGRNT_CFDA_INTERNAL_ID_NO FRAGRNT COMPOSITE VIEW

AF_GRANT

AF_GRANT

FEDERAL_IDENTIFICATION_UID

FEDERAL_IDENTIFICATION

NA
FRBGRNT_COAS_CODE FRAGRNT COMPOSITE VIEW

AF_GRANT

CHART_OF_ACCOUNTS

NA
FRBGRNT_COAS_CODE_IC_CS FRAGRNT COMPOSITE VIEW

AF_GRANT

CHART_OF_ACCOUNTS_COST

NA
FRBGRNT_CODE FRAGRNT COMPOSITE VIEW

AF_GRANT

GRANT_ID

NA
FRBGRNT_CSTA_CODE_CHARGE FRAGRNT COMPOSITE VIEW

AF_GRANT

COST_SHARE_CHARGE

NA
FRBGRNT_CSTD_CODE_DISTR FRAGRNT COMPOSITE VIEW

AF_GRANT

COST_SHARE_DISTRIBUTION

NA
FRBGRNT_CSTR_CODE_RATE FRAGRNT COMPOSITE VIEW

AF_GRANT

COST_SHARE_RATE

NA
FRBGRNT_CUM_FUNDING_AMT FRAGRNT COMPOSITE VIEW

AF_GRANT

CUMULATIVE_AMOUNT

NA
FRBGRNT_CURRENT_FUNDING_AMT FRAGRNT COMPOSITE VIEW

AF_GRANT

CURRENT_YEAR_AMOUNT

NA
FRBGRNT_EXPEND_END_DATE FRAGRNT COMPOSITE VIEW

AF_GRANT

EXPENDITURE_END_DATE

NA
FRBGRNT_GRANT_TYPE FRAGRNT COMPOSITE VIEW

AF_GRANT

GRANT_TYPE

NA
FRBGRNT_GRNT_CODE_RELATED FRAGRNT COMPOSITE VIEW

AF_GRANT

RELATED_GRANT

NA
FRBGRNT_INDA_CODE_CHARGE FRAGRNT COMPOSITE VIEW

AF_GRANT

INDIRECT_COST_CHARGE

NA
FRBGRNT_INDD_CODE_DISTR FRAGRNT COMPOSITE VIEW

AF_GRANT

INDIRECT_COST_DISTRIBUTION

NA
FRBGRNT_INDR_CODE_RATE FRAGRNT COMPOSITE VIEW

AF_GRANT

INDIRECT_COST_RATE

NA
FRBGRNT_LONG_TITLE FRAGRNT COMPOSITE VIEW

AF_GRANT_ATTRIBUTES_ODS

AF_FIXED_ASSET_ITEM

AF_GRANT

LONG_TITLE

GRANT_LONG_TITLE

LONG_TITLE

NA
FRBGRNT_MAX_FUNDING_AMT FRAGRNT COMPOSITE VIEW

AF_GRANT

AGENCY_COMMITMENT_AMOUNT

NA
FRBGRNT_ORGN_CODE_RESP_OFFICE FRAGRNT COMPOSITE VIEW

AF_GRANT

RESPONSIBLE_ORGANIZATION_CODE

NA
FRBGRNT_PI_PIDM NA COMPOSITE VIEW

AF_GRANT

PRINCIPAL_INVESTIGATOR_UID

NA
FRBGRNT_PROJECT_END_DATE FRAGRNT COMPOSITE VIEW

AF_GRANT

PROJECT_END_DATE

NA
FRBGRNT_PROJECT_START_DATE FRAGRNT COMPOSITE VIEW

AF_GRANT

PROJECT_START_DATE

NA
FRBGRNT_PROP_CODE FRAGRNT COMPOSITE VIEW

AF_GRANT

PROPOSAL

NA
FRBGRNT_SPONSOR_ID FRAGRNT COMPOSITE VIEW

AF_GRANT

SPONSOR_NUMBER

NA
FRBGRNT_STATUS_CODE FRAGRNT COMPOSITE VIEW

AF_GRANT

STATUS

NA
FRBGRNT_STATUS_DATE FRAGRNT COMPOSITE VIEW

AF_GRANT

STATUS_DATE

NA
FRBGRNT_SUB_CATEGORY FRAGRNT COMPOSITE VIEW

AF_GRANT

SUBCATEGORY

NA
FRBGRNT_TERM_DATE FRAGRNT COMPOSITE VIEW

AF_GRANT

TERMINATION_DATE

NA
FRBGRNT_TITLE FRAGRNT COMPOSITE VIEW

AF_GRANT

AF_GRANT_ATTRIBUTES_ODS

AF_FIXED_ASSET_ITEM

SHORT_TITLE

SHORT_TITLE

GRANT_TITLE

NA


Ver: 3.1