sdmx - circabc.europa.eu filesdmx labour cost index page 3 - sdmx for the labour cost index guide -...

17
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

Upload: others

Post on 28-Oct-2019

21 views

Category:

Documents


0 download

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]