RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: FTVLOCN Finance Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: FTVLOCN

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

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

LOCATION_HIERARCHY

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

NA
FTVLOCN_LOCN_CODE FTMLOCN

REPORTING VIEW

TRANSACTION_HISTORY

LOCATION_HIERARCHY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

FOAPAL_NO_ATTRIBUTES

ACTUAL_LOCATION_LEVEL_3

LOCATION

ACTUAL_LOCATION_LEVEL_1

ACTUAL_LOCATION_LEVEL_2

ACTUAL_LOCATION_LEVEL_5

ACTUAL_LOCATION_LEVEL_4

FOAPAL_ELEMENT

NA
FTVLOCN_NCHG_DATE FTMLOCN       NA
FTVLOCN_STATUS_IND FTMLOCN

REPORTING VIEW

TRANSACTION_HISTORY

LOCATION_HIERARCHY

PAYROLL_DISTRIBUTION

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ACTUAL_LOCATION_STATUS_2

LOCATION_STATUS

LOCATION_STATUS

ACTUAL_LOCATION_STATUS_5

ACTUAL_LOCATION_STATUS_3

ACTUAL_LOCATION_STATUS_1

ACTUAL_LOCATION_STATUS_4

NA
FTVLOCN_TERM_DATE FTMLOCN       NA
FTVLOCN_TITLE FTMLOCN

REPORTING VIEW

PAYROLL_DISTRIBUTION

LOCATION_HIERARCHY

LOCATION_ATTRIBUTES

FOAPAL_NO_ATTRIBUTES

LOCATION_DESC

LOCATION_DESC

LOCATION_DESC

FOAPAL_ELEMENT_DESC

NA


Ver: 3.1