• BOOKING_SOURCE
• CONFIRMATION_NUMBER
• COVERAGE_AMT
• COVERAGE_CURR_CODE
• DATE_INSURANCE_BEGINS
• DATE_INSURANCE_ENDS
• DEPARTURE_CITY
• DEPARTURE_COUNTRY
• DEPARTURE_COUNTRY_CODE
• DESTINATION_CITY
• DESTINATION_COUNTRY
• DESTINATION_COUNTRY_CODE
• INSURANCE_SEGMENT_ID
• NUMBER_OF_POLICIES
• PLACE_OF_ISSUE
• PNR_ID
• PNR_LAST_UPDATED_DATE
• PREMIUM_AMT
• PREMIUM_CURR_CODE
• PREMIUM_TAX_AMT
• PREMIUM_TAX_CURR_CODE
• PURCHASE_DATE
• SEGMENT_NUMBER
• STATUS
• VENDOR_CODE
• VENDOR_NAME

BOOKING_SOURCE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

CONFIRMATION_NUMBER

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

COVERAGE_AMT

Format NUMBER

Indexed? No

May be Null? Yes

COVERAGE_CURR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

DATE_INSURANCE_BEGINS

Format DATE

Indexed? Yes

May be Null? Yes

DATE_INSURANCE_ENDS

Format DATE

Indexed? Yes

May be Null? Yes

DEPARTURE_CITY

Format VARCHAR2(30)

Indexed? Yes

May be Null? Yes

DEPARTURE_COUNTRY

Format VARCHAR2(1000)

Indexed? Yes

May be Null? Yes

DEPARTURE_COUNTRY_CODE

Format VARCHAR2(2)

Indexed? Yes

May be Null? Yes

DESTINATION_CITY

Format VARCHAR2(30)

Indexed? Yes

May be Null? Yes

DESTINATION_COUNTRY

Format VARCHAR2(1000)

Indexed? Yes

May be Null? Yes

DESTINATION_COUNTRY_CODE

Format VARCHAR2(2)

Indexed? Yes

May be Null? Yes

INSURANCE_SEGMENT_ID

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

NUMBER_OF_POLICIES

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

PLACE_OF_ISSUE

Format VARCHAR2(30)

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 insurance 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 insurance segment record was last updated. 

PREMIUM_AMT

Format NUMBER

Indexed? No

May be Null? Yes

PREMIUM_CURR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

PREMIUM_TAX_AMT

Format NUMBER

Indexed? No

May be Null? Yes

PREMIUM_TAX_CURR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

PURCHASE_DATE

Format DATE

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 insurance segment. 

STATUS

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

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

VENDOR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

VENDOR_NAME

Format VARCHAR2(30)

Indexed? No

May be Null? Yes