Fare Basis Survey Record Layout
For Information onlyThis is an electronic survey example for information purposes only. This is not a working questionnaire.
Introduction
Purpose
The Fare Basis Survey represents a regular and comprehensive source of fare type-specific data on passengers, revenues, and average air fares.
Additional information
The Fare Basis Survey collects passenger and revenue data on a coupon origin and destination basis, by city-pair (on a directional basis) and by fare basis code. All Canadian Level I air carriers conducting scheduled transportation services, both domestic and international, are required to report Fare Basis data for 14 sample days of each quarter (i.e., 56 sample days in every calendar year).
Preparation
Preparation - Question identifier:1.
Each record is to be a summary of the data recorded from coupons such that there is one record for each combination of sample day, city-pair and fare basis code.
Preparation - Question identifier:2.
The file record layout is as follows:
Field Number: 1 Size: 2 Position: 1-2 Type: Character Title: Carrier
Field Number: 2 Size: 4 Position: 3-6 Type: Numeric Title: Year
Field Number: 3 Size: 2 Position: 7-8 Type: Numeric Title: Month
Field Number: 4 Size: 2 Position: 9-10 Type: Numeric Title: Day
Field Number: 5 Size: 4 Position: 11-14 Type: Character Title: "From-City" of the coupon city-pair
Field Number: 6 Size: 4 Position: 15-18 Type: Character Title: "To-City" of the coupon city-pair
Field Number: 7 Size: 8 Position: 19-26 Type: Character Title: Fare basis code
Field Number: 8 Size: 5 Position: 27-31 Type: Numeric Title: Number of passengers
Field Number: 9 Size: 7 Position: 32-38 Type: Numeric Title: Revenue
Preparation - Question identifier:3.
The fields are to be completed as follows:
Preparation - Question identifier:1)
"Carrier" is to contain the two-character IATA carrier code.
Preparation - Question identifier:2)
"Year" is to be the four digits of the year in which the sample day falls.
Preparation - Question identifier:3)
"Month" is to be a two-digit number, with preceding zeroes whenever required,
representing the month within which the sample day falls.
Preparation - Question identifier:4)
"Day" is to be a two-digit number, with preceding zeroes whenever required,
representing the sample day.
Preparation - Question identifier:5)
"From-city" is to be a valid, left-justified three-character IATA code for one of the cities in the coupon city-pair. It is to be 'UNKb' (1), if the city is missing. If the code on the coupon was wrong, the correct code should be used.
Preparation - Question identifier:6)
"To-city" is to be a valid, left-justified three-character IATA code for one of the cities in the coupon city-pair. It is to be 'UNKb' (1), if the city is missing. If the code on the coupon was wrong, the correct code should be used.
Preparation - Question identifier:7)
"Fare basis code" is to be a valid, left-justified eight-character code. If the fare basis code on the coupon was missing, record 'UNKbbbbb' (1). If the code on the coupon was wrong, the correct code should be used.
Preparation - Question identifier:8)
"Number of passengers" is to be all numeric with preceding zeroes.
Preparation - Question identifier:9)
"Revenue" is to be all numeric with preceding zeroes, rounded to the
nearest dollar and with cents omitted.
Preparation - Question identifier:4.
It is imperative that records on the file be sorted in ascending order by sample day, then by city-pair and then by fare basis code.
(1) "b" stands for blank.
- Date modified: