Dataset: SHS – Securities Holding Statistics

Data Structure Definition: Securities Holding Statistics

[ECB_SHS6 agency: ECB] Download SDMX 2.1 Schema of the ECB_SHS6 DSD

Click on the name of the codelist to see the full list of available codes.

Cube dimensions and attributes
  Concept description Concept Codelist Usage on SDW portal
1. dimension Frequency FREQ CL_FREQ Frequency dimension: used in Dimension Filters on Data Selection, Data Table and Quick View pages.
2. dimension Holder country HOLDER_AREA CL_AREA Country codes: used in Georgraphic Area filters on Data Selection pages.
3. dimension Issuer domicile country ISSUER_AREA CL_AREA
4. dimension Holder sector HOLDER_SECTOR CL_SECTOR
5. dimension Issuer ESA 2010 sector ISSUER_SECTOR CL_SECTOR
6. dimension Functional category FUNCTIONAL_CAT CL_FUNCTIONAL_CAT
7. dimension Stocks, Transactions, Other Flows STO CL_NA_STO
8. dimension Instrument and assets classification INSTR_ASSET CL_INSTR_ASSET
9. dimension Maturity MATURITY CL_MATURITY
10. dimension Unit of measure UNIT_MEASURE CL_UNIT Unit: displayed on the Data Table, Metadata and Quickview pages, downloadable in CSV and SDMX format.
11. dimension Valuation VALUATION CL_VALUATION
12. dimension Security type SECURITY_TYPE CL_SECURITY_TYPE
13. dimension Macro-adjustment flag MA_FLAG CL_YES_NO
14. dimension Is in EADB IS_IN_EADB CL_YES_NO
15. dimension Asset securitisation type SECURITISATION_TYP CL_SECURITISATION
16. dimension Debt type DEBT_TYPE CL_DEBT_TYPE
17. dimension Third party holdings flag TPH CL_TPH
18. dimension Nominal currency of the security NOM_CURR CL_CURRENCY
19. dimension Compiling organisation COMPILING_ORG CL_ORGANISATION
Observation-level attribute Observation value OBS_VALUE
Observation-level attribute Observation status OBS_STATUS CL_OBS_STATUS Observation status: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Observation-level attribute Confidentiality status CONF_STATUS CL_CONF_STATUS Observation confidentiality: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Observation-level attribute Pre-break value PRE_BREAK_VALUE Observation pre-break value: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Observation-level attribute Comments to the observation value COMMENT_OBS Observation comment: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Observation-level attribute ESCB flag ESCB_FLAG CL_YES_NO
Observation-level attribute EAPlus flag EAPLUS_FLAG CL_YES_NO
Time Series-level attribute Title complement, detailed description of the series COMMENT_TS Long title/description: used in the Search and displayed on Data Selection, Metadata and Quick View pages.
Time Series-level attribute Title TITLE Short title: used in the Search and displayed on Data Selection, Metadata and Quick View pages.
Time Series-level attribute Unit multiplier UNIT_MULT CL_UNIT_MULT Unit Multiplier: displayed on the Data Table, Metadata and Quick View pages, downloadable in CSV and SDMX format.
Time Series-level attribute Decimals DECIMALS CL_DECIMALS Number of decimals: used on the Data Table and Quick View pages.
Time Series-level attribute Time period collection TIME_PER_COLLECT CL_TIME_COLLECT Collection attribute: used on the Data Table, Data Chart and Quick View pages, displayed on the Metadata page.
Time Series-level attribute Reference period detail REF_PERIOD_DETAIL CL_REF_PERIOD_DTL
Time Series-level attribute Underlying compilation DATA_COMP
Time Series-level attribute Title complement TITLE_COMPL
Time Series-level attribute Data dissemination organisation DISS_ORG CL_ORGANISATION