Navigation

 ·   Wiki Home
 ·   Wiki Help
 ·   Categories
 ·   Title List
 ·   Uncategorized Pages
 ·   Random Page
 ·   Recent Changes
 ·   RSS
 ·   Atom
 ·   What Links Here

Active Members:

Search:

 

Create or Find Page:

 

View CSV Layout for Airlines

Category:File Layouts

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.

Filename: {xxx}airlines.[csv/db] where xxx = Airport Code

ex:  bosairlines.csv, jfkairlines.csv, mcoairlines.csv, xx1airlines.csv

The Airlines csv file is used to identify the airlines (and other data) that service each configured airport. Generally, each airport fare file will have its own unique and corresponding airlines.csv file.  For example.  bosfares.csv will contain a listing of services and fares offered to/from Boston Logan Airport.  bosairlines.csv will contain a listing of the airlines that arrive / depart from Boston Logan Airport.  Manchester airport will have mhtfares.csv and mhtairlines.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.

**FLIGHTNOTRIMTYPE: This value determines if the FlightNumber field on the HWeb Agent, Fare and Availability screen, will contain a commercial airline flight number (value will be set to <0> or <> (blank) on the csv, or will contain the Tail Number from a private aircraft  (value will be set to  <1>).  

If the value is set to <0>, and the reservations agent were to enter DL210 as a flight number,  the DL will be stripped when submitting to a flight status lookup supplier.

If the value is set to <1>, and the reservations agent were to enter a tail number N298W in the Flight Number field, the entire string, including letters, will be submitted.
 

 

Categories: