Commission Regulation (EC) No 1358/2003Show full title

ANNEX II U.K. DESCRIPTION OF THE DATA FILES AND TRANSMISSION MEDIUM

Two EDI compatible formats are acceptable for the transmission of the regulation tables: ‘CSV’ (Comma Separated Values) with semicolon (;) as field separator and GESMES-EDIFACT.

List and description of the fields to be used for each table of the Regulation: U.K.

The following summary table gives for each table of the regulation (A1, B1 and C1) and each record (line), the list of fields to be provided. Two different types of fields are marked in the column associated to the relevant table:

• ‘X’: fields that have to be provided for a table,

• ‘ ’ (space): fields not relevant for the table. These fields should normally not be provided in the related tables. Nevertheless empty fields (two fields separator without data between) are also acceptable in this case.

Format and size of the fields: U.K.

The format of each field is either numeric (n) or alphabetic (a) or alphanumeric (an)

The size is either fixed (‘format + number’ — e.g.: ‘n4’) or variable with a maximum number of positions (‘format + “..” + maximum number of positions — e.g.: “n..12”’).

Pos	Fields	Format and size	Tables
			A1	B1	C1
1	Table identification	an2	X	X	X
2	Reporting country	a2	X	X	X
3	Reference year	n2	X	X	X
4	Reference period	an2	X	X	X
5	Reporting airport	an4	X	X	X
6	Partner airport	an4	X	X
7	Arrival/departure	n1	X	X
8	Scheduled/non-scheduled services	n1	X	X
9	Passenger flight/All-freight and mail flight	n1	X	X
10	Airline information	a3	X	X	X
11	Aircraft type	an..4	X
12	Passengers	n..12	X	X	X
13	Direct transit passengers	n..12			X
14	Freight and mail	n..12	X	X	X
15	Commercial air flights (table ‘A1’)/Total commercial aircraft movements (table ‘C1’)	n..12	X		X
16	Total aircraft movements	n..12			X
17	Passenger seats available	n..12	X

One table (for one period) should correspond to one file (or ‘consignment’) transmitted to Eurostat

Each file (table) should be named according to the following standard: ‘CCYYPPTT.csv’ (for csv format) or: ‘CCYYPPTT.ges’ (for gesmes format): where ‘CC’ represents the Country Code (ISO alpha2), ‘YY’ the Year, ‘PP’ the period (AN, Q1..Q4 or 01..12) and ‘TT’, the Table-ID (‘A1’, ‘B1’ or ‘C1’).

In case the file is compressed, the ‘.zip’ suffix should be used instead of ‘.csv’ or ‘.ges’.

The transmission mean shall be compatible with an automatic monitoring and processing of data in Eurostat.

EDI compatible tools should be favoured. Nevertheless, ‘Pre-EDI’ tools as well as structured e-mail sent to an address given by Eurostat could also be accepted in a transitional period.

In case a structured e-mail is used, then:

• the subject field of the e-mail should contain the name of the file (table) to be transmitted,

• the file (table) should be attached to the e-mail (only one file attached per e-mail is acceptable),

• comments on data can be entered as plain text in the body of the message to which a table is attached (formatted text shall not be used).