Reporting View Source: FTVPROG

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: FTVPROG Finance Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
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