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 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	NA
FTVLOCN_NCHG_DATE	FTMLOCN	REPORTING VIEW	LOCATION_HIERARCHY_FISCAL	NEXT_CHANGE_DATE	NA
FTVLOCN_STATUS_IND	FTMLOCN	REPORTING VIEW	TRANSACTION_HISTORY LOCATION_HIERARCHY_FISCAL TRANSACTION_HISTORY FOAPAL_NO_ATTRIBUTES LOCATION_HIERARCHY PAYROLL_DISTRIBUTION TRANSACTION_HISTORY TRANSACTION_HISTORY GRANT_DEFERRED_COST GRANT_DEFERRED_COST 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 ORIG_LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS LOCATION_STATUS ACTUAL_LOCATION_STATUS_5	NA
FTVLOCN_TERM_DATE	FTMLOCN	REPORTING VIEW	LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL	TERMINATION_DATE TERMINATION_DATE	NA
FTVLOCN_TITLE	FTMLOCN	REPORTING VIEW	FUND_HIERARCHY_FISCAL PERSONNEL_ACTION_LABOR_DIST PROFILE_DEFAULT_ACCOUNTING LOCATION_HIERARCHY_FISCAL PAYROLL_DISTRIBUTION PAYROLL_LABOR_DIST_OVERRIDE OPERATING_LEDGER REIMBURSEMENT_ACCOUNTING FUND_HIERARCHY LOCATION_ATTRIBUTES FOAPAL_NO_ATTRIBUTES GRANT_DEFERRED_COST ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL LABOR_COST_DISTRIBUTION GRANT_DEFERRED_COST LOCATION_HIERARCHY LABOR_COST_DISTRIBUTION AUTHORIZATION_ACCOUNTING	LOCATION_DEFAULT_DESC LOCATION_DESC LOCATION_DEFAULT_DESC LOCATION_DESC LOCATION_DESC POSITION_LOCATION_DESC LOCATION_DESC LOCATION_DESC LOCATION_DESC LOCATION_DESC FOAPAL_ELEMENT_DESC ORIG_LOCATION_DESC LOCATION_DESC LOCATION_DEFAULT_DESC FRINGE_LOCATION_DESC LOCATION_DESC LOCATION_DESC ASSIGNMENT_LOCATION_DESC LOCATION_DESC	NA

Ver: 9.0