Dataset: DCM – Dealogic DCM analytics data

Data Structure Definition: Dealogic

[ECB_DCM1 agency: ECB] Download SDMX 2.1 Data Structure Definition of the DCM Dataflow

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 Reference area REF_AREA CL_AREA_EE Country codes: used in Georgraphic Area filters on Data Selection pages.
3. dimension Securities issuing sector SEC_ISSUING_SECTOR CL_ESA95_SECTOR
4. dimension Securities item SEC_ITEM CL_ESA95_ACCOUNT
5. dimension Debt type DEBT_TYPE CL_DEBT_TYPE_DCM
6. dimension Maturity type MATURITY_TYPE CL_MATURITY_TYPE
7. dimension Maturity category MATURITY_CAT CL_MATURITY_CAT
8. dimension Securities valuation SEC_VALUATION CL_MUFA_VALUATION
9. dimension Securities data type DATA_TYPE_SEC CL_DATA_TYPE_SEC
10. dimension Currency of transaction CURRENCY_TRANS CL_CURRENCY
11. dimension Series denominat/spec calcul SERIES_DENOM CL_SERIES_DENOM
12. dimension Series suffix - SEC context SEC_SUFFIX CL_SEC_SUFFIX
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 Observation confidentiality OBS_CONF CL_OBS_CONF Observation confidentiality: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Observation-level attribute Pre-break observation value OBS_PRE_BREAK Observation pre-break value: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Observation-level attribute Observation comment OBS_COM Observation comment: displayed on the Data Table and Quickview pages, downloadable in SDMX format.
Time Series-level attribute Breaks BREAKS
Time Series-level attribute Collection indicator COLLECTION CL_COLLECTION Collection attribute: used on the Data Table, Data Chart and Quick View pages, displayed on the Metadata page.
Time Series-level attribute Compiling organisation COMPILING_ORG CL_ORGANISATION
Time Series-level attribute Data dissemination organisation DISS_ORG CL_ORGANISATION
Time Series-level attribute Domestic series ids DOM_SER_IDS
Time Series-level attribute Source publication (ECB only) PUBL_ECB
Time Series-level attribute Source publication (Euro area only) PUBL_MU
Time Series-level attribute Source publication (public) PUBL_PUBLIC
Time Series-level attribute Unit index base UNIT_INDEX_BASE Unit index base: displayed on the Data Table, Metadata and Quick View pages, downloadable in CSV and SDMX format.
Sibling-level attribute Compilation COMPILATION
Sibling-level attribute Coverage COVERAGE
Sibling-level attribute Decimals DECIMALS CL_DECIMALS Number of decimals: used on the Data Table and Quick View pages.
Sibling-level attribute National language title NAT_TITLE
Sibling-level attribute Source agency SOURCE_AGENCY CL_ORGANISATION Source Agency: displayed on the Data Table, Data Chart and Quick View pages.
Sibling-level attribute Title TITLE Short title: used in the Search and displayed on Data Selection, Metadata and Quick View pages.
Sibling-level attribute Title complement TITLE_COMPL Long title/description: used in the Search and displayed on Data Selection, Metadata and Quick View pages.
Sibling-level attribute Unit UNIT CL_UNIT Unit: displayed on the Data Table, Metadata and Quickview pages, downloadable in CSV and SDMX format.
Sibling-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.


Code List Description

Code Code Description
A Value including accrued interest (only for discounted bonds)
B Book value
E Effective amount paid
M ESA95 valuation
N Nominal value
O Other method of valuation
Q Quantity
Z Not specified