Example Depositor Subscribed Services

This worksheet is an example of a complex field select that draws its value from a different column in the configuration worksheet.

The DEPOSITOR_SUB_SERVICES database table has two columns we want to focus on: SERVICE_CODE and SERVICE_TYPE in this example. The value in the Inbound Service Code supplies both fields. The SERVICE_CODE is loaded as a direct load.

"&attribute'Inbound Service Code'" in the complex select statement is translated to a "?" under the covers and the value is supplied by the previous column. The Inbound Service Type column in the map worksheet does not have a corresponding column in the configuration worksheet. Also this same column is not needed in the export map "Depositor Subscribed Service E".