| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| FTVFUND_ACCT_CODE_ACCR |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
UNBILLED_ACCRUAL_ACCOUNT |
NO |
NA |
| FTVFUND_ACCT_CODE_CIP |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
CONSTR_IN_PROGR_ACCOUNT |
NO |
NA |
| FTVFUND_ACCT_CODE_REV |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
REVENUE_ACCRUAL_ACCOUNT |
NO |
NA |
| FTVFUND_ACTV_CODE_DEF |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL |
ACTIVITY_DEFAULT ACTIVITY_DEFAULT |
NO NO |
|
| FTVFUND_BANK_CODE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
FUND_BANK |
NO |
NA |
| FTVFUND_CASH_RECEIPT_BANK_CODE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
CASH_RECEIPT_BANK |
NO |
NA |
| FTVFUND_CLOSE_PROJ_IND |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
PROJECT_CLOSE_IND |
NO |
NA |
| FTVFUND_COAS_CODE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY AF_GRANT_FUND AF_FUND_HIERARCHY_FISCAL |
CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS |
NO NO NO |
NA |
| FTVFUND_CONP_PROJ_NUM |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
CONSTR_PROJECT_NUMBER |
NO |
NA |
| FTVFUND_CUM_COST_AMT |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
ESTIMATED_CUM_COST_AMOUNT |
NO |
NA |
| FTVFUND_DATA_ENTRY_IND |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_VALIDATION AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
DATA_ENTRY_IND DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED |
NO NO NO |
NA |
| FTVFUND_EFF_DATE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL |
EFFECTIVE_DATE |
NO |
|
| FTVFUND_EXPEND_END_DATE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY AF_GRANT_FUND AF_FUND_HIERARCHY_FISCAL |
EXPEND_END_DATE FUND_EXPENDITURE_END_DATE EXPEND_END_DATE |
NO NO NO |
NA |
| FTVFUND_FBAL_IND |
FTVFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
FUND_BALANCE FUND_BALANCE |
NO NO |
|
| FTVFUND_FMGR_CODE_PIDM |
NA |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
FINANCIAL_MANAGER_UID FINANCIAL_MANAGER_UID |
NO NO |
NA |
| FTVFUND_FMGR_CODE_PIDM_CONP |
NA |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
CONSTR_PROJECT_FMGR_UID |
NO |
NA |
| FTVFUND_FTYP_CODE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY AF_GRANT_FUND AF_FUND_HIERARCHY_FISCAL |
FUND_TYPE FUND_TYPE FUND_TYPE |
NO NO NO |
NA |
| FTVFUND_FUND_CODE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL AF_GRANT_FUND AF_FUND_HIERARCHY |
FUND FUND FUND |
NO NO NO |
NA |
| FTVFUND_FUND_CODE_PLANT_CONP |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
CONSTRUCTION_PLANT_FUND |
NO |
NA |
| FTVFUND_FUND_CODE_PRED |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
FUND_PREDECESSOR |
NO |
NA |
| FTVFUND_FUND_CODE_SOURCE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
SOURCE_FUND |
NO |
NA |
| FTVFUND_GRNT_CODE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_GRANT_FUND |
GRANT_ID GRANT_ID GRANT_ID |
NO NO NO |
NA |
| FTVFUND_LOCN_CODE_DEF |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
LOCATION_DEFAULT LOCATION_DEFAULT |
NO NO |
|
| FTVFUND_MAX_CONSTR_AMT |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
MAXIMUM_CONSTR_PROJECT_AMOUNT |
NO |
NA |
| FTVFUND_NCHG_DATE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL |
NEXT_CHANGE_DATE |
NO |
NA |
| FTVFUND_ORGN_CODE_DEF |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
ORGANIZATION_DEFAULT ORGANIZATION_DEFAULT |
NO NO |
|
| FTVFUND_PROG_CODE_DEF |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
PROGRAM_DEFAULT PROGRAM_DEFAULT |
NO NO |
|
| FTVFUND_PROJ_COMPLETE_DATE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
CONSTR_PROJECT_COMPLETE_DATE |
NO |
NA |
| FTVFUND_PROJ_DESC |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
CONSTR_PROJECT_DESC |
NO |
NA |
| FTVFUND_PROJ_END_DATE_CONP |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
CONSTR_PROJECT_END_DATE |
NO |
NA |
| FTVFUND_PROJ_START_DATE_CONP |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
CONSTR_PROJECT_START_DATE |
NO |
NA |
| FTVFUND_PROP_CODE |
FRAGRNT |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND |
PROPOSAL |
NO |
NA |
| FTVFUND_REST_IND |
FTVFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL |
FUND_RESTRICTION FUND_RESTRICTION |
NO NO |
|
| FTVFUND_STATUS_IND |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_GRANT_FUND |
FUND_STATUS FUND_STATUS FUND_STATUS |
NO NO NO |
NA |
| FTVFUND_TERM_DATE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY AF_GRANT_FUND AF_FUND_HIERARCHY_FISCAL |
TERMINATION_DATE FUND_TERMINATION_DATE TERMINATION_DATE |
NO NO NO |
NA |
| FTVFUND_TITLE |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_GRANT_FUND AN_PERSONNEL_ACTION_LABOR_DIST AF_TRANSACTION_HISTORY AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_ATTRIBUTES_ODS AP_PAYROLL_LABOR_DIST_OVERRIDE |
FUND_DESC FUND_DESC FUND_POOL_DESC FUND_DESC FUND_DESC FUND_DESC POSITION_FUND_DESC |
NO NO NO NO NO NO NO |
NA |