ANNEX IIISupplementary provisions
ANNEX III Micro-data files for the transmission of data listed in Section 2 of Annex II to Regulation (EU) No 692/2011 File structure and codification Each observed trip shall be an individual record in the transmitted micro-data file. This micro-data file shall be fully checked, edited and, where necessary, imputed and shall follow the file structure and codification described in the table below. The Commission (Eurostat) will supply additional guidance in relation to the transmission format. Data that does not respect the provisions for the exchange standard set out in this Annex will be considered as not having been sent. Column Identifier Description Filter/remarks 1/6 000001-999999 Sequence number of the trip CHARACTERISTICS OF THE TRIP 7/8 Month of departure 01-24 Number of the month (January of the reference year = 01, December of the reference year = 12; January of previous calendar year = 13, December of previous calendar year = 24) 9/11 Duration of the trip in number of nights 001-366 Number of nights (3 digits) 12/14 Duration of the trip: number of nights spent on the domestic territory Only for outbound trips; Triennial variable, in the optional years: code = Blank 000-183 Number of nights (3 digits) 15/17 Main country of destination 001-999 Coding according to the country list in the methodological manual drawn up under Article 10 of Regulation (EU) No 692/2011 18 Main purpose of the trip 1 Private/personal purpose: leisure, recreation and holidays 2 Private/personal purpose: visiting relatives and friends 3 Private/personal purpose: other (e.g. health treatment, pilgrimage) 4 Professional/business purpose 19/24 Type of destination Column 18 = [1, 2, 3]; Triennial variable, in the optional years: code = Blank 19 1 City = Yes 2 City = No 9 City = Not applicable (Column 18 = 4) 20 1 Seaside = Yes 2 Seaside = No 9 Seaside = Not applicable (Column 18 = 4) 21 1 Countryside (including lakeside, river, etc.) = Yes 2 Countryside (including lakeside, river, etc.) = No 9 Countryside (including lakeside, river, etc.) = Not applicable (Column 18 = 4) 22 1 Cruise ship = Yes 2 Cruise ship = No 9 Cruise ship = Not applicable (Column 18 = 4) 23 1 Mountains (highlands, hills, etc.) = Yes 2 Mountains (highlands, hills, etc.) = No 9 Mountains (highlands, hills, etc.) = Not applicable (Column 18 = 4) 24 1 Other = Yes 2 Other = No 9 Other = Not applicable (Column 18 = 4) 25 Participation of children Column 18 = [1, 2, 3]; Triennial variable, in the optional years: code = Blank 1 Yes 2 No 9 Not applicable (Column 18 = 4) 26 Main means of transport 1 Air (flight services, scheduled or chartered, or other air services) 2 Waterway (passenger lines and ferries, cruises, pleasure boat, rented vessel, etc.) 3 Railway 4 Bus, coach (scheduled or non-scheduled) 5 Motor vehicle (private or rented) 6 Other (e.g. bicycle) 27 Main means of accommodation 1 Rented accommodation: hotels or similar establishments 2 Rented accommodation: campsites, caravan or trailer park (non-residential) 3 Rented accommodation: other rented accommodation (health establishments, youth hostels, marinas, etc.) 4 Non-rented accommodation: own holiday home 5 Non-rented accommodation: accommodation provided without charge by relatives or friends 6 Non-rented accommodation: other non-rented accommodation 28 Booking of the trip: use of a tour operator or travel agency to book the main means of transport Triennial variable, in the optional years: code = Blank 1 Yes 2 No 9 Don’t know 29 Booking of the trip: use of a tour operator or travel agency to book the main means of accommodation Triennial variable, in the optional years: code = Blank 1 Yes 2 No 9 Don’t know 30 Booking of the trip (independent) Triennial variable, in the optional years: code = Blank Column 28 = 2 and Column 29 = 2 1 The services were booked directly with the service provider 2 No booking was needed 9 Not applicable (Column 28 ≠ 2 or Column 29 ≠ 2) 31 Booking of the trip: package trip Triennial variable, in the optional years: code = Blank 1 Yes 2 No 32 Booking of the trip: Internet booking of the main means of transport Triennial variable, in the optional years: code = Blank 1 Yes 2 No 9 Don’t know 33 Booking of the trip: Internet booking of the main means of accommodation Triennial variable, in the optional years: code = Blank 1 Yes 2 No 9 Don’t know 34/41 Expenditure of the individual tourist during the trip relating to transport 00000000-99999998 Amount in euro (8 digits) 42/49 Expenditure of the individual tourist during the trip relating to accommodation 00000000-99999998 Amount in euro (8 digits) 50/57 Expenditure of the individual tourist during the trip on food and drinks in cafés and restaurants Optional variable, if not transmitted: code = Blank 00000000-99999998 Amount in euro (8 digits) 58/65 Other expenditure of the individual tourist during the trip (total other, including durables and valuable goods) 00000000-99999998 Amount in euro (8 digits) 66/73 Durables and valuable goods (subcategory of Other expenditure of the individual tourist during the trip) 00000000-99999998 Amount in euro (8 digits) PROFILE OF THE VISITOR 74 Gender 1 Male 2 Female 75/77 Age 000-198 Number of completed years (3 digits) 78/79 Country of residence The 2-digit country code (Belgium = BE, Bulgaria = BG, etc.) 80 Educational level Optional variable, if not transmitted: code = Blank 1 Lower (ISCED 0, 1 or 2) 2 Middle (ISCED 3 or 4) 3 Higher (ISCED 5 or 6) 81 Employment situation Optional variable, if not transmitted: code = Blank 1 Employed (employee or self-employed) 2 Unemployed 3 Student (or pupil) 4 Other not in the labour force 82 Household income in quartiles Optional variable, if not transmitted: code = Blank 1 First quartile 2 Second quartile 3 Third quartile 4 Fourth quartile GROSSING-UP FACTOR 83/91 Grossing-up factor from sample to population 000000-999999 Columns 83 to 88 contain integers 000-999 Columns 89 to 91 contain decimal places