Composite View Source: FTVACCT

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: FTVACCT Finance

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FTVACCT_ACCT_CLASS_CODE	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_GRANT_LEDGER	ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS	NA
FTVACCT_ACCT_CODE	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL	ACCOUNT ACCOUNT	NA
FTVACCT_ATYP_CODE	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL	ACCOUNT_TYPE ACCOUNT_TYPE	NA
FTVACCT_COAS_CODE	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS	NA
FTVACCT_DATA_ENTRY_IND	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_VALIDATION	DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED DATA_ENTRY_IND	NA
FTVACCT_EFF_DATE	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY_FISCAL	EFFECTIVE_DATE
FTVACCT_NCHG_DATE	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY_FISCAL	NEXT_CHANGE_DATE	NA
FTVACCT_NORMAL_BAL	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL	NORMAL_BALANCE NORMAL_BALANCE	NA
FTVACCT_STATUS_IND	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL	ACCOUNT_STATUS ACCOUNT_STATUS	NA
FTVACCT_TERM_DATE	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL	TERMINATION_DATE TERMINATION_DATE	NA
FTVACCT_TITLE	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_ATTRIBUTES_ODS AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AP_PAYROLL_LABOR_DIST_OVERRIDE	ACCOUNT_DESC ACCOUNT_DESC ACCOUNT_DESC POSITION_ACCOUNT_DESC	NA

Ver: 8.2