| 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 |
|