Dataset: DD – Derived Data

Data Structure Definition: Derived Data

[ECB_DD1 agency: ECB] Download SDMX 2.1 Data Structure Definition of the DD 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 Derived data economic concept DD_ECON_CONCEPT CL_DD_ECON_CONCEPT
4. dimension Derived data transformation DD_TRANSF CL_DD_TRANSF
5. dimension Derived data suffix DD_SUFFIX CL_DD_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 BoP data collection basis BOP_BASIS CL_BOP_BASIS
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 Aggregation equations AGG_EQUN
Sibling-level attribute Compilation COMPILATION
Sibling-level attribute Decimals DECIMALS CL_DECIMALS Number of decimals: used on the Data Table and Quick View pages.
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
AUD_EUR Exchange rate AUD against EUR
BPM_DIAB BOP - monetary presentation - direct investment by resident units abroad (non-MFIs)
BPM_DIEA BOP - monetary presentation - direct investment by non-resident units in the Euro area
BPM_DIME BOP - monetary presentation - direct investment by non-resident units in the Euro area, non-MFIs
BPM_OIAS BOP - monetary presentation - other investment assets, non-MFIs
BPM_OILI BOP - monetary presentation - other investment liabilities, non-MFIs
BPM_PIAD BOP - monetary presentation - portfolio investment assets, debt instruments, non-MFIs
BPM_PIAS BOP - monetary presentation - portfolio investment assets, non-MFIs
BPM_PILA BOP - monetary presentation - portfolio investment liabilities, non-MFIs, Total
BPM_PILD BOP - monetary presentation - portfolio investment liabilities, debt instruments
BPM_PILE BOP - monetary presentation - portfolio investment liabilities, equity
BPM_PILI BOP - monetary presentation - portfolio investment liabilities, debt instruments, non-MFIs
BPM_PILT BOP - monetary presentation - portfolio investment liabilities, Total
BPM_TOE BOP - monetary presentation - total
BPM_TOT BOP - monetary presentation - total
BP_BOND Financial account, Portfolio investment, Liabilities, Debt securities, Bonds and notes - Outstanding amounts at the end of the period (stocks)
BP_CU Current account balance
BP_CUCA Current and new capital account balance
BP_DIPI Combined direct and portfolio investment, net transactions
BP_EXP BOP - goods and services, export
BP_EXPG BOP - net export of goods
BP_EXPS BOP - net export of services
BP_EXTD Gross external debt
BP_GG Financial account, General government, Gross external debt excluding direct investment - Outstanding amounts at the end of the period (stocks)
BP_GS BOP - goods and services balance
BP_IIP_5N International investment position, Net, Price valuation adjustment
BP_IIP_6N International investment position, Net, Exchange rate valuation adjustment
BP_IIP_7N International investment position, Net, Other adjustments
BP_IIP_9N International investment position, Net, Other changes
BP_IIP_AS International investment position, asset
BP_IIP_D_5A International investment position, Asset, Price valuation adjustment
BP_IIP_D_5L International investment position, Liabilities, Price valuation adjustment
BP_IIP_D_6A International investment position, Asset, Exchange rate valuation adjustment
BP_IIP_D_6L International investment position, Liabilities, Exchange rate valuation adjustment
BP_IIP_D_7A International investment position, Asset, Other adjustments
BP_IIP_D_7L International investment position, Liabilities, Other adjustments
BP_IIP_D_9A International investment position, Asset, Other changes
BP_IIP_D_9L International investment position, Liabilities, Other changes
BP_IIP_D_AS International investment position, Assets (including Net Financial Derivatives)
BP_IIP_D_LI International investment position, Liabilities, (excluding Financial Derivatives)
BP_IIP_D_TA International investment position, Asset, Net transactions (international investment position sign convention)
BP_IIP_D_TL International investment position, Liabilities, Net transactions (international investment position sign convention)
BP_IIP_LI International investment position, liabilities
BP_IIP_NT International investment position, net
BP_IIP_TN International investment position, Net, Net transactions (international investment position sign convention)
BP_IMP BOP - goods and services, import
BP_INTLEND Financial account, Direct investment abroad, Other capital, Liabilities, inter-company lending - Outstanding amounts at the end of the period (stocks)
BP_LOAN Financial account, Other investment, Liabilities, Loans/currency and deposits - Outstanding amounts at the end of the period (stocks)
BP_MFI Financial account, MFIs, Gross external debt excluding direct investment - Outstanding amounts at the end of the period (stocks)
BP_MMI Financial account, Portfolio investment, Liabilities, Debt securities, Money market instruments - Outstanding amounts at the end of the period (stocks)
BP_MONAUTH Financial account, Monetary authorities, Gross external debt excluding direct investment - Outstanding amounts at the end of the period (stocks)
BP_OTHLIAB Financial account, Other investment, Liabilities, Other liabilities - Outstanding amounts at the end of the period (stocks)
BP_OTHSEC Financial account, Other sectors, Gross external debt excluding direct investment - Outstanding amounts at the end of the period (stocks)
BP_TRADE Financial account, Other investment, Liabilities, Trade credits - Outstanding amounts at the end of the period (stocks)
BSI_OMFIAGDP Share of other MFIs assets in GDP
BSI_STF Share of central bank funding in credit institutions liabilities (total liabilities exclude capital and reserves as well as remaining liabilities; credit institutions are MFIs excluding the ESCB and money markets funds, and ESCB funding comprises loans to the other MFIs and excludes holdings of securities other than shares issued by other MFIs)
CAD_EUR Exchange rate CAD against EUR
CDPS Credit to domestic private sector
CHF_EUR Exchange rate CHF against EUR
COMPE Compensation per employee, whole economy
CPI Consumer prices, all items
CRED1 Credit institutions (MFIs excluding the ESCB and MMFs), outstanding amounts at the end of the period (stocks)
CREDA Growth rate of total assets of credit institutions (MFIs excluding the ESCB and MMFs)
CREDI Index of notional stocks of total assets of credit institutions (MFIs excluding the ESCB and MMFs)
CT1DGGV Share of other MFIs credit to domestic general government in total assets, excluding remaining assets
CYP_EUR Exchange rate CYP against EUR
CZK_EUR Exchange rate CZK against EUR
DDDD Domestic demand deflator
DKK_EUR Exchange rate DKK against EUR
EEK_EUR Exchange rate EEK against EUR
EFF_CPI Real effective exchange rate deflated by CPI
EXPD Export deflator
EXPMS Export market share
FXL1TL Share of other MFI FX loans in total loans (excluding inter-MFI loans)
GBP_EUR Exchange rate GBP against EUR
GCSD Government consumption deflator
GDPD Gross domestic product deflator
GDPR Real GDP
GFCFD Gross fixed capital formation deflator
GRNLHHNFC Annual growth rate of MFIs new loans to households and non-financial corporations
HICP Harmonised CPI (overall index)
HKD_EUR Exchange rate HKD against EUR
HUF_EUR Exchange rate HUF against EUR
IBL1TL Share of interbank loans in total loans
ICPFA Growth rate of total assets of insurance corporations and pension funds
ICPFI Index of notional stocks of total assets of insurance corporations and pension funds
IEA_FSL Financial sector liabilities
IEA_FSLC Transactions in financial instruments - Financial sector liabilities - Consolidated, Current prices
IEA_PSCF Private sector credit flow
IEA_PSCFC Transactions in financial instruments - Private sector credit flow - Consolidated, Current prices
IEA_PSCFP Transactions in financial instruments - Private sector credit flow - Partially consolidated, Current prices
IEA_PSD Private sector debt
IEA_PSDC Transactions in financial instruments - Private sector debt - Consolidated, Current prices
IEA_PSDP Transactions in financial instruments - Private sector debt - Partially consolidated - Current prices
IFOFI1 Total assets of MMF and non-MMF investment funds and other financial institutions (OFIs), outstanding amounts at the end of the period (stocks)
IFOFI4 Total assets of MMF and non-MMF investment funds and other financial institutions (OFIs), financial transactions (flows)
IFOFIA Growth rate of total assets of MMF and non-MMF investment funds and other financial institutions (OFIs)
IFOFII Index of notional stocks of total assets of MMF and non-MMF investment funds and other financial institutions (OFIs)
IMPD Import deflator
IP_TIND_P Industrial production, total industry excluding construction, production
IR_L 10-year (or equivalent) government bond yield (capital market interest rate)
IR_ODEPO Deposit rate (official rate)
IR_OMARG Marginal lending rate (official rate)
IR_OOVRN Overnight deposits (money market rate)
IR_OREPO Main refinancing rate (official rate)
IR_S 3-month deposits (money market rate)
JPY_EUR Exchange rate JPY against EUR
KRK_EUR Exchange rate HRK against EUR
LA1STL Share of liquid assets in short term liabilities
LABPRO Labour productivity
LC1DHHS Share of other MFIs loans to domestic households for house purchase in total credit to other domestic residents
LD3ERES Share of other MFIs loans in deposits vis-a-vis euro area non-financial corporations and households, and non-euro area non-banks, excluding general government
LD3PRES Share of other MFIs loans in deposits vis-a-vis euro area and domestic non-financial corporations and households, and non-euro non-domestic non-banks, excluding general government
LEV140 Investment funds - leverage, real estate
LEV150 Investment funds - leverage, hedge funds
LEV160 Investment funds - leverage, other funds
LEVR Leverage ratio
LIQ500 Investment funds - liquidity transformation, total funds
LIQ52A Investment funds - liquidity transformation, bond funds
LL1DHHS Share of other MFIs loans to domestic households in loans to other domestic residents
LL1DICP Share of other MFIs loans to domestic insurance corporations and pension funds in loans to other domestic residents
LL1DNFC Share of other MFIs loans to domestic non-financial corporations in loans to other domestic residents
LL1DOFI Share of other MFIs loans to domestic other financial intermediaries in loans to other domestic residents
LMGBLNFCH Lending margin on new business loans to non-financial corporations and households
LMGLHH MFIs lending margins on loans for house purchase
LMGLNFC MFIs lending margins on loans to non-financial corporations (NFC)
LMGOLNFCH Lending margin on outstanding loans to non-financial corporations and households
LTD Loans to deposits ratio
LTL_EUR Exchange rate LTL against EUR
LVL_EUR Exchange rate LVL against EUR
M2 M2 (Broad money)
M3_NOM_GAP Nominal money gap
M3_REAL_GAP Real money gap
MMTCH Maturity mismatch
MTL_EUR Exchange rate MTL against EUR
NDEPFUN Non-deposit funding
NOK_EUR Exchange rate NOK against EUR
OTHOFI1 Total assets of other financial institutions (OFIs) excluding financial vehicle corporations (FVCs), outstanding amounts at the end of the period (stocks)
OTHOFI4 Total assets of other financial institutions (OFIs) excluding financial vehicle corporations (FVCs), financial transactions (flows)
PCSD Private consumption deflator
PLN_EUR Exchange rate PLN against EUR
POILBRENT Oil price, brent crude -1 month forward
POP Population
POPE Population (Eurostat estimates)
SEK_EUR Exchange rate SEK against EUR
SGD_EUR Exchange rate SGD against EUR
SIT_EUR Exchange rate SIT against EUR
SKK_EUR Exchange rate SKK against EUR
SS_APK_Y Securities settlement, Euroclear Finland Ltd, value of delivery instructions processed (total)
SS_BOG_Y Securities settlement, BOGS (Bank of Greece), value of delivery instructions processed (total)
SS_BSE_Y Securities settlement, BSED, value of delivery instructions processed (total)
SS_BSS_Y Securities settlement, BSSE (Slovakia), value of delivery instructions processed (total)
SS_CBF_Y Securities settlement, Clearstream Banking Frankfurt (Germany), value of delivery instructions processed (total)
SS_CBL_Y Securities settlement, Clearstream Banking Luxembourg, value of delivery instructions processed (total)
SS_CDA_Y Securities settlement, Central Depository AD (CDAD), value of delivery instructions processed (total)
SS_CDP_Y Securities settlement, CDCP SR (Slovakia), value of delivery instructions processed (total)
SS_CDR_Y Securities settlement, CDCR (Cyprus), value of delivery instructions processed (total)
SS_CIK_Y Securities settlement, Euroclear Belgium, value of delivery instructions processed (total)
SS_CRS_Y Securities settlement, CRESTCo (United Kingdom), value of delivery instructions processed (total)
SS_CSG_Y Securities settlement, Hellenic Exchanges (HELEX) (Greece), value of delivery instructions processed (total)
SS_CSL_Y Securities settlement, Central Securities Depository of Lithuania, plc., value of delivery instructions processed (total)
SS_ECS_Y Securities settlement, ECSD (Estonia), value of delivery instructions processed (total)
SS_EOC_Y Securities settlement, Euroclear Bank (Belgium), value of delivery instructions processed (total)
SS_EOF_Y Securities settlement, Euroclear France, value of delivery instructions processed (total)
SS_EON_Y Securities settlement, Euroclear Netherlands, value of delivery instructions processed (total)
SS_GSD_Y Securities settlement, Government Securities Depository (GSD), value of delivery instructions processed (total)
SS_IBC_Y Securities settlement, Iberclear (Spain), value of delivery instructions processed (total)
SS_INB_Y Securities settlement, Interbolsa (Portugal), value of delivery instructions processed (total)
SS_KDD_Y Securities settlement, KDD (Slovenia), value of delivery instructions processed (total)
SS_KDP_Y Securities settlement, kdpw_stream (Poland), value of delivery instructions processed (total)
SS_KEL_Y Securities settlement, Keler (Hungary), value of delivery instructions processed (total)
SS_LCD_Y Securities settlement, LCD-DENOS (Latvia), value of delivery instructions processed (total)
SS_LUX_Y Securities settlement, LUX (Luxembourg), value of delivery instructions processed (total)
SS_MSE_Y Securities settlement, MSE (Malta), value of delivery instructions processed (total)
SS_MTI_Y Securities settlement, Monte Titoli (Italy), value of delivery instructions processed (total)
SS_NBB_Y Securities settlement, National Bank of Belgium SSS, value of delivery instructions processed (total)
SS_NBR_Y Securities settlement, NBRD, value of delivery instructions processed (total)
SS_NBS_Y Securities settlement, NBS-CR (Slovakia), value of delivery instructions processed (total)
SS_NCE_Y Securities settlement, Nasdaq CSD SE Estonian Securities Settlement System, value of delivery instructions processed (total)
SS_NCL_Y Securities settlement, Nasdaq CSD SE Lithuanian Securities Settlement System, value of delivery instructions processed (total)
SS_NCS_Y Securities settlement, Nasdaq CSD SE Latvian Securities Settlement System, value of delivery instructions processed (total)
SS_NDP_Y Securities settlement, National Central Securities Depository (NCDCP), value of delivery instructions processed (total)
SS_NTM_Y Securities settlement, NTMA (Ireland), value of delivery instructions processed (total)
SS_OKB_Y Securities settlement, OeKB (WSB system) (Austria), value of delivery instructions processed (total)
SS_R00_Y Securities settlement, Regional securities settlement and clearing system, value of delivery instructions processed (total)
SS_RMS_Y Securities settlement, RM-SYSTEM (Czech Republic), value of delivery instructions processed (total)
SS_RPW_Y Securities settlement, RPW (Poland), value of delivery instructions processed (total)
SS_SBA_Y Securities settlement, SCL Barcelona (Spain), value of delivery instructions processed (total)
SS_SBI_Y Securities settlement, SCL Bilbao (Spain), value of delivery instructions processed (total)
SS_SCP_Y Securities settlement, SCP (Czech Republic), value of delivery instructions processed (total)
SS_SIB_Y Securities settlement, SC Depozitarul Sibex SA, value of delivery instructions processed (total)
SS_SIT_Y Securities settlement, SITEME (Banco de Portugal), value of delivery instructions processed (total)
SS_SKD_Y Securities settlement, SKD (Czech Republic), value of delivery instructions processed (total)
SS_SNC_Y Securities settlement, National Securities Clearing, Settlement and Depository Company (SNCDD), value of delivery instructions processed (total)
SS_SVA_Y Securities settlement, SCL Valencia (Spain), value of delivery instructions processed (total)
SS_UNI_Y Securities settlement, Central securities depository Prague (Czech Republic), value of delivery instructions processed (total)
SS_VNS_Y Securities settlement, VNS (Latvia), value of delivery instructions processed (total)
SS_VPA_Y Securities settlement, VP (Denmark), value of delivery instructions processed (total)
SS_VPC_Y Securities settlement, Euroclear Sweden AB, value of delivery instructions processed (total)
SS_VPL_Y Securities settlement, VP Lux (Luxembourg), value of delivery instructions processed (total)
ST1DGGV Share of insurance corporations and pension funds holdings of debt securities issued by domestic general government in total assets
ST1OGGV Share of insurance corporations and pension funds holdings of debt securities issued by other MUMs general government in total assets
ST1TMF Share of short-term funding in total market funding
SVLHHNFC Share of new loans with a floating rate or an initial rate fixation period of up to one year in total new loans from MFIs to households and non-financial corporations
SVLHPHH Share of new loans to households for house purchase with a floating rate or an initial rate fixation period of up to one year in total new loans from MFIs to households
TA_DBG Total consolidated assets of domestic banking groups
TA_DFB Total assets of all domestic banking groups and stand alone banks, foreign (EU and non-EU) controlled subsidiaries and foreign (EU and non-EU) controlled branches
TA_DLB Total assets of domestic large banking groups
TA_DMB Total assets of domestic medium banking groups
TA_DSB Total assets of domestic small banking groups
TA_FBS Total assets of foreign controlled branches and subsidiaries
TA_FEAB Total assets of foreign EA controlled branches
TA_FEAS Total assets of foreign EA controlled subsidiaries (subconsolidated or stand alone)
TA_FEB Total assets of foreign EU controlled branches
TA_FES Total assets of foreign EU controlled subsidiaries (subconsolidated or stand alone)
TA_FNB Total assets of foreign non-EU controlled branches
TA_FNS Total assets of foreign non-EU controlled subsidiaries (subconsolidated or stand alone)
TA_IFA Annual growth rate of investment funds - total assets
TA_IFG Investment funds - total assets, as % of GDP
TA_SSML Total assets of SSM Less significant banks
TA_SSMS Total assets of SSM Significant banks
ULC Unit labour costs, whole economy
USD_EUR Exchange rate USD against EUR
VAC Job vacancy rate
W_COMP Compensation weights
W_CSP_PPP Consumer spending weights at PPP exchange rates
W_CSP_X Consumer spending weights at actual exchange rates
W_GDP_PPP GDP weights at PPP exchange rates
W_GDP_X GDP weights at actual exchange rates
W_LABOUR Labour force weights
W_VA Value added weights in industry excluding construction at factor costs 2010 converted by exchange rate