Reporting View Source: FTVACCT

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FTVACCT_ACCT_CLASS_CODE	FTMACCT	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	NA
FTVACCT_ACCT_CODE	FTMACCT	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	NA
FTVACCT_ATYP_CODE	FTMACCT	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING ACCOUNT_HIERARCHY_FISCAL ACCOUNT_HIERARCHY	ACCOUNT_TYPE_LEVEL_2 ACCOUNT_TYPE_LEVEL_2 ACCOUNT_TYPE ACCOUNT_TYPE	NA
FTVACCT_COAS_CODE	FTMACCT	REPORTING VIEW	ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL	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	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	NA
FTVACCT_STATUS_IND	FTMACCT	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	NA
FTVACCT_TERM_DATE	FTMACCT	REPORTING VIEW	ACCOUNT_HIERARCHY_FISCAL ACCOUNT_HIERARCHY	TERMINATION_DATE TERMINATION_DATE	NA
FTVACCT_TITLE	FTMACCT	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	NA

Ver: 8.5