sdmx - circabc.europa.eu filesdmx labour cost index page 3 - sdmx for the labour cost index guide -...
TRANSCRIPT
EUROPEAN COMMISSION EUROSTAT Directorate F: Social statistics Unit F-3: Labour market statistics
Abstract: This guide provides the technical specifications for the use of SDMX for the transmission of Labour
Cost Index (LCI) data to Eurostat according to the Council Regulation 1216/2003. It contains the list of statistical
concepts, the Data Structure Definitions (DSDs or ‘key family’), a cross-reference to code lists and some practical
guidelines.
SDMX
for
Labour Cost Index (LCI) Technical Guide
Version 2.0 – 21/12/2015
SMDX Labour Cost Index page 2
- SDMX for the Labour Cost Index Guide - Version 2.0
SDMX for the Labour Cost Index
Table of Contents
INTRODUCTION ............................................................................................................................................................... 3
RELEVANT DOCUMENTS .............................................................................................................................................. 3
INTRODUCTION TO DATASETS AND STRUCTURES ............................................................................................. 3
DATA SETS ......................................................................................................................................................................... 3
STATISTICAL CONCEPTS ............................................................................................................................................. 4
CODE LISTS ....................................................................................................................................................................... 5
DATA SET STRUCTURES ............................................................................................................................................... 6
INDICES AND WEIGHTS OF LABOUR COST INDEX ................................................................................................................... 6
EXAMPLES......................................................................................................................................................................... 8
APPENDIX 1 - CODE LISTS ............................................................................................................................................ 9
CL_FREQ ............................................................................................................................................................................. 9 CL_AREA ............................................................................................................................................................................. 9 CL_SEASONAL_ADJUST ................................................................................................................................................ 10 CL_ INDIC_BZ ................................................................................................................................................................... 10 CL _ACTIVITY .................................................................................................................................................................. 10 CL_UNIT ............................................................................................................................................................................ 11 CL_UNIT_MULT ............................................................................................................................................................... 12 CL_DECIMALS ................................................................................................................................................................. 12 CL_OBS_STATUS ............................................................................................................................................................. 12 CL_CONF_STATUS .......................................................................................................................................................... 13 CL_TIME_PER_COLLECT ............................................................................................................................................... 13 CL_ORGANISATION........................................................................................................................................................ 13 CL_TIME_FORMAT ......................................................................................................................................................... 14
APPENDIX 2 – MESSAGE IMPLEMENTATION GUIDELINES ............................................................................. 15
1. MESSAGE OVERVIEW FOR LCI_Q_INDEX ................................................................................................................. 15 2. MESSAGE OVERVIEW FOR LCI_WEIGHT_A .............................................................................................................. 16
TOOLS AVAILABLE ...................................................................................................................................................... 17
SDMX Labour Cost Index page 3
- SDMX for the Labour Cost Index Guide - Version 2.0
INTRODUCTION
This document provides the technical specifications for the use of SDMX for the Labour Cost
Index.
If clarification is required in relation to this document please contact:
For administrative matters: For SDMX matters:
Mr. Hubertus Vreeswijk SDMX Support
EUROSTAT EUROSTAT
Bâtiment Joseph Bech D3/726 Bâtiment Joseph Bech
5 Rue Alphonse Weicker, 5 Rue Alphonse Weicker
L-2721 Luxembourg L-2721 Luxembourg
Tel.: (352) 4301-34323
Fax: (352) 4301 – 33649 Functional MailBox
Email : [email protected] Email:[email protected]
@ec.europa.eu
RELEVANT DOCUMENTS
WORKING PAPERS, COUNCIL AND COMMISSION REGULATIONS
Council Regulation no 450/2003 of 27 February 2003 concerning the labour cost index
Commission Regulation no 1216/2003 of 7 July 2003 implementing Regulation (EC) No
450/2003, as amended by Commission Regulations (EC) 224/2007 and 973/2007.
SDMX, the xml standard for data transmissions
There are several guides as well as general assistance available at the SDMX wiki-page:
https://webgate.ec.europa.eu/fpfis/mwikis/sdmx/
INTRODUCTION TO DATASETS AND STRUCTURES
There are 2 available data sets for Labour Cost Index reporting and these are listed in the
section Data Sets. To report this information, one data structure definitions (DSD's) is used
called ‘LCI’.
DATA SETS
The table below lists the available data sets.
Data Set Identifier Description
LCI_INDEX_Q Labour Cost Indices-Quarterly.
LCI_WEIGHT_A Labour Cost Index - Weight.
SDMX Labour Cost Index page 4
- SDMX for the Labour Cost Index Guide - Version 2.0
STATISTICAL CONCEPTS
The following table shows the name and the description of the statistical concepts to be used in
LCI/LCW transmissions.
Concept Mnemonic
Concept Name
Description Code list
SEASONAL_ADJ
UST
Adjustment
method
Code defining the adjustment
of data such as working day or
seasonally adjusted, etc.
CL_SEASONAL_ADJUST
BASE_YEAR
Series variation
in the domain's
context
Concept to distinguish series
variations in the domain’s
context
FREQ Frequency Frequency of the series (e.g. A,
Q, M). CL_FREQ
ACTIVITY Economic
Activity code
NACE Rev. 2 special
aggregates CL_ACTIVITY
INDICATOR
Indicators for
business
statistics
Type of series, such as Total
Labour Cost, Wages and
Salaries, etc.
CL_INDIC_BZ
COMMENT_OBS Observation
comment
Comments to the observation
value
CONF_STATUS Confidentiality
status
Confidentiality status of the
observation CL_CONF_STATUS
PRE_BREAK_VA
LUE
Pre-break
observation
value
Observation value if the reason
of the "break" did not show up.
OBS_STATUS Observation
status
Status of the observation, such
as normal or provisional CL_OBS_STATUS
OBS_VALUE Observation
value
The value of the index.
REF_AREA Reference area
Reporting Country in ISO code
(The country, or
geographical/political group of
countries that the measured
economic phenomenon relates
to)
CL_AREA
TIME_PERIOD Time period or
range
The time period of the data.
TITLE Title
UNIT Unit The unit of the data CL_UNIT
UNIT_MULT Unit multiplier The multiplier (mainly for
weights) CL_UNIT_MULT
DECIMALS Decimals The number of decimals CL_DECIMALS
COMMENT_TS
Detailed
description of
the group of
series
AN..1050
SDMX Labour Cost Index page 5
- SDMX for the Labour Cost Index Guide - Version 2.0
DATA_COMP Underlying
compilation
Information on the
methodology used to compile
the data
AN..4000
COVERAGE
Coverage
(geographical,
..)
Information on the parts of the
economy that would not be
covered by the data
AN..4000
TIME_PER_COLL
ECT
Time period
collection
Information on the date(s) of
observation within the
reference period
CL_TIME_PER_COLLECT (1.0)
DISS_ORG Dissemination
organisation
Organisation that transmitted
the data CL_ORGANISATION (1.5)
COMPILING_ORG Compiling
organisation
Organisation that compiled the
data CL_ORGANISATION (1.5)
TIME_FORMAT Time format Format used for reference
periods CL_TIME_FORMAT (1.0)
CODE LISTS
The following table lists all the code lists used by the statistical concepts.
Code List Mnemonic Code List Name Format
CL_SEASONAL_ADJUST Adjustment code list AN1
CL_AREA Area code list AN5
CL_FREQ Frequency code AN1
CL_CONF_STATUS Confidentiality code AN1
CL_OBS_STATUS Observation status code AN1
CL_ACTIVITY Economic Activity code (NACE rev. 2) AN6
CL_INDIC_BZ Indicators for Business Statistics AN3
CL_UNIT Unit AN3
CL_UNIT_MULT Unit multiplier AN1
CL_DECIMALS Decimals AN1
CL_TIME_PER_COLLECT Time period for data collection AN1
CL_ORGANISATION Compiling/dissemination organisation AN4
CL_TIME_FORMAT Time format AN4
For each of the above code lists, the subset of code values that are relevant for Labour Cost Index
statistics are presented in APPENDIX 1.
SDMX Labour Cost Index page 6
- SDMX for the Labour Cost Index Guide - Version 2.0
DATA SET STRUCTURES
Indices and weights of Labour Cost Index
- Data Set Structure Identifier: LCI
- Data Set Identifier: LCI_INDEX_Q / LCI_WEIGHT_A
Description: Labour Cost Indices-Quarterly / Labour Cost Index Weights
A Data Structure Definition (DSD), also named ‘Key Family’, is a set of dimensions, measures and
attributes that gives all information necessary to fully describe the data transmitted. The DSD used
for LCI purposes is described in the following tables.
Organization and statistical concepts involved
DIMENSIONS
Positi
on in
Key
CONCEPT REPRESENTATION
Dimension
Type ID Name CONCEPT SCHEME CODELIST TEXT
FORMAT ID VER AGENCY ID VER AGENCY
1 FREQ Frequency LCI 2.0 ESTAT CL_FREQ 2.0 SDMX
2 REF_AREA Reference
area LCI 2.0 ESTAT CL_AREA 1.5 IMF
3 SEASONAL_AD
JUST
Adjustmen
t method LCI 2.0 ESTAT
CL_SEASO
NAL_ADJU
ST
1.4 ESTAT
4 INDICATOR
Indicators
for
business
statistics
LCI 2.0 ESTAT CL_
INDIC_BZ 1.0 ESTAT
5 ACTIVITY
Economic
Activity
code
LCI 2.0 ESTAT CL_ACTIVI
TY 1.4 ESTAT
TIME TIME_PERIOD*
Time
period or
range
LCI 2.0 ESTAT
* Quarters are put as yyyyQq, e.g. "2013Q4". Years (for annual data) are put as simple YYYY, e.g. "2013".
MEASURES
TYPE
CONCEPT REPRESENTATION MEASU
RE
DIMENS
ION
CODE ID Name
CONCEPT SCHEME CODELIST TEXT
FORMAT ID VE
R
AGENC
Y ID
VE
R
AGENC
Y
Primary OBS_VA
LUE
Observati
on value LCI 2.0 ESTAT N/A N/A
SDMX Labour Cost Index page 7
- SDMX for the Labour Cost Index Guide - Version 2.0
ATTRIBUTES
ATTA
CHME
NT
LEVE
L
CONCEPT REPRESENTATION
ATTRIB
UTE
TYPE
ASSIGN
MENT
STATUS ID Name
CONCEPT SCHEME CODELIST TEXT
FORMA
T ID VE
R AGENCY ID
VE
R AGENCY
Observ
ation
OBS_STA
TUS
Observation
status LCI 2.0 ESTAT
CL_OBS_
STATUS 2.0 SDMX M
Observ
ation
CONF_ST
ATUS
Confidentialit
y status LCI 2.0 ESTAT
CL_CON
F_STATU
S
1.1 SDMX C
Observ
ation
PRE_BRE
AK_VAL
UE
Pre-break
observation
value
LCI 2.0 ESTAT C
Observ
ation
COMME
NT_OBS
Observation
comment LCI 2.0 ESTAT C
Series BASE_PE
R
Series
variation in
the domain's
context
LCI 1.0 ESTAT M
Series TITLE Title LCI 2.0 ESTAT C
Series UNIT Unit LCI 2.0 ESTAT CL_UNIT 1.5 IMF M
Series UNIT_M
ULT
Unit
multiplier LCI 2.0 ESTAT
CL_UNIT
_MULT 1.0 ESTAT M
Series DECIMA
LS Decimals LCI 2.0 ESTAT
CL_DECI
MALS 1.0 ESTAT C
Series COMME
NT_TS
Comment for
Time Series LCI 2.0 ESTAT C
Series DATA_C
OMP
Underlying
Compilation LCI 2.0 ESTAT C
Series COVERA
GE Coverage LCI 2.0 ESTAT C
Series
TIME_PE
R_COLL
ECT
Time period
collection LCI 2.0 ESTAT
CL_TIME
_PER_CO
LLECT
1.0 ESTAT M
Series DISS_OR
G
Dissemination
organisation LCI 2.0 ESTAT
CL_ORG
ANISATI
ON
1.5 IMF C
Series COMPILI
NG_ORG
Compiling
organisation LCI 2.0 ESTAT
CL_ORG
ANISATI
ON
1.5 IMF C
Series TIME_FO
RMAT Time format LCI 2.0 ESTAT
CL_TIME
_FORMA
T
1.0 ESTAT M
*: ‘M’ holds for ‘Mandatory’ and ‘C’ for ‘Conditional’ (i.e. ‘Optional’).
SDMX Labour Cost Index page 8
- SDMX for the Labour Cost Index Guide - Version 2.0
EXAMPLES
Examples of SDMX messages for LCI_INDEX_Q and LCI_WEIGHT_A can be found in
Appendix 2, including explanations on their structure.
A full SDMX User Guide is referred to in the section “Relevant Documents” (page 3).
SDMX Labour Cost Index page 9
SDMX for Job Vacancy Statistics Guide - Version 2.0
APPENDIX 1 - CODE LISTS
CL_FREQ
CL_AREA
Value Description
AT Austria
BE Belgium
BG Bulgaria
CH Switzerland
CY Cyprus
CZ Czech Republic
DE Germany
DK Denmark
EE Estonia
ES Spain
FI Finland
FR France
GB United Kingdom
GR Greece
HR Croatia
HU Hungary
U2 Euro area, changing composition
I8 Euro area 19
IE Ireland
IS Iceland
IT Italy
LT Lithuania
LU Luxembourg
LV Latvia
MK FYROM
MT Malta
NL Netherlands
NO Norway
PL Poland
PT Portugal
RO Romania
SE Sweden
SI Slovenia
SK Slovakia
B0 EU, changing composition
B5 EU 28, fixed composition
Please consult the CL_AREA (ESTAT, ver 1.5) code list at: https://webgate.ec.europa.eu/sdmxregistry/
Value Description
Q Quarterly
A Annual
SDMX Labour Cost Index page 10
SDMX for Job Vacancy Statistics Guide - Version 2.0
CL_SEASONAL_ADJUST
Value Description
N Neither seasonally adjusted nor calendar adjusted data
W Calendar adjusted data, not seasonally adjusted
Y Calendar and seasonally adjusted data
CL_ INDIC_BZ
Value Description
LCI_O LabourCostIndex – labour costs other than wages and salaries
LCI_T LabourCostIndex - total labour costs
LCI_TXB LabourCostIndex - total labour costs excluding bonuses
LCI_WAG LabourCostIndex - wages and salaries
WGT_O Annual weights (for NACE aggregation) for LCI_O
WGT_T Annual weights (for NACE aggregation) for LCI_T
WGT_TXB Annual weights (for NACE aggregation) for LCI_TXB
WGT_WAG Annual weights (for NACE aggregation) for LCI_WAG
LC_O Labour costs other than wages and salaries
LC_T Total Labour costs
LC_TXB Labour costs excluding bonuses
LC_WAG Wages and salaries
HW Hours worked
CL _ACTIVITY
Value Description
B Mining and quarrying
BTE Industry (except construction)
BTF Industry and construction
BTN Business economy
BTS
Industry, construction and services (except activities of
households as employers and extra-territorial organisations
and bodies)
C Manufacturing
D Electricity, gas, steam, and air conditioning
E Water supply, sewerage, waste management and
remediation activities
F Construction
G Wholesale and retail trade: repair of motor vehicles and
motorcycles
GTJ Wholesale and retail trade; transport; accommodation and
food service activities; information and communication
GTN Services of the business economy
GTS Services (except activities of households as employers and
extra-territorial organisations and bodies)
H Transportation and storage
I Accommodation and food service activities
J Information and communication
K Financial and insurance activities
SDMX Labour Cost Index page 11
SDMX for Job Vacancy Statistics Guide - Version 2.0
KTN
Financial and insurance activities; real estate activities;
professional, scientific and technical activities;
administrative and support service activities
L Real estate activities
M Professional, scientific and technical activities
N Administrative and support service activities
O Public administration and defence: compulsory social
security
OTS
Public administration and defence; compulsory social
security; education; human health and social work
activities; arts, entertainment and recreation; other service
activities
P Education
PTS Education; human health and social work activities; arts,
entertainment and recreation; other service activities
Q Human health and social work activities
R Arts, entertainment and recreation
S Other service activities
Note: a request has been made by Eurostat to include, by April 2016, the missing NACE aggregates in the cross-domain
codelist CL_ACTIVITY.
CL_UNIT
Value Description
BGN Bulgarian lev
CHF Swiss franc
CZK Czech koruna
DKK Danish krone
EUR ECU/euro
GBP UK pound sterling
HRK Croatian kuna
HUF Hungarian forint
IX Index
ISK Iceland krona
LTL Lithuanian litas
LVL Latvian lats
MKD Macedonian denar
NOK Norwegian krone
PLN Polish zloty
PN Pure Number
RON Romanian leu
RSD Serbian Dinar
SEK Swedish krona
TRY Turkish lira
SDMX Labour Cost Index page 12
SDMX for Job Vacancy Statistics Guide - Version 2.0
CL_UNIT_MULT
Value Description
0 Units
6 Millions
CL_DECIMALS
Value Description
0 Zero
1 One
2 Two
3 Three
4 Four
5 Five
6 Six
7 Seven
8 Eight
9 Nine
CL_OBS_STATUS
Value Description
A Normal value
B Time series break
E Estimated value
F Forecast value
H Missing value; holiday or weekend
I Imputed value (CCSA definition)
L Missing value; data exist but were not collected
M Missing value, data cannot exist
N Not significant
P Provisional value
Q Missing value; suppressed
S Strike or other special events
U Low reliability
SDMX Labour Cost Index page 13
SDMX for Job Vacancy Statistics Guide - Version 2.0
CL_CONF_STATUS
Value Description
F Free (free for publication)
N Not for publication, restricted for internal use only*
C Confidential statistical information
D Secondary confidentiality set by the sender, not for publication
S Secondary confidentiality set and managed by the receiver, not for publication
* This means the number may only be used for building aggregate figure..
CL_TIME_PER_COLLECT
Value Description
A Average of observations through the period
B Beginning of the period
E End of the period
V Other
CL_ORGANISATION
Value Description
4D0 European Commission (including Eurostat)
4D1 Statistical Office of the European Commission (Eurostat)
4F0 ECB (European Central Bank)
6O0 OECD (Organisation for Economic Co-operation and Development)
AL1 Institute of Statistics (Albania)
AT1 Statistik Österreich (Austria)
BE1 Institut National de Statistiques de Belgique
BG1 National Statistical Institute of Bulgaria
CH1 Swiss Federal Statistical Office
CY1 Department of Statistics and Research (Ministry of Finance) (Cyprus)
CZ1 Czech Statistical Office
DE1 Statistisches Bundesamt (Germany)
DE99 Other competent National Authority (Germany)
DK1 Danmarks Statistik (Denmark)
EE1 Estonia, State Statistical Office
ES1 Instituto Nacional de Estadística (Spain)
FI1 Statistics Finland (Finland)
FR1 Institut National de la Statistique et des Etudes Economiques - INSEE (France)
FR99 Other competent National Authority (France)
GB1 Office for National Statistics (United Kingdom)
GR1 National Statistical Service of Greece (Greece)
HR1 Central Bureau of Statistics (Croatia)
HU1 Hungarian Central Statistical Office
IE1 Central Statistical Office (Ireland)
IS1 Statistics Iceland
IT1 Instituto Nazionale di Statistica (ISTAT) (Italy)
SDMX Labour Cost Index page 14
SDMX for Job Vacancy Statistics Guide - Version 2.0
Value Description
LT1 Lithuania, Department of Statistics
LU1 STATEC - Service central de la statistique et des études économiques du Luxembourg
LV1 Central Statistical Bureau of Latvia
ME1 Statistical Office (Montenegro)
MK1 State Statistical Office (Macedonia)
MT1 National Statistics Office (Malta)
NL1 Central Bureau voor de Statistiek (Netherlands)
NO1 Statistics Norway
PL1 Central Statistical Office of Poland
PT1 Instituto Nacional de Estatística (Portugal)
RO1 Romania, National Commission for Statistics
RS1 Statistical Office of the Republic of Serbia
SE1 Statistics Sweden (Sweden)
SI1 Statistical Office of the Republic of Slovenia
SK1 Statistical Office of the Slovak Republic
TR1 State Institute of Statistics (Turkey)
CL_TIME_FORMAT
Value Description
P3M Quarterly
P1Y Annual
SDMX Labour Cost Index page 15
SDMX for Job Vacancy Statistics Guide - Version 2.0
APPENDIX 2 – MESSAGE IMPLEMENTATION GUIDELINES
1. Message Overview for LCI_Q_INDEX
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with SDMX Converter v2.7.2 -->
<CompactData
xmlns="http://www.SDMX.org/resources/SDMXML/schemas/v2_0/message"
xmlns:lci="urn:sdmx:org.sdmx.infomodel.keyfamily.KeyFamily=ESTAT:LCI:2.0:compact"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.SDMX.org/resources/SDMXML/schemas/v2_0/message SDMXMessage.xsd
urn:sdmx:org.sdmx.infomodel.keyfamily.KeyFamily=ESTAT:LCI:2.0:compact ESTAT_LCI_Compact.xsd">
<Header>
<ID>LCI_INDEX_Q</ID>
<Test>true</Test>
<Truncated>true</Truncated>
<Prepared>2013-04-30T16:43:52.000+02:00</Prepared>
<Sender id="BE1">
</Sender>
</Header>
<lci:DataSet>
<lci:Series FREQ="Q" REF_AREA="BE" SEASONAL_ADJUST="W" INDICATOR="LCI_T" ACTIVITY="B" UNIT="IX"
UNIT_MULT="0" TIME_PER_COLLECT="A" TIME_FORMAT="P3M">
<lci:Obs TIME_PERIOD="2014Q1" OBS_VALUE="108.831" OBS_STATUS="A" BASE_YEAR="2012"/>
<lci:Obs TIME_PERIOD="2014Q2" OBS_VALUE="128.612" OBS_STATUS="A" BASE_YEAR="2012"/>
<lci:Obs TIME_PERIOD="2014Q3" OBS_VALUE="108.775" OBS_STATUS="A" BASE_YEAR="2012"/>
<lci:Obs TIME_PERIOD="2014Q4" OBS_VALUE="135.429" OBS_STATUS="A" BASE_YEAR="2012"/>
</lci:Series>
<lci:Series FREQ="Q" REF_AREA="BE" SEASONAL_ADJUST="N" INDICATOR="LCI_WAG" ACTIVITY="B" TIME_PER_COLLECT="A" TIME_FORMAT="P3M">>
<lci:Obs TIME_PERIOD="2014Q1" OBS_VALUE="106.722" OBS_STATUS="A" BASE_YEAR="2012"/>
<lci:Obs TIME_PERIOD="2014Q2" OBS_VALUE="128.354" OBS_STATUS="A" BASE_YEAR="2012"/>
<lci:Obs TIME_PERIOD="2014Q3" OBS_VALUE="106.9" OBS_STATUS="A" BASE_YEAR="2012"/>
<lci:Obs TIME_PERIOD="2014Q4" OBS_VALUE="136.233" OBS_STATUS="A" BASE_YEAR="2012"/>
</lci:Series>
<lci:Series FREQ="Q" REF_AREA="BE" SEASONAL_ADJUST="N" INDICATOR="LCI_O" ACTIVITY="B" TIME_PER_COLLECT="A" TIME_FORMAT="P3M">>
<lci:Obs TIME_PERIOD="2014Q1" OBS_VALUE="113.95" OBS_STATUS="A" BASE_YEAR="2012"/>
<lci:Obs TIME_PERIOD="2014Q2" OBS_VALUE="129.239" OBS_STATUS="A" BASE_YEAR="2012"/>
<lci:Obs TIME_PERIOD="2014Q3" OBS_VALUE="113.326" OBS_STATUS="A" BASE_YEAR="2012"/>
<lci:Obs TIME_PERIOD="2014Q4" OBS_VALUE="133.477" OBS_STATUS="A" BASE_YEAR="2012"/>
Part 1, the metadata
Part 2, the general information
SDMX Labour Cost Index page 16
SDMX for Job Vacancy Statistics Guide - Version 2.0
</lci:Series>
</lci:DataSet>
</CompactData>
2. Message Overview for LCI_WEIGHT_A
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with SDMX Converter v2.7.2 -->
<CompactData
xmlns="http://www.SDMX.org/resources/SDMXML/schemas/v2_0/message"
xmlns:lci="urn:sdmx:org.sdmx.infomodel.keyfamily.KeyFamily=ESTAT:LCI:2.0:compact"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.SDMX.org/resources/SDMXML/schemas/v2_0/message SDMXMessage.xsd
urn:sdmx:org.sdmx.infomodel.keyfamily.KeyFamily=ESTAT:LCI:2.0:compact ESTAT_LCI_Compact.xsd">
<Header>
<ID> LCI_WEIGHT_A </ID>
<Test>true</Test>
<Truncated>true</Truncated>
<Prepared>2013-04-30T16:43:52.000+02:00</Prepared>
<Sender id="BE1">
</Sender>
</Header>
<lci:DataSet> <lci:Series FREQ="A" REF_AREA="BE" SEASONAL_ADJUST="N" INDICATOR="WGT_T" ACTIVITY="B" UNIT="EUR" UNIT_MULT="6" TIME_PER_COLLECT="A" TIME_FORMAT="P1Y">
<lci:Obs TIME_PERIOD="1996" OBS_VALUE="7959" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="1997" OBS_VALUE="7265" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="1998" OBS_VALUE="6706" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="1999" OBS_VALUE="6298" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2000" OBS_VALUE="6325" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2001" OBS_VALUE="5372" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2002" OBS_VALUE="4987" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2003" OBS_VALUE="4850" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2004" OBS_VALUE="4631" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2005" OBS_VALUE="4615" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2006" OBS_VALUE="4371" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2007" OBS_VALUE="4302" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2012" OBS_VALUE="4431" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2009" OBS_VALUE="4435" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2010" OBS_VALUE="4404" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2011" OBS_VALUE="4517" OBS_STATUS="A" BASE_YEAR="XXXX"/>
<lci:Obs TIME_PERIOD="2012" OBS_VALUE="4454" OBS_STATUS="A" BASE_YEAR="XXXX"/>
</lci:Series>
Part 3, the data
Part 1, the metadata
Part 2, the general information
Part 3, the data
SDMX Labour Cost Index page 17
SDMX for Job Vacancy Statistics Guide - Version 2.0
</lci:DataSet>
</CompactData>
The first part of the data message contains the instructions on where to find the code list information for the
data in the file. This is indeed one of the main advantages with an XML-based message that all the information
needed to decode the message is contained with the message itself.
The second part contains general information on the ID of the dataset, production date and the sender id of the
institution providing the data.
Finally the third part contains the actual data. The above shown messages are heavily truncated compared to a
real datasets, here we only show four quarters of unadjusted (NSA) data for NACE section B for the three main
indicators; the total (LCI_T) and its two components (LCI_WAG and LCI_O) for the first example and a full
time series of total weights (WGT_T) for NACE section B. As it can be seen the only real difference is in the
data part of the messages, therefore it can also be envisaged to include both in the same message. An important
difference to the GESMES/TS standard is the fact that all items have a description with them, whereas is
GESMES (or indeed in csv) the order of the items indicates what it is.
TOOLS AVAILABLE
SDMX Converter Converts data files between SDMX formats and other file formats
Data Structure Wizard (DSW) Used to create, edit and test SDMX artefacts
SDMX Registry A central repository for storing and sharing SDMX artefacts
SDMX Reference Infrastructure (SDMX-RI) A set of tools that allows to connect your IT systems to the SDMX world
Mapping Assistant Mapping and transcoding of the contents of an existing database to SDMX data structures
XSD Generator Generates a standard XML schema definition for a given SDMX DSD
If clarification is required in relation to this document please contact
Mr. Hubertus Vreeswijk / Daniel ISCRU
EUROSTAT
Bâtiment Joseph Bech
5 Rue Alphonse Weicker,
L-2721 Luxembourg
Tel.: (352) 4301- 34323/37095
Fax: (352) 4301 – 33649
Email : [email protected]
For technical matters concerning SDMX: Email: [email protected]