Composite View Source: FTVFUND

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FTVFUND_ACCT_CODE_ACCR	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	UNBILLED_ACCRUAL_ACCOUNT	NA
FTVFUND_ACCT_CODE_CIP	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	CONSTR_IN_PROGR_ACCOUNT	NA
FTVFUND_ACCT_CODE_REV	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	REVENUE_ACCRUAL_ACCOUNT	NA
FTVFUND_BANK_CODE	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	FUND_BANK	NA
FTVFUND_CASH_RECEIPT_BANK_CODE	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	CASH_RECEIPT_BANK	NA
FTVFUND_CLOSE_PROJ_IND	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	PROJECT_CLOSE_IND	NA
FTVFUND_COAS_CODE	FRAGRNT	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_GRANT_FUND	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS	NA
FTVFUND_CONP_PROJ_NUM	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	CONSTR_PROJECT_NUMBER	NA
FTVFUND_CUM_COST_AMT	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	ESTIMATED_CUM_COST_AMOUNT	NA
FTVFUND_DATA_ENTRY_IND	FTMFUND	COMPOSITE VIEW	AF_VALIDATION	DATA_ENTRY_IND	NA
FTVFUND_EXPEND_END_DATE	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_GRANT_FUND	EXPEND_END_DATE FUND_EXPENDITURE_END_DATE	NA
FTVFUND_FBAL_IND	FTVFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY	FUND_BALANCE
FTVFUND_FMGR_CODE_PIDM	NA	COMPOSITE VIEW	AF_FUND_HIERARCHY	FINANCIAL_MANAGER_UID	NA
FTVFUND_FMGR_CODE_PIDM_CONP	NA	COMPOSITE VIEW	AF_GRANT_FUND	CONSTR_PROJECT_FMGR_UID	NA
FTVFUND_FTYP_CODE	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_GRANT_FUND	FUND_TYPE FUND_TYPE	NA
FTVFUND_FUND_CODE	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_GRANT_FUND	FUND FUND	NA
FTVFUND_FUND_CODE_PLANT_CONP	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	CONSTRUCTION_PLANT_FUND	NA
FTVFUND_FUND_CODE_PRED	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	FUND_PREDECESSOR	NA
FTVFUND_FUND_CODE_SOURCE	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	SOURCE_FUND	NA
FTVFUND_GRNT_CODE	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_GRANT_FUND	GRANT_ID GRANT_ID	NA
FTVFUND_MAX_CONSTR_AMT	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	MAXIMUM_CONSTR_PROJECT_AMOUNT	NA
FTVFUND_NCHG_DATE	FTMFUND				NA
FTVFUND_PROJ_COMPLETE_DATE	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	CONSTR_PROJECT_COMPLETE_DATE	NA
FTVFUND_PROJ_DESC	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	CONSTR_PROJECT_DESC	NA
FTVFUND_PROJ_END_DATE_CONP	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	CONSTR_PROJECT_END_DATE	NA
FTVFUND_PROJ_START_DATE_CONP	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	CONSTR_PROJECT_START_DATE	NA
FTVFUND_PROP_CODE	FRAGRNT	COMPOSITE VIEW	AF_GRANT_FUND	PROPOSAL	NA
FTVFUND_REST_IND	FTVFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY	FUND_RESTRICTION
FTVFUND_STATUS_IND	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_GRANT_FUND	FUND_STATUS FUND_STATUS	NA
FTVFUND_TERM_DATE	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_GRANT_FUND	TERMINATION_DATE FUND_TERMINATION_DATE	NA
FTVFUND_TITLE	FTMFUND	COMPOSITE VIEW	AF_FUND_ATTRIBUTES_ODS AF_FUND_HIERARCHY AF_GRANT_FUND AF_TRANSACTION_HISTORY AP_PAYROLL_LABOR_DIST_OVERRIDE	FUND_DESC FUND_DESC FUND_DESC FUND_POOL_DESC POSITION_FUND_DESC	NA

Ver: 8.1