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 ORGANIZATION_HIERARCHY_FISCAL	PROGRAM_DEFAULT PROGRAM_DEFAULT
FTVPROG	FTMPROG				NA
FTVPROG_COAS_CODE	FTMPROG	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES PROGRAM_HIERARCHY PROGRAM_HIERARCHY_FISCAL	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS	NA
FTVPROG_DATA_ENTRY_IND	FTMPROG	REPORTING VIEW	PROGRAM_HIERARCHY PROGRAM_HIERARCHY_FISCAL VALIDATION	DATA_ENTRY_PERMITTED DATA_ENTRY_PERMITTED DATA_ENTRY_IND	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	FOAPAL_NO_ATTRIBUTES PROGRAM_HIERARCHY PROGRAM_HIERARCHY_FISCAL TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY	FOAPAL_ELEMENT PROGRAM PROGRAM ACTUAL_PROGRAM_LEVEL_1 ACTUAL_PROGRAM_LEVEL_2 ACTUAL_PROGRAM_LEVEL_3 ACTUAL_PROGRAM_LEVEL_4 ACTUAL_PROGRAM_LEVEL_5	NA
FTVPROG_STATUS_IND	FTMPROG	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER ENDOWMENT_UNITS FOAPAL_NO_ATTRIBUTES GRANT_LEDGER OPERATING_LEDGER PROGRAM_ATTRIBUTES PROGRAM_HIERARCHY PROGRAM_HIERARCHY_FISCAL TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY PAYROLL_DISTRIBUTION	PROGRAM_STATUS PROGRAM_STATUS FOAPAL_ELEMENT_STATUS PROGRAM_STATUS PROGRAM_STATUS PROGRAM_STATUS PROGRAM_STATUS PROGRAM_STATUS ACTUAL_PROGRAM_STATUS_1 ACTUAL_PROGRAM_STATUS_2 ACTUAL_PROGRAM_STATUS_3 ACTUAL_PROGRAM_STATUS_4 ACTUAL_PROGRAM_STATUS_5 PROGRAM_STATUS	NA
FTVPROG_TERM_DATE	FTMPROG	REPORTING VIEW	PROGRAM_HIERARCHY PROGRAM_HIERARCHY_FISCAL	TERMINATION_DATE TERMINATION_DATE	NA
FTVPROG_TITLE	FTMPROG	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER FOAPAL_NO_ATTRIBUTES FUND_HIERARCHY FUND_HIERARCHY_FISCAL OPERATING_LEDGER ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL PROGRAM_ATTRIBUTES PROGRAM_HIERARCHY PROGRAM_HIERARCHY_FISCAL PAYROLL_DISTRIBUTION PAYROLL_LABOR_DIST_OVERRIDE AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING	PROGRAM_DESC FOAPAL_ELEMENT_DESC PROGRAM_DESC PROGRAM_DEFAULT_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DEFAULT_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC POSITION_PROGRAM_DESC PROGRAM_DESC PROGRAM_DEFAULT_DESC PROGRAM_DESC	NA

Ver: 8.2