Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: FTVACCT Finance Reporting View Meta Data Reports
SGHE 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

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