| Data element |
Definition |
ARRIVAL_CITY_CODE
Format VARCHAR2(9)
Indexed? Yes
May be Null? Yes |
The arrival city IATA code for this miscellaneoussegment. |
ARRIVAL_CITY_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The two character arrival city country code for this miscellaneoussegment. |
ARRIVAL_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
The arrival country for this miscellaneoussegment. |
ARRIVAL_COUNTRY_CODE
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
The arrival country name for this miscellaneoussegment. |
CHECK_IN_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The check-in date/time for this miscellaneoussegment. |
CLASS_OF_SERVICE
Format VARCHAR2(9)
Indexed? No
May be Null? Yes |
The class of service code for this miscellaneous segment.
Values: Unknown |
DEPARTURE_CITY_CODE
Format VARCHAR2(9)
Indexed? Yes
May be Null? Yes |
The departure city IATA code for this miscellaneoussegment. |
DEPARTURE_CITY_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The two character departure city country code for this miscellaneoussegment. |
DEPARTURE_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
The departure country for this miscellaneoussegment. |
DEPARTURE_COUNTRY_CODE
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
The departure country name for this miscellaneoussegment. |
DEPARTURE_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The check-out date/time for this miscellaneoussegment. |
MISC_OPERATOR
Format VARCHAR2(9)
Indexed? No
May be Null? Yes |
|
NUMBER_IN_PARTY
Format VARCHAR2(1)
Indexed? No
May be Null? Yes |
|
PNR_ID
Format VARCHAR2(16)
Indexed? Yes
May be Null? No |
The Passenger Name Record (PNR) associated with this miscellanous segment record. |
PNR_LAST_UPDATED_DATE
Format DATE
Indexed? Yes
May be Null? No |
The the date that the Passenger Name Record (PNR) associated with this miscellanous 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 miscellanous segment. |
STATUS
Format VARCHAR2(2)
Indexed? No
May be Null? Yes |
The two character status code for this miscellanous segment.
Values: Unknown |
