View CSV Layout for Airlines
CSV Layout for Airlines
Airline Layout for the Hudson HWeb System
To download a blank airline csv template: browse to and select the file attachment listed to the right.
ex: bosairlines.csv, jfkairlines.csv, mcoairlines.csv, xx1airlines.csv
The airlines.csv file will contain terminal letters, numbers or names for departing and arriving flights, along with other details, such as additional arrival or departure delays (times that will be considered with calculating system pickup and drop off times).
| Letter | Title | Content Description |
| A | Key | Record Key (Usually the two letter airline identifier (AA, US, DL, CO, etc.) |
| B | Name | Airline Name (American Airlines, US Airways, Delta, Continental, etc.) |
| C | Code | Airline code – same as Key (AA, US, DL, CO, etc.) |
| D | DARRDELAY | Domestic airport terminal arrival delay |
| E | ARRDELAY | International airport terminal arrival delay |
| F | DDEPDELAY | Domestic airport terminal departure delay |
| G | DEPDELAY | International airport terminal departure delay |
| H | DARRSCHEDDELAY | Domestic arrival scheduled delay (offset) |
| I | ARRSCHEDDELAY | International arrival scheduled delay (offset) |
| J | DARRTERMINAL | Domestic arrival terminal |
| K | ARRTERMINAL | International arrival terminal |
| L | DDEPTERMINAL | Domestic departure terminal |
| M | DEPTERMINAL | International departure terminal |
| N | Notes | General airline notes field |
| O | RARRTERMINAL | Customer request arrival terminal name |
| P | OARRTERMINAL | Other arrival terminal name |
| Q | RDEPTERMINAL | Customer request departure terminal name |
| R | ODEPTERMINAL | Other departure terminal name |
| S | RARRDELAY | Customer request airport terminal arrival delay |
| T | OARRDELAY | Other airport terminal arrival delay |
| U | RDEPDELAY | Customer request airport terminal departure delay |
| V | ODEPDELAY | Other request airport terminal departure delay |
| W | RARRSCHEDDELAY | Customer request arrival scheduled delay |
| X | OARRSCHEDDELAY | Other request arrival scheduled delay |
| Y | FLIGHTNOTRIMTYPE** | <0> or <Blank>=Remove letters, <1>=Leave letters (in Tail Numbers) |
NOTE: Arrival Delay, or Departure Delay fields above are entered as positive whole integers and correspond to the number of minutes (eg 15, 20, 30, etc.) that should be added when calculating a pickup or drop-off time for that airline or terminal. These times are in addition to, and are separate from times already specified in the general airport configuration.
Arrival Delay example: American Airlines International flights arrive at a terminal that is further away from the airport based pickup location. It typically takes arriving clients an additional 10 minutes to walk the long connecting walkways to the main terminal / customs. This additional time would be set as value of < 10 > in the ARRDELAY field for American Airlines. If the general Airport configuration is already calculating the pickup time for International Arrivals at this airport for thirty minutes after flight arrival, then if the Airline is American, it will add 10 minutes to this time for a total of 40 minutes.
Departure Delay example: There is major long-term roadway construction occurring in front of a new terminal that has opened and it takes an additional 15 minutes to navigate the detours to the terminal. For all airlines that have departures at this terminal, you wish to add 15 minutes to the travel time, on all departure trips, to compensate for this time. You will therefore enter a value of < 15 > to the DARRDELAY, DDEPDELAY fields for the airlines that are located at this terminal. The system will calculate a reservation pickup time for the client that is 15 minutes earlier than customary, for this airport.
Customer Request & Other: These are additional flight “types” (in addition to Domestic and International) that are enabled in the Directions tab of the Fare and Services configuration. The delay examples, as outlined above, may also be configured for these two additional flight types / directions.