-
Notifications
You must be signed in to change notification settings - Fork 0
/
Data-Dictionary-Avaition.ecl
56 lines (56 loc) · 5.74 KB
/
Data-Dictionary-Avaition.ecl
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
STRING3 Carrier; // two or three letter code assigned by IATA or ICAO for the Carrier
INTEGER2 FlightNumber; // flight number
STRING1 CodeShareFlag; // service type indicator is used to classify carriers according to the type of air service they provide
STRING3 CodeShareCarrier; // alternate flight designator or ticket selling airline
STRING1 ServiceType; // classify carriers according to the type of air service they provide
STRING8 EffectiveDate; // effective date represents the date that the carrier has scheduled this flight service to begin; YYYYMMDD
STRING8 DiscontinueDate; // discontinued date represents the last date that the carrier has scheduled this flight service to operate; YYYYMMDD
UNSIGNED1 IsOpMon; // indicates whether the flight has service on Monday
UNSIGNED1 IsOpTue; // indicates whether the flight has service on Tuesday
UNSIGNED1 IsOpWed; // indicates whether the flight has service on Wednesday
UNSIGNED1 IsOpThu; // indicates whether the flight has service on Thursday
UNSIGNED1 IsOpFri; // indicates whether the flight has service on Friday
UNSIGNED1 IsOpSat; // indicates whether the flight has service on Saturday
UNSIGNED1 IsOpSun; // indicates whether the flight has service on Sunday
STRING3 DepartStationCode; // standard IATA Airport code for the point of trip origin
STRING2 DepartCountryCode; // standard IATA Country code for the point of trip origin
STRING2 DepartStateProvCode; // Innovata State Code
STRING3 DepartCityCode; // departure city code contains the city code for the point of trip origin
STRING10 DepartTimePassenger; // published flight departure time; HHMMSS
STRING10 DepartTimeAircraft; // agreed SLOT departure time; HHMMSS
STRING5 DepartUTCVariance; // UTC Variant for the departure airport; [+-]HHMM
STRING2 DepartTerminal; // departure terminal
STRING3 ArriveStationCode; // standard IATA Airport code for the point of arrival
STRING2 ArriveCountryCode; // standard IATA Country code for the point of arrival
STRING2 ArriveStateProvCode; // Innovata State Code
STRING3 ArriveCityCode; // arrival city code contains the city code for the point of trip origin
STRING10 ArriveTimePassenger; // published flight arrival time; HHMMSS
STRING10 ArriveTimeAircraft; // agreed SLOT arrival time; HHMMSS
STRING5 ArriveUTCVariance; // UTC Variant for the arrival airport; [+-]HHMM
STRING2 ArriveTerminal; // arrival terminal
STRING3 EquipmentSubCode; // sub aircraft type on the first leg of the flight
STRING3 EquipmentGroupCode; // group aircraft type on the first leg of the flight
VARSTRING4 CabinCategoryClasses; // most commonly used service classes
VARSTRING40 BookingClasses; // full list of Service Class descriptions
INTEGER1 ArriveDayIndicator; // signifies which day the flight will arrive with respect to the origin depart day; <blank> = same day, -1 = day before, 1 = day after, 2 = two days after
INTEGER1 NumberOfIntermediateStops; // set to zero (i.e. nonstop) if the flight does not land between the point of origin and final destination
VARSTRING50 IntermediateStopStationCodes; // IATA airport codes where stops occur, separated by “!”
BOOLEAN IsEquipmentChange; // signifies whether there has been an aircraft change at a stopover point for the flight leg
VARSTRING60 EquipmentCodesAcrossSector; // sub-aircraft type on each leg of the flight
VARSTRING80 MealCodes; // contains up to two meal codes per class of service
INTEGER2 FlightDurationLessLayover; // fefers to Actual Air time of flight; does not include layover time
INTEGER2 FlightDistance; // shortest distance (in miles) between the origin and destination points
INTEGER2 FlightDistanceThroughIndividualLegs;
INTEGER2 LayoverTime; // minutes
INTEGER2 IVI;
INTEGER2 FirstLegNumber;
VARSTRING50 InFlightServiceCodes;
BOOLEAN IsCodeShare; // true if flight is operated by another carrier
BOOLEAN IsWetLease; // true if wet lease (owned by one carrier and operated by another)
VARSTRING155 CodeShareInfo; // information regarding operating and marketing carriers
INTEGER FirstClassSeats;
INTEGER BusinessClassSeats;
INTEGER PremiumEconomySeats;
INTEGER EconomyClassSeats;
INTEGER TotalSeats;
UNSIGNED SectorizedId; // unique record I