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

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

FUND_HIERARCHY_FISCAL

GRANT_FUND_SLOT

FUND_HIERARCHY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

CHART_OF_ACCOUNTS6

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS9

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS2

CHART_OF_ACCOUNTS1

CHART_OF_ACCOUNTS10

CHART_OF_ACCOUNTS5

CHART_OF_ACCOUNTS8

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS4

CHART_OF_ACCOUNTS3

CHART_OF_ACCOUNTS7

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

FUND_HIERARCHY

VALIDATION

FUND_HIERARCHY_FISCAL

DATA_ENTRY_PERMITTED

DATA_ENTRY_IND

DATA_ENTRY_PERMITTED

NA
FTVFUND_EFF_DATE FTMFUND        
FTVFUND_EXPEND_END_DATE FTMFUND

REPORTING VIEW

FUND_HIERARCHY

FUND_HIERARCHY_FISCAL

GRANT_FUND

EXPEND_END_DATE

EXPEND_END_DATE

FUND_EXPENDITURE_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

FIXED_ASSET_ACCOUNTING_SOURCE

GRANT_DEFERRED_COST

GRANT_FUND

BUDGET_AVAILABILITY_LEDGER

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY_FISCAL

AUTHORIZATION_ACCOUNTING

OPERATING_LEDGER

TRANSACTION_HISTORY

BUDGET_DETAIL

GRANT_DEFERRED_COST

INVOICE_ACCOUNTING

INVOICE_ITEM_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

REIMBURSEMENT_ACCOUNTING

FUND_HIERARCHY

GENERAL_LEDGER

PURCHASE_ORDER_ITEM_ACCOUNTING

FUND_FINANCIAL_MANAGER_UID

ORIG_FUND_FMGR_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

FUND_FINANCIAL_MANAGER_UID

FUND_FINANCIAL_MANAGER_UID

FUND_FINANCIAL_MANAGER_UID

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

REIMBURSEMENT_ACCOUNTING

FUND_HIERARCHY_FISCAL

GRANT_FUND

AUTHORIZATION_ACCOUNTING

FUND_HIERARCHY

AUTHORIZATION_ACCOUNTING

FUND_TYPE_LEVEL_2

FUND_TYPE

FUND_TYPE

FUND_TYPE_LEVEL_2

FUND_TYPE

FUND_TYPE_LEVEL_1

NA
FTVFUND_FUND_CODE FTMFUND

REPORTING VIEW

FUND_HIERARCHY

TRANSACTION_HISTORY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

TRANSACTION_HISTORY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

TRANSACTION_HISTORY

GRANT_FUND_SLOT

FUND_HIERARCHY_FISCAL

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

TRANSACTION_HISTORY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FOAPAL_NO_ATTRIBUTES

TRANSACTION_HISTORY

FOAPAL_NO_ATTRIBUTES

GRANT_FUND_SLOT

FUND

ACTUAL_FUND_LEVEL_3

FUND1

FUND2

ACTUAL_FUND_LEVEL_5

FUND5

FUND8

ACTUAL_FUND_LEVEL_1

FUND7

FUND

FUND

FUND10

FUND4

ACTUAL_FUND_LEVEL_2

FUND3

FUND9

CHART_OF_ACCOUNTS

ACTUAL_FUND_LEVEL_4

FOAPAL_ELEMENT

FUND6

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

AUTHORIZATION_ACCOUNTING

REIMBURSEMENT_ACCOUNTING

GENERAL_LEDGER

INVOICE_ACCOUNTING

INVOICE_ITEM_ACCOUNTING

OPERATING_LEDGER

FUND_HIERARCHY

TRANSACTION_HISTORY

FUND_HIERARCHY_FISCAL

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

FUND_HIERARCHY_FISCAL

ORGANIZATION_DEFAULT

ORGANIZATION_DEFAULT

 
FTVFUND_PROG_CODE_DEF FTMFUND

REPORTING VIEW

FUND_HIERARCHY_FISCAL

FUND_HIERARCHY

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

GRANT_DEFERRED_COST

GRANT_FUND_SLOT

TRANSACTION_HISTORY

ENDOWMENT_DISTRIBUTION

GRANT_FUND_SLOT

TRANSACTION_HISTORY

GRANT_FUND_SLOT

OPERATING_LEDGER

TRANSACTION_HISTORY

ENDOWMENT_UNITS

FUND_HIERARCHY_FISCAL

GRANT_DEFERRED_COST

GRANT_FUND_SLOT

GRANT_FUND_SLOT

TRANSACTION_HISTORY

ENDOWMENT_SUMMARIZED_UNITS

FOAPAL_NO_ATTRIBUTES

GRANT_FUND_SLOT

FUND_HIERARCHY

GENERAL_LEDGER

GRANT_FUND

GRANT_LEDGER

ENDOWMENT_ATTRIBUTES

ENDOWMENT_UNITS

FUND_ATTRIBUTES

GRANT_FUND_SLOT

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

ENDOWMENT_DISTRIBUTION

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

TRANSACTION_HISTORY

FUND_STATUS

FUND_STATUS7

ACTUAL_FUND_STATUS_4

INCOME_CR_FUND_STATUS

FUND_STATUS2

ACTUAL_FUND_STATUS_3

FUND_STATUS3

FUND_STATUS

ACTUAL_FUND_STATUS_1

INCOME_CR_FUND_STATUS

FUND_STATUS

ORIG_FUND_STATUS

FUND_STATUS1

FUND_STATUS10

ACTUAL_FUND_STATUS_2

FUND_STATUS

FOAPAL_ELEMENT_STATUS

FUND_STATUS6

FUND_STATUS

FUND_STATUS

FUND_STATUS

FUND_STATUS

FUND_STATUS

FUND_STATUS

FUND_STATUS

FUND_STATUS4

FUND_STATUS

FUND_STATUS

FUND_STATUS

FUND_STATUS5

FUND_STATUS8

FUND_STATUS9

ACTUAL_FUND_STATUS_5

NA
FTVFUND_TERM_DATE FTMFUND

REPORTING VIEW

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FUND_HIERARCHY_FISCAL

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FUND_HIERARCHY

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FUND_TERMINATION_DATE7

FUND_TERMINATION_DATE1

FUND_TERMINATION_DATE8

FUND_TERMINATION_DATE10

TERMINATION_DATE

FUND_TERMINATION_DATE4

FUND_TERMINATION_DATE9

FUND_TERMINATION_DATE3

FUND_TERMINATION_DATE6

TERMINATION_DATE

FUND_TERMINATION_DATE

FUND_TERMINATION_DATE2

FUND_TERMINATION_DATE5

NA
FTVFUND_TITLE FTMFUND

REPORTING VIEW

FUND_HIERARCHY

GENERAL_LEDGER

GRANT_DEFERRED_COST

GRANT_FUND_SLOT

PERSONNEL_ACTION_LABOR_DIST

AUTHORIZATION_ACCOUNTING

FOAPAL_NO_ATTRIBUTES

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

OPERATING_LEDGER

LABOR_COST_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

GRANT_FUND_SLOT

ORGANIZATION_HIERARCHY_FISCAL

TRANSACTION_HISTORY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FUND_HIERARCHY_FISCAL

GRANT_FUND_SLOT

FUND_ATTRIBUTES

GRANT_FUND

GRANT_FUND_SLOT

PAYROLL_DISTRIBUTION

REIMBURSEMENT_ACCOUNTING

GRANT_DEFERRED_COST

PAYROLL_LABOR_DIST_OVERRIDE

PROFILE_DEFAULT_ACCOUNTING

ORGANIZATION_HIERARCHY

LABOR_COST_DISTRIBUTION

FUND_DESC

FUND_DESC

FUND_DESC

FUND_DESC10

FUND_DESC

FUND_DESC

FOAPAL_ELEMENT_DESC

FUND_DESC7

FUND_DESC8

FUND_DESC9

FUND_DESC

ASSIGNMENT_FUND_DESC

FUND_DESC

FUND_DESC3

FUND_DEFAULT_DESC

FUND_POOL_DESC

FUND_DESC1

FUND_DESC4

FUND_DESC6

FUND_DESC

FUND_DESC2

FUND_DESC

FUND_DESC

FUND_DESC5

FUND_DESC

FUND_DESC

ORIG_FUND_DESC

POSITION_FUND_DESC

FUND_DEFAULT_DESC

FUND_DESC

FRINGE_FUND_DESC

NA


Ver: 8.5