Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: FTVFUND Finance Reporting View Meta Data Reports
Banner Operational Data Store Reporting View Source: FTVFUND - NULL

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


Ver: 9.2