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 LOCATION_HIERARCHY_FISCAL TRANSACTION_HISTORY LOCATION_HIERARCHY TRANSACTION_HISTORY	ACTUAL_LOCATION_LEVEL_4 ACTUAL_LOCATION_LEVEL_3 ACTUAL_LOCATION_LEVEL_5 FOAPAL_ELEMENT LOCATION ACTUAL_LOCATION_LEVEL_1 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	GRANT_VIEW TRANSACTION_HISTORY TRANSACTION_HISTORY TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES GRANT_DEFERRED_COST OPERATING_LEDGER TRANSACTION_HISTORY TRANSACTION_HISTORY LOCATION_ATTRIBUTES PROPOSAL PAYROLL_DISTRIBUTION GRANT_DEFERRED_COST GRANT_LEDGER LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL FIXED_ASSET_ITEM	LOCATION_STATUS ACTUAL_LOCATION_STATUS_3 ACTUAL_LOCATION_STATUS_2 ACTUAL_LOCATION_STATUS_5 FOAPAL_ELEMENT_STATUS ORIG_LOCATION_STATUS LOCATION_STATUS ACTUAL_LOCATION_STATUS_1 ACTUAL_LOCATION_STATUS_4 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	GRANT_DEFERRED_COST LOCATION_HIERARCHY OPERATING_LEDGER PAYROLL_LABOR_DIST_OVERRIDE GRANT_DEFERRED_COST ORGANIZATION_HIERARCHY LABOR_COST_DISTRIBUTION LABOR_COST_DISTRIBUTION FUND_HIERARCHY FUND_HIERARCHY_FISCAL PAYROLL_DISTRIBUTION ORGANIZATION_HIERARCHY_FISCAL PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING FOAPAL_NO_ATTRIBUTES LOCATION_ATTRIBUTES LOCATION_HIERARCHY_FISCAL PERSONNEL_ACTION_LABOR_DIST	ORIG_LOCATION_DESC LOCATION_DESC LOCATION_DESC POSITION_LOCATION_DESC LOCATION_DESC LOCATION_DESC FRINGE_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