• ARRIVAL_DATE
• ARRIVAL_STATION_CODE
• ARRIVAL_STATION_COUNTRY
• ARRIVAL_STATION_COUNTRY_CODE
• ARRIVAL_STATION_NAME
• CHANGE_NOTE_1
• CHANGE_NOTE_2
• CLASS_OF_SERVICE
• CONFIRMATION
• DEPARTURE_DATE
• DEPARTURE_STATION_CODE
• DEPARTURE_STATION_COUNTRY
• DEPARTURE_STATION_COUNTRY_CODE
• DEPARTURE_STATION_NAME
• LAST_CHANGE_DATE
• NEXT_RAIL_ARR_CITY
• NEXT_RAIL_DATE
• NEXT_RAIL_DEP_CITY
• PNR_ID
• PNR_LAST_UPDATED_DATE
• RAIL_OPERATOR
• RAIL_SEGMENT_ID
• RATE_CURR_CODE
• RATE_QUOTE
• SEGMENT_NUMBER
• STATUS
• TRAIN_NUMBER

ARRIVAL_DATE

Format DATE

Indexed? Yes

May be Null? Yes

The arrival date/time for this rail segment. 

ARRIVAL_STATION_CODE

Format VARCHAR2(3)

Indexed? Yes

May be Null? Yes

The arrival station IATA code for this rail segment. 

ARRIVAL_STATION_COUNTRY

Format VARCHAR2(1000)

Indexed? No

May be Null? Yes

The arrival station country for this rail segment. 

ARRIVAL_STATION_COUNTRY_CODE

Format VARCHAR2(2)

Indexed? Yes

May be Null? Yes

The two character arrival station country code for this rail segment. 

ARRIVAL_STATION_NAME

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The arrival station name for this rail segment. 

CHANGE_NOTE_1

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

CHANGE_NOTE_2

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

CLASS_OF_SERVICE

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

The class of service code for this rail segment 

CONFIRMATION

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

DEPARTURE_DATE

Format DATE

Indexed? Yes

May be Null? Yes

The departure date/time for this rail segment. 

DEPARTURE_STATION_CODE

Format VARCHAR2(3)

Indexed? No

May be Null? Yes

The departure station IATA code for this rail segment. 

DEPARTURE_STATION_COUNTRY

Format VARCHAR2(1000)

Indexed? No

May be Null? Yes

The departure station country for this rail segment. 

DEPARTURE_STATION_COUNTRY_CODE

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

The two character departure station country code for this rail segment. 

DEPARTURE_STATION_NAME

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The departure station name for this rail segment. 

LAST_CHANGE_DATE

Format DATE

Indexed? No

May be Null? Yes

NEXT_RAIL_ARR_CITY

Format VARCHAR2(3)

Indexed? No

May be Null? Yes

NEXT_RAIL_DATE

Format DATE

Indexed? No

May be Null? Yes

The departure date/time of the next rail segment. 

NEXT_RAIL_DEP_CITY

Format VARCHAR2(3)

Indexed? No

May be Null? Yes

The departure airport IATA code of the next rail segment. 

PNR_ID

Format VARCHAR2(16)

Indexed? Yes

May be Null? No

The Passenger Name Record (PNR) associated with this phone number. 

PNR_LAST_UPDATED_DATE

Format DATE

Indexed? Yes

May be Null? No

The the date that the Passenger Name Record (PNR) associated with this phone number record was last updated. 

RAIL_OPERATOR

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

RAIL_SEGMENT_ID

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

RATE_CURR_CODE

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

RATE_QUOTE

Format NUMBER

Indexed? No

May be Null? Yes

SEGMENT_NUMBER

Format NUMBER

Indexed? Yes

May be Null? No

A numeric value specifying the itinerary segment number for this rail segment. 

STATUS

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

The two character status code for this rail segment. Values: Unknown 

TRAIN_NUMBER

Format VARCHAR2(4)

Indexed? No

May be Null? Yes

The train number associated with this rail segment.