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

GENERAL_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

BUDGET_DETAIL

GRANT_LEDGER

BUDGET_AVAILABILITY_LEDGER

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

NA
FTVACCT_ACCT_CODE FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY

BUDGET_DETAIL

FOAPAL_NO_ATTRIBUTES

FOAPAL_NO_ATTRIBUTES

TRANSACTION_HISTORY

FIXED_ASSET_FUNDING_SOURCE

BUDGET_AVAILABILITY_LEDGER

INVOICE_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PURCHASE_ORDER_ACCOUNTING

GENERAL_LEDGER

OPERATING_LEDGER

ACCOUNT

ACCOUNT_LEVEL_4

CHART_OF_ACCOUNTS

FOAPAL_ELEMENT

ACTUAL_ACCOUNT_LEVEL_3

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

ACTUAL_ACCOUNT_LEVEL_2

ACTUAL_ACCOUNT_LEVEL_1

ACTUAL_ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_4

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

GENERAL_LEDGER

BUDGET_DETAIL

GRANT_LEDGER

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_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

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

ACCOUNT_HIERARCHY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ACTUAL_ACCOUNT_STATUS_4

ACTUAL_ACCOUNT_STATUS_3

ACCOUNT_STATUS

ACCOUNT_STATUS

ACTUAL_ACCOUNT_STATUS_1

ACTUAL_ACCOUNT_STATUS_2

NA
FTVACCT_TERM_DATE FTMACCT       NA
FTVACCT_TITLE FTMACCT

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

ACCOUNT_ATTRIBUTES

PAYROLL_DISTRIBUTION

ACCOUNT_HIERARCHY

PAYROLL_LABOR_DIST_OVERRIDE

FOAPAL_ELEMENT_DESC

ACCOUNT_DESC

ACCOUNT_DESC

ACCOUNT_DESC

POSITION_ACCOUNT_DESC

NA


Ver: 8.0