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_ACTV_CODE_DEF	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL	ACTIVITY_DEFAULT ACTIVITY_DEFAULT
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 AF_FUND_HIERARCHY_FISCAL	CHART_OF_ACCOUNTS 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 AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY	DATA_ENTRY_IND DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED	NA
FTVFUND_EFF_DATE	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL	EFFECTIVE_DATE
FTVFUND_EXPEND_END_DATE	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_GRANT_FUND AF_FUND_HIERARCHY_FISCAL	EXPEND_END_DATE FUND_EXPENDITURE_END_DATE EXPEND_END_DATE	NA
FTVFUND_FBAL_IND	FTVFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY	FUND_BALANCE FUND_BALANCE
FTVFUND_FMGR_CODE_PIDM	NA	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY	FINANCIAL_MANAGER_UID 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 AF_FUND_HIERARCHY_FISCAL	FUND_TYPE FUND_TYPE FUND_TYPE	NA
FTVFUND_FUND_CODE	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL AF_GRANT_FUND AF_FUND_HIERARCHY	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_FUND_HIERARCHY_FISCAL AF_GRANT_FUND	GRANT_ID GRANT_ID GRANT_ID	NA
FTVFUND_LOCN_CODE_DEF	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY	LOCATION_DEFAULT LOCATION_DEFAULT
FTVFUND_MAX_CONSTR_AMT	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND	MAXIMUM_CONSTR_PROJECT_AMOUNT	NA
FTVFUND_NCHG_DATE	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL	NEXT_CHANGE_DATE	NA
FTVFUND_ORGN_CODE_DEF	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY	ORGANIZATION_DEFAULT ORGANIZATION_DEFAULT
FTVFUND_PROG_CODE_DEF	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY	PROGRAM_DEFAULT PROGRAM_DEFAULT
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 AF_FUND_HIERARCHY_FISCAL	FUND_RESTRICTION FUND_RESTRICTION
FTVFUND_STATUS_IND	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_GRANT_FUND	FUND_STATUS FUND_STATUS FUND_STATUS	NA
FTVFUND_TERM_DATE	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_GRANT_FUND AF_FUND_HIERARCHY_FISCAL	TERMINATION_DATE FUND_TERMINATION_DATE TERMINATION_DATE	NA
FTVFUND_TITLE	FTMFUND	COMPOSITE VIEW	AF_GRANT_FUND AN_PERSONNEL_ACTION_LABOR_DIST AF_TRANSACTION_HISTORY AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_ATTRIBUTES_ODS AP_PAYROLL_LABOR_DIST_OVERRIDE	FUND_DESC FUND_DESC FUND_POOL_DESC FUND_DESC FUND_DESC FUND_DESC POSITION_FUND_DESC	NA

Ver: