search

GLEIF-IT / lei-rdf

RDF LEI Project
MIT License
7 stars 4 forks source link

BIC Code Mappings #148

Closed bryonjacob closed 1 year ago

rivettp commented 5 years ago

I have completed the code for this. However I noticed that the same BIC code is used for multiple banks e.g. lines 2 and 3 of the CSV file have the following for 2 different banks unrelated to each other as far as I can see: AAALSARIXXX 21380017F62N8MDBAH89 (ALAWWAL BANK) AAALSARIXXX 558600TQS0WENZUC5190 (Saudi British Bank) Despite the fact that the SWIFTcodes (non-official) site says: "Swift Code is a standard format of Bank Identifier Codes (BIC) and it is unique identification code for a particular bank."

In fact it appears there is a bug in the mapping file since from this page https://www.theswiftcodes.com/saudi-arabia/page/2/ the BIC code for Saudi British Bank is SABBSARI.

I looked up the latter in the CSV file and that had the same 2 LEIs: "SABBSARIXXX","21380017F62N8MDBAH89" "SABBSARIXXX","558600TQS0WENZUC5190"

Jeff, is this a known issue? Is this somethign we should provide a detailed report on?

rivettp commented 5 years ago

FWIW from a quick search it appears there are 316 cases where a BIC has multiple LEIs. If they are all similar to the above example that might mean 158 duplications. Actually there are 28 or so cases such as BIC VOFWAT21XXX where there are 3 associated LEIs and BCABIT21XXX, BEPOIT21XXX, BFDVIT31XXX, BLOPIT22XXX, BLOPIT31XXX, BPAMIT31XXX, BPCCITM1XXX, BPGGITG1XXX, BREUITM1XXX, BVCAIT21XXX, CARMIT31XXX, MELGIT21XXX have 4

rivettp commented 5 years ago

Conversely the LEI 8156003405A2893A4488 (BANCA POPOLARE DELL'ETRURIA E DEL LAZIO) has 12 different BIC codes mapped to it. And none of them are correct - it should be ARBAIT33-XXX see https://transferwise.com/us/swift-codes/ARBAIT33777 - ARBAIT is not in the CSV file at all.

rivettp commented 2 years ago

Most of the examples quoted earlier no longer seem to be present. However BCITITMMXXX seems to be mapped to 5 different LEIs.

rivettp commented 1 year ago

Already complete and uploaded