Penn Computing

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

AIR_SEGMENT Table - Data Element Index

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




Data element Definition

AIR_LEG_IND

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

 

AIR_SEGMENT_ID

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

 

AIR_SEGMENT_NUM

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

A numeric value specifying the air segment number for this flight segment. 

ARRIVAL_AIRPORT_CODE

Format VARCHAR2(3)

Indexed? Yes

May be Null? Yes

The arrival airport IATA code for this air segment. 

ARRIVAL_AIRPORT_COUNTRY

Format VARCHAR2(1000)

Indexed? No

May be Null? Yes

The two character arrival airport country code for this air segment. 

ARRIVAL_AIRPORT_COUNTRY_CODE

Format VARCHAR2(2)

Indexed? Yes

May be Null? Yes

The arrival airport country for this air segment. 

ARRIVAL_AIRPORT_NAME

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The arrival airport name for this air segment. 

ARRIVAL_DATE_TIME

Format DATE

Indexed? Yes

May be Null? Yes

The arrival date/time for this air segment. 

CABIN

Format VARCHAR2(8)

Indexed? No

May be Null? Yes

The cabin class for this segment. 

CARRIER

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

The carrier code for this flght segment. 

CARRIER_LOCATOR

Format VARCHAR2(6)

Indexed? No

May be Null? Yes

The carrier record locator for this air segement. 

CARRIER_NAME

Format VARCHAR2(26)

Indexed? No

May be Null? Yes

The carrier name for this flght segment. 

CHANGE_NOTE_1

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

 

CHANGE_NOTE_2

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

 

CLASS_OF_SERVICE

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

The class of service code for this air segment. Values: Unknown 

CODE_SHARE_CARRIER

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

The code share carrier code for this air segment 

DEPARTURE_AIRPORT_CODE

Format VARCHAR2(3)

Indexed? Yes

May be Null? Yes

The departure airport IATA code for this air segment. 

DEPARTURE_AIRPORT_COUNTRY

Format VARCHAR2(1000)

Indexed? No

May be Null? Yes

The two character departure airport country code for this air segment. 

DEPARTURE_AIRPORT_COUNTRY_CODE

Format VARCHAR2(2)

Indexed? Yes

May be Null? Yes

The departure country for this air segment. 

DEPARTURE_AIRPORT_NAME

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The departure name for this air segment. 

DEPARTURE_DATE_TIME

Format DATE

Indexed? Yes

May be Null? Yes

The departure date/time for this air segment. 

DURATION

Format VARCHAR2(4)

Indexed? No

May be Null? Yes

 

FLIGHT_NUMBER

Format VARCHAR2(4)

Indexed? No

May be Null? Yes

The flight number for this air segment. 

LAST_CHANGE_DATE

Format DATE

Indexed? No

May be Null? Yes

 

LEG_SEQ_NUM

Format NUMBER

Indexed? No

May be Null? Yes

 

NEXT_AIR_ARR_CITY

Format VARCHAR2(3)

Indexed? No

May be Null? Yes

 

NEXT_AIR_DATE

Format DATE

Indexed? No

May be Null? Yes

The departure date/time of the next air segment. 

NEXT_AIR_DEP_CITY

Format VARCHAR2(3)

Indexed? No

May be Null? Yes

The departure airport IATA code of the next air segment. 

PNR_ID

Format VARCHAR2(16)

Indexed? Yes

May be Null? No

The Passenger Name Record (PNR) associated with this air segment record. 

PNR_LASTUPDATED_DATE

Format DATE

Indexed? Yes

May be Null? No

The the date that the Passenger Name Record (PNR) associated with this air 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 air segment. 

SEGMENT_SEQUENCE

Format NUMBER

Indexed? No

May be Null? Yes

 

STATUS

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

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

 
AIR_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