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_ACTV_CODE_DEF	FTMFUND	REPORTING VIEW	FUND_HIERARCHY FUND_HIERARCHY_FISCAL	ACTIVITY_DEFAULT ACTIVITY_DEFAULT
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	GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT FUND_HIERARCHY_FISCAL FUND_HIERARCHY GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND GRANT_FUND_SLOT GRANT_FUND_SLOT	CHART_OF_ACCOUNTS9 CHART_OF_ACCOUNTS5 CHART_OF_ACCOUNTS10 CHART_OF_ACCOUNTS8 CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS1 CHART_OF_ACCOUNTS2 CHART_OF_ACCOUNTS3 CHART_OF_ACCOUNTS7 CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS4 CHART_OF_ACCOUNTS6	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 FUND_HIERARCHY FUND_HIERARCHY_FISCAL	DATA_ENTRY_IND DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED	NA
FTVFUND_EFF_DATE	FTMFUND
FTVFUND_EXPEND_END_DATE	FTMFUND	REPORTING VIEW	GRANT_FUND FUND_HIERARCHY_FISCAL FUND_HIERARCHY	FUND_EXPENDITURE_END_DATE EXPEND_END_DATE EXPEND_END_DATE	NA
FTVFUND_FBAL_IND	FTVFUND	REPORTING VIEW	FUND_HIERARCHY FUND_HIERARCHY_FISCAL	FUND_BALANCE FUND_BALANCE
FTVFUND_FMGR_CODE_PIDM	NA	REPORTING VIEW	FUND_HIERARCHY FUND_HIERARCHY_FISCAL GRANT_FUND GENERAL_LEDGER PURCHASE_ORDER_ITEM_ACCOUNTING BUDGET_AVAILABILITY_LEDGER GRANT_DEFERRED_COST OPERATING_LEDGER REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING INVOICE_ITEM_ACCOUNTING PURCHASE_ORDER_ACCOUNTING TRANSACTION_HISTORY FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_FUNDING_SOURCE GRANT_DEFERRED_COST BUDGET_DETAIL INVOICE_ACCOUNTING	FINANCIAL_MANAGER_UID FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID FUND_FINANCIAL_MANAGER_UID ORIG_FUND_FMGR_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 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	GRANT_FUND AUTHORIZATION_ACCOUNTING FUND_HIERARCHY_FISCAL FUND_HIERARCHY AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	FUND_TYPE FUND_TYPE_LEVEL_1 FUND_TYPE FUND_TYPE FUND_TYPE_LEVEL_2 FUND_TYPE_LEVEL_2	NA
FTVFUND_FUND_CODE	FTMFUND	REPORTING VIEW	GRANT_FUND GRANT_FUND_SLOT GRANT_FUND_SLOT FUND_HIERARCHY FUND_HIERARCHY_FISCAL GRANT_FUND_SLOT TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES GRANT_FUND_SLOT GRANT_FUND_SLOT FOAPAL_NO_ATTRIBUTES GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY TRANSACTION_HISTORY GRANT_FUND_SLOT TRANSACTION_HISTORY GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY	FUND FUND4 FUND9 FUND FUND FUND3 ACTUAL_FUND_LEVEL_3 CHART_OF_ACCOUNTS FUND2 FUND6 FOAPAL_ELEMENT FUND1 FUND5 ACTUAL_FUND_LEVEL_1 ACTUAL_FUND_LEVEL_4 FUND10 ACTUAL_FUND_LEVEL_2 FUND7 FUND8 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 OPERATING_LEDGER FUND_HIERARCHY_FISCAL INVOICE_ITEM_ACCOUNTING TRANSACTION_HISTORY REIMBURSEMENT_ACCOUNTING GENERAL_LEDGER INVOICE_ACCOUNTING AUTHORIZATION_ACCOUNTING	GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID GRANT_ID	NA
FTVFUND_LOCN_CODE_DEF	FTMFUND	REPORTING VIEW	FUND_HIERARCHY_FISCAL FUND_HIERARCHY	LOCATION_DEFAULT LOCATION_DEFAULT
FTVFUND_MAX_CONSTR_AMT	FTMFUND	REPORTING VIEW	GRANT_FUND	MAXIMUM_CONSTR_PROJECT_AMOUNT	NA
FTVFUND_NCHG_DATE	FTMFUND				NA
FTVFUND_ORGN_CODE_DEF	FTMFUND	REPORTING VIEW	FUND_HIERARCHY_FISCAL FUND_HIERARCHY	ORGANIZATION_DEFAULT ORGANIZATION_DEFAULT
FTVFUND_PROG_CODE_DEF	FTMFUND	REPORTING VIEW	FUND_HIERARCHY FUND_HIERARCHY_FISCAL	PROGRAM_DEFAULT PROGRAM_DEFAULT
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_FISCAL FUND_HIERARCHY	FUND_RESTRICTION FUND_RESTRICTION
FTVFUND_STATUS_IND	FTMFUND	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER GRANT_FUND GRANT_FUND_SLOT TRANSACTION_HISTORY ENDOWMENT_DISTRIBUTION GRANT_FUND_SLOT ENDOWMENT_DISTRIBUTION ENDOWMENT_UNITS FUND_HIERARCHY GRANT_DEFERRED_COST FUND_HIERARCHY_FISCAL GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY ENDOWMENT_ATTRIBUTES FUND_ATTRIBUTES GRANT_DEFERRED_COST GRANT_LEDGER TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES GRANT_FUND_SLOT OPERATING_LEDGER ENDOWMENT_SUMMARIZED_UNITS GRANT_FUND_SLOT GRANT_FUND_SLOT ENDOWMENT_UNITS GENERAL_LEDGER GRANT_FUND_SLOT GRANT_FUND_SLOT TRANSACTION_HISTORY TRANSACTION_HISTORY PAYROLL_DISTRIBUTION	FUND_STATUS FUND_STATUS FUND_STATUS5 ACTUAL_FUND_STATUS_5 FUND_STATUS FUND_STATUS7 INCOME_CR_FUND_STATUS FUND_STATUS FUND_STATUS ORIG_FUND_STATUS FUND_STATUS FUND_STATUS10 FUND_STATUS2 FUND_STATUS3 ACTUAL_FUND_STATUS_3 FUND_STATUS FUND_STATUS FUND_STATUS FUND_STATUS ACTUAL_FUND_STATUS_2 FOAPAL_ELEMENT_STATUS FUND_STATUS1 FUND_STATUS FUND_STATUS FUND_STATUS8 FUND_STATUS9 INCOME_CR_FUND_STATUS FUND_STATUS FUND_STATUS4 FUND_STATUS6 ACTUAL_FUND_STATUS_1 ACTUAL_FUND_STATUS_4 FUND_STATUS	NA
FTVFUND_TERM_DATE	FTMFUND	REPORTING VIEW	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 FUND_HIERARCHY_FISCAL GRANT_FUND FUND_HIERARCHY GRANT_FUND_SLOT	FUND_TERMINATION_DATE2 FUND_TERMINATION_DATE7 FUND_TERMINATION_DATE3 FUND_TERMINATION_DATE8 FUND_TERMINATION_DATE5 FUND_TERMINATION_DATE6 FUND_TERMINATION_DATE1 FUND_TERMINATION_DATE10 FUND_TERMINATION_DATE4 TERMINATION_DATE FUND_TERMINATION_DATE TERMINATION_DATE FUND_TERMINATION_DATE9	NA
FTVFUND_TITLE	FTMFUND	REPORTING VIEW	GENERAL_LEDGER GRANT_FUND_SLOT GRANT_FUND_SLOT GRANT_FUND_SLOT AUTHORIZATION_ACCOUNTING FOAPAL_NO_ATTRIBUTES GRANT_FUND LABOR_COST_DISTRIBUTION BUDGET_AVAILABILITY_LEDGER GRANT_FUND_SLOT GRANT_FUND_SLOT PERSONNEL_ACTION_LABOR_DIST FUND_ATTRIBUTES LABOR_COST_DISTRIBUTION FUND_HIERARCHY GRANT_DEFERRED_COST GRANT_FUND_SLOT ORGANIZATION_HIERARCHY PAYROLL_DISTRIBUTION PROFILE_DEFAULT_ACCOUNTING GRANT_FUND_SLOT TRANSACTION_HISTORY GRANT_FUND_SLOT OPERATING_LEDGER FUND_HIERARCHY_FISCAL GRANT_DEFERRED_COST GRANT_FUND_SLOT GRANT_FUND_SLOT ORGANIZATION_HIERARCHY_FISCAL PAYROLL_LABOR_DIST_OVERRIDE REIMBURSEMENT_ACCOUNTING	FUND_DESC FUND_DESC1 FUND_DESC4 FUND_DESC9 FUND_DESC FOAPAL_ELEMENT_DESC FUND_DESC ASSIGNMENT_FUND_DESC FUND_DESC FUND_DESC6 FUND_DESC7 FUND_DESC FUND_DESC FRINGE_FUND_DESC FUND_DESC ORIG_FUND_DESC FUND_DESC3 FUND_DESC FUND_DESC FUND_DEFAULT_DESC FUND_DESC5 FUND_POOL_DESC FUND_DESC2 FUND_DESC FUND_DESC FUND_DESC FUND_DESC10 FUND_DESC8 FUND_DEFAULT_DESC POSITION_FUND_DESC FUND_DESC	NA

Ver: 9.0