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

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: