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
AN1100 Fixed assets
B11000 External balance of goods and services
B11100 External balance of goods
B11200 External balance of services
B12000 Current external balance
B1G000 Gross value added at basic prices
B1GXFI Gross value added at basic prices minus FISIM
B1N000 Net value added at basic prices
B1QCAP Gross domestic product per capita at market prices in euro PPP
B1QG00 Gross domestic product at market prices
B1QN00 Net domestic product at market prices
B1QPPS Gross domestic product PPP exchange rate, referenced to the euro area
B2G000 Gross operating surplus
B2N000 Net operating surplus
B2_3G0 Gross operating surplus and mixed income
B2_3N0 Net operating surplus and mixed income
B3G000 Gross mixed income
B3N000 Net mixed income
B5G000 Gross balance of primary income
B5N000 Net balance of primary income
B5QG00 Gross national income
B5QN00 Net national income
B6G000 Gross disposable income
B6N000 Net disposable income
B8G000 Gross saving
B8N000 Net saving
B90000 Net lending/net borrowing
B9F000 Net lending/net borrowing from financial accounts
BF9000 Net financial assets
COMEMP Compensation per employee
COMPHW Hourly compensation
CS000G Gross capital stock
CS000N Net capital stock
D10000 Compensation of employees
D10U40 Real primary incomes
D10_40 Primary incomes
D11000 Wages and salaries
D12000 Employers social contributions
D12100 Employers actual social contributions
D12200 Employers imputed social contributions
D20000 Taxes on production and imports
D20X30 Taxes on production and imports minus subsidies
D21000 Taxes on products
D21100 Value added type taxes (VAT)
D21200 Taxes and duties on imports excluding VAT
D21210 Import duties
D21220 Taxes on imports, excluding VAT and import duties
D2122A Levies on imported agricultural products
D2122B Monetary compensatory amounts on imports
D2122C Excise duties
D2122D General sales taxes
D2122E Taxes on specific services
D2122F Profits of import monopolies
D21400 Taxes on products, except VAT and import taxes
D2140A Excise duties and consumption taxes
D2140B Stamp taxes
D2140C Taxes on financial and capital transactions
D2140D Car registration taxes
D2140E Taxes on entertainment
D2140F Taxes on lotteries, gambling and betting
D2140G Taxes on insurance premiums
D2140H Other taxes on specific services
D2140I General sales or turnover taxes
D2140J Profits of fiscal monopolies
D2140K Export duties and monetary comp. amounts on exports
D21410 Trade and transport margins
D21500 Other taxes on products n. e. c.
D21X31 Taxes on products minus subsidies on products
D29000 Other taxes on production
D2900A Taxes on land, buildings or other structures
D2900B Taxes on the use of fixed assets
D2900C Total wage bill and payroll taxes
D2900D Taxes on international transactions
D2900E Business and professional licences
D2900F Taxes on pollution
D2900G Under-compensation of VAT (flat rate system)
D2900H Other taxes on production n. e. c.
D29X39 Other taxes on production minus other subsidies on production
D30000 Subsidies
D31000 Subsidies on products
D39000 Other subsidies on production
D40000 Property income
D41000 Interest
D42000 Distributed income of corporations
D42100 Dividends
D42200 Withdrawals from income of quasi-corporations
D42_45 Other property income (D42 and D43 and D44 and D45)
D43000 Reinvested earnings on direct foreign investment
D44000 Property income attributed to insurance policy holders
D45000 Rents
D50000 Current taxes on income, wealth, etc.
D50_70 Current transfers (D5 and D6 and D7)
D51000 Taxes on income
D5100A Taxes on individual or household income
D5100B Taxes on the income or profits of corporations
D5100C Taxes on holding gains
D5100D Taxes on winnings from lotteries or gambling
D5100E Other taxes on income n. e. c.
D59000 Other current taxes
D5900A Current taxes on capital
D5900B Poll taxes
D5900C Expenditure taxes
D5900D Payments by households for licences
D5900E Taxes on international transactions (current taxes)
D5900F Other current taxes n. e. c.
D60000 Social contributions and social benefits
D61000 Social contributions
D61100 Actual social contributions
D61110 Employers actual social contributions (secondary income account)
D61111 Compulsory employers actual social contributions
D61112 Voluntary employers actual social contributions
D61120 Employees social contributions
D61121 Compulsory employees social contributions
D61122 Voluntary employees social contributions
D61130 Social contributions by self- and non-employed persons
D61131 Compulsory social contributions by self- and non-employed persons
D61132 Voluntary social contributions by self- and non-employed persons
D61200 Imputed social contributions
D61_62 Social contributions and social benefits other than social transfers in kind
D62000 Social benefits other than social transfers in kind
D70000 Other current transfers
D71000 Net non-life insurance premiums
D72000 Non-life insurance claims
D73000 Current transfers within general government
D74000 Current international co-operation
D75000 Miscellaneous current transfers
D75100 GNP based fourth own resource
D80000 Adjustment for the change in net equity of households in pension funds
D90000 Capital transfers
D91000 Capital taxes
D9100A Taxes on capital transfers
D9100B Capital levies
D9100C Other capital taxes n.e.c.
D92000 Investment grants
D92U99 Other capital transfers (Investment grants and others)
D99000 Other capital transfers
DISEXP Discrepancy for expenditure approach
DISINC Discrepancy for income approach
DISOUT Discrepancy for output approach
DTOTTX Total tax receipts
DTTXSC Total receipts from taxes and social contributions
ECACPO Economically active population
EMPLOY Employees
F33000 Securities other than shares, excluding financial derivatives
F33100 Short-term securities other than shares
F33200 Long-term securities other than shares
F33201 Long-term / Fixed rate issues
F33202 Long-term / Floating rate issues
F33203 Long-term / Zero coupon bonds
F4REPO Repos
F51000 Shares and other equity, excluding mutual funds shares
F51100 Listed shares
F51200 Unlisted shares
F51300 Other equity
FT0001 Debt and equities
K10000 Consumption of fixed capital
K11000 Nominal holding gains/losses
K11700 Unrealised holding gains/losses
K11710 Unrealised holding gains/losses, change in exchange rate
K11720 Unrealised holding gains/losses, change in market valuation
K11900 Realised holding gains/losses
K11910 Realised holding gains/losses, change in exchange rate
K11920 Realised holding gains/losses, change in market valuation
K20000 Acquisitions less disposals of non-financial non-produced assets
LABPHW Hourly labour productivity
LABPRO Person based labour productivity
P10000 Output
P11000 Market output
P11900 FISIM
P11_12 Market output plus output for own final use
P12000 Output for own final use
P13000 Other non-market output
P20000 Intermediate consumption
P30000 Final consumption expenditure
P30_50 Domestic demand
P30_51 Domestic demand excluding changes in inventories and acquisitions less disposals of valuables
P30_60 Total demand
P31000 Individual consumption expenditure
P31100 Private consumption of households, durable goods
P31200 Private consumption of households, semi-durable goods
P31300 Private consumption of households, non-durable goods
P31400 Private consumption of households, services
P31N00 Private consumption of households, semi-durable and non-durable goods and services
P32000 Collective consumption expenditure
P33000 Final consumption of resident households in the rest of the world
P34000 Final consumption of non-resident households on the economic territory
P40000 Actual final consumption
P41000 Actual individual consumption
P50000 Gross capital formation
P51000 Gross fixed capital formation
P52000 Changes in inventories
P52_53 Changes in inventories plus acquisitions less disposals of valuables
P53000 Acquisitions less disposals of valuables
P60000 Exports of goods and services
P61000 Exports of goods
P62000 Exports of services
P70000 Imports of goods and services
P71000 Imports of goods
P72000 Imports of services
POPULA Total population
REAGDI Real gross domestic income
SELFEM Self-employed
T10000 Total resources/uses of production account/external account
T21100 Total resources/uses of generation of income account
T21200 Total resources/uses of allocation of primary income account
T22000 Total resources/uses of secondary distribution of income account
T24100 Total resources/uses of use of disposable income account
T31100 Total change due to saving and capital transfers account
T31200 Total change due to acquisition of non-financial assets account
TOTEMP Total employment
TOTEXP Total expenditure of government sectors
TRADGL Trading gain or loss
UND2X3 Unit taxes
UNEMPL Unemployed
UNLACO Unit labour costs
UNLAHW Hourly unit labour cost
UNPRFT Unit profits
WAGEMP Wages and salaries per employee
WEA00G Gross household housing wealth at current replacement costs
WEA00N Net household housing wealth at current replacement costs