Dataset: ICPF – Insurance Corporations & Pension Funds Statistics (discontinued)

Data Structure Definition: Sector

[ESTAT_ESAIEA agency: EUROSTAT] Download SDMX 2.1 Data Structure Definition of the ICPF 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 Adjustment indicator ADJUSTMENT CL_ADJUSTMENT
4. dimension Valuation ESA95TP_PRICE CL_ESA95TP_PRICE
5. dimension Transactions and other flows ESA95TP_TRANS CL_ESA95TP_TRANS
6. dimension Asset/instr classification ESA95TP_ASSET CL_ESA95TP_ASSET
7. dimension Reporting institutional sector ESA95TP_SECTOR CL_ESA95TP_SECTOR
8. dimension Counterpart area ESA95TP_CPAREA CL_AREA_EE
9. dimension Counterpart institution sector ESA95TP_CPSECTOR CL_ESA95TP_SECTOR
10. dimension Uses and resources ESA95TP_DC_AL CL_ESA95TP_DC_AL
11. dimension Consolidation ESA95TP_CONS CL_ESA95TP_CONS
12. dimension Denomination ESA95TP_DENOM CL_ESA95TP_DENOM
13. dimension Reference table number ESA95TP_SUFFIX CL_ESA95TP_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 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 Any textual explanation on the seasonal adjustment method applied ADJUST_DETAIL
Time Series-level attribute Source publication (public) PUBL_PUBLIC
Time Series-level attribute Source publication (EA only) PUBL_MU
Sibling-level attribute Title TITLE Short title: 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.
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 Decimals DECIMALS CL_DECIMALS Number of decimals: used on the Data Table and Quick View pages.
Sibling-level attribute Compilation COMPILATION
Sibling-level attribute Coverage COVERAGE
Sibling-level attribute Unit price base PRICE_BASE CL_PRICE_BASE
Sibling-level attribute Source publication SOURCE_PUB
Sibling-level attribute Source agency SOURCE_AGENCY CL_ORGANISATION Source Agency: displayed on the Data Table, Data Chart and Quick View pages.


Code List Description

Code Code Description
B9 Net lending/net borrowing (to be deleted)
B9F Net financial transactions (to be deleted)
BF90 Net financial assets (to be deleted)
F All financial assets and liabilities
F1 Monetary gold and special drawing rights (SDRs)
F11 Monetary gold
F12 Special drawing rights (SDRs)
F2 Currency and deposits
F21 Currency
F22 Transferable deposits
F22A Overnight deposits
F22Z Other transferable deposits, except overnight deposits
F29 Other deposits
F29A Deposits with agreed maturity
F29AA Deposits with agreed maturity, of which up to 2 years
F29AAA Deposits up to 1 year
F29AAB Deposits over 1 year and up to 2 years
F29AB Deposits over 2 years
F29ABB Deposits over 1 year
F29B Deposits redeemable at notice
F29BA Deposits redeemable at notice, of which up to 3 months
F29BB Deposits redeemable at notice, over 3 months
F29C Repurchase agreements
F2A Currency and overnight deposits
F2B Currency and monetary deposits
F2M Deposits
F2MF Non-monetary deposits
F2MM Monetary deposits
F3 Securities other than shares
F33 Securities other than shares, excluding financial derivatives
F331 Short-term - Securities other than shares, excluding financial derivatives
F332 Long-term - Securities other than shares, excluding financial derivatives
F3321 Long-term securities other than shares, excluding financial derivatives / fixed rate issues
F3322 Long-term securities other than shares, excluding financial derivatives / floating rate issues
F3323 Long-term securities other than shares, excluding financial derivatives / zero coupon bonds
F332A Long-term securities, of which from 1 to 2 years maturity
F332B Long-term securities, of which over 2 years maturity
F332F Long-term non-monetary securities other than shares, excluding financial derivatives
F332M Long-term monetary securities other than shares, excluding financial derivatives
F33F Non-monetary securities other than shares, excluding financial derivatives
F33M Monetary securities other than shares, excluding financial derivatives
F34 Financial derivatives
F4 Loans
F41 Short-term - Loans
F42 Long-term - Loans
F42A Long-term loans, with maturity over 1 year and up to 5 years
F42B Long-term loans, with maturity over 5 years
F4A Consumer credit
F4B Loans for house purchasing
F4C Loans for other purpose
F5 Shares and other equity
F51 Shares and other equity, excluding mutual funds shares
F511 Quoted shares
F512 Unquoted shares
F513 Other equity
F51A Shares
F51B Quoted shares and mutual funds shares
F51M Unquoted shares and other equity
F52 Mutual funds shares
F52F Mutual fund shares, excluding money market fund shares
F52M Money market funds shares
F5F Shares and other equity, excluding money market fund shares
F6 Insurance technical reserves
F61 Net equity of households in life insurance reserves and in pension funds reserves
F611 Net equity of households in life insurance reserves
F611A Net equity of households in life insurance reserves, of which unit linked
F611B Net equity of households in life insurance reserves, of which non-unit-linked
F612 Net equity of households in pension funds reserves
F612A Net equity of households in pension fund reserves, of which defined contribution
F612B Net equity of households in pension fund reserves, of which defined benefit
F612C Net equity of households in pension fund reserves, of which hybrid schemes
F62 Prepayments of insurance premiums and reserves for outstanding claims
F7 Other accounts receivable/payable
F71 Trade credits and advances
F71A Trade credits
F71B Advances
F79 Other accounts receivable/payable, except trade credits and advances
F791 Interest accrued and not paid on deposits
F792 Interest accrued and not paid on total loans
F7921 Interest accrued and not paid on short-term loans
F7922 Interest accrued and not paid on long-term loans
F7_34 Other accounts receivable/payable plus financial derivatives
FD Financing
FF Non-monetary financial assets
FI Financial investment
FM Monetary financial assets
FP Debt (loans, debt securities and pension fund reserves)
FQ Remaining net assets of non-financial corporations, insurance corporations and pension funds
FR Remaining net assets of households
FS Assets in remaining net flows of households
FT Other, mainly inter-company loans
GD Maastricht debt
LE Lending Exertion
N All non-financial assets
N1 Produced assets
N11 Fixed assets
N111 Tangible fixed assets
N1111 Dwellings
N1112 Other buildings and structures
N11121 Non-residential buildings
N11122 Other structures n.e.c.
N1113 Machinery and equipment
N11131 Transport equipment
N11132 Other machinery and equipment
N111321 Other machinery and equipemnt office machinery and hardware
N111322 Other machinery and equipemnt radio, tv and communiation equipment
N111329 Other machinery and equipment n.e.c.
N1114 Cultivated assets
N11141 Livestock for breeding, dairy, draught, etc.
N11142 Vineyards, orchards and other plantations of trees yielding repeat products
N111A Total construction
N111M Total construction (to be deleted)
N112 Intangible fixed assets
N1121 Mineral exploration
N1122 Computer software
N1123 Entertainment, literary or artistic originals
N1129 Other intangible fixed assets n.e.c.
N11N Cultivated assets and Intangible fixed assets
N12 Inventories
N121 Materials and supplies
N122 Work in progress
N1221 Work in progress on cultivated assets
N1222 Other work in progress
N123 Finished goods
N124 Goods for resale
N13 Valuables
N131 Precious metals and stones
N132 Antiques and other art objects
N139 Other valuables n.e.c.
N1N Inventories and valuables
N2 Non-produced assets
N21 Tangible non-produced assets
N211 Land
N2111 Land underlying buildings and structures
N2111A Land underlying dwellings
N2112 Land under cultivation
N2113 Recreational land and associated surface water
N2119 Other land and associated surface water
N212 Subsoil assets
N2121 Coal, oil and natural gas reserves
N2122 Metallic mineral reserves
N2123 Nonmetallic mineral reserves
N213 Non-cultivated biological resources
N214 Water resources
N21A Non-cultivated biological resources and Water resources
N22 Intangible non-produced assets
N221 Patented entities
N222 Leases and other transferable contracts
N223 Purchased goodwill
N229 Other intangible non-produced assets
NM111 Dwellings and land underlying buildings and structures
N_F Total Assets (financial and non-financial)
RF2B Ratio of currency and deposits to gross value added including FISIM (sector specific)
RF2D Ratio of currency and deposits to gross disposable income, adjusted (sector specific)
RF2E Ratio of currency and deposits to financial investment (sector specific)
RF331D Ratio of short-term debt securities to gross disposable income, adjusted (sector specific)
RF332D Ratio of long-term debt securities to gross disposable income, adjusted (sector specific)
RF33E Ratio of debt securities to financial investment (sector specific)
RF4A Ratio of loans to gross domestic product at market prices
RF4B Ratio of loans to gross value added including FISIM (sector specific)
RF4D Ratio of loans to gross disposable income, adjusted (sector specific)
RF4E Ratio of loans to financial investment (sector specific)
RF4F Ratio of loans to financing (sector specific)
RF4G Ratio of loans to total assets/liabilities (sector specific)
RF511E Ratio of quoted shares to financial investment (sector specific)
RF52E Ratio of mutual fund shares to financial investment (sector specific)
RF5B Ratio of shares and other equity to gross value added including FISIM (sector specific)
RF5D Ratio of shares and other equity to gross disposable income, adjusted (sector specific)
RF5E Ratio of shares and other equity to financial investment (sector specific)
RF5F Ratio of shares and other equity to financing (sector specific)
RF61F Ratio of net equity of households to financing (sector specific)
RF62F Ratio of prepayment of insurance premiums to financing (sector specific)
RF6D Ratio of insurance technical reserves to gross disposable income, adjusted (sector specific)
RF6F Ratio of insurance technical reserves to financing (sector specific)
RFDB Ratio of total financing to gross value added including FISIM (sector specific)
RFDF Ratio of financing to financing (sector specific)
RFF Ratio of net financial assets to financing (sector specific)
RFIB Ratio of financial investment to gross value added including FISIM (sector specific)
RFID Ratio of financial investment to gross disposable income, adjusted (sector specific)
RFIE Ratio of financial investment to financial investment (sector specific)
RFPA Ratio of debt to gross domestic product at market prices
RFPB Ratio of debt to gross value added including FISIM (sector specific)
RFPG Ratio of debt to total assets/liabilities (sector specific)
T All non financial assets (net)
T1 Produced assets (net)
T11 Fixed assets (net)
T111 Tangible fixed assets (net)
T1111 Dwellings (net)
T1112 Other buildings and structures (net)
T11121 Non-residential buildings (net)
T11122 Other structures n.e.c. (net)
T1113 Machinery and equipment (net)
T11131 Transport equipment (net)
T11132 Other machinery and equipment (net)
T111321 Other machinery and equipment: office machinery and hardware (net)
T111322 Other machinery and equipment: radio, tv and communiation equipment (net)
T111329 Other machinery and equipment n.e.c. (net)
T1114 Cultivated assets (net)
T11141 Livestock for breeding, dairy, draught, etc. (net)
T11142 Vineyards, orchards and other plantations of trees yielding repeat products (net)
T111M Total construction (net)
T112 Intangible fixed assets (net)
T1121 Mineral exploration (net)
T1122 Computer software (net)
T1123 Entertainment, literary or artistic originals (net)
T1129 Other intangible fixed assets n.e.c. (net)
T11N Cultivated assets and intangible fixed assets (net)
T12 Inventories (net)
T121 Materials and supplies (net)
T122 Work in progress (net)
T1221 Work in progress on cultivated assets (net)
T1222 Other work in progress (net)
T123 Finished goods (net)
T124 Goods for resale (net)
T13 Valuables (net)
T131 Precious metals and stones (net)
T132 Antiques and other art objects (net)
T139 Other valuables n.e.c. (net)
T1N Inventories and valuables (net)
T2 Non-produced assets (net)
T21 Tangible non-produced assets (net)
T211 Land (net)
T2111 Land underlying buildings and structures (net)
T2111A Land underlying dwellings (net)
T2112 Land under cultivation (net)
T2113 Recreational land and associated surface water (net)
T2119 Other land and associated surface water (net)
T212 Subsoil assets (net)
T2121 Coal, oil and natural gas reserves (net)
T2122 Metallic mineral reserves (net)
T2123 Nonmetallic mineral reserves (net)
T213 Non-cultivated biological resources (net)
T214 Water resources (net)
T21A Non-cultivated biological resources and Water resources (net)
T22 Intangible non-produced assets (net)
T221 Patented entities (net)
T222 Leases and other transferable contracts (net)
T223 Purchased goodwill (net)
T229 Other intangible non-produced assets (net)
TM111 Dwellings and land underlying buildings and structures (net)
TU Household housing wealth (net)
TY Household non-financial assets (includes total produced fixed assets and land underlying dwellings) (net)
XDB9 Discrepancy with net lending/net borrowing
Z Not applicable