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_GRANT_LEDGER AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL	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_FISCAL AF_ACCOUNT_HIERARCHY	ACCOUNT_TYPE ACCOUNT_TYPE	NA
FTVACCT_COAS_CODE	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS	NA
FTVACCT_DATA_ENTRY_IND	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY AF_VALIDATION AF_ACCOUNT_HIERARCHY_FISCAL	DATA_ENTRY_PERMITTED DATA_ENTRY_IND DATA_ENTRY_PERMITTED	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_FISCAL AF_ACCOUNT_HIERARCHY	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_HIERARCHY AF_ACCOUNT_HIERARCHY AN_PERSONNEL_ACTION_LABOR_DIST AP_PAYROLL_LABOR_DIST_OVERRIDE AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_ATTRIBUTES_ODS AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY	CTRL_BUDGET_ADJUSTMENT_PY_DESC CTRL_TEMPORARY_BUDGET_PY_DESC ACCOUNT_DESC POSITION_ACCOUNT_DESC CTRL_ACTUAL_ACTIVITY_DESC CTRL_ACTUAL_ACTIVITY_PY_DESC CTRL_ADOPTED_BUDGET_PY_DESC CTRL_BUDGET_ADJUSTMENT_DESC CTRL_TEMPORARY_BUDGET_DESC ACCOUNT_DESC CTRL_ENCUMBRANCE_PY_DESC CTRL_BUDGET_RESERVE_DESC CTRL_ENCUMBRANCE_DESC ACCOUNT_DESC ACCOUNT_DESC CTRL_ADOPTED_BUDGET_DESC CTRL_BUDGET_RESERVE_PY_DESC	NA

Ver: