| Data element |
Definition |
| Airline Indexed - no
Format - Varchar2(1000)
May be Null? Y | Name of the airline used by an individual for a Travel Leg. |
| Airline_Code Indexed - no
Format - Varchar2(10)
May be Null? Y | 2 character Airline code. ie) "UA" = United Airlines |
| Airline_Id Indexed - no
Format - Number
May be Null? Y | Unique identifier for an Airline in the LOV table.
(Airline.ID) |
| Arrival_Airport Indexed - no
Format - Varchar2(200)
May be Null? Y | Airport name of arrival. For example, "Logan International", "John F Kennedy Intl", "Heathrow". |
| Arrival_Airport_Code Indexed - no
Format - Varchar2(3)
May be Null? Y | Airport code of arrival. For example, "BOS", "JFK","LHR". |
| Arrival_City Indexed - no
Format - Varchar2(500)
May be Null? Y | Arrival City. |
| Arrival_Country Indexed - no
Format - Varchar2(1000)
May be Null? Y | Country of arrival. For example, "United Kingdom", "United States", "South Africa". |
| Arrival_Country_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Country code of arrival. For example, "GB", "US", "ZA". |
| Arrival_Date Indexed - no
Format - Date
May be Null? Y | Arrival date/ End date of a Travel Leg. |
| Arrival_Region Indexed - no
Format - Varchar2(1000)
May be Null? Y | Region of arrival. |
| Departure_Airport Indexed - no
Format - Varchar2(200)
May be Null? Y | Airport name of departure. For example, "Logan International", "John F Kennedy Intl", "Heathrow". |
| Departure_Airport_Code Indexed - no
Format - Varchar2(3)
May be Null? Y | Airport code of departure. For example, "BOS", "JFK","LHR". |
| Departure_City Indexed - no
Format - Varchar2(500)
May be Null? Y | Departure City. |
| Departure_Country Indexed - no
Format - Varchar2(1000)
May be Null? Y | Country of departure. For example, "United Kingdom", "United States", "South Africa". |
| Departure_Country_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Country code of departure. For example, "GB", "US", "ZA". |
| Departure_Date Indexed - no
Format - Date
May be Null? Y | Departure date/ Starting date of a Travel Leg. |
| Departure_Region Indexed - no
Format - Varchar2(1000)
May be Null? Y | Region of departure. |
| Group_Trip_Id Indexed - no
Format - Number
May be Null? Y | Group Trip Id (optional) related to the Individual Trip Travel Leg. |
| Individual_Travel_Leg_Id Indexed - no
Format - Number
May be Null? N | Unique identifier for an Individual Trip Travel Leg. |
| Individual_Trip_Id Indexed - no
Format - Number
May be Null? Y | Unique identifier for an Individual Trip |
| Individual_Trip_Traveler_Id Indexed - no
Format - Number
May be Null? Y | Person identifier for the Individual trip traveler. |
| Transportation_Notes Indexed - no
Format - Varchar2(4000)
May be Null? Y | Notes from a Travel Leg. |
| Transportation_Number Indexed - no
Format - Varchar2(100)
May be Null? Y | Number that identifies the individual on a Travel Leg. For example, the Flight number for airline travel, or a train number, bus route number, etc. |
| Travel_Mode Indexed - no
Format - Varchar2(1000)
May be Null? Y | Description of the Travel mode. |
