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

Source Column Source Form Target Type Target Target Column Calculation Formula
FTVORGN_PROG_CODE_DEF FTMPROG

REPORTING VIEW

ORGANIZATION_HIERARCHY_FISCAL

ORGANIZATION_HIERARCHY

PROGRAM_DEFAULT

PROGRAM_DEFAULT

 
FTVPROG_COAS_CODE FTMPROG

REPORTING VIEW

PROGRAM_HIERARCHY

FOAPAL_NO_ATTRIBUTES

PROGRAM_HIERARCHY_FISCAL

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

NA
FTVPROG_DATA_ENTRY_IND FTMPROG

REPORTING VIEW

VALIDATION

PROGRAM_HIERARCHY_FISCAL

PROGRAM_HIERARCHY

DATA_ENTRY_IND

DATA_ENTRY_PERMITTED

DATA_ENTRY_PERMITTED

NA
FTVPROG_EFF_DATE FTMPROG

REPORTING VIEW

PROGRAM_HIERARCHY_FISCAL

EFFECTIVE_DATE

 
FTVPROG_NCHG_DATE FTMPROG

REPORTING VIEW

PROGRAM_HIERARCHY_FISCAL

NEXT_CHANGE_DATE

NA
FTVPROG_PROG_CODE FTMPROG

REPORTING VIEW

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

FOAPAL_NO_ATTRIBUTES

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY_FISCAL

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ACTUAL_PROGRAM_LEVEL_1

ACTUAL_PROGRAM_LEVEL_2

ACTUAL_PROGRAM_LEVEL_5

FOAPAL_ELEMENT

PROGRAM

PROGRAM

ACTUAL_PROGRAM_LEVEL_3

ACTUAL_PROGRAM_LEVEL_4

NA
FTVPROG_STATUS_IND FTMPROG

REPORTING VIEW

BUDGET_AVAILABILITY_LEDGER

PROGRAM_HIERARCHY_FISCAL

PAYROLL_DISTRIBUTION

FOAPAL_NO_ATTRIBUTES

GRANT_DEFERRED_COST

OPERATING_LEDGER

TRANSACTION_HISTORY

GRANT_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PROGRAM_ATTRIBUTES

PROGRAM_HIERARCHY

GRANT_DEFERRED_COST

TRANSACTION_HISTORY

ENDOWMENT_UNITS

PROGRAM_STATUS

PROGRAM_STATUS

PROGRAM_STATUS

FOAPAL_ELEMENT_STATUS

ORIG_PROGRAM_STATUS

PROGRAM_STATUS

ACTUAL_PROGRAM_STATUS_5

PROGRAM_STATUS

ACTUAL_PROGRAM_STATUS_1

ACTUAL_PROGRAM_STATUS_3

ACTUAL_PROGRAM_STATUS_4

PROGRAM_STATUS

PROGRAM_STATUS

PROGRAM_STATUS

ACTUAL_PROGRAM_STATUS_2

PROGRAM_STATUS

NA
FTVPROG_TERM_DATE FTMPROG

REPORTING VIEW

PROGRAM_HIERARCHY_FISCAL

PROGRAM_HIERARCHY

TERMINATION_DATE

TERMINATION_DATE

NA
FTVPROG_TITLE FTMPROG

REPORTING VIEW

BUDGET_AVAILABILITY_LEDGER

FUND_HIERARCHY

GRANT_DEFERRED_COST

ORGANIZATION_HIERARCHY_FISCAL

PROGRAM_ATTRIBUTES

PROGRAM_HIERARCHY_FISCAL

PROFILE_DEFAULT_ACCOUNTING

AUTHORIZATION_ACCOUNTING

FUND_HIERARCHY_FISCAL

PERSONNEL_ACTION_LABOR_DIST

REIMBURSEMENT_ACCOUNTING

LABOR_COST_DISTRIBUTION

PAYROLL_LABOR_DIST_OVERRIDE

ORGANIZATION_HIERARCHY

PROGRAM_HIERARCHY

FOAPAL_NO_ATTRIBUTES

GRANT_DEFERRED_COST

OPERATING_LEDGER

LABOR_COST_DISTRIBUTION

PAYROLL_DISTRIBUTION

PROGRAM_DESC

PROGRAM_DESC

ORIG_PROGRAM_DESC

PROGRAM_DEFAULT_DESC

PROGRAM_DESC

PROGRAM_DESC

PROGRAM_DEFAULT_DESC

PROGRAM_DESC

PROGRAM_DEFAULT_DESC

PROGRAM_DESC

PROGRAM_DESC

FRINGE_PROGRAM_DESC

POSITION_PROGRAM_DESC

PROGRAM_DESC

PROGRAM_DESC

FOAPAL_ELEMENT_DESC

PROGRAM_DESC

PROGRAM_DESC

ASSIGNMENT_PROGRAM_DESC

PROGRAM_DESC

NA


Ver: 8.5