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

Source Column Source Form Target Type Target Target Column Calculation Formula
FTVACCT_ACCT_CLASS_CODE FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY_FISCAL

BUDGET_AVAILABILITY_LEDGER

GRANT_LEDGER

GRANT_DEFERRED_COST

OPERATING_LEDGER

GENERAL_LEDGER

GRANT_DEFERRED_COST

GRANT_LEDGER

BUDGET_AVAILABILITY_LEDGER

TRANSACTION_HISTORY

BUDGET_DETAIL

GENERAL_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ORIG_ACCOUNT_CLASS

ORIG_ACCOUNT_CLASS

ACCOUNT_CLASS

ORIG_ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ORIG_ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ORIG_ACCOUNT_CLASS

ORIG_ACCOUNT_CLASS

NA
FTVACCT_ACCT_CODE FTMACCT

REPORTING VIEW

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

BUDGET_DETAIL

PURCHASE_ORDER_ITEM_ACCOUNTING

TRANSACTION_HISTORY

ACCOUNT_HIERARCHY_FISCAL

FOAPAL_NO_ATTRIBUTES

INVOICE_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

INVOICE_ITEM_ACCOUNTING

ACCOUNT_HIERARCHY

FIXED_ASSET_FUNDING_SOURCE

FOAPAL_NO_ATTRIBUTES

ACCOUNT_LEVEL_4

ACTUAL_ACCOUNT_LEVEL_2

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

ACTUAL_ACCOUNT_LEVEL_1

ACCOUNT

FOAPAL_ELEMENT

ACCOUNT_LEVEL_4

ACTUAL_ACCOUNT_LEVEL_3

ACTUAL_ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

ACCOUNT

ACCOUNT_LEVEL_4

CHART_OF_ACCOUNTS

NA
FTVACCT_ATYP_CODE FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY_FISCAL

AUTHORIZATION_ACCOUNTING

REIMBURSEMENT_ACCOUNTING

ACCOUNT_TYPE

ACCOUNT_TYPE

ACCOUNT_TYPE_LEVEL_2

ACCOUNT_TYPE_LEVEL_2

NA
FTVACCT_COAS_CODE FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY_FISCAL

ACCOUNT_HIERARCHY

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

NA
FTVACCT_DATA_ENTRY_IND FTMACCT

REPORTING VIEW

VALIDATION

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY_FISCAL

DATA_ENTRY_IND

DATA_ENTRY_PERMITTED

DATA_ENTRY_PERMITTED

NA
FTVACCT_EFF_DATE FTMACCT        
FTVACCT_NCHG_DATE FTMACCT       NA
FTVACCT_NORMAL_BAL FTMACCT

REPORTING VIEW

GENERAL_LEDGER

GRANT_DEFERRED_COST

ACCOUNT_HIERARCHY_FISCAL

BUDGET_AVAILABILITY_LEDGER

GRANT_LEDGER

GRANT_DEFERRED_COST

OPERATING_LEDGER

BUDGET_DETAIL

ACCOUNT_HIERARCHY

TRANSACTION_HISTORY

NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

ORIG_NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

NA
FTVACCT_STATUS_IND FTMACCT

REPORTING VIEW

ENDOWMENT_UNITS

ACCOUNT_HIERARCHY

FOAPAL_NO_ATTRIBUTES

TRANSACTION_HISTORY

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

GRANT_DEFERRED_COST

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ENDOWMENT_UNITS

ACCOUNT_ATTRIBUTES

ACCOUNT_HIERARCHY_FISCAL

GENERAL_LEDGER

TRANSACTION_HISTORY

BUDGET_AVAILABILITY_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

PAYROLL_DISTRIBUTION

ACCOUNT_TYPE_STATUS

ACCOUNT_STATUS

FOAPAL_ELEMENT_STATUS

ACTUAL_ACCOUNT_STATUS_4

ACCOUNT_TYPE_STATUS

ACCOUNT_STATUS

ACCOUNT_STATUS

ACTUAL_ACCOUNT_STATUS_1

ACTUAL_ACCOUNT_STATUS_2

INCOME_CR_CHART_STATUS

ACCOUNT_STATUS

ACCOUNT_STATUS

ACCOUNT_STATUS

ACTUAL_ACCOUNT_STATUS_3

ACCOUNT_STATUS

ACCOUNT_STATUS

ACCOUNT_STATUS

ACCOUNT_STATUS

NA
FTVACCT_TERM_DATE FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY_FISCAL

ACCOUNT_HIERARCHY

TERMINATION_DATE

TERMINATION_DATE

NA
FTVACCT_TITLE FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY_FISCAL

LABOR_COST_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

GRANT_DEFERRED_COST

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

OPERATING_LEDGER

PAYROLL_LABOR_DIST_OVERRIDE

ACCOUNT_HIERARCHY

OPERATING_LEDGER

LABOR_COST_DISTRIBUTION

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

FOAPAL_NO_ATTRIBUTES

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PERSONNEL_ACTION_LABOR_DIST

ACCOUNT_ATTRIBUTES

ACCOUNT_HIERARCHY

OPERATING_LEDGER

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

GENERAL_LEDGER

PAYROLL_DISTRIBUTION

AUTHORIZATION_ACCOUNTING

PROFILE_DEFAULT_ACCOUNTING

REIMBURSEMENT_ACCOUNTING

CTRL_ACTUAL_ACTIVITY_DESC

CTRL_BUDGET_RESERVE_PY_DESC

CTRL_TEMPORARY_BUDGET_DESC

ACCOUNT_DESC

FRINGE_ACCOUNT_DESC

ACCOUNT_DESC

ACCOUNT_DESC

ACCOUNT_DESC

CTRL_ENCUMBRANCE_PY_DESC

CTRL_TEMPORARY_BUDGET_PY_DESC

ACCOUNT_DESC

POSITION_ACCOUNT_DESC

CTRL_BUDGET_ADJUSTMENT_DESC

CTRL_ENCUMBRANCE_DESC

ASSIGNMENT_ACCOUNT_DESC

CTRL_ADOPTED_BUDGET_PY_DESC

CTRL_ENCUMBRANCE_DESC

FOAPAL_ELEMENT_DESC

CTRL_ADOPTED_BUDGET_DESC

CTRL_BUDGET_ADJUSTMENT_DESC

CTRL_BUDGET_RESERVE_DESC

CTRL_TEMPORARY_BUDGET_DESC

ACCOUNT_DESC

ACCOUNT_DESC

CTRL_BUDGET_ADJUSTMENT_PY_DESC

CTRL_ACTUAL_ACTIVITY_DESC

CTRL_ACTUAL_ACTIVITY_PY_DESC

CTRL_ADOPTED_BUDGET_DESC

CTRL_BUDGET_RESERVE_DESC

ACCOUNT_DESC

ACCOUNT_DESC

ACCOUNT_DESC

ACCOUNT_DEFAULT_DESC

ACCOUNT_DESC

NA


Ver: 9.2