C.3 Delta Watch List Configurations for the Dow Jones Watch List

Note:

These configurations are performed when you do not want to download the full watch list, and only want to download the delta watch list. This helps to reduce the download time and is not part of the screening process.

Customer Screening recommends that you always use the full watch list during the screening process. Due to the clustering strategy which is implemented in the screening process, you must not download the delta watch list. There are certain cases in which you must download the delta watch list files, for example, if the full watch list files are not yet available for download or if you want to save time.

Customers who download the delta watch list files must first download the full watch list files and then download the delta watch list files. The delta watch list is then merged into the full watch list before screening.

The following image shows the information flow for the delta watch list:

Figure C-9 Flow for Delta Watch List


Flow for Delta Watch List

When you download the full watch list, data is stored in the FSI_WATCHLIST_INDIVIDUAL and FSI_WATCHLIST_ENTITIES tables. When you download the delta watch list, data is first stored in the FSI_WATCHLIST_DELTA_INDIVIDUAL and FSI_WATCHLIST_DELTA_ENTITIES tables. Then, based on the value in the ACTION Flag tag in the delta watch list, it merges with the full watch list.

The ACTION flag key is a non-editable value, and can be one of the following values:
  • new: If the value is new, it means that these records are new and are added to the full watch list when the delta files are merged with the full watch list.
  • chg: If the value is chg, it means that these records are modified and are added to the full watch list when the delta files are merged with the full watch list.
  • del: If the value is del, it means that these records are no longer active and are removed from the full watch list when the delta files are merged with the full watch list.

    Note:

    You must always run the full watch list files before you run the delta watch list files. The full watch list files must be downloaded if, for example, the download of the delta watch list files has failed for multiple days. You can also run the full watch list once every week to ensure that the complete data has been processed.

Configurations for the Full and Delta Watch Lists

The following configurations must be done for both full and delta watch list updates in the watch list-management.properties run profile. The run profile is available in the <domain_name>/edq/oedq.local.home/runprofiles/ directory when you log in to the WinSCP server.
  • Set phase.Initialise\ staged\ data.enabled = N to disable the .jmp file updates.
  • Set phase.Initialise\ staged\ data\ DB.enabled = Y to initialize the database.
  • Set phase.Initilize\ Prepared\ List\ Data.enabled = N to disable the .jmp file updates.
  • Set phase.Initilize\ Prepared\ List\ Data\ DB.enabled = Y to prepare the database.

Running the Full Watch list

To run the full watch list, follow these steps:
  1. Set the following properties in the watch list-management.properties file:
    • phase.DJW\ -\ Download.enabled = Y.
    • phase.DJW\ -\ Download\ Delta.enabled = N.
    • phase.DJW\ -\ Stage\ reference\ lists.enabled = Y.
    • phase.DJW\ -\ Sanction_List_Reference.enabled = Y
    • phase.DJW\ -\ Keywords_Preparation.enabled = Y
    • phase.*.export.*.ind_table_name = FSI_WATCHLIST_INDIVIDUAL.
    • phase.*.export.*.entities_table_name = FSI_WATCHLIST_ENTITIES.
  2. Set the following properties in the customer-screening.properties file:
    • phase.DJW\ -\ Load\ without\ filtering.enabled = N
    • phase.DJW\ -\ Load\ without\ filtering\ DB.enabled = Y
    • phase.DJW\ -\ Load\ with\ filtering\ (Part\ 1).enabled = N
    • phase.DJW\ -\ Load\ with\ filtering\ (Part\ 1)\ DB.enabled = Y
    • phase.DJW\ -\ Load\ with\ filtering\ (Part\ 2).enabled = Y
  3. Set the following properties in the customer-screening-real-time.properties file:
    • phase.DJW\ -\ Load\ without\ filtering.enabled = N
    • phase.DJW\ -\ Load\ without\ filtering\ DB.enabled = Y
    • phase.DJW\ -\ Load\ with\ filtering\ (Part\ 1).enabled = N
    • phase.DJW\ -\ Load\ with\ filtering\ (Part\ 1)\ DB.enabled = Y
    • phase.DJW\ -\ Load\ with\ filtering\ (Part\ 2).enabled = Y
  4. Set the following properties in the external-entity-screening.properties file:
    • phase.DJW\ -\ Load\ without\ filtering.enabled = N
    • phase.DJW\ -\ Load\ without\ filtering\ DB.enabled = Y
    • phase.DJW\ -\ Load\ with\ filtering\ (Part\ 1).enabled = N
    • phase.DJW\ -\ Load\ with\ filtering\ (Part\ 1)\ DB.enabled = Y
    • phase.DJW\ -\ Load\ with\ filtering\ (Part\ 2).enabled = Y

Running the Delta Watch List

To run the delta watch list, follow these steps:
  1. Set the following properties in the watch list-management.properties file:
    • phase.DJW\ -\ Download.enabled = N.
    • phase.DJW\ -\ Download\ Delta.enabled = Y.
    • phase.DJW\ -\ Stage\ reference\ lists.enabled = Y.
    • phase.DJW\ -\ Sanction_List_Reference.enabled = Y
    • phase.DJW\ -\ Keywords_Preparation.enabled = Y
  2. Set phase.*.export.*.ind_table_name = FSI_WATCHLIST_DELTA_INDIVIDUAL.
  3. Set phase.*.export.*.entities_table_name = FSI_WATCHLIST_DELTA_ENTITIES.

Merging the Delta Watch List to the Full Watch List

To merge the delta watch list with the full watch list, set the following properties in the watch list-management.properties file:
  • phase.Delta\ Merge.enabled = Y.
  • phase.Linked\ Profiles.enabled = Y.