Structural Business Statistics

1. Structural Business Statistics Data reporting to Eurostat, transmission format and tools

2. Data transmission SBS • Which data need to be reported to Eurostat each reference year? • In what form should the data be sent? • How can the data be sent? • What happens with the data at Eurostat?

3. 1. Series of data to be transmitted • Which data need to be transmitted for each reference year ->Commission Regulation concerning the series of data to be produced for SBS (after recast) • First reference year • Frequency • Activity coverage • List of characteristics • Level of activity breakdown • Level of other breakdowns (size class, regional,...)

4. 1. Series of data to be transmitted • Series 1X: Services (NACE Rev.2 Sections H to J and L to N and division 95) • Series 2X: Industry (NACE Rev.2 Sections B, C, D, and E) • Series 3X: Distributive trade (NACE Rev.2 Section G) • Series 4X: Construction (NACE Rev.2 Section F) • Series 5X: Insurance services (NACE Rev.2 division 65 except for group 65.3)

5. 1. Series of data to be transmitted • Series 6X: Credit institutions (All credit institutions within the scope of NACE Rev.2 classes 64.19 and 64.92) • Series 7X: Pension funds (NACE Rev.2 group 65.3) • Series 8X: Business services (NACE Rev.2 division 62, groups 58.2, 63.1 and 73.1 and division 78 annual; NACE Rev.2 groups 69.1, 69.2, and 70.2 as well as NACE Rev.2 groups 73.2, 71.1 and 71.2 biennial) • Series 9X: Business demography (NACE Rev.2 Sections B to N )

6. 1.Series of data to be transmitted • Series: • XA: Annual enterprise statistics • XB: Annual enterprise statistics by size class • XC: Annual regional statistics • XP: Preliminary results

7. 2. Technical format • In what form should the data be transmitted? ->Technical format is laid down in a Regulation • Why? • Least possible errors when importing the data in our Oracle Olap database

8. 2. Technical format • Set of records • Record = description of characteristics of data (country, year, economic activity,...) + data + explanatory notes • All levels of aggregation of breakdowns to be provided • Confidential data to be sent with true value + flag (including secondary confidential cells)

9. 2. Technical format • One file per series of data • Standard file names to be used • Complete data sets including records for data that is not available (‘na’) • Monetary data in thousands of national currency • Data not respecting technical format is considered not being sent

10. 2.a) Data set indentifier • eDAMIS-codes • Ensures a correct identification of the data sent

11. 2.b) Record structure 1. Series 2. Year 3. Territorial unit 4. Size class 5. Economic activity 6. Variable

12. 2.b) Record structure 7. Data value 8. Quality flag 9. Confidentiality flag 10. Dominance/share largest unit 11. Share second largest unit 12. Units of data values

13. 2.b) Record structure 13. Breakdown of products 14. Turnover size classes 15. Breakdown by environmental domains 16. Geographical breakdown 17. Residence of parent enterprise 18. Legal form

14. 2.b) Record structure 19. Type of insurance enterprise or insurance business 20. Category 21. Currency breakdown 22. Residence of client 23. Population 24. Footnote

15. 2.c) Data value • data equal to zero (coded '0'): Real values of zero only (phenomenon is not existing or rounded value of existing phenomenon • data not available (coded ‘na’): This is data which is not collected in a Member State. Only in very exceptional cases allowed (derogations 1%-rule).

16. 2.d) Quality flag • Revised data R • Provisional data P • Insufficiently reliable data that can be used for calculating Community totals but that cannot be disseminated at national level W • Estimation (only for Annex IX) E

17. 2.e) Confidentiality flags • Too few enterprises A • One enterprise dominates the data B • Two enterprises dominate the data C • Confidential data due to secondary confidentiality D • Data is confidential in application of the p%-rule F • Data not published at national level because sensitive information or as suppression partner of data that is not required by SBS Regulation H

18. 2.f) Units • Units UNIT • Thousands 1000 • Millions MIO • National currency in thousands KNC • National currency in millions MNC • Euro in thousands KEUR • Euro in millions MEUR

19. 2.g) Examples • Example 1: Confidential data: dominance by one enterprise The number of persons employed (2700) in France in 2008 for enterprises of 50 to 249 persons employed for NACE C1411 is confidential. One enterprise dominates the data and represents 92% of employment. This is provisional data. 2B;2008;FR;06;C1411;16110;2700;P;B;92; ;UNIT; ; ; ; ; ; ; ; ; ; ; ;

20. 2.g) Examples • Example 2: Size class dataThe turnover of the retail sale of foods (NACE Rev.2 G472) in Luxembourg in 2008 with an annual turnover between 1 and 2 million EUR was 25123000 EUR. It is revised data. Data is not confidential

21. 2.g) Examples • Example 4: Business services dataGermany declares for the activities of NACE Rev.2 group 62 that EURO 250123000 of turnover is generated by publishing services of computer games in 2008. The data is non confidential.

22. 2.i) Transmission format • Comma separated value (csv) format • No thousand separators in values • 1 file per series: Annex 1 limited to activities of NACE H, I, (J) and K: EDIFLOW codes

23. 3. How can the data be sent? • To be sent via Stadium/eDAMIS • eDAMIS: electronic Data files Administration and Management Information System • Software running the Eurostat’s Single Entry Point for data reception • Encryption/decryption

24. 4. What happens with the data at Eurostat? • Quality checking / data validation • « Audit »  confidentiality pattern • Dissemination • EU aggregates