Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FTVLOCN Finance
SGHE Banner Operational Data Store Composite View Source: FTVLOCN - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
FTVLOCN_COAS_CODE FTMLOCN COMPOSITE VIEW

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY_FISCAL

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

NA
FTVLOCN_EFF_DATE FTMLOCN COMPOSITE VIEW

AF_LOCATION_HIERARCHY_FISCAL

EFFECTIVE_DATE

 
FTVLOCN_LOCN_CODE FTMLOCN COMPOSITE VIEW

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY

LOCATION

LOCATION

NA
FTVLOCN_NCHG_DATE FTMLOCN COMPOSITE VIEW

AF_LOCATION_HIERARCHY_FISCAL

NEXT_CHANGE_DATE

NA
FTVLOCN_STATUS_IND FTMLOCN COMPOSITE VIEW

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY_FISCAL

LOCATION_STATUS

LOCATION_STATUS

NA
FTVLOCN_TERM_DATE FTMLOCN COMPOSITE VIEW

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY_FISCAL

TERMINATION_DATE

TERMINATION_DATE

NA
FTVLOCN_TITLE FTMLOCN COMPOSITE VIEW

AF_LOCATION_HIERARCHY_FISCAL

AP_PAYROLL_LABOR_DIST_OVERRIDE

AN_PERSONNEL_ACTION_LABOR_DIST

AF_LOCATION_ATTRIBUTES_ODS

AF_LOCATION_HIERARCHY

LOCATION_DESC

POSITION_LOCATION_DESC

LOCATION_DESC

LOCATION_DESC

LOCATION_DESC

NA


Ver: