| Data element |
Definition |
PASSENGER_ID
Format VARCHAR2(30)
Indexed? Yes
May be Null? Yes |
|
PNR_ID
Format VARCHAR2(16)
Indexed? Yes
May be Null? No |
The Passenger Name Record (PNR) associated with this seat. |
PNR_LAST_UPDATED_DATE
Format DATE
Indexed? Yes
May be Null? No |
The the date that the Passenger Name Record (PNR) associated with this seat record was last updated. |
SEAT_LOCATION
Format VARCHAR2(3)
Indexed? No
May be Null? Yes |
The seat number associated with this itinerary segment. |
SEAT_TYPE
Format VARCHAR2(13)
Indexed? No
May be Null? Yes |
The seat type associated with this itinerary segment.
Values:
Asile
Window |
SEGMENT_NUMBER
Format NUMBER
Indexed? Yes
May be Null? No |
A numeric value specifying the itinerary segment number for this seat. |
STATUS
Format VARCHAR2(2)
Indexed? No
May be Null? Yes |
The two character status code for this seat.
Values: Unknown |
