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	FTMPROG				NA
FTVPROG_COAS_CODE	FTMPROG	REPORTING VIEW	PROGRAM_HIERARCHY PROGRAM_HIERARCHY_FISCAL FOAPAL_NO_ATTRIBUTES	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 PROGRAM_HIERARCHY_FISCAL PROGRAM_HIERARCHY TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES TRANSACTION_HISTORY	ACTUAL_PROGRAM_LEVEL_3 ACTUAL_PROGRAM_LEVEL_4 ACTUAL_PROGRAM_LEVEL_2 PROGRAM PROGRAM ACTUAL_PROGRAM_LEVEL_1 FOAPAL_ELEMENT ACTUAL_PROGRAM_LEVEL_5	NA
FTVPROG_STATUS_IND	FTMPROG	REPORTING VIEW	TRANSACTION_HISTORY GRANT_DEFERRED_COST ENDOWMENT_UNITS PROGRAM_ATTRIBUTES GRANT_DEFERRED_COST BUDGET_AVAILABILITY_LEDGER OPERATING_LEDGER TRANSACTION_HISTORY PROGRAM_HIERARCHY_FISCAL GRANT_LEDGER PROGRAM_HIERARCHY TRANSACTION_HISTORY PAYROLL_DISTRIBUTION TRANSACTION_HISTORY TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES	ACTUAL_PROGRAM_STATUS_2 PROGRAM_STATUS PROGRAM_STATUS PROGRAM_STATUS ORIG_PROGRAM_STATUS PROGRAM_STATUS PROGRAM_STATUS ACTUAL_PROGRAM_STATUS_4 PROGRAM_STATUS PROGRAM_STATUS PROGRAM_STATUS ACTUAL_PROGRAM_STATUS_5 PROGRAM_STATUS ACTUAL_PROGRAM_STATUS_1 ACTUAL_PROGRAM_STATUS_3 FOAPAL_ELEMENT_STATUS	NA
FTVPROG_TERM_DATE	FTMPROG	REPORTING VIEW	PROGRAM_HIERARCHY_FISCAL PROGRAM_HIERARCHY	TERMINATION_DATE TERMINATION_DATE	NA
FTVPROG_TITLE	FTMPROG	REPORTING VIEW	LABOR_COST_DISTRIBUTION PAYROLL_LABOR_DIST_OVERRIDE PROGRAM_HIERARCHY_FISCAL AUTHORIZATION_ACCOUNTING PROGRAM_HIERARCHY PERSONNEL_ACTION_LABOR_DIST OPERATING_LEDGER LABOR_COST_DISTRIBUTION FOAPAL_NO_ATTRIBUTES ORGANIZATION_HIERARCHY_FISCAL GRANT_DEFERRED_COST GRANT_DEFERRED_COST FUND_HIERARCHY_FISCAL FUND_HIERARCHY PROGRAM_ATTRIBUTES PAYROLL_DISTRIBUTION ORGANIZATION_HIERARCHY PROFILE_DEFAULT_ACCOUNTING BUDGET_AVAILABILITY_LEDGER REIMBURSEMENT_ACCOUNTING	ASSIGNMENT_PROGRAM_DESC POSITION_PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC FRINGE_PROGRAM_DESC FOAPAL_ELEMENT_DESC PROGRAM_DEFAULT_DESC PROGRAM_DESC ORIG_PROGRAM_DESC PROGRAM_DEFAULT_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DEFAULT_DESC PROGRAM_DESC PROGRAM_DESC	NA

Ver: 8.4.1