| Field | Type | Description | Example |
|---|---|---|---|
| YYMM | VARCHAR(4) | Travel year and travel month in the YYMM format | 2309 |
| OWAC | VARCHAR(3) | Origin world area code (a unique code for each state within the US and each country outside the US) | 022 |
| DWAC | VARHCAR(3) | Destination world area code | 554 |
| ORG | VARCHAR(3) | IATA airport code of the trip origin | JFK |
| DST | VARCHAR(3) | IATA airport code of the trip destination | NIM |
| STATION2 | VARCHAR(3) | IATA airport code of the first connecting point, if any, or the destination airport | CDG |
| STATION3 | VARCHAR(3) | IATA airport code of the second connecting point, if any, or the destination airport | NIM |
| STATION4 | VARCHAR(3) | IATA airport code of the third connecting point, if any, or the destination airport | |
| 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 | NUMBER | Net fare in USD to airlines | 1331 |
| LOAD_DATE | DATE | Date when the data is loaded | 2023-11-15 |
Flight BI
Flight Business Intelligence