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; = 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 |