Reporting View Source: FTVACCT

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: FTVACCT Finance Reporting View Meta Data Reports

**Banner Operational Data Store**
Source Column	Source Form	Local Source	Target Type	Target	Target Column	Local Target	Calculation Formula
FTVACCT_ACCT_CLASS_CODE	FTMACCT	NO	REPORTING VIEW	GENERAL_LEDGER ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL GRANT_DEFERRED_COST GENERAL_LEDGER GRANT_LEDGER BUDGET_AVAILABILITY_LEDGER BUDGET_DETAIL GRANT_DEFERRED_COST BUDGET_AVAILABILITY_LEDGER GRANT_LEDGER OPERATING_LEDGER TRANSACTION_HISTORY OPERATING_LEDGER TRANSACTION_HISTORY	ORIG_ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS ORIG_ACCOUNT_CLASS ACCOUNT_CLASS ORIG_ACCOUNT_CLASS ORIG_ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS ORIG_ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS ORIG_ACCOUNT_CLASS	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO	NA
FTVACCT_ACCT_CODE	FTMACCT	NO	REPORTING VIEW	ACCOUNT_HIERARCHY_FISCAL FOAPAL_NO_ATTRIBUTES PURCHASE_ORDER_ITEM_ACCOUNTING TRANSACTION_HISTORY TRANSACTION_HISTORY INVOICE_ACCOUNTING INVOICE_ITEM_ACCOUNTING FIXED_ASSET_FUNDING_SOURCE TRANSACTION_HISTORY ACCOUNT_HIERARCHY FOAPAL_NO_ATTRIBUTES PURCHASE_ORDER_ACCOUNTING TRANSACTION_HISTORY BUDGET_DETAIL	ACCOUNT CHART_OF_ACCOUNTS ACCOUNT_LEVEL_4 ACTUAL_ACCOUNT_LEVEL_1 ACTUAL_ACCOUNT_LEVEL_4 ACCOUNT_LEVEL_4 ACCOUNT_LEVEL_4 ACCOUNT_LEVEL_4 ACTUAL_ACCOUNT_LEVEL_2 ACCOUNT FOAPAL_ELEMENT ACCOUNT_LEVEL_4 ACTUAL_ACCOUNT_LEVEL_3 ACCOUNT_LEVEL_4	NO NO NO NO NO NO NO NO NO NO NO NO NO NO	NA
FTVACCT_ATYP_CODE	FTMACCT	NO	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING ACCOUNT_HIERARCHY_FISCAL ACCOUNT_HIERARCHY	ACCOUNT_TYPE_LEVEL_2 ACCOUNT_TYPE_LEVEL_2 ACCOUNT_TYPE ACCOUNT_TYPE	NO NO NO NO	NA
FTVACCT_COAS_CODE	FTMACCT	NO	REPORTING VIEW	ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS	NO NO	NA
FTVACCT_DATA_ENTRY_IND	FTMACCT	NO	REPORTING VIEW	VALIDATION ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL	DATA_ENTRY_IND DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED	NO NO NO	NA
FTVACCT_EFF_DATE	FTMACCT	NO
FTVACCT_NCHG_DATE	FTMACCT	NO					NA
FTVACCT_NORMAL_BAL	FTMACCT	NO	REPORTING VIEW	BUDGET_DETAIL GRANT_LEDGER BUDGET_AVAILABILITY_LEDGER GRANT_DEFERRED_COST ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL TRANSACTION_HISTORY GENERAL_LEDGER GRANT_DEFERRED_COST OPERATING_LEDGER	NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE ORIG_NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE	NO NO NO NO NO NO NO NO NO NO	NA
FTVACCT_STATUS_IND	FTMACCT	NO	REPORTING VIEW	ACCOUNT_HIERARCHY_FISCAL BUDGET_AVAILABILITY_LEDGER ENDOWMENT_DISTRIBUTION GRANT_DEFERRED_COST GRANT_LEDGER FOAPAL_NO_ATTRIBUTES ENDOWMENT_UNITS ENDOWMENT_UNITS OPERATING_LEDGER TRANSACTION_HISTORY PAYROLL_DISTRIBUTION ACCOUNT_ATTRIBUTES ACCOUNT_HIERARCHY ENDOWMENT_UNITS GENERAL_LEDGER TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY	ACCOUNT_STATUS ACCOUNT_STATUS ACCOUNT_TYPE_STATUS ACCOUNT_STATUS ACCOUNT_STATUS FOAPAL_ELEMENT_STATUS ACCOUNT_STATUS ACCOUNT_TYPE_STATUS ACCOUNT_STATUS ACTUAL_ACCOUNT_STATUS_3 ACCOUNT_STATUS ACCOUNT_STATUS ACCOUNT_STATUS INCOME_CR_CHART_STATUS ACCOUNT_STATUS ACTUAL_ACCOUNT_STATUS_1 ACTUAL_ACCOUNT_STATUS_2 ACTUAL_ACCOUNT_STATUS_4	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO	NA
FTVACCT_TERM_DATE	FTMACCT	NO	REPORTING VIEW	ACCOUNT_HIERARCHY_FISCAL ACCOUNT_HIERARCHY	TERMINATION_DATE TERMINATION_DATE	NO NO	NA
FTVACCT_TITLE	FTMACCT	NO	REPORTING VIEW	ACCOUNT_HIERARCHY PERSONNEL_ACTION_LABOR_DIST ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY OPERATING_LEDGER LABOR_COST_DISTRIBUTION REIMBURSEMENT_ACCOUNTING ACCOUNT_HIERARCHY FOAPAL_NO_ATTRIBUTES ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY AUTHORIZATION_ACCOUNTING ACCOUNT_ATTRIBUTES ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL BUDGET_AVAILABILITY_LEDGER GRANT_DEFERRED_COST OPERATING_LEDGER OPERATING_LEDGER OPERATING_LEDGER PAYROLL_DISTRIBUTION PAYROLL_LABOR_DIST_OVERRIDE ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY OPERATING_LEDGER LABOR_COST_DISTRIBUTION GENERAL_LEDGER OPERATING_LEDGER OPERATING_LEDGER PROFILE_DEFAULT_ACCOUNTING	CTRL_ENCUMBRANCE_DESC ACCOUNT_DESC CTRL_ACTUAL_ACTIVITY_PY_DESC CTRL_BUDGET_ADJUSTMENT_DESC CTRL_BUDGET_RESERVE_DESC FRINGE_ACCOUNT_DESC ACCOUNT_DESC CTRL_BUDGET_RESERVE_DESC FOAPAL_ELEMENT_DESC CTRL_BUDGET_ADJUSTMENT_PY_DESC CTRL_ENCUMBRANCE_PY_DESC CTRL_TEMPORARY_BUDGET_DESC CTRL_ACTUAL_ACTIVITY_DESC CTRL_ADOPTED_BUDGET_DESC ACCOUNT_DESC ACCOUNT_DESC CTRL_BUDGET_RESERVE_PY_DESC ACCOUNT_DESC ACCOUNT_DESC ACCOUNT_DESC CTRL_ACTUAL_ACTIVITY_DESC CTRL_ADOPTED_BUDGET_DESC CTRL_BUDGET_ADJUSTMENT_DESC ACCOUNT_DESC POSITION_ACCOUNT_DESC ACCOUNT_DESC CTRL_ADOPTED_BUDGET_PY_DESC CTRL_TEMPORARY_BUDGET_PY_DESC CTRL_ENCUMBRANCE_DESC ASSIGNMENT_ACCOUNT_DESC ACCOUNT_DESC ACCOUNT_DESC CTRL_TEMPORARY_BUDGET_DESC ACCOUNT_DEFAULT_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 NO NO NO	NA

Ver: 9.2