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	FOAPAL_NO_ATTRIBUTES LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL	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	FOAPAL_NO_ATTRIBUTES LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY	FOAPAL_ELEMENT LOCATION LOCATION ACTUAL_LOCATION_LEVEL_1 ACTUAL_LOCATION_LEVEL_2 ACTUAL_LOCATION_LEVEL_3 ACTUAL_LOCATION_LEVEL_4 ACTUAL_LOCATION_LEVEL_5	NA
FTVLOCN_NCHG_DATE	FTMLOCN	REPORTING VIEW	LOCATION_HIERARCHY_FISCAL	NEXT_CHANGE_DATE	NA
FTVLOCN_STATUS_IND	FTMLOCN	REPORTING VIEW	FIXED_ASSET_ITEM FOAPAL_NO_ATTRIBUTES GRANT_LEDGER GRANT_VIEW LOCATION_ATTRIBUTES LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL OPERATING_LEDGER PROPOSAL TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY PAYROLL_DISTRIBUTION	LOCATION_STATUS FOAPAL_ELEMENT_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS ACTUAL_LOCATION_STATUS_1 ACTUAL_LOCATION_STATUS_2 ACTUAL_LOCATION_STATUS_3 ACTUAL_LOCATION_STATUS_4 ACTUAL_LOCATION_STATUS_5 LOCATION_STATUS	NA
FTVLOCN_TERM_DATE	FTMLOCN	REPORTING VIEW	LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL	TERMINATION_DATE TERMINATION_DATE	NA
FTVLOCN_TITLE	FTMLOCN	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES FUND_HIERARCHY FUND_HIERARCHY_FISCAL LOCATION_ATTRIBUTES LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL OPERATING_LEDGER ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL PAYROLL_DISTRIBUTION PAYROLL_LABOR_DIST_OVERRIDE AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING	FOAPAL_ELEMENT_DESC LOCATION_DESC LOCATION_DEFAULT_DESC LOCATION_DESC LOCATION_DESC LOCATION_DESC LOCATION_DESC LOCATION_DESC LOCATION_DEFAULT_DESC LOCATION_DESC POSITION_LOCATION_DESC LOCATION_DESC LOCATION_DEFAULT_DESC LOCATION_DESC	NA

Ver: 8.2