Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FTVFUND Finance
Banner Operational Data Store Composite View Source: FTVFUND - NULL

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
FTVFUND_ACCT_CODE_ACCR FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

UNBILLED_ACCRUAL_ACCOUNT

NO

NA
FTVFUND_ACCT_CODE_CIP FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

CONSTR_IN_PROGR_ACCOUNT

NO

NA
FTVFUND_ACCT_CODE_REV FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

REVENUE_ACCRUAL_ACCOUNT

NO

NA
FTVFUND_ACTV_CODE_DEF FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

ACTIVITY_DEFAULT

ACTIVITY_DEFAULT

NO

NO

 
FTVFUND_BANK_CODE FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

FUND_BANK

NO

NA
FTVFUND_CASH_RECEIPT_BANK_CODE FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

CASH_RECEIPT_BANK

NO

NA
FTVFUND_CLOSE_PROJ_IND FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

PROJECT_CLOSE_IND

NO

NA
FTVFUND_COAS_CODE FRAGRNT NO COMPOSITE VIEW

AF_FUND_HIERARCHY

AF_GRANT_FUND

AF_FUND_HIERARCHY_FISCAL

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

NO

NO

NO

NA
FTVFUND_CONP_PROJ_NUM FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

CONSTR_PROJECT_NUMBER

NO

NA
FTVFUND_CUM_COST_AMT FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

ESTIMATED_CUM_COST_AMOUNT

NO

NA
FTVFUND_DATA_ENTRY_IND FTMFUND NO COMPOSITE VIEW

AF_VALIDATION

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

DATA_ENTRY_IND

DATA_ENTRY_PERMITTED

DATA_ENTRY_PERMITTED

NO

NO

NO

NA
FTVFUND_EFF_DATE FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

EFFECTIVE_DATE

NO

 
FTVFUND_EXPEND_END_DATE FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY

AF_GRANT_FUND

AF_FUND_HIERARCHY_FISCAL

EXPEND_END_DATE

FUND_EXPENDITURE_END_DATE

EXPEND_END_DATE

NO

NO

NO

NA
FTVFUND_FBAL_IND FTVFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

FUND_BALANCE

FUND_BALANCE

NO

NO

 
FTVFUND_FMGR_CODE_PIDM NA NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

FINANCIAL_MANAGER_UID

FINANCIAL_MANAGER_UID

NO

NO

NA
FTVFUND_FMGR_CODE_PIDM_CONP NA NO COMPOSITE VIEW

AF_GRANT_FUND

CONSTR_PROJECT_FMGR_UID

NO

NA
FTVFUND_FTYP_CODE FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY

AF_GRANT_FUND

AF_FUND_HIERARCHY_FISCAL

FUND_TYPE

FUND_TYPE

FUND_TYPE

NO

NO

NO

NA
FTVFUND_FUND_CODE FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

AF_GRANT_FUND

AF_FUND_HIERARCHY

FUND

FUND

FUND

NO

NO

NO

NA
FTVFUND_FUND_CODE_PLANT_CONP FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

CONSTRUCTION_PLANT_FUND

NO

NA
FTVFUND_FUND_CODE_PRED FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

FUND_PREDECESSOR

NO

NA
FTVFUND_FUND_CODE_SOURCE FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

SOURCE_FUND

NO

NA
FTVFUND_GRNT_CODE FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

AF_GRANT_FUND

GRANT_ID

GRANT_ID

GRANT_ID

NO

NO

NO

NA
FTVFUND_LOCN_CODE_DEF FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

LOCATION_DEFAULT

LOCATION_DEFAULT

NO

NO

 
FTVFUND_MAX_CONSTR_AMT FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

MAXIMUM_CONSTR_PROJECT_AMOUNT

NO

NA
FTVFUND_NCHG_DATE FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

NEXT_CHANGE_DATE

NO

NA
FTVFUND_ORGN_CODE_DEF FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

ORGANIZATION_DEFAULT

ORGANIZATION_DEFAULT

NO

NO

 
FTVFUND_PROG_CODE_DEF FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

PROGRAM_DEFAULT

PROGRAM_DEFAULT

NO

NO

 
FTVFUND_PROJ_COMPLETE_DATE FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

CONSTR_PROJECT_COMPLETE_DATE

NO

NA
FTVFUND_PROJ_DESC FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

CONSTR_PROJECT_DESC

NO

NA
FTVFUND_PROJ_END_DATE_CONP FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

CONSTR_PROJECT_END_DATE

NO

NA
FTVFUND_PROJ_START_DATE_CONP FTMFUND NO COMPOSITE VIEW

AF_GRANT_FUND

CONSTR_PROJECT_START_DATE

NO

NA
FTVFUND_PROP_CODE FRAGRNT NO COMPOSITE VIEW

AF_GRANT_FUND

PROPOSAL

NO

NA
FTVFUND_REST_IND FTVFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

FUND_RESTRICTION

FUND_RESTRICTION

NO

NO

 
FTVFUND_STATUS_IND FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

AF_GRANT_FUND

FUND_STATUS

FUND_STATUS

FUND_STATUS

NO

NO

NO

NA
FTVFUND_TERM_DATE FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY

AF_GRANT_FUND

AF_FUND_HIERARCHY_FISCAL

TERMINATION_DATE

FUND_TERMINATION_DATE

TERMINATION_DATE

NO

NO

NO

NA
FTVFUND_TITLE FTMFUND NO 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

NO

NO

NO

NO

NO

NO

NO

NA


Ver: