Bank Directory Plus to Party Entity Directory mapping

File Types Supported

File Name File Types Supported File Formats Supported File Naming Conventions

Bank Directory Plus

FULL

XML

BANKDIRECTORYPLUS_V3_FULL_YYYYMMDD

Bank Directory Plus

DELTA

XML

BANKDIRECTORYPLUS_V3_DELTA_YYYYMMDD
AWS S3 Ingestion identifies this file when the file name starts with "BANKDIRECTORYPLUS".

Important points to remember:

  1. The client implementations should not modify the files names provided by industry sources and ingest the files as received.

  2. The initial file processed must be a full file. Subsequently, full and delta files may be processed.

  3. IPF currently does not maintain a counter for delta files. It is important for client implementations to ensure files are not processed out of sequence or any intermediate delta files are not skipped before processing subsequent delta files.

  4. IPF does not currently support FIX and UNDO_FIX Bank Directory Plus files provided by SWIFTRef.

Delta File Load Processing

Bank Directory Plus provides a record of changes between the current and previous file version. The modification_flag denotes the type of change. Possible values are:

  • A = Added

  • D = Deleted

  • M = Modified

Records are updated accordingly.

For FULL files, all existing entries that are not part of the new file will be deleted.

For DELTA files, processing follows predefined flags, considering only the specified entries for (A)ddition, (D)eletion, or (M)odification.

More on how FULL files are processed can be found here

Mapping Definitions

Below table provides the mapping as performed from Bank Directory Plus file into Party Entity Directory.

Bank Directory Plus Property (Source) PartyEntity Directory Property (Destination) Comment

record_key

entityUniqueId

-

entityDataSource

Constant value: Bank_Directory_Plus

institution_name

entityName

-

entityAddress.addressType

Constant value: ADDR

street_address_1

entityAddress.streetName

streetName is populated by concatenating address details from street_address_1, street_address_2, street_address_3 & street_address_4, separated using 'space'.

street_address_2

entityAddress.streetName

streetName is populated by concatenating address details from street_address_1, street_address_2, street_address_3 & street_address_4, separated using 'space'.

street_address_3

entityAddress.streetName

streetName is populated by concatenating address details from street_address_1, street_address_2, street_address_3 & street_address_4, separated using 'space'.

street_address_4

entityAddress.streetName

streetName is populated by concatenating address details from street_address_1, street_address_2, street_address_3 & street_address_4, separated using 'space'.

pob_number

entityAddress.postBox

zip_code

entityAddress.postCode

city

entityAddress.townName

cps

entityAddress.countrySubDivision

iso_country_code

entityAddress.country

bic

entityIdentifier[ ].identifier

/

entityIdentifier[ ].identifierType

Constant value: BIC

-

entityIdentifier[ ].identifierSubType

Constant value: ACCOUNT_ISSUING_BIC

national_id

entityIdentifier[ ].identifier

Mapped when national_id is specified on the record

-

entityIdentifier[ ].identifierType

Constant value: NCC, mapped when national_id is specified on the record

field_b

entityIdentifier[ ].identifierSubType

Mapped as field_b. When field_b value has corresponding ISO20022 code available, then one more identifier type of NCC is mapped with national_id value and subtype as corresponding ISO20022 code available.

iso_lei_code

entityIdentifier[ ].identifier

Map when iso_lei_code is specified on the record

-

entityIdentifier[ ].identifierType

Constant value: LEI, map when iso_lei_code is specified on the record

chips_uid

entityIdentifier[ ].identifier

Map when chips_uid is specified on the record

-

entityIdentifier[ ].identifierType

Constant value: NCC, map when chips_uid is specified on the record

-

entityIdentifier[ ].IdentifierSubType

Constant value: USPID, map when chips_uid is specified on the record

Office Type = HO

isHeadOffice

Boolean: Indicates if the entity is a head office entity in the group.

Below mapping of ISO20022 aligned subtype values for NCCs is supported on IPF CSM Reachability.

ISO20022 Code Mapping

field_b ISO20022 code

ABA

USABA

ABA/FN

USABA

BC

CHBCC

BC/FN

CHBCC

BLZ

DEBLZ

BLZ/FN

DEBLZ

BLZAT

ATBLZ

BM

MZBMO

BOK

KRBOK

BOK/FN

KRBOK

BSB

AUBSB

CH-SIC6

CHSIC

CH-SIC6/FN

CHSIC

CNAPS

CNAPS

CNAPS/FN

CNAPS

CPA

CACPA

HEBIC

GRBIC

IFSC

INFSC

RCBIC

RUCBC

SBA

SESBA

SBA/FN

SESBA

SC

GBDSC

SC/FN

GBDSC

ZENGIN

JPZGN

Example Mapping

Source Record from Industry file

<?xml version="1.0" encoding="UTF-8"?>
<dataexport product="bankdirectoryplus_v3" filetype="full" filedate="20231124">
    <bankdirectoryplus_v3>
        <modification_flag>A</modification_flag>
        <record_key>BD000000DAMC</record_key>
        <office_type>FB</office_type>
        <parent_office_key>BD000000DAMD</parent_office_key>
        <head_office_key>BD000000DAMD</head_office_key>
        <legal_type>B</legal_type>
        <legal_parent_key>BD000000DAMD</legal_parent_key>
        <group_type>Member</group_type>
        <group_parent_key>BD000000DAMD</group_parent_key>
        <institution_status>BANK</institution_status>
        <bic8>BDCCBQBN</bic8>
        <branch_bic>XXX</branch_bic>
        <bic>BDCCBQBNXXX</bic>
        <national_id>000700708</national_id>
        <connected_bic>BDCCBQBNXXX</connected_bic>
        <institution_name>BANCO DI CARIBE N.V. BONAIRE</institution_name>
        <street_address_1>KAYA GRANDI 22</street_address_1>
        <city>KRALENDIJK</city>
        <cps>BONAIRE</cps>
        <country_name>BONAIRE, SINT EUSTATIUS AND SABA</country_name>
        <iso_country_code>BQ</iso_country_code>
        <timezone>B</timezone>
        <subtype_indicator>SUPE</subtype_indicator>
        <network_connectivity>CCN</network_connectivity>
        <service_codes>FIN</service_codes>
        <ssi_group_key>BD000000DAMC</ssi_group_key>
        <field_b>CWANP</field_b>
    </bankdirectoryplus_v3>
    <bankdirectoryplus_v3>
        <modification_flag>A</modification_flag>
        <record_key>BD000000DBB1</record_key>
        <office_type>HO</office_type>
        <parent_office_key>BD000000DBB1</parent_office_key>
        <head_office_key>BD000000DBB1</head_office_key>
        <legal_type>L</legal_type>
        <legal_parent_key>BD000000DBB1</legal_parent_key>
        <group_type>Member</group_type>
        <group_parent_key>BD0000012O42</group_parent_key>
        <institution_status>BANK</institution_status>
        <iso_lei_code>254900D9C6WH4TFOTC80</iso_lei_code>
        <bic8>MCBKBQBN</bic8>
        <branch_bic>XXX</branch_bic>
        <bic>MCBKBQBNXXX</bic>
        <chips_uid>039344</chips_uid>
        <national_id>000704351</national_id>
        <connected_bic>MCBKBQBNXXX</connected_bic>
        <institution_name>MADURO AND CURIEL'S BANK (BONAIRE) NV</institution_name>
        <street_address_1>BULEVAR GOBERNADOR NICOLAAS DEBR 70</street_address_1>
        <city>KRALENDIJK</city>
        <cps>BONAIRE</cps>
        <country_name>BONAIRE, SINT EUSTATIUS AND SABA</country_name>
        <iso_country_code>BQ</iso_country_code>
        <timezone>B</timezone>
        <subtype_indicator>SUPE</subtype_indicator>
        <network_connectivity>CCN</network_connectivity>
        <service_codes>FIN</service_codes>
        <ssi_group_key>BD000000DBB1</ssi_group_key>
        <field_b>CWANP</field_b>
    </bankdirectoryplus_v3>
    <bankdirectoryplus_v3>
        <modification_flag>A</modification_flag>
        <record_key>BD000000DBES</record_key>
        <office_type>FB</office_type>
        <parent_office_key>BD000000DBET</parent_office_key>
        <head_office_key>BD000000DBET</head_office_key>
        <legal_type>B</legal_type>
        <legal_parent_key>BD000000DBET</legal_parent_key>
        <group_type>Member</group_type>
        <group_parent_key>BD000000DBET</group_parent_key>
        <institution_status>BANK</institution_status>
        <bic8>ORBABQBN</bic8>
        <branch_bic>XXX</branch_bic>
        <bic>ORBABQBNXXX</bic>
        <national_id>000705059</national_id>
        <connected_bic>ORBABQBNXXX</connected_bic>
        <institution_name>ORCO BANK N.V. BONAIRE</institution_name>
        <street_address_1>KAYA GRANDI 48</street_address_1>
        <city>KRALENDIJK</city>
        <cps>BONAIRE</cps>
        <country_name>BONAIRE, SINT EUSTATIUS AND SABA</country_name>
        <iso_country_code>BQ</iso_country_code>
        <timezone>B</timezone>
        <subtype_indicator>SUPE</subtype_indicator>
        <network_connectivity>CCN</network_connectivity>
        <service_codes>FIN</service_codes>
        <ssi_group_key>BD000000DBES</ssi_group_key>
        <field_b>CWANP</field_b>
    </bankdirectoryplus_v3>
    <bankdirectoryplus_v3>
        <modification_flag>A</modification_flag>
        <record_key>BD000000I8PJ</record_key>
        <office_type>FB</office_type>
        <parent_office_key>BD000000DBH8</parent_office_key>
        <head_office_key>BD000000DBH8</head_office_key>
        <legal_type>B</legal_type>
        <legal_parent_key>BD000000DBH8</legal_parent_key>
        <group_type>Member</group_type>
        <group_parent_key>BD00000037HJ</group_parent_key>
        <institution_status>BANK</institution_status>
        <bic8>RBTTBQBN</bic8>
        <branch_bic>XXX</branch_bic>
        <bic>RBTTBQBNXXX</bic>
        <chips_uid>434722</chips_uid>
        <national_id>000704500</national_id>
        <connected_bic>RBTTBQBNXXX</connected_bic>
        <institution_name>RBC ROYAL BANK N.V.(FORMERLY RBTT BANK N.V.)</institution_name>
        <street_address_1>KAYA KORONA 15</street_address_1>
        <city>BONAIRE</city>
        <cps>BONAIRE</cps>
        <country_name>BONAIRE, SINT EUSTATIUS AND SABA</country_name>
        <iso_country_code>BQ</iso_country_code>
        <timezone>B</timezone>
        <subtype_indicator>SUPE</subtype_indicator>
        <network_connectivity>CCN</network_connectivity>
        <service_codes>FINSCO</service_codes>
        <ssi_group_key>BD000000I8PJ</ssi_group_key>
        <field_b>CWANP</field_b>
    </bankdirectoryplus_v3>
    <bankdirectoryplus_v3>
        <modification_flag>A</modification_flag>
        <record_key>BD000000I8Q5</record_key>
        <office_type>SF</office_type>
        <parent_office_key>BD000000I8PJ</parent_office_key>
        <head_office_key>BD000000DBH8</head_office_key>
        <legal_type>B</legal_type>
        <legal_parent_key>BD000000I8PJ</legal_parent_key>
        <group_type>Member</group_type>
        <group_parent_key>BD00000037HJ</group_parent_key>
        <institution_status>BANK</institution_status>
        <bic8>RBTTBQSA</bic8>
        <branch_bic>XXX</branch_bic>
        <bic>RBTTBQSAXXX</bic>
        <chips_uid>438386</chips_uid>
        <connected_bic>RBTTBQSAXXX</connected_bic>
        <institution_name>RBC ROYAL BANK N.V. (FORMERLY RBTT BANK N.V.)</institution_name>
        <street_address_1>WINDWARD SIDE</street_address_1>
        <city>SABA</city>
        <cps>SABA</cps>
        <country_name>BONAIRE, SINT EUSTATIUS AND SABA</country_name>
        <iso_country_code>BQ</iso_country_code>
        <timezone>S</timezone>
        <subtype_indicator>SUPE</subtype_indicator>
        <network_connectivity>CCN</network_connectivity>
        <service_codes>FINSCO</service_codes>
        <ssi_group_key>BD000000I8Q5</ssi_group_key>
    </bankdirectoryplus_v3>
</dataexport>

Destination Record - Party Entity Directory

{
  "logicalUniqueKey": "partyentity-Bank_Directory_Plus-GB-BD000000DBB1",
  "processingEntity": null,
  "activeFromDate": "2022-03-15T12:24:55.963Z",
  "source": "import",
  "status": "INACTIVE_APPROVAL_PENDING",
  "version": 1,
  "createdBy": "import",
  "payload": {
    "className": "com.iconsolutions.ipf.dynamicsettings.domain.PartyEntity",
    "entityUniqueId": "BD000000DBB2",
    "entityDataSource": "Bank_Directory_Plus",
    "entityType": "Bank",
    "entityName": "The bank",
    "entityAddress": {
      "addressType": "ADDR",
      "department": "mainn",
      "subDepartment": null,
      "streetName": "Oxford roadd",
      "buildingNumber": null,
      "buildingName": "10h",
      "floor": "3",
      "postBox": "pb002",
      "room": "26",
      "postCode": "56777",
      "townName": "Londonn",
      "townLocationName": null,
      "districtName": null,
      "countrySubDivision": null,
      "country": "RSD",
      "addressLines": [
        "line1",
        "line3"
      ]
    },
    "entityEmail": "test@example.com",
    "entityPhoneNumber": "00123456789",
    "entityIdentifiers": [
      {
        "identifier": "DECCBQBNXXX",
        "identifierType": "BIC",
        "identifierSubType": "ACCOUNT_ISSUING_BIC"
      },
      {
        "identifier": "000704351",
        "identifierType": "NCC",
        "identifierSubType": "ATBLZ"
      }
    ],
    "isHeadOffice": false
  }
}