ANNEX IISupplementary provisions
ANNEX II TECHNICAL FORMAT 1. THE FORM OF THE DATA The data are sent as a set of records of which a large part describes the characteristics of the data (country, year, economic activity etc.). The data itself is a number which can be linked to flags and explanatory footnotes. Confidential data should be sent with the true value being recorded in the value field and a flag indicating the nature of the confidential data being added to the record. 2. RECORD STRUCTURE Records are made up of fields of variable length separated by semi-colons (;). The maximum expected length is shown in the table for your information. In order from left to right they are: Field Type Maximum length Values Series A 3 Alphanumeric code of the series (see list below). Year A 4 Year in four characters e.g. 2003. Country A 6 Country code (see list below). Type of production A 3 To distinguish Maximum Possible Production from the Actual Production (only used for the statistics on capacity) or to distinguish the type of plant (plant for load preparation, rolling mill departments, blast furnaces and electric iron making furnaces, electricity generating stations, melting shops, other plant) (only used for the statistics on fuel and energy consumption). Variable A 4 Variable code. The codes laid down in Regulation (EC) No 48/2004 on the production of annual Community statistics on the steel industry for the reference years 2003-2009 have 4 characters (see list below). Data value N 12 Numeric value of the data expressed as a whole number without decimal places. Confidentiality flag A 1 A, B, C, D: indicates that the data are confidential and the reason for that confidentiality (see list below). A blank space indicates non-confidential data. Dominance N 3 A numeric value less than or equal to 100. This indicates the percentage dominance of one or two enterprises which dominate the data and make it confidential. The value is rounded to the nearest whole number: e.g. 90,3 becomes 90, 94,50 becomes 95. This field is blank for non-confidential data. This field is only used when the confidentiality flags B or C are used in the previous field. Units of data values A 4 Codes for indicating the units. 3. DESCRIPTION OF THE FIELDS 3.1. The type of series Series type Code Yearly statistics on the steel and cast iron scrap balance sheet S10 Annual statistics on the Fuel and Energy Consumption broken down by type of plant S2A Annual statistics on the Balance Sheet for Electrical Energy in the Steel Industry S2B Enquiry on Investments in the Iron and Steel Industry S3A Annual statistics on capacity S3B 3.2. Countries Country Code Belgium BE Czech Republic CZ Denmark DK Germany DE Estonia EE Greece GR Spain ES France FR Ireland IE Italy IT Cyprus CY Latvia LV Lithuania LT Luxembourg LU Hungary HU Malta MT Netherlands NL Austria AT Portugal PT Poland PL Slovenia SI Slovakia SK Finland FI Sweden SE United Kingdom UK Iceland IS Liechtenstein LI Norway NO Switzerland CH 3.3. Type of production or type of plant Type of production Code Maximum possible production MPP Actual production (optional) ACP Type of plant Plant for load preparation PLP Rolling mill departments RMD Blast furnaces and electric iron making furnaces FRN Electricity generating stations EGS Melting shops MLS Other plant OTH 3.4. Variables and unit of data value Code Title Unit of data value Steel and Cast Iron Scrap Balance Sheet Metric tonnes 1010 Stocks on first day of year MTON 1020 Arising within the works MTON 1030 Receipts (1031 + 1032 + 1033 ) MTON 1031 from home sources MTON 1032 from Community countries MTON 1033 from third countries MTON 1040 Total available (1010 + 1020 + 1030 ) MTON 1050 Consumption total … MTON 1051 … of which electric furnaces MTON 1052 … of which stainless scrap MTON 1060 Deliveries MTON 1070 Stocks on last day of year (1040 – 1050 – 1060 ) MTON Fuel and Energy Consumption 2010 Solid fuels (2011 + 2012 ) MTON 2011 Coke MTON 2012 Other solid fuels MTON 2020 Liquid fuels MTON 2030 Gas (2031 + 2032 + 2033 + 2034 ) GJ 2031 Blast furnace gas GJ 2032 Coke oven gas GJ 2033 Converter gas GJ 2034 Other gas GJ 2040 External deliveries of blast furnace gas GJ 2050 External deliveries of converter gas GJ Annual statistics on the Balance Sheet for Electrical Energy in the Steel Industry MWh 3100 Resources (3101 + 3102 ) MWh 3101 Gross production MWh 3102 Receipts from outside MWh 3200 Used (3210 + 3220 + 3230 ) MWh 3210 Consumption by plant (3211 + 3212 + 3213 + 3214 + 3215 + 3216 + 3217 ) MWh 3211 Sinter plant and plant for preparation of burden MWh 3212 Blast furnaces and electric iron making furnaces MWh 3213 Electric melting shops and continuing casting MWh 3214 Other melting shops and continuing casting MWh 3215 Rolling mill departments MWh 3216 Electricity generating stations MWh 3217 Other plant MWh 3220 Deliveries to outside MWh 3230 Losses MWh Monetary data must be expressed in thousands of euros for euro zone countries and in thousands of national currencies for countries outside the euro area. Code Title Unit of data value Investment expenditure in the Iron and Steel Industry Thousands of euros or thousands of national currency 4010 Coking plant KEUR or KNC 4020 Plant for load preparation KEUR or KNC 4030 Plant for iron making and ferro-alloys (including blast furnaces) KEUR or KNC 4040 Steelworks melting shops KEUR or KNC 4041 of which electric KEUR or KNC 4050 Continuous casting KEUR or KNC 4060 Rolling mills (4061 + 4062 + 4063 + 4064 ) KEUR or KNC 4061 Flat products KEUR or KNC 4062 Long products KEUR or KNC 4063 Cold wide strip mills KEUR or KNC 4064 Coating installations KEUR or KNC 4070 Other plant KEUR or KNC 4100 General total (4010 + 4020 + 4030 + 4040 + 4050 + 4060 + 4070 ) KEUR or KNC 4200 Of which to combat pollution KEUR or KNC Maximum Possible Production in the Iron and Steel Industry (Capacity) 1 000 tonnes per year 5010 Coke 1 000 5020 Load preparation 1 000 5030 Pig iron and ferro-alloys 1 000 5040 Crude steel 1 000 5041 of which electric 1 000 5042 of which used in continuous casting 1 000 5050 Products obtained directly by hot rolling (5051 + 5052 ) 1 000 5051 Flat products 1 000 5052 Long products 1 000 5060 Products obtained from hot rolling products (excluding coated products) 1 000 5061 of which products obtained by cold rolling 1 000 5070 Coated products 1 000 3.5. Confidentiality flags Member States are asked to clearly indicate confidential data using the flags listed below: Reason for confidentiality Flag Too few enterprises A One enterprise dominates the data B Two enterprises dominate the data C Confidential data due to secondary confidentiality D 4. EXAMPLES OF RECORDS Example 1 S10;2003;DE;;1010;12345;;;MTON As far as the yearly statistics on the steel and cast iron scrap balance sheet is concerned, the stocks on 1.1.2003 in Germany was 12 345 metric tonnes. These data were not confidential. Example 2 S3B;2003;SK;MPP;5010;12000;;;MTON As far as the annual statistics on capacity are concerned, the maximal possible production of Coke in Slovakia in 2003 was 12 000 tonnes. These data were not confidential. Example 3 S3B;2003;ES;ACP;5040;12000;B;95;MTON As far as the annual statistics on capacity are concerned, the actual production of crude steel in Spain in 2003 was 12 000 tonnes. These data were confidential, as one enterprise dominated the data and represented 95 % of the production. 5. ELECTRONIC FORM Member States shall transmit to the Commission (Eurostat) the data and metadata required by this Regulation in an electronic format compliant with an interchange standard proposed by the Commission (Eurostat).