Reporting View Source: FTVLOCN

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FTVLOCN_COAS_CODE	FTMLOCN	REPORTING VIEW	LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL FOAPAL_NO_ATTRIBUTES	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS	NA
FTVLOCN_EFF_DATE	FTMLOCN	REPORTING VIEW	LOCATION_HIERARCHY_FISCAL	EFFECTIVE_DATE
FTVLOCN_LOCN_CODE	FTMLOCN	REPORTING VIEW	TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES TRANSACTION_HISTORY LOCATION_HIERARCHY_FISCAL LOCATION_HIERARCHY TRANSACTION_HISTORY	ACTUAL_LOCATION_LEVEL_4 ACTUAL_LOCATION_LEVEL_3 ACTUAL_LOCATION_LEVEL_5 FOAPAL_ELEMENT ACTUAL_LOCATION_LEVEL_1 LOCATION LOCATION ACTUAL_LOCATION_LEVEL_2	NA
FTVLOCN_NCHG_DATE	FTMLOCN	REPORTING VIEW	LOCATION_HIERARCHY_FISCAL	NEXT_CHANGE_DATE	NA
FTVLOCN_STATUS_IND	FTMLOCN	REPORTING VIEW	TRANSACTION_HISTORY GRANT_VIEW TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES OPERATING_LEDGER GRANT_DEFERRED_COST PAYROLL_DISTRIBUTION LOCATION_ATTRIBUTES PROPOSAL LOCATION_HIERARCHY GRANT_LEDGER LOCATION_HIERARCHY_FISCAL GRANT_DEFERRED_COST FIXED_ASSET_ITEM	ACTUAL_LOCATION_STATUS_3 LOCATION_STATUS ACTUAL_LOCATION_STATUS_2 ACTUAL_LOCATION_STATUS_5 ACTUAL_LOCATION_STATUS_1 ACTUAL_LOCATION_STATUS_4 FOAPAL_ELEMENT_STATUS LOCATION_STATUS ORIG_LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS	NA
FTVLOCN_TERM_DATE	FTMLOCN	REPORTING VIEW	LOCATION_HIERARCHY_FISCAL LOCATION_HIERARCHY	TERMINATION_DATE TERMINATION_DATE	NA
FTVLOCN_TITLE	FTMLOCN	REPORTING VIEW	LOCATION_HIERARCHY PAYROLL_LABOR_DIST_OVERRIDE OPERATING_LEDGER GRANT_DEFERRED_COST ORGANIZATION_HIERARCHY LABOR_COST_DISTRIBUTION GRANT_DEFERRED_COST LABOR_COST_DISTRIBUTION PAYROLL_DISTRIBUTION FUND_HIERARCHY_FISCAL FUND_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING FOAPAL_NO_ATTRIBUTES LOCATION_ATTRIBUTES LOCATION_HIERARCHY_FISCAL PERSONNEL_ACTION_LABOR_DIST	LOCATION_DESC POSITION_LOCATION_DESC LOCATION_DESC ORIG_LOCATION_DESC LOCATION_DESC FRINGE_LOCATION_DESC LOCATION_DESC ASSIGNMENT_LOCATION_DESC LOCATION_DESC LOCATION_DEFAULT_DESC LOCATION_DESC LOCATION_DEFAULT_DESC LOCATION_DEFAULT_DESC LOCATION_DESC LOCATION_DESC FOAPAL_ELEMENT_DESC LOCATION_DESC LOCATION_DESC LOCATION_DESC	NA

Ver: 8.5