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**
Banner Source Column	Source Form	ODS Target	ODS Target Column
FTVLOCN_COAS_CODE	FTMLOCN	LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL FOAPAL_NO_ATTRIBUTES	CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS
FTVLOCN_EFF_DATE	FTMLOCN	LOCATION_HIERARCHY_FISCAL	EFFECTIVE_DATE
FTVLOCN_LOCN_CODE	FTMLOCN	TRANSACTION_HISTORY TRANSACTION_HISTORY LOCATION_HIERARCHY FOAPAL_NO_ATTRIBUTES LOCATION_HIERARCHY_FISCAL TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY	ACTUAL_LOCATION_LEVEL_1 ACTUAL_LOCATION_LEVEL_4 LOCATION FOAPAL_ELEMENT LOCATION ACTUAL_LOCATION_LEVEL_3 ACTUAL_LOCATION_LEVEL_2 ACTUAL_LOCATION_LEVEL_5
FTVLOCN_NCHG_DATE	FTMLOCN	LOCATION_HIERARCHY_FISCAL	NEXT_CHANGE_DATE
FTVLOCN_STATUS_IND	FTMLOCN	TRANSACTION_HISTORY LOCATION_HIERARCHY_FISCAL TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES LOCATION_HIERARCHY PAYROLL_DISTRIBUTION TRANSACTION_HISTORY TRANSACTION_HISTORY GRANT_LEDGER GRANT_VIEW LOCATION_ATTRIBUTES PROPOSAL FIXED_ASSET_ITEM OPERATING_LEDGER TRANSACTION_HISTORY	ACTUAL_LOCATION_STATUS_4 LOCATION_STATUS ACTUAL_LOCATION_STATUS_1 FOAPAL_ELEMENT_STATUS LOCATION_STATUS LOCATION_STATUS ACTUAL_LOCATION_STATUS_2 ACTUAL_LOCATION_STATUS_3 LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS ACTUAL_LOCATION_STATUS_5
FTVLOCN_TERM_DATE	FTMLOCN	LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL	TERMINATION_DATE TERMINATION_DATE
FTVLOCN_TITLE	FTMLOCN	FUND_HIERARCHY_FISCAL PROFILE_DEFAULT_ACCOUNTING LOCATION_HIERARCHY_FISCAL PAYROLL_DISTRIBUTION PAYROLL_LABOR_DIST_OVERRIDE OPERATING_LEDGER REIMBURSEMENT_ACCOUNTING FUND_HIERARCHY LOCATION_ATTRIBUTES FOAPAL_NO_ATTRIBUTES ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL LOCATION_HIERARCHY AUTHORIZATION_ACCOUNTING	LOCATION_DEFAULT_DESC LOCATION_DEFAULT_DESC LOCATION_DESC LOCATION_DESC POSITION_LOCATION_DESC LOCATION_DESC LOCATION_DESC LOCATION_DESC LOCATION_DESC FOAPAL_ELEMENT_DESC LOCATION_DESC LOCATION_DEFAULT_DESC LOCATION_DESC LOCATION_DESC

Ver: 8.3