Penn Computing

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

SEAT Table - Data Element Index

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




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 

 
SEAT 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