Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: FTVATYP Finance Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: FTVATYP - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
FTVATYP_ATYP_CODE FTMATYP

REPORTING VIEW

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

GENERAL_LEDGER

GENERAL_LEDGER

PURCHASE_ORDER_ACCOUNTING

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

GRANT_LEDGER

TRANSACTION_HISTORY

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

FIXED_ASSET_ACCOUNTING_SOURCE

ACCOUNT_HIERARCHY

TRANSACTION_HISTORY

FIXED_ASSET_FUNDING_SOURCE

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

FOAPAL_NO_ATTRIBUTES

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_TYPE_LEVEL_1

ACCOUNT_TYPE_LEVEL_2

ACCOUNT_TYPE_LEVEL_1

ACCOUNT_TYPE_LEVEL_2

ACCOUNT_TYPE_LEVEL_2

ACCOUNT_TYPE_LEVEL_2

ACCOUNT_TYPE_LEVEL_1

ACCOUNT_TYPE_LEVEL_2

ACTUAL_ACCOUNT_TYPE_LEVEL_1

ACCOUNT_TYPE_LEVEL_1

ACCOUNT_TYPE_LEVEL_1

ACCOUNT_TYPE_LEVEL_2

ACCOUNT_TYPE_LEVEL_1

ACCOUNT_TYPE_LEVEL_2

ACCOUNT_TYPE_LEVEL_2

ACCOUNT_TYPE_LEVEL_1

ACTUAL_ACCOUNT_TYPE_LEVEL_2

ACCOUNT_TYPE_LEVEL_1

ACCOUNT_TYPE_LEVEL_1

ACCOUNT_TYPE_LEVEL_2

FOAPAL_ELEMENT

ACCOUNT_TYPE_LEVEL_1

ACCOUNT_TYPE_LEVEL_2

NA
FTVATYP_COAS_CODE FTMATYP

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

CHART_OF_ACCOUNTS

NA
FTVATYP_INTERNAL_ATYP_CODE FTMATYP

REPORTING VIEW

OPERATING_LEDGER

BUDGET_AVAILABILITY_LEDGER

ACCOUNT_HIERARCHY

GENERAL_LEDGER

BUDGET_DETAIL

GRANT_LEDGER

TRANSACTION_HISTORY

INTERNAL_ACCOUNT_TYPE

INTERNAL_ACCOUNT_TYPE

INTERNAL_ACCOUNT_TYPE

INTERNAL_ACCOUNT_TYPE

INTERNAL_ACCOUNT_TYPE

INTERNAL_ACCOUNT_TYPE

INTERNAL_ACCOUNT_TYPE

NA
FTVATYP_NCHG_DATE FTMATYP       NA
FTVATYP_STATUS_IND FTMATYP

REPORTING VIEW

BUDGET_AVAILABILITY_LEDGER

FIXED_ASSET_FUNDING_SOURCE

INVOICE_ACCOUNTING

TRANSACTION_HISTORY

ACCOUNT_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

GRANT_LEDGER

OPERATING_LEDGER

BUDGET_DETAIL

INVOICE_ACCOUNTING

FIXED_ASSET_ACCOUNTING_SOURCE

PURCHASE_ORDER_ACCOUNTING

BUDGET_AVAILABILITY_LEDGER

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

OPERATING_LEDGER

ACCOUNT_HIERARCHY

GENERAL_LEDGER

BUDGET_DETAIL

GENERAL_LEDGER

GRANT_LEDGER

ACCOUNT_TYPE_STATUS_2

ACCOUNT_TYPE_STATUS_2

ACCOUNT_TYPE_STATUS_2

ACTUAL_ACCOUNT_TYPE_STATUS_1

ACCOUNT_TYPE_STATUS_1

ACCOUNT_TYPE_STATUS_1

ACTUAL_ACCOUNT_TYPE_STATUS_2

ACCOUNT_TYPE_STATUS_2

ACCOUNT_TYPE_STATUS_2

ACCOUNT_TYPE_STATUS_1

ACCOUNT_TYPE_STATUS_1

ACCOUNT_TYPE_STATUS_2

ACCOUNT_TYPE_STATUS_2

ACCOUNT_TYPE_STATUS_1

ACCOUNT_TYPE_STATUS_1

ACCOUNT_TYPE_STATUS_1

ACCOUNT_TYPE_STATUS_1

ACCOUNT_TYPE_STATUS_2

ACCOUNT_TYPE_STATUS_2

ACCOUNT_TYPE_STATUS_2

ACCOUNT_TYPE_STATUS_1

ACCOUNT_TYPE_STATUS_1

NA
FTVATYP_TERM_DATE FTMATYP       NA
FTVATYP_TITLE FTMATYP

REPORTING VIEW

ACCOUNT_HIERARCHY

ENDOWMENT_DISTRIBUTION

FIXED_ASSET_ACCOUNTING_SOURCE

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

GENERAL_LEDGER

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

ACCOUNT_TYPE_ATTRIBUTES

BUDGET_DETAIL

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

BUDGET_AVAILABILITY_LEDGER

ENDOWMENT_UNITS

GENERAL_LEDGER

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

PURCHASE_ORDER_ACCOUNTING

FIXED_ASSET_ACCOUNTING_SOURCE

INVOICE_ACCOUNTING

ACCOUNT_TYPE_DESC

ACCOUNT_TYPE_DESC

ACCOUNT_TYPE_DESC_2

ACCOUNT_TYPE_DESC_1

ACCOUNT_TYPE_DESC_1

ACCOUNT_TYPE_DESC_2

ACTUAL_ACCOUNT_TYPE_DESC_2

ACCOUNT_TYPE_DESC_2

ACCOUNT_TYPE_DESC_1

ACCOUNT_TYPE_DESC_1

ACCOUNT_TYPE_DESC_2

ACCOUNT_TYPE_DESC_1

ACCOUNT_TYPE_DESC_2

ACCOUNT_TYPE_DESC

ACCOUNT_TYPE_DESC_2

ACCOUNT_TYPE_DESC_1

ACTUAL_ACCOUNT_TYPE_DESC_1

ACCOUNT_TYPE_DESC_1

ACCOUNT_TYPE_DESC

ACCOUNT_TYPE_DESC_1

ACCOUNT_TYPE_DESC_2

ACCOUNT_TYPE_DESC_1

ACCOUNT_TYPE_DESC_2

ACCOUNT_TYPE_DESC_2

ACCOUNT_TYPE_DESC_1

ACCOUNT_TYPE_DESC_2

NA


Ver: 8.0