Documentation for banking groups which have to report data on securities holdings directly to the ECB
Certain banking groups must provide statistics on their securities holdings in respect of so-called Securities Holdings Statistics Group (SHSG) data directly to the ECB, as provided for in the SHS Regulation. The ECB has prepared a range of material to facilitate this.
Banking groups subject to direct reporting of SHSG data – the group reporting agent will be sent a notification by the relevant national central bank – have to comply with the instructions contained in the documentation below. For other banking groups, the relevant national central bank is responsible for collecting the required data and, as such, will provide its own data reporting instructions.
Only SHSG data must be reported to the ECB, i.e. “Securities Holdings Statistics by Sector” data are not covered by the direct reporting. Data are processed via the ESCB Securities Holdings Statistics Database, which is jointly operated by the ECB and the Deutsche Bundesbank on behalf of the Eurosystem.
Please send an email if you have any questions to both of the following addresses:
This document explains the methodology behind the reporting requirements and provides guidance on the approach that may be followed in cases where the relevant ECB legal act leaves scope for interpretation. It also aims to clarify the requirements and definitions laid down in the SHS Regulation. Note that the Guidance notes are also applicable to banking groups for which the relevant national central bank is responsible for collecting the required data.
Guidance notes to reporting agents on SHS regulation last update: 15 May 2017
Excel views of the reporting templates
The reporting templates specify and describe the attributes of the input fields for the SHSG data collection. All attributes flagged as mandatory have to be filled in the files to be submitted (except where stated otherwise in the respective templates). Some attributes are coded, i.e. only values from the corresponding code list (to be found in the code list repository) can be reported, while other attributes only have to comply with certain formats, e.g. the format for securities with an international securities identification number (ISIN).
SHSG_Stage_4_Reporting_Templates-Direct_reporting.xlsx last update: 22 November 2017
Code list repository
The specific code lists for the SHSG data collection are defined in the code list repository.
SHSG_Stage_4_Codelists_Repository-Direct_reporting.xlsx last update: 22 November 2017
Reporting format documentation
This documentation provides guidance and more detailed information on the requirements for the direct reporting on securities holdings, including any additional requirements which may not be included in the guidance notes on the SHS Regulation. The material complements the reporting templates and the code list repository.
SHSG_Stage_4_Reporting_format_documentation-Direct_reporting.docx last update: 22 November 2017
SDMX 2.1 Data Structure Definitions in XML (including example files)
The Data Structure Definitions (DSDs) specify the characteristics of the expected XML reporting files. They outline, in particular, which fields involve mandatory or optional attributes. They also specify the level at which the specific attributes are to be assigned in the XML reporting files and restrict the expected values to certain codes or patterns.
The XML Schema files (XSDs) are derived from the DSDs.
SHSDB_Stage_4_Reporting_Schemes.zip last update: 20 November 2017
CSV reporting files
Examples of CSV reporting files have been created for all four input feeds.
SHSG_Stage_4_Example_ENTITY-Direct_reporting.csv last update: 22 November 2017
SHSG_Stage_4_Example_GROUP-Direct_reporting.csv last update: 22 November 2017
SHSG_Stage_4_Example_ISIN-Direct_reporting.csv last update: 22 November 2017
SHSG_Stage_4_Example_NonISIN-Direct_reporting.csv last update: 22 November 2017
Data validation checks
There are currently four main types of data validation check:
- Technical checks are performed at the data reception stage and are necessary to ensure that input files are successfully uploaded into the ESCB Securities Holdings Statistics Database.
- Formal checks are required to ensure the successful processing of input files.
- Plausibility checks lead to validation warnings which need to be addressed in order to ensure that uploaded data are plausible.
- FINREP/COREP checks cover benchmark comparisons at banking group level for data obtained from supervisory reporting and the information on securities holdings issued by reporting banks.
SHSG_Stage_4_Data_validation_rules-(excl.FINREP_and_COREP)-Direct_reporting.xlsx last update: 20 November 2017
SHSG_Stage_4_Data_validation_rules-FINREP_(IFRS)_and_COREP_Framework_2.7-Direct_reporting.xlsx last update: 20 November 2017
In the event of future updates, changes in the material on direct reporting will be clearly indicated.