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

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

NA
FTVACCT_ACCT_CODE FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

FOAPAL_NO_ATTRIBUTES

FOAPAL_NO_ATTRIBUTES

GENERAL_LEDGER

INVOICE_ACCOUNTING

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ACCOUNT

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

CHART_OF_ACCOUNTS

FOAPAL_ELEMENT

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

ACTUAL_ACCOUNT_LEVEL_1

ACTUAL_ACCOUNT_LEVEL_2

ACTUAL_ACCOUNT_LEVEL_3

ACTUAL_ACCOUNT_LEVEL_4

NA
FTVACCT_ATYP_CODE FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY

ACCOUNT_TYPE

NA
FTVACCT_COAS_CODE FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY

CHART_OF_ACCOUNTS

NA
FTVACCT_DATA_ENTRY_IND FTMACCT

REPORTING VIEW

VALIDATION

DATA_ENTRY_IND

NA
FTVACCT_NCHG_DATE FTMACCT       NA
FTVACCT_NORMAL_BAL FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

NORMAL_BALANCE

NA
FTVACCT_STATUS_IND FTMACCT

REPORTING VIEW

ACCOUNT_ATTRIBUTES

ACCOUNT_HIERARCHY

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

FOAPAL_NO_ATTRIBUTES

GRANT_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

ACCOUNT_STATUS

ACCOUNT_STATUS

ACCOUNT_TYPE_STATUS

ACCOUNT_STATUS

ACCOUNT_TYPE_STATUS

INCOME_CR_CHART_STATUS

FOAPAL_ELEMENT_STATUS

ACCOUNT_STATUS

ACTUAL_ACCOUNT_STATUS_1

ACTUAL_ACCOUNT_STATUS_2

ACTUAL_ACCOUNT_STATUS_3

ACTUAL_ACCOUNT_STATUS_4

ACCOUNT_STATUS

NA
FTVACCT_TERM_DATE FTMACCT       NA
FTVACCT_TITLE FTMACCT

REPORTING VIEW

ACCOUNT_ATTRIBUTES

ACCOUNT_HIERARCHY

FOAPAL_NO_ATTRIBUTES

PAYROLL_DISTRIBUTION

PAYROLL_LABOR_DIST_OVERRIDE

ACCOUNT_DESC

ACCOUNT_DESC

FOAPAL_ELEMENT_DESC

ACCOUNT_DESC

POSITION_ACCOUNT_DESC

NA


Ver: 8.1