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

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

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FUND_HIERARCHY

GRANT_FUND_SLOT

CHART_OF_ACCOUNTS1

CHART_OF_ACCOUNTS9

CHART_OF_ACCOUNTS8

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS3

CHART_OF_ACCOUNTS5

CHART_OF_ACCOUNTS6

CHART_OF_ACCOUNTS7

CHART_OF_ACCOUNTS10

CHART_OF_ACCOUNTS4

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS2

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

DATA_ENTRY_IND

NA
FTVFUND_EXPEND_END_DATE FTMFUND

REPORTING VIEW

FUND_HIERARCHY

GRANT_FUND

EXPEND_END_DATE

FUND_EXPENDITURE_END_DATE

NA
FTVFUND_FMGR_CODE_PIDM NA

REPORTING VIEW

PURCHASE_ORDER_ACCOUNTING

GRANT_FUND

FIXED_ASSET_ACCOUNTING_SOURCE

TRANSACTION_HISTORY

GENERAL_LEDGER

INVOICE_ACCOUNTING

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

OPERATING_LEDGER

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

NA
FTVFUND_FMGR_CODE_PIDM_CONP NA

REPORTING VIEW

GRANT_FUND

CONSTR_PROJECT_FMGR_UID

NA
FTVFUND_FTYP_CODE FTMFUND

REPORTING VIEW

FUND_HIERARCHY

GRANT_FUND

FUND_TYPE

FUND_TYPE

NA
FTVFUND_FUND_CODE FTMFUND

REPORTING VIEW

TRANSACTION_HISTORY

GRANT_FUND_SLOT

TRANSACTION_HISTORY

TRANSACTION_HISTORY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FOAPAL_NO_ATTRIBUTES

TRANSACTION_HISTORY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

TRANSACTION_HISTORY

GRANT_FUND_SLOT

FUND_HIERARCHY

GRANT_FUND

GRANT_FUND_SLOT

FOAPAL_NO_ATTRIBUTES

ACTUAL_FUND_LEVEL_1

FUND6

ACTUAL_FUND_LEVEL_3

ACTUAL_FUND_LEVEL_5

FUND10

FUND9

FOAPAL_ELEMENT

ACTUAL_FUND_LEVEL_2

FUND1

FUND4

FUND5

FUND2

FUND3

ACTUAL_FUND_LEVEL_4

FUND8

FUND

FUND

FUND7

CHART_OF_ACCOUNTS

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

OPERATING_LEDGER

GENERAL_LEDGER

TRANSACTION_HISTORY

FUND_HIERARCHY

INVOICE_ACCOUNTING

GRANT_ID

GRANT_ID

GRANT_ID

GRANT_ID

GRANT_ID

NA
FTVFUND_MAX_CONSTR_AMT FTMFUND

REPORTING VIEW

GRANT_FUND

MAXIMUM_CONSTR_PROJECT_AMOUNT

NA
FTVFUND_NCHG_DATE FTMFUND       NA
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_STATUS_IND FTMFUND

REPORTING VIEW

TRANSACTION_HISTORY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

TRANSACTION_HISTORY

TRANSACTION_HISTORY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

PAYROLL_DISTRIBUTION

GRANT_FUND_SLOT

FUND_HIERARCHY

TRANSACTION_HISTORY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND

TRANSACTION_HISTORY

GRANT_FUND_SLOT

ACTUAL_FUND_STATUS_2

FUND_STATUS1

FUND_STATUS6

FUND_STATUS7

ACTUAL_FUND_STATUS_3

ACTUAL_FUND_STATUS_4

FUND_STATUS10

FUND_STATUS2

FUND_STATUS5

FUND_STATUS

FUND_STATUS9

FUND_STATUS

ACTUAL_FUND_STATUS_1

FUND_STATUS3

FUND_STATUS8

FUND_STATUS

ACTUAL_FUND_STATUS_5

FUND_STATUS4

NA
FTVFUND_TERM_DATE FTMFUND

REPORTING VIEW

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FUND_HIERARCHY

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_TERMINATION_DATE

FUND_TERMINATION_DATE4

FUND_TERMINATION_DATE8

TERMINATION_DATE

FUND_TERMINATION_DATE3

FUND_TERMINATION_DATE7

FUND_TERMINATION_DATE10

FUND_TERMINATION_DATE5

FUND_TERMINATION_DATE9

FUND_TERMINATION_DATE1

FUND_TERMINATION_DATE2

FUND_TERMINATION_DATE6

NA
FTVFUND_TITLE FTMFUND

REPORTING VIEW

GRANT_FUND_SLOT

TRANSACTION_HISTORY

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FOAPAL_NO_ATTRIBUTES

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FUND_ATTRIBUTES

PAYROLL_DISTRIBUTION

GRANT_FUND_SLOT

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

FUND_HIERARCHY

FUND_DESC9

FUND_POOL_DESC

FUND_DESC2

FUND_DESC4

FUND_DESC8

FOAPAL_ELEMENT_DESC

FUND_DESC1

FUND_DESC3

FUND_DESC7

FUND_DESC

FUND_DESC

FUND_DESC5

FUND_DESC

FUND_DESC10

FUND_DESC6

FUND_DESC

NA


Ver: 3.1