| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| FRBGRNT_ACTIVITY_DATE |
FRAGRNT |
NO |
|
|
|
|
|
| FRBGRNT_AGENCY_ADDR_CODE |
FTMAGCY |
NO |
COMPOSITE VIEW |
AF_GRANT |
AGENCY_ADDRESS |
NO |
NA |
| FRBGRNT_AGENCY_ADDR_SEQ_NUM |
FTMAGCY |
NO |
COMPOSITE VIEW |
AF_GRANT |
AGENCY_ADDRESS_SEQUENCE_NUMBER |
NO |
NA |
| FRBGRNT_AGENCY_CONTACT |
FTMAGCY |
NO |
COMPOSITE VIEW |
AF_GRANT |
AGENCY_CONTACT |
NO |
NA |
| FRBGRNT_AGENCY_EMAIL |
FTMAGCY |
NO |
COMPOSITE VIEW |
AF_GRANT |
AGENCY_EMAIL |
NO |
NA |
| FRBGRNT_AGENCY_PHONE_TYPE |
FTMAGCY |
NO |
COMPOSITE VIEW |
AF_GRANT |
AGENCY_PHONE_TYPE |
NO |
NA |
| FRBGRNT_AGENCY_PIDM |
NA |
NO |
COMPOSITE VIEW |
AF_GRANT |
AGENCY_UID |
NO |
NA |
| FRBGRNT_AGENCY_TELE_SEQNO |
FTMAGCY |
NO |
COMPOSITE VIEW |
AF_GRANT |
AGENCY_TELEPHONE_SEQ_NUMBER |
NO |
NA |
| FRBGRNT_ALTERNATE_STATUS_DESC |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
ALTERNATE_STATUS_DESC |
NO |
NA |
| FRBGRNT_BASI_CODE_CS |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
COST_SHARE_BASE |
NO |
NA |
| FRBGRNT_BASI_CODE_IC |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
INDIRECT_COST_BASE |
NO |
NA |
| FRBGRNT_CATEGORY |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
CATEGORY |
NO |
NA |
| FRBGRNT_CFDA_INTERNAL_ID_NO |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT AF_GRANT |
FEDERAL_IDENTIFICATION_UID FEDERAL_IDENTIFICATION |
NO NO |
NA |
| FRBGRNT_COAS_CODE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT_PERSONNEL AF_GRANT |
CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS |
NO NO |
NA |
| FRBGRNT_COAS_CODE_IC_CS |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
CHART_OF_ACCOUNTS_COST |
NO |
NA |
| FRBGRNT_CODE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
GRANT_ID |
NO |
NA |
| FRBGRNT_CSTA_CODE_CHARGE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
COST_SHARE_CHARGE |
NO |
NA |
| FRBGRNT_CSTD_CODE_DISTR |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
COST_SHARE_DISTRIBUTION |
NO |
NA |
| FRBGRNT_CSTR_CODE_RATE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
COST_SHARE_RATE |
NO |
NA |
| FRBGRNT_CUM_FUNDING_AMT |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
CUMULATIVE_AMOUNT |
NO |
NA |
| FRBGRNT_CURRENT_FUNDING_AMT |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
CURRENT_YEAR_AMOUNT |
NO |
NA |
| FRBGRNT_EFF_CERT_REQUIRED_IND |
FRAGRNT |
NO |
|
|
|
|
|
| FRBGRNT_EXPEND_END_DATE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
EXPENDITURE_END_DATE |
NO |
NA |
| FRBGRNT_GRANT_TYPE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
GRANT_TYPE |
NO |
NA |
| FRBGRNT_GRNT_CODE_RELATED |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
RELATED_GRANT |
NO |
NA |
| FRBGRNT_INDA_CODE_CHARGE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
INDIRECT_COST_CHARGE |
NO |
NA |
| FRBGRNT_INDD_CODE_DISTR |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
INDIRECT_COST_DISTRIBUTION |
NO |
NA |
| FRBGRNT_INDR_CODE_RATE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
INDIRECT_COST_RATE |
NO |
NA |
| FRBGRNT_LONG_TITLE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_FIXED_ASSET_ITEM AF_GRANT AF_GRANT_ATTRIBUTES_ODS |
GRANT_LONG_TITLE LONG_TITLE LONG_TITLE |
NO NO NO |
NA |
| FRBGRNT_MAX_FUNDING_AMT |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
AGENCY_COMMITMENT_AMOUNT |
NO |
NA |
| FRBGRNT_ORGN_CODE_RESP_OFFICE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
RESPONSIBLE_ORGANIZATION_CODE |
NO |
NA |
| FRBGRNT_PI_PIDM |
NA |
NO |
COMPOSITE VIEW |
AF_GRANT |
PRINCIPAL_INVESTIGATOR_UID |
NO |
NA |
| FRBGRNT_PROJECT_END_DATE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
PROJECT_END_DATE |
NO |
NA |
| FRBGRNT_PROJECT_START_DATE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
PROJECT_START_DATE |
NO |
NA |
| FRBGRNT_PROP_CODE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
PROPOSAL |
NO |
NA |
| FRBGRNT_RCPT_SHARE_TOTAL |
FRAGRNT |
NO |
|
|
|
|
|
| FRBGRNT_SPONSOR_ID |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
SPONSOR_NUMBER |
NO |
NA |
| FRBGRNT_STATUS_CODE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
STATUS |
NO |
NA |
| FRBGRNT_STATUS_DATE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
STATUS_DATE |
NO |
NA |
| FRBGRNT_SUB_CATEGORY |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
SUBCATEGORY |
NO |
NA |
| FRBGRNT_TERM_DATE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT |
TERMINATION_DATE |
NO |
NA |
| FRBGRNT_TITLE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_FIXED_ASSET_ITEM AF_GRANT AF_GRANT_ATTRIBUTES_ODS |
GRANT_TITLE SHORT_TITLE SHORT_TITLE |
NO NO NO |
NA |
| FRBGRNT_USER_ID |
FRAGRNT |
NO |
|
|
|
|
|