|
Chapter 8: Data Entry Software
Introduction
The T100 Data Entry Software (October 2002) is designed for use by U.S. air carriers to prepare monthly submissions of the traffic and capacity data required by the Department’s T100 regulations found in …
14 CFR Part 421
UNIFORM SYSTEMS OF ACCOUNTS AND REPORTS FOR LARGE CERTIFICATED AIR CARRIERS
The target carriers are those who normally expect to report a relatively low volume of segment and market information that is not readily producible on a mainframe or minicomputer using one/half inch magnetic tape medium as specified in the rule.
The software includes a set of procedures for entering and editing T100 data, and for creating comma-delimited files for monthly submissions of Nonstop Segment data, and On-flight Market data.
The purpose for the issuing this new software is to ease the carrier’s burden of reporting and to assure that these important data submissions are received in a standardized format. The edit checks built into the software are intended to increase overall data reliability by reducing the number of potential syntax errors.
Carriers are not limited to using the T100 Data Entry Software and are welcome to generate Segment and Market files by another means, but are required to submit data files in the format described in the following sections of this document.
Questions concerning filing dates or reporting specifications should be addressed to the Office of Airline Information T100 Traffic Data Adminstrators:
Ms. Jennifer Fabrizi (202) 366-8513 - jennifer.fabrizi@bts.gov
Ms. Cecelia Robinson (202) 366-4405 - cecelia.robinson@bts.gov
For questions about the T100 Data Entry Software or other technical support please contact:
Ms. Nina Tatyanina, (202) 366-5780 - nina.tatyanina@bts.gov
Ms. Marianne Seguin (202) 366-1457 - marianne.seguin@bts.gov
Reporting T100 Segment Data - Naming Convention and File Type
The Segment File naming convention is "CC_SegYY_MM.csv" where:
CC - Carrier Alpha Code
Seg - Indicates that file contains segment data
YY - Last two digits of the year
MM - Month
.csv - comma separated variable file type. *
* The .csv extension indicates a comma separated variable file type - where commas separate each value in a record.
EXAMPLE: AA_Seg02_11.csv = American Airlines, Segment data for November 2002
The first record listed below indicates each of the fields in the records that follow.
There are five data records in the sample file listing below.
Each data value is separated by a comma.
Example of a Segment file submission: AA_Seg02_10.csv
DATA TYPE, ENTITY CODE,
YEAR, MONTH,
ORIG
AIRPORT, DEST
AIRPORT,
SERVICE CLASS,
AIRCRAFTTYPE, CABINCONFIG,
DEPARTURESPERF,
AVAILABLEPAYLOAD, AVAILABLESEATS,
SEGPASSENGERS, SEG FREIGHT, SEG MAIL,
SCHED DEPARTURES, R TO R MINUTES, AIRB MINUTES
S,0A050,2002,10,DFW,IAD,F,614,1,1,44000,200,198,0,0,1,0,0
S,0A050,2002,10,SLC,JFK,F,625,1,1,69000,200,195,0,0,1,0,0
S,0A050,2002,10,ORD,SLC,F,627,1,1,110000,270,265,0,0,1,0,0
S,0A050,2002,10,DTW,IAD,F,614,1,1,44000,180,171,0,0,1,0,0
S,0A050,2002,10,LAA,LAX,F,622,1,1,55000,200,189,0,0,1,0,0
T100 Segment File - Record Layout and Field Description
Excel | CSV
1 |
Data Type |
1 |
Character |
"S" is used for segment data |
2 |
Entity Code |
5 |
Character |
A five-character code assigned to each air carrier that is used primarily for DOT reporting purposes. It is used to separate the Domestic, Atlantic, Latin America, and Pacific operations of each air carrier. |
3 |
Year |
4 |
Numeric |
Format: CCYY = century and year |
4 |
Month |
2 |
Numeric |
Format: MM: 01 = January … 12 = December |
5 |
Origin Airport |
3 |
Character |
The three letter code identifying the airport. The airport codes are recognized by the International Air Transport Association (IATA), as used in all of the major airline reservation systems – OR – when there is no IATA code for an origin airport/point – contact the BTS/Office of Airline Information, and one will be assigned. |
6 |
Destination Airport |
3 |
Character |
The three letter code identifying the airport. The airport codes are recognized by the International Air Transport Association (IATA), as used in all of the major airline reservation systems – OR – when there is no IATA code for the destination airport/point – contact the BTS/Office of Airline Information, and one will be assigned. |
7 |
Service Class |
1 |
Character |
The Service Class Code refers to the class of service used.
F Scheduled Passenger/Cargo Service
G Scheduled All Cargo Service
L Non-Scheduled Civilian Passenger/Cargo Service
P Non-Scheduled Civilian All Cargo Service
N Non-Scheduled Military Passenger/Cargo Service
R Non-Scheduled Military All Cargo Service |
8 |
Aircraft Type |
3 |
Number |
Type of aircraft used on the non-stop segment. |
9 |
Cabin Configuration |
1 |
Number |
This code indicates the type of configuration:
1 - Passenger
2 – Cargo
3 – Passenger/Cargo
4 – Amphibious |
10 |
Departures Performed |
Up to 5 |
Number |
The number of revenue aircraft departures performed in revenue scheduled service. |
11 |
Available Payload |
Up to 10 |
Number |
Reflects total available capacity in pounds for passengers, freight, and mail applicable to the aircraft with which this flight is performed. |
12 |
Available Seats |
Up to 7 |
Number |
Reflects the actual number of seats for sale, excluding those blocked for safety or operational reasons. |
13 |
Segment Passengers |
Up to 10 |
Number |
Number of passengers originating (enplaning) the flight at the origin airport of the segment and terminating (deplaning) the flight at the destination airport of the segment. |
14 |
Segment Freight |
Up to 10 |
Number |
Amount of Freight – in pounds – originating (enplaning) the flight at the origin airport of the segment and terminating (deplaning) the flight at the destination airport of the segment. |
15 |
Segment Mail |
Up to 10 |
Number |
Amount of Mail – in pounds – originating (enplaning) the flight at the origin airport of the segment and terminating (deplaning) the flight at the destination airport of the segment. |
16 |
Scheduled Departures |
Up to 5 |
Number |
The number of aircraft departures scheduled, whether or not actually performed. |
17 |
Ramp to Ramp Minutes |
Up to 10 |
Number |
Is the total elapsed time computed from the moment the aircraft moves under its own power until it comes to rest at the next point of landing. |
18 |
Airborne Time |
Up to 10 |
Number |
Is the elapsed time computed from the moment the aircraft leaves the gro und until it touches down at the next point of landing. |
Reporting T100 Market Data - Naming Convention and File Type
The Market File naming convention is "CC_MktYY_MM.csv" where:
CC - Carrier Alpha Code
Mkt -
Indicates that file contains Market data
YY - Last two digits of the year
MM - Month
.csv - comma separated variable file type. *
* The .csv extension indicates a comma separated variable file type - where commas separate each value in a record.
EXAMPLE:
AA_Mkt02_11.csv = American Airlines, Market data for November 2002
The first record listed below indicates each of the fields in the records that follow.
There are five data records in the sample file listing below.
Each data value is separated by a comma.
Example of a Market file submission: AA_Mkt02_10.csv
DATA TYPE, ENTITY CODE,
YEAR, MONTH,
ORIG
AIRPORT, DEST
AIRPORT,
SERVICE CLASS,
MKT PAX, MKT FREIGHT, MKT MAIL
M,0A050,2002,10,JFK,IAD,F,0,0,0
M,0A050,2002,10,SLC,JFK,F,0,0,0
M,0A050,2002,10,ORD,SLC,F,0,0,0
M,0A050,2002,10,DTW,IAD,F,0,0,0
M,0A050,2002,10,LAA,LAX,F,0,0,0
T100 Market File - Record Layout and Field Description
Excel | CSV
1 |
Data Type |
1 |
Character |
"M" is used for segment data |
2 |
Entity Code |
5 |
Character |
A five-character code assigned to each air carrier that is used primarily for DOT reporting purposes. It is used to separate the Domestic, Atlantic, Latin America, and Pacific operations of each air carrier. |
3 |
Year |
4 |
Numeric |
Format: CCYY = century and year |
4 |
Month |
2 |
Numeric |
Format: MM: 01 = January … 12 = December |
5 |
Origin Airport |
3 |
Character |
The three letter code identifying the airport. The airport codes are recognized by the International Air Transport Association (IATA), as used in all of the major airline reservation systems – OR – when there is no IATA code for an origin airport/point – contact the BTS/Office of Airline Information, and one will be assigned. |
6 |
Destination Airport |
3 |
Character |
The three letter code identifying the airport. The airport codes are recognized by the International Air Transport Association (IATA), as used in all of the major airline reservation systems – OR – when there is no IATA code for the destination airport/point – contact the BTS/Office of Airline Information, and one will be assigned. |
7 |
Service Class |
1 |
Character |
The Service Class Code refers to the class of service used.
F Scheduled Passenger/Cargo Service
G Scheduled All Cargo Service
L Non-Scheduled Civilian Passenger/Cargo Service
P Non-Scheduled Civilian All Cargo Service
N Non-Scheduled Military Passenger/Cargo Service
R Non-Scheduled Military All Cargo Service |
8 |
Market Passengers |
Up to 7 |
Numeric |
Number of Passengers originating (enplaning) the flight at the origin airport and terminating (deplaning) the flight at the destination airport. |
9 |
Market Freight |
Up to 7 |
Numeric |
Amount of Freight – in pounds – originating (enplaning) the flight at the origin airport and terminating (deplaning) the flight at the destination airport. |
10 |
Market Mail |
Up to 7 |
Numeric |
Amount of Mail – in pounds – originating (enplaning) the flight at the origin airport and terminating (deplaning) the flight at the destination airport. |
|
|