1. MFI database structureThe following table describes the structure of the MFI data, to enable the data to be exported to local databases. The corresponding look-up tables are reported in the last column.
|Field name||Type||Max. length||Codes||Description|
|COUNTRY OF REGISTRATION||Text||2||country codes||The country of residence of the MFI|
|RIAD CODE||Text||30||The ID code is a unique identifier for each MFI|
|BANK IDENTIFIER CODE||Text||15||The BIC or SWIFT code|
|NAME||Text||255||The full registration name of the MFI|
|ADDRESS||Text||150||The name of the street and the number of the building|
|BOX||Text||10||The post office box number|
|POSTAL CODE||Text||15||The postcode of the institution|
|CITY||Text||50||The town or city of location|
|CATEGORY||Text||20||The type of MFI according to predefined categories|
|HEAD COUNTRY OF REGISTRATION||Text||2||country codes||The country in which the head office is located (for foreign branches only)|
|NAME OF HEAD OFFICE||Text||200||The full registration name of the head office institution (for foreign branches only)|
|HEAD RIAD CODE||Text||30||The ID code of the head office|
|SUBJECT TO MINIMUM RESERVE REQUIREMENTS||Yes/No||Whether or not the credit institution is legally subject to minimum reserve requirements|
|EXEMPT FROM MINIMUM RESERVE REQUIREMENTS||Yes/No||Whether or not the credit institution is exempt from minimum reserve requirements|
2. How to perform user-defined queriesFor the MFI database provided on the ECB's website, there is a special form which allows users to perform individual queries under “ Search the database”. In this form you are able to insert search criteria into each field. If you enter criteria into more than one field, your entries will be handled as logical "AND" conditions. Each field type has its own features (please note that the querying feature is case-sensitive):
You can use the "Clear form" button to reset all settings in the form to the default setting. After submitting the form, a summary of the request will be displayed. It will be possible to display the result on screen or to prepare a file for automatic download.
3. How to download files
3.1. Download data set
The ECB provides several files for public download. They can be found in the section MID download.
3.2. File format
Each file will be available in compressed format (standard GZIP format), as well as in uncompressed format. The compressed files can be uncompressed using unzipping tools which are available for most operating systems on the internet. Software to decompress these files under several operating systems can be found here . To download an uncompressed file (.csv or .xml extension), please use the right mouse button and select "Save link as...", or the corresponding menu item from the pop-up menu of your browser.
3.3. Data format
With MID, two download file formats are provided. The download files can either be in a CSV format or in a XML format to be directly used by other software, automatic processes or by the user in any kind of spreadsheet software. The used character set in MID for CSV files is UTF-16LE and for XML files it is UTF-16, i.e. the same encoding is used as with the current list of Eligible Assets.
4. Receive datasets via RSS
To be notified about new information and receive new data published by ECB RSS is the recommended channel. After subscribing to RSS service, all information published via MID are collected in one feed, accessible via URL http://mid.ecb.europa.eu/rss/mid.xml.
In every case when updated data are available a new entry will be shown in the RSS containing the links to retrieve the updated data.
The relevant part in the RSS feed is the release Title ‘List of monetary financial institutions (MFIs)’ and ‘List of monetary financial institutions including minimum reserve requirement features (monthly data)’.
All website pages are delivered through secure http. Files in the download area are also transmitted through secure http. For more information about the secure http protocol please refer to your browser documentation.
The MID messages for MFIs (daily data) and institutions subject to minimum reserve requirements contain a digital signature which is used to validate the authenticity of the sender (ECB) and to ensure that the message has not been altered after its creation. Further details regarding the usage of a digital signature and how to verify it are explained in detail in the MID Catalogue of services and integration guide.