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

Ver: 9.0