| Data element |
Definition |
AIR_LEG_IND
Format VARCHAR2(9)
Indexed? No
May be Null? Yes |
|
AIR_SEGMENT_ID
Format VARCHAR2(9)
Indexed? No
May be Null? Yes |
|
AIR_SEGMENT_NUM
Format VARCHAR2(2)
Indexed? No
May be Null? Yes |
A numeric value specifying the air segment number for this flight segment. |
ARRIVAL_AIRPORT_CODE
Format VARCHAR2(3)
Indexed? Yes
May be Null? Yes |
The arrival airport IATA code for this air segment. |
ARRIVAL_AIRPORT_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
The two character arrival airport country code for this air segment. |
ARRIVAL_AIRPORT_COUNTRY_CODE
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
The arrival airport country for this air segment. |
ARRIVAL_AIRPORT_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The arrival airport name for this air segment. |
ARRIVAL_DATE_TIME
Format DATE
Indexed? Yes
May be Null? Yes |
The arrival date/time for this air segment. |
CABIN
Format VARCHAR2(8)
Indexed? No
May be Null? Yes |
The cabin class for this segment. |
CARRIER
Format VARCHAR2(2)
Indexed? No
May be Null? Yes |
The carrier code for this flght segment. |
CARRIER_LOCATOR
Format VARCHAR2(6)
Indexed? No
May be Null? Yes |
The carrier record locator for this air segement. |
CARRIER_NAME
Format VARCHAR2(26)
Indexed? No
May be Null? Yes |
The carrier name for this flght segment. |
CHANGE_NOTE_1
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
CHANGE_NOTE_2
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
CLASS_OF_SERVICE
Format VARCHAR2(2)
Indexed? No
May be Null? Yes |
The class of service code for this air segment.
Values: Unknown |
CODE_SHARE_CARRIER
Format VARCHAR2(9)
Indexed? No
May be Null? Yes |
The code share carrier code for this air segment |
DEPARTURE_AIRPORT_CODE
Format VARCHAR2(3)
Indexed? Yes
May be Null? Yes |
The departure airport IATA code for this air segment. |
DEPARTURE_AIRPORT_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
The two character departure airport country code for this air segment. |
DEPARTURE_AIRPORT_COUNTRY_CODE
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
The departure country for this air segment. |
DEPARTURE_AIRPORT_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The departure name for this air segment. |
DEPARTURE_DATE_TIME
Format DATE
Indexed? Yes
May be Null? Yes |
The departure date/time for this air segment. |
DURATION
Format VARCHAR2(4)
Indexed? No
May be Null? Yes |
|
FLIGHT_NUMBER
Format VARCHAR2(4)
Indexed? No
May be Null? Yes |
The flight number for this air segment. |
LAST_CHANGE_DATE
Format DATE
Indexed? No
May be Null? Yes |
|
LEG_SEQ_NUM
Format NUMBER
Indexed? No
May be Null? Yes |
|
NEXT_AIR_ARR_CITY
Format VARCHAR2(3)
Indexed? No
May be Null? Yes |
|
NEXT_AIR_DATE
Format DATE
Indexed? No
May be Null? Yes |
The departure date/time of the next air segment. |
NEXT_AIR_DEP_CITY
Format VARCHAR2(3)
Indexed? No
May be Null? Yes |
The departure airport IATA code of the next air segment. |
PNR_ID
Format VARCHAR2(16)
Indexed? Yes
May be Null? No |
The Passenger Name Record (PNR) associated with this air segment record. |
PNR_LASTUPDATED_DATE
Format DATE
Indexed? Yes
May be Null? No |
The the date that the Passenger Name Record (PNR) associated with this air segment record was last updated. |
SEGMENT_NUMBER
Format NUMBER
Indexed? Yes
May be Null? No |
A numeric value specifying the itinerary segment number for this air segment. |
SEGMENT_SEQUENCE
Format NUMBER
Indexed? No
May be Null? Yes |
|
STATUS
Format VARCHAR2(2)
Indexed? No
May be Null? Yes |
The two character status code for this air segment.
Values: Unknown |
