RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: MULTIPLE Common Composite View Reports
SGHE Operational Data Store Composite View Source: MULTIPLE

Source Column Source Form Target Type Target Target Column Calculation Formula
MULTIPLE MULTIPLE COMPOSITE VIEW

AN_VALIDATION

AN_VALIDATION

AS_VALIDATION

AF_VALIDATION

AP_VALIDATION

AR_VALIDATION

AS_VALIDATION

AA_VALIDATION

AA_VALIDATION

AF_VALIDATION

AP_VALIDATION

AR_VALIDATION

AS_VALIDATION

AP_VALIDATION

AR_VALIDATION

AT_VALIDATION

AT_VALIDATION

AF_VALIDATION

AF_VALIDATION

AF_VALIDATION

AF_VALIDATION

AN_VALIDATION

AF_VALIDATION

AF_VALIDATION

AF_VALIDATION

AT_VALIDATION

AA_VALIDATION

VALUE_DESCRIPTION

TABLE_NAME

VALUE

TABLE_NAME

VALUE_DESCRIPTION

VALUE

TABLE_NAME

TABLE_NAME

VALUE_DESCRIPTION

QUALIFIER

VALUE

TABLE_NAME

VALUE_DESCRIPTION

TABLE_NAME

VALUE_DESCRIPTION

VALUE

VALUE_DESCRIPTION

EFFECTIVE_DATE

QUALIFIER_DESCRIPTION

STATUS

TERMINATION_DATE

VALUE

NEXT_CHANGE_DATE

VALUE

VALUE_DESCRIPTION

TABLE_NAME

VALUE

This was created to support all the union selects extracting various validation tables from the source ERP. They are too numerous to list as mapping sources for each target. So MULTIPLE was chosen to represent sources too numerous to name.


Ver: 3.1