FieldTypeDescriptionExample
YEARNUMBERTravel year2022
MONTHNUMBERTravel month9
O_COUNTRYVARCHAR(2)Origin country codeUS
D_COUNTRYVARHCAR(2)Destination country codeNE
O_CITYVARCHAR(3)Origin city codeNYC
D_CITYVARCHAR(3)Destination city codeNIM
ORGVARCHAR(3)IATA airport code of the trip originJFK
DSTVARCHAR(3)IATA airport code of the trip destinationNIM
CNX1VARCHAR(3)IATA airport code of the first connecting point, if any. CDG
CNX2VARCHAR(3)IATA airport code of the second connecting point, if any.
DOM_MKT_ALVARCHAR(3)Dominant marketing airline codeDL
MKT_AL1VARCHAR(3)IATA code of the marketing airline on the first segmentDL
MKT_AL2VARCHAR(3)IATA code of the marketing airline on the second segment, if anyAF
MKT_AL3VARCHAR(3)IATA code of the marketing airline on the third segment, if any
DOM_OPT_ALVARCHAR(3)Dominant operating airline codeDL
OPT_AL1VARCHAR(3)IATA code of the operating airline on the first segmentDL
OPT_AL2VARCHAR(3)IATA code of the operating airline on the second segment, if anyAF
OPT_AL3VARCHAR(3)IATA code of the operating airline on the third segment, if any
PAXNUMBERNumber of passengers30
FARE_USDNUMBERNet fare in USD to airlines1331