| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| FTVFUND_ACCT_CODE_ACCR |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
UNBILLED_ACCRUAL_ACCOUNT |
NO |
NA |
| FTVFUND_ACCT_CODE_CIP |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
CONSTR_IN_PROGR_ACCOUNT |
NO |
NA |
| FTVFUND_ACCT_CODE_REV |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
REVENUE_ACCRUAL_ACCOUNT |
NO |
NA |
| FTVFUND_ACTV_CODE_DEF |
FTMFUND |
NO |
REPORTING VIEW |
FUND_HIERARCHY FUND_HIERARCHY_FISCAL |
ACTIVITY_DEFAULT ACTIVITY_DEFAULT |
NO NO |
|
| FTVFUND_BANK_CODE |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
FUND_BANK |
NO |
NA |
| FTVFUND_CASH_RECEIPT_BANK_CODE |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
CASH_RECEIPT_BANK |
NO |
NA |
| FTVFUND_CLOSE_PROJ_IND |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
PROJECT_CLOSE_IND |
NO |
NA |
| FTVFUND_COAS_CODE |
FRAGRNT |
NO |
REPORTING VIEW |
GRANT_FUND_SLOT FUND_HIERARCHY_FISCAL GRANT_FUND_SLOT FUND_HIERARCHY GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT |
CHART_OF_ACCOUNTS6 CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS9 CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS2 CHART_OF_ACCOUNTS1 CHART_OF_ACCOUNTS10 CHART_OF_ACCOUNTS5 CHART_OF_ACCOUNTS8 CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS4 CHART_OF_ACCOUNTS3 CHART_OF_ACCOUNTS7 |
NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| FTVFUND_CONP_PROJ_NUM |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
CONSTR_PROJECT_NUMBER |
NO |
NA |
| FTVFUND_CUM_COST_AMT |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
ESTIMATED_CUM_COST_AMOUNT |
NO |
NA |
| FTVFUND_DATA_ENTRY_IND |
FTMFUND |
NO |
REPORTING VIEW |
FUND_HIERARCHY VALIDATION FUND_HIERARCHY_FISCAL |
DATA_ENTRY_PERMITTED DATA_ENTRY_IND DATA_ENTRY_PERMITTED |
NO NO NO |
NA |
| FTVFUND_EFF_DATE |
FTMFUND |
NO |
|
|
|
|
|
| FTVFUND_EXPEND_END_DATE |
FTMFUND |
NO |
REPORTING VIEW |
FUND_HIERARCHY FUND_HIERARCHY_FISCAL GRANT_FUND |
EXPEND_END_DATE EXPEND_END_DATE FUND_EXPENDITURE_END_DATE |
NO NO NO |
NA |
| FTVFUND_FBAL_IND |
FTVFUND |
NO |
REPORTING VIEW |
FUND_HIERARCHY FUND_HIERARCHY_FISCAL |
FUND_BALANCE FUND_BALANCE |
NO NO |
|
| FTVFUND_FMGR_CODE_PIDM |
NA |
NO |
REPORTING VIEW |
FIXED_ASSET_ACCOUNTING_SOURCE GRANT_DEFERRED_COST GRANT_FUND BUDGET_AVAILABILITY_LEDGER FIXED_ASSET_FUNDING_SOURCE FUND_HIERARCHY_FISCAL AUTHORIZATION_ACCOUNTING OPERATING_LEDGER TRANSACTION_HISTORY BUDGET_DETAIL GRANT_DEFERRED_COST INVOICE_ACCOUNTING INVOICE_ITEM_ACCOUNTING PURCHASE_ORDER_ACCOUNTING REIMBURSEMENT_ACCOUNTING FUND_HIERARCHY GENERAL_LEDGER PURCHASE_ORDER_ITEM_ACCOUNTING |
FUND_FINANCIAL_MANAGER_UID ORIG_FUND_FMGR_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| FTVFUND_FMGR_CODE_PIDM_CONP |
NA |
NO |
REPORTING VIEW |
GRANT_FUND |
CONSTR_PROJECT_FMGR_UID |
NO |
NA |
| FTVFUND_FTYP_CODE |
FTMFUND |
NO |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING FUND_HIERARCHY_FISCAL GRANT_FUND AUTHORIZATION_ACCOUNTING FUND_HIERARCHY AUTHORIZATION_ACCOUNTING |
FUND_TYPE_LEVEL_2 FUND_TYPE FUND_TYPE FUND_TYPE_LEVEL_2 FUND_TYPE FUND_TYPE_LEVEL_1 |
NO NO NO NO NO NO |
NA |
| FTVFUND_FUND_CODE |
FTMFUND |
NO |
REPORTING VIEW |
FUND_HIERARCHY TRANSACTION_HISTORY GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY GRANT_FUND_SLOT FUND_HIERARCHY_FISCAL GRANT_FUND GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY GRANT_FUND_SLOT GRANT_FUND_SLOT FOAPAL_NO_ATTRIBUTES TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES GRANT_FUND_SLOT |
FUND ACTUAL_FUND_LEVEL_3 FUND1 FUND2 ACTUAL_FUND_LEVEL_5 FUND5 FUND8 ACTUAL_FUND_LEVEL_1 FUND7 FUND FUND FUND10 FUND4 ACTUAL_FUND_LEVEL_2 FUND3 FUND9 CHART_OF_ACCOUNTS ACTUAL_FUND_LEVEL_4 FOAPAL_ELEMENT FUND6 |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| FTVFUND_FUND_CODE_PLANT_CONP |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
CONSTRUCTION_PLANT_FUND |
NO |
NA |
| FTVFUND_FUND_CODE_PRED |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
FUND_PREDECESSOR |
NO |
NA |
| FTVFUND_FUND_CODE_SOURCE |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
SOURCE_FUND |
NO |
NA |
| FTVFUND_GRNT_CODE |
FTMFUND |
NO |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING GENERAL_LEDGER INVOICE_ACCOUNTING INVOICE_ITEM_ACCOUNTING OPERATING_LEDGER FUND_HIERARCHY TRANSACTION_HISTORY FUND_HIERARCHY_FISCAL |
GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID |
NO NO NO NO NO NO NO NO NO |
NA |
| FTVFUND_LOCN_CODE_DEF |
FTMFUND |
NO |
REPORTING VIEW |
FUND_HIERARCHY_FISCAL FUND_HIERARCHY |
LOCATION_DEFAULT LOCATION_DEFAULT |
NO NO |
|
| FTVFUND_MAX_CONSTR_AMT |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
MAXIMUM_CONSTR_PROJECT_AMOUNT |
NO |
NA |
| FTVFUND_NCHG_DATE |
FTMFUND |
NO |
|
|
|
|
NA |
| FTVFUND_ORGN_CODE_DEF |
FTMFUND |
NO |
REPORTING VIEW |
FUND_HIERARCHY FUND_HIERARCHY_FISCAL |
ORGANIZATION_DEFAULT ORGANIZATION_DEFAULT |
NO NO |
|
| FTVFUND_PROG_CODE_DEF |
FTMFUND |
NO |
REPORTING VIEW |
FUND_HIERARCHY_FISCAL FUND_HIERARCHY |
PROGRAM_DEFAULT PROGRAM_DEFAULT |
NO NO |
|
| FTVFUND_PROJ_COMPLETE_DATE |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
CONSTR_PROJECT_COMPLETE_DATE |
NO |
NA |
| FTVFUND_PROJ_DESC |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
CONSTR_PROJECT_DESC |
NO |
NA |
| FTVFUND_PROJ_END_DATE_CONP |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
CONSTR_PROJECT_END_DATE |
NO |
NA |
| FTVFUND_PROJ_START_DATE_CONP |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND |
CONSTR_PROJECT_START_DATE |
NO |
NA |
| FTVFUND_PROP_CODE |
FRAGRNT |
NO |
REPORTING VIEW |
GRANT_FUND |
PROPOSAL |
NO |
NA |
| FTVFUND_REST_IND |
FTVFUND |
NO |
REPORTING VIEW |
FUND_HIERARCHY_FISCAL FUND_HIERARCHY |
FUND_RESTRICTION FUND_RESTRICTION |
NO NO |
|
| FTVFUND_STATUS_IND |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_DEFERRED_COST GRANT_FUND_SLOT TRANSACTION_HISTORY ENDOWMENT_DISTRIBUTION GRANT_FUND_SLOT TRANSACTION_HISTORY GRANT_FUND_SLOT OPERATING_LEDGER TRANSACTION_HISTORY ENDOWMENT_UNITS FUND_HIERARCHY_FISCAL GRANT_DEFERRED_COST GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY ENDOWMENT_SUMMARIZED_UNITS FOAPAL_NO_ATTRIBUTES GRANT_FUND_SLOT FUND_HIERARCHY GENERAL_LEDGER GRANT_FUND GRANT_LEDGER ENDOWMENT_ATTRIBUTES ENDOWMENT_UNITS FUND_ATTRIBUTES GRANT_FUND_SLOT PAYROLL_DISTRIBUTION BUDGET_AVAILABILITY_LEDGER ENDOWMENT_DISTRIBUTION GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY |
FUND_STATUS FUND_STATUS7 ACTUAL_FUND_STATUS_4 INCOME_CR_FUND_STATUS FUND_STATUS2 ACTUAL_FUND_STATUS_3 FUND_STATUS3 FUND_STATUS ACTUAL_FUND_STATUS_1 INCOME_CR_FUND_STATUS FUND_STATUS ORIG_FUND_STATUS FUND_STATUS1 FUND_STATUS10 ACTUAL_FUND_STATUS_2 FUND_STATUS FOAPAL_ELEMENT_STATUS FUND_STATUS6 FUND_STATUS FUND_STATUS FUND_STATUS FUND_STATUS FUND_STATUS FUND_STATUS FUND_STATUS FUND_STATUS4 FUND_STATUS FUND_STATUS FUND_STATUS FUND_STATUS5 FUND_STATUS8 FUND_STATUS9 ACTUAL_FUND_STATUS_5 |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| FTVFUND_TERM_DATE |
FTMFUND |
NO |
REPORTING VIEW |
GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT FUND_HIERARCHY_FISCAL GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT FUND_HIERARCHY GRANT_FUND GRANT_FUND_SLOT GRANT_FUND_SLOT |
FUND_TERMINATION_DATE7 FUND_TERMINATION_DATE1 FUND_TERMINATION_DATE8 FUND_TERMINATION_DATE10 TERMINATION_DATE FUND_TERMINATION_DATE4 FUND_TERMINATION_DATE9 FUND_TERMINATION_DATE3 FUND_TERMINATION_DATE6 TERMINATION_DATE FUND_TERMINATION_DATE FUND_TERMINATION_DATE2 FUND_TERMINATION_DATE5 |
NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| FTVFUND_TITLE |
FTMFUND |
NO |
REPORTING VIEW |
FUND_HIERARCHY GENERAL_LEDGER GRANT_DEFERRED_COST
GRANT_FUND_SLOT PERSONNEL_ACTION_LABOR_DIST
AUTHORIZATION_ACCOUNTING FOAPAL_NO_ATTRIBUTES
GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT
OPERATING_LEDGER LABOR_COST_DISTRIBUTION
BUDGET_AVAILABILITY_LEDGER GRANT_FUND_SLOT
ORGANIZATION_HIERARCHY_FISCAL TRANSACTION_HISTORY
GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT
FUND_HIERARCHY_FISCAL GRANT_FUND_SLOT FUND_ATTRIBUTES
GRANT_FUND GRANT_FUND_SLOT PAYROLL_DISTRIBUTION
REIMBURSEMENT_ACCOUNTING GRANT_DEFERRED_COST
PAYROLL_LABOR_DIST_OVERRIDE PROFILE_DEFAULT_ACCOUNTING
ORGANIZATION_HIERARCHY LABOR_COST_DISTRIBUTION
|
FUND_DESC FUND_DESC FUND_DESC
FUND_DESC10 FUND_DESC
FUND_DESC FOAPAL_ELEMENT_DESC
FUND_DESC7 FUND_DESC8 FUND_DESC9
FUND_DESC ASSIGNMENT_FUND_DESC
FUND_DESC FUND_DESC3
FUND_DEFAULT_DESC FUND_POOL_DESC
FUND_DESC1 FUND_DESC4 FUND_DESC6
FUND_DESC FUND_DESC2
FUND_DESC FUND_DESC FUND_DESC5
FUND_DESC FUND_DESC
ORIG_FUND_DESC POSITION_FUND_DESC
FUND_DEFAULT_DESC FUND_DESC
FRINGE_FUND_DESC
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |