Penn Computing

University of Pennsylvania
Penn Computing << go backback
INSURANCE_SEGMENT Table    Tables and Data Elements   World Travel Home   Data Warehouse Home

INSURANCE_SEGMENT Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.




Data element Definition

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

 

 
INSURANCE_SEGMENT Table    Tables and Data Elements   World Travel Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania