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**
Banner Source Column	Source Form	ODS Target	ODS Target Column
FTVACCT_ACCT_CLASS_CODE	FTMACCT	OPERATING_LEDGER GENERAL_LEDGER OPERATING_LEDGER TRANSACTION_HISTORY GRANT_LEDGER TRANSACTION_HISTORY BUDGET_AVAILABILITY_LEDGER BUDGET_DETAIL GENERAL_LEDGER ACCOUNT_HIERARCHY BUDGET_AVAILABILITY_LEDGER ACCOUNT_HIERARCHY_FISCAL GRANT_LEDGER	ACCOUNT_CLASS ORIG_ACCOUNT_CLASS ORIG_ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS ORIG_ACCOUNT_CLASS ORIG_ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS ORIG_ACCOUNT_CLASS
FTVACCT_ACCT_CODE	FTMACCT	TRANSACTION_HISTORY ACCOUNT_HIERARCHY FOAPAL_NO_ATTRIBUTES TRANSACTION_HISTORY BUDGET_DETAIL FIXED_ASSET_FUNDING_SOURCE TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES INVOICE_ACCOUNTING ACCOUNT_HIERARCHY_FISCAL TRANSACTION_HISTORY PURCHASE_ORDER_ACCOUNTING	ACTUAL_ACCOUNT_LEVEL_3 ACCOUNT FOAPAL_ELEMENT ACTUAL_ACCOUNT_LEVEL_1 ACCOUNT_LEVEL_4 ACCOUNT_LEVEL_4 ACTUAL_ACCOUNT_LEVEL_4 CHART_OF_ACCOUNTS ACCOUNT_LEVEL_4 ACCOUNT ACTUAL_ACCOUNT_LEVEL_2 ACCOUNT_LEVEL_4
FTVACCT_ATYP_CODE	FTMACCT	ACCOUNT_HIERARCHY_FISCAL AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING ACCOUNT_HIERARCHY	ACCOUNT_TYPE ACCOUNT_TYPE_LEVEL_2 ACCOUNT_TYPE_LEVEL_2 ACCOUNT_TYPE
FTVACCT_COAS_CODE	FTMACCT	ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS
FTVACCT_DATA_ENTRY_IND	FTMACCT	ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL VALIDATION	DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED DATA_ENTRY_IND
FTVACCT_EFF_DATE	FTMACCT
FTVACCT_NCHG_DATE	FTMACCT
FTVACCT_NORMAL_BAL	FTMACCT	ACCOUNT_HIERARCHY_FISCAL GENERAL_LEDGER BUDGET_DETAIL GRANT_LEDGER TRANSACTION_HISTORY ACCOUNT_HIERARCHY BUDGET_AVAILABILITY_LEDGER OPERATING_LEDGER	NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE NORMAL_BALANCE
FTVACCT_STATUS_IND	FTMACCT	ACCOUNT_ATTRIBUTES ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL ENDOWMENT_UNITS TRANSACTION_HISTORY BUDGET_AVAILABILITY_LEDGER ENDOWMENT_UNITS TRANSACTION_HISTORY TRANSACTION_HISTORY PAYROLL_DISTRIBUTION ENDOWMENT_UNITS GRANT_LEDGER FOAPAL_NO_ATTRIBUTES ENDOWMENT_DISTRIBUTION GENERAL_LEDGER OPERATING_LEDGER TRANSACTION_HISTORY	ACCOUNT_STATUS ACCOUNT_STATUS ACCOUNT_STATUS ACCOUNT_STATUS ACTUAL_ACCOUNT_STATUS_2 ACCOUNT_STATUS INCOME_CR_CHART_STATUS ACTUAL_ACCOUNT_STATUS_3 ACTUAL_ACCOUNT_STATUS_4 ACCOUNT_STATUS ACCOUNT_TYPE_STATUS ACCOUNT_STATUS FOAPAL_ELEMENT_STATUS ACCOUNT_TYPE_STATUS ACCOUNT_STATUS ACCOUNT_STATUS ACTUAL_ACCOUNT_STATUS_1
FTVACCT_TERM_DATE	FTMACCT	ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL	TERMINATION_DATE TERMINATION_DATE
FTVACCT_TITLE	FTMACCT	ACCOUNT_HIERARCHY_FISCAL BUDGET_AVAILABILITY_LEDGER AUTHORIZATION_ACCOUNTING FOAPAL_NO_ATTRIBUTES GENERAL_LEDGER OPERATING_LEDGER ACCOUNT_HIERARCHY PAYROLL_DISTRIBUTION PROFILE_DEFAULT_ACCOUNTING ACCOUNT_ATTRIBUTES PAYROLL_LABOR_DIST_OVERRIDE REIMBURSEMENT_ACCOUNTING	ACCOUNT_DESC ACCOUNT_DESC ACCOUNT_DESC FOAPAL_ELEMENT_DESC ACCOUNT_DESC ACCOUNT_DESC ACCOUNT_DESC ACCOUNT_DESC ACCOUNT_DEFAULT_DESC ACCOUNT_DESC POSITION_ACCOUNT_DESC ACCOUNT_DESC

Ver: 8.3