Reporting View Source: FTVFUND

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: FTVFUND Finance Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FTVFUND_ACCT_CODE_ACCR	FTMFUND	REPORTING VIEW	GRANT_FUND	UNBILLED_ACCRUAL_ACCOUNT	NA
FTVFUND_ACCT_CODE_CIP	FTMFUND	REPORTING VIEW	GRANT_FUND	CONSTR_IN_PROGR_ACCOUNT	NA
FTVFUND_ACCT_CODE_REV	FTMFUND	REPORTING VIEW	GRANT_FUND	REVENUE_ACCRUAL_ACCOUNT	NA
FTVFUND_BANK_CODE	FTMFUND	REPORTING VIEW	GRANT_FUND	FUND_BANK	NA
FTVFUND_CASH_RECEIPT_BANK_CODE	FTMFUND	REPORTING VIEW	GRANT_FUND	CASH_RECEIPT_BANK	NA
FTVFUND_CLOSE_PROJ_IND	FTMFUND	REPORTING VIEW	GRANT_FUND	PROJECT_CLOSE_IND	NA
FTVFUND_COAS_CODE	FRAGRNT	REPORTING VIEW	FUND_HIERARCHY GRANT_FUND GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS1 CHART_OF_ACCOUNTS10 CHART_OF_ACCOUNTS2 CHART_OF_ACCOUNTS3 CHART_OF_ACCOUNTS4 CHART_OF_ACCOUNTS5 CHART_OF_ACCOUNTS6 CHART_OF_ACCOUNTS7 CHART_OF_ACCOUNTS8 CHART_OF_ACCOUNTS9	NA
FTVFUND_CONP_PROJ_NUM	FTMFUND	REPORTING VIEW	GRANT_FUND	CONSTR_PROJECT_NUMBER	NA
FTVFUND_CUM_COST_AMT	FTMFUND	REPORTING VIEW	GRANT_FUND	ESTIMATED_CUM_COST_AMOUNT	NA
FTVFUND_DATA_ENTRY_IND	FTMFUND	REPORTING VIEW	VALIDATION	DATA_ENTRY_IND	NA
FTVFUND_EXPEND_END_DATE	FTMFUND	REPORTING VIEW	FUND_HIERARCHY GRANT_FUND	EXPEND_END_DATE FUND_EXPENDITURE_END_DATE	NA
FTVFUND_FBAL_IND	FTVFUND	REPORTING VIEW	FUND_HIERARCHY	FUND_BALANCE
FTVFUND_FMGR_CODE_PIDM	NA	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER BUDGET_DETAIL FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_FUNDING_SOURCE FUND_HIERARCHY GENERAL_LEDGER GRANT_FUND INVOICE_ACCOUNTING OPERATING_LEDGER PURCHASE_ORDER_ACCOUNTING TRANSACTION_HISTORY	FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID	NA
FTVFUND_FMGR_CODE_PIDM_CONP	NA	REPORTING VIEW	GRANT_FUND	CONSTR_PROJECT_FMGR_UID	NA
FTVFUND_FTYP_CODE	FTMFUND	REPORTING VIEW	FUND_HIERARCHY GRANT_FUND	FUND_TYPE FUND_TYPE	NA
FTVFUND_FUND_CODE	FTMFUND	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES FOAPAL_NO_ATTRIBUTES FUND_HIERARCHY GRANT_FUND GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY	CHART_OF_ACCOUNTS FOAPAL_ELEMENT FUND FUND FUND1 FUND10 FUND2 FUND3 FUND4 FUND5 FUND6 FUND7 FUND8 FUND9 ACTUAL_FUND_LEVEL_1 ACTUAL_FUND_LEVEL_2 ACTUAL_FUND_LEVEL_3 ACTUAL_FUND_LEVEL_4 ACTUAL_FUND_LEVEL_5	NA
FTVFUND_FUND_CODE_PLANT_CONP	FTMFUND	REPORTING VIEW	GRANT_FUND	CONSTRUCTION_PLANT_FUND	NA
FTVFUND_FUND_CODE_PRED	FTMFUND	REPORTING VIEW	GRANT_FUND	FUND_PREDECESSOR	NA
FTVFUND_FUND_CODE_SOURCE	FTMFUND	REPORTING VIEW	GRANT_FUND	SOURCE_FUND	NA
FTVFUND_GRNT_CODE	FTMFUND	REPORTING VIEW	FUND_HIERARCHY GENERAL_LEDGER INVOICE_ACCOUNTING OPERATING_LEDGER TRANSACTION_HISTORY	GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID	NA
FTVFUND_MAX_CONSTR_AMT	FTMFUND	REPORTING VIEW	GRANT_FUND	MAXIMUM_CONSTR_PROJECT_AMOUNT	NA
FTVFUND_NCHG_DATE	FTMFUND				NA
FTVFUND_PROJ_COMPLETE_DATE	FTMFUND	REPORTING VIEW	GRANT_FUND	CONSTR_PROJECT_COMPLETE_DATE	NA
FTVFUND_PROJ_DESC	FTMFUND	REPORTING VIEW	GRANT_FUND	CONSTR_PROJECT_DESC	NA
FTVFUND_PROJ_END_DATE_CONP	FTMFUND	REPORTING VIEW	GRANT_FUND	CONSTR_PROJECT_END_DATE	NA
FTVFUND_PROJ_START_DATE_CONP	FTMFUND	REPORTING VIEW	GRANT_FUND	CONSTR_PROJECT_START_DATE	NA
FTVFUND_PROP_CODE	FRAGRNT	REPORTING VIEW	GRANT_FUND	PROPOSAL	NA
FTVFUND_REST_IND	FTVFUND	REPORTING VIEW	FUND_HIERARCHY	FUND_RESTRICTION
FTVFUND_STATUS_IND	FTMFUND	REPORTING VIEW	ENDOWMENT_ATTRIBUTES ENDOWMENT_DISTRIBUTION ENDOWMENT_DISTRIBUTION ENDOWMENT_SUMMARIZED_UNITS ENDOWMENT_UNITS ENDOWMENT_UNITS FOAPAL_NO_ATTRIBUTES FUND_ATTRIBUTES FUND_HIERARCHY GRANT_FUND GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_LEDGER TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY PAYROLL_DISTRIBUTION	FUND_STATUS FUND_STATUS INCOME_CR_FUND_STATUS FUND_STATUS FUND_STATUS INCOME_CR_FUND_STATUS FOAPAL_ELEMENT_STATUS FUND_STATUS FUND_STATUS FUND_STATUS FUND_STATUS1 FUND_STATUS10 FUND_STATUS2 FUND_STATUS3 FUND_STATUS4 FUND_STATUS5 FUND_STATUS6 FUND_STATUS7 FUND_STATUS8 FUND_STATUS9 FUND_STATUS ACTUAL_FUND_STATUS_1 ACTUAL_FUND_STATUS_2 ACTUAL_FUND_STATUS_3 ACTUAL_FUND_STATUS_4 ACTUAL_FUND_STATUS_5 FUND_STATUS	NA
FTVFUND_TERM_DATE	FTMFUND	REPORTING VIEW	FUND_HIERARCHY GRANT_FUND GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT	TERMINATION_DATE FUND_TERMINATION_DATE FUND_TERMINATION_DATE1 FUND_TERMINATION_DATE10 FUND_TERMINATION_DATE2 FUND_TERMINATION_DATE3 FUND_TERMINATION_DATE4 FUND_TERMINATION_DATE5 FUND_TERMINATION_DATE6 FUND_TERMINATION_DATE7 FUND_TERMINATION_DATE8 FUND_TERMINATION_DATE9	NA
FTVFUND_TITLE	FTMFUND	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES FUND_ATTRIBUTES FUND_HIERARCHY GRANT_FUND GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY PAYROLL_DISTRIBUTION PAYROLL_LABOR_DIST_OVERRIDE	FOAPAL_ELEMENT_DESC FUND_DESC FUND_DESC FUND_DESC FUND_DESC1 FUND_DESC10 FUND_DESC2 FUND_DESC3 FUND_DESC4 FUND_DESC5 FUND_DESC6 FUND_DESC7 FUND_DESC8 FUND_DESC9 FUND_POOL_DESC FUND_DESC POSITION_FUND_DESC	NA

Ver: 8.1