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