Marking records to be ignored

Sometimes, you might want a reference data record to be ignored, for example, because the corresponding item (a BIC, currency, or country) is not used by your financial institution, and you do not want it to appear in the lists generated for the MER Facility. Normally, when you want a record to be ignored, you can delete it from its database table. However, if you were to delete a record from one of the reference data tables, it would be reinserted during the next full update of the reference data. To prevent this from happening, instead of deleting the record, mark it as "to be ignored". Use SQL commands to set the value of the IGNORE_FOR_QUERY column to Y. To undo this, set the value to N. For examples, see Table 1.

Note: Marking a record as to be ignored does not imply this record cannot be deleted by a future import. For this, see Marking records as write-protected.
Table 1. SQL Examples for marking records to be ignored
Examples Result 
UPDATE schema.DNI_COUNTRY
    SET IGNORE_FOR_QUERY = 'Y'
    WHERE CTR_CODE = 'DE'
 The record is not to be used for message validation by FTM SWIFT. 
UPDATE schema.DNI_BIC
    SET IGNORE_FOR_QUERY = 'Y'
    WHERE BIC_RECORD_KEY = 'DE000001';
 The record is not to be used
  • to create an entry for BIC drop-down lists in the MER Facility.
  • to obtain information about the institution which belongs to the own or correspondent BIC of a relationship, or to identify stale authorisations in RMA.
 
UPDATE schema.DNI_CURRENCY_CTR
    SET IGNORE_FOR_QUERY = 'Y'
    WHERE CUR_CODE = 'EUR' AND CTR_CODE = 'DE'
 The record is not to be used for message validation by FTM SWIFT.