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

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