| Field | Type | Description | Example |
|---|---|---|---|
| YEAR | NUMBER | Travel year | 2022 |
| MONTH | NUMBER | Travel month | 9 |
| O_COUNTRY | VARCHAR(2) | Origin country code | US |
| D_COUNTRY | VARHCAR(2) | Destination country code | NE |
| O_CITY | VARCHAR(3) | Origin city code | NYC |
| D_CITY | VARCHAR(3) | Destination city code | NIM |
| ORG | VARCHAR(3) | IATA airport code of the trip origin | JFK |
| DST | VARCHAR(3) | IATA airport code of the trip destination | NIM |
| CNX1 | VARCHAR(3) | IATA airport code of the first connecting point, if any. | CDG |
| CNX2 | VARCHAR(3) | IATA airport code of the second connecting point, if any. | |
| DOM_MKT_AL | VARCHAR(3) | Dominant marketing airline code | DL |
| MKT_AL1 | VARCHAR(3) | IATA code of the marketing airline on the first segment | DL |
| MKT_AL2 | VARCHAR(3) | IATA code of the marketing airline on the second segment, if any | AF |
| MKT_AL3 | VARCHAR(3) | IATA code of the marketing airline on the third segment, if any | |
| DOM_OPT_AL | VARCHAR(3) | Dominant operating airline code | DL |
| OPT_AL1 | VARCHAR(3) | IATA code of the operating airline on the first segment | DL |
| OPT_AL2 | VARCHAR(3) | IATA code of the operating airline on the second segment, if any | AF |
| OPT_AL3 | VARCHAR(3) | IATA code of the operating airline on the third segment, if any | |
| PAX | NUMBER | Number of passengers | 30 |
| FARE_USD | NUMBER | Net fare in USD to airlines | 1331 |
Flight BI
Flight Business Intelligence