.  
Traffic unique identifier – TrafficId
This field is controlled by Access. It is an auto number.

.  
Sources application (“ETMS”) – Sources
This field stores the source application name.

.  
Fluid code – Fluid This field is a combination of three other fields using a predefined formula: Fluid = CCCCCCCAAAAYYMMDDHHNN, where CCCCCCC = call sign, AAAA = departure airport and YYMMDDHHNN is the departure time in <yymmddhhnn> format. If the call sign length for example is smaller than 7, then the rest of the CCCCCCC value is filled with “-”. The same procedure is used for departure airport.

2.2. ETMS flight legs text file (Flight_chord.txt)

If the text file name is Flight_20001005 then this file contains all flight legs that belong to the flight heads, which are saved in the Traffic_20001005.txt file. The file’s structure is given in Table 56.
Table 56: ETMS flight text file.

Field Name  Description 
1  Init_char  Currently not used 
2  Flight_key  Combination of the ETMS-generated flight_UID and the flight_id 
3  Flight_date  The date that the fight operated 
4  Msg_time  The timestamp (curr_time, in Zulu time) for the message 
5  Lat  Latitude in minutes 
6  Lon  Longitude in minutes 
7  Center  The single letter code for the Center reporting the message 
8  DeltaLat  The difference between the latitude of this message and the latitude of the previous message 
9  DeltaLon  The difference between the longitude of this message and the longitude of the previous message 
10  AvgAlt  The average of reported altitudes between this message and the previous message 
11  AltType  The type of altitude 
12  AvgSpeed  The average of reported ground speeds between this message and the previous message (knots) 
13  ActMiles  Actual nautical miles traveled between the location of this message and the location of the previous message 
14  SlMiles  Straight line nautical miles between the location of this message and the location of the previous message 
15  ReasonCode  Code used for debugging 

Below is a sample of the file’s content:

1 2 3 4 5 6 7 8 9 10
P,000000EGF551,2000-10-04 00:00:00,2000-10-04 02:23:00,2393,-4956,I, 3,25,79,

P,000000EGF551,2000-10-04 00:00:00,2000-10-04 02:19:00,2390,-4931,I,-1,29,100,

1112 13 14 15

C,262,19,19,5

C,340,22,22,5

Fields underlined in red are the only ones to be imported:
.  
2 – Flight_key – CallSign
This field remains unchanged.

.  
4 – Msg_time – EventTime
This field remains unchanged.

.  
5 – Lat – Latitude
This field remains unchanged.

.  
6 – Lon – Longitude
This field remains unchanged.

.  
10 – AvgAlt – FlightLevel
This field remains unchanged.

.  
12 – AvgSpeed – GroundSpeed
This field remains unchanged.

Beside these 6 fields, in the traffic table will be inserted another 4 fields:
.  
Unique identifier – UniqueID The single use for this field is to provide consecutive numbers to two consecutive flight legs of the same flight. It is an auto number.

.  
Traffic identifier – TrafficId
This field links flight legs with the flight heads from the traffic table.
　
中國航空網 www.k6050.com
航空翻譯 www.aviation.cn
本文鏈接地址：AERO2K Flight Movement Inventory Project Report(56)