RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FTVFUND Finance Composite View Reports
SGHE Operational Data Store Composite View Source: FTVFUND

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_GRANT_FUND

AF_FUND_HIERARCHY

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_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_GRANT_FUND

AF_FUND_HIERARCHY

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_STATUS_IND FTMFUND COMPOSITE VIEW

AF_GRANT_FUND

AF_FUND_HIERARCHY

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_GRANT_FUND

AF_FUND_HIERARCHY

AF_TRANSACTION_HISTORY

AF_FUND_ATTRIBUTES_ODS

FUND_DESC

FUND_DESC

FUND_POOL_DESC

FUND_DESC

NA


Ver: 3.1