Collision Lists

Collision List View

This is where collision lists are stored, which are used during conflict checks. You can create your own collision lists, import them as CSV files, or import official sanction lists as collision lists.

To ensure the phonetic search in the KFC doesn't return too many potential matches when checking sanction lists, the StopWords configuration file (StopWordsConfig.XML) in the search profile area "CCCollisionListEntryValue" should be set as strictly as possible. Additionally, first and last names that frequently appear in sanction lists should be added to the weakwords list. This further improves the accuracy of the results.

Object List

The object list displays the available lists. Lists that have already been used cannot be deleted. The "Last Updated" column shows the date of the most recent update, if available.

Detail

In the 'List Entries' tab, you can see the contents of the collision list that will be checked. Clicking the '…' button in the Values column opens a dialog showing the available collision list attributes.

Manually Creating Collision Lists

You can create your own collision lists (e.g., a blacklist) and enter individual entries in the List Entries tab. By clicking the '…' button in the Values column, you can open the entry and enter the attributes to be checked during the conflict check, such as first name, last name, or location.
The available attributes can be expanded under Specialist Administration (General) > Collision List Attributes.

Sanctions List Download

Overview

By clicking this button, you can download sanction lists and import them as collision lists. When importing for the first time, a new collision list is created. When updating, the existing list is overwritten. The name of the collision list is used as a reference.

The following sanction lists can be downloaded and imported:

• EU Sanctions List
• UN Sanctions List
• US Sanctions List
• US SDN Sanctions List
• UK Sanctions List
• CH Sanctions List

EU Sanctions List

To access the sanctions lists, you must register with an EU Login.

At https://webgate.ec.europa.eu/europeaid/fsd/fsf, you can retrieve addresses with a token specifically for non-personalized access to the sanctions lists in the "Show settings for crawler/robot" section. Version 1.1 "XML (Based on XSD)" is supported. This URL with the generated token must be entered as a value in the configuration file.

The URL must be entered in the server configuration.

<add key="EuSanctionsListAddress" value=""></add>

The server service must be restarted to activate the changes.

The collision list is updated if the date in the downloadable list is more recent than the current collision list. The date of the sanctions list is determined from the generationDate attribute of the export element in the download.

Swiss Sanctions List

No configuration is needed for this sanctions list. The list is downloaded from the following URL: https://www.sesam.search.admin.ch/sesam-search-web/pages/downloadXmlGesamtliste.xhtml?lang=de&action=downloadXmlGesamtlisteAction

The collision list is updated if the date in the downloadable list is more recent than the current collision list. The date of the sanctions list is determined from the date attribute of the swiss-sanctions-list element in the download.

UK Sanctions List

No configuration is needed for this sanctions list. The list is downloaded from the following URL: https://sanctionslist.fcdo.gov.uk/docs/UK-Sanctions-List.xml

More information can be found here: https://www.gov.uk/government/publications/the-uk-sanctions-list

The collision list is updated if the date in the downloadable list is more recent than the current collision list. The date of the sanctions list is determined from the DateGenerated element in the download.

UN Sanctions List

No configuration is needed for this sanctions list. The list is downloaded from the following URL: https://scsanctions.un.org/resources/xml/en/consolidated.xml

More information can be found here: https://main.un.org/securitycouncil/en/content/un-sc-consolidated-list

The collision list is updated if the date in the downloadable list is more recent than the current collision list. The date of the sanctions list is determined from the dateGenerated attribute of the CONSOLIDATED_LIST element in the download.

US Sanctions Lists

No configuration is needed for these sanctions lists. OFAC provides two lists via a service. More information can be found here: https://sanctionslist.ofac.treas.gov/Home/

The Specially Designated Nationals List (SDN List) is downloaded from the following URL: https://sanctionslistservice.ofac.treas.gov/api/PublicationPreview/exports/SDN.XML

The collision list is updated if the date in the downloadable list is more recent than the current collision list. The date of the sanctions list is determined from the Publish_Date element of the publshInformation element in the download.

The consolidated list is downloaded from the following URL: https://www.treasury.gov/ofac/downloads/consolidated/consolidated.xml

The collision list is updated if the date in the downloadable list is more recent than the current collision list. The date of the sanctions list is determined from the Publish_Date element of the publshInformation element in the download.

Automatic Update of Sanctions Lists

The automated download and update time can be enabled with the following parameters.

<add key="IsSanctionsListDownloadEnabled" value="false"></add>
<add key="SanctionsListDownloadTime" value="03:00"></add

The server service must be restarted to activate the changes.

Importing Files

Perform Import

After clicking the "Import Files" button, you can select a CSV file in the file selection dialog to import as a collision list. If the collision list name already exists, it will be overwritten. Otherwise, a new collision list will be created. In both cases, the creator and creation date are updated.

CSV File Format Description for Collision Lists

Row 1 specifies the type of data and the file format version.
Row 2 specifies the name and description for the collision list.
Row 3 specifies the column headers for the list entries. All columns must be present.
Starting from row 4, you can enter data. Unless otherwise noted, data should be provided as text.

Row 1

Row 2

Row 3