Penn Computing

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

CAR_SEGMENT Table - Data Element Index

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




Data element Definition

APPROVER

Format VARCHAR(8)

Indexed? No

May be Null? Yes

 

BASE_RATE_AMT

Format VARCHAR(6)

Indexed? No

May be Null? Yes

The base rental rate amount for this car segment. 

BASE_RATE_CURR_CODE

Format VARCHAR(3)

Indexed? No

May be Null? Yes

The base rental rate currency code for this car segment. 

CAR_COMPANY

Format VARCHAR(2)

Indexed? No

May be Null? Yes

The two character rental car company code for this car segment. 

CAR_COMPANY_NAME

Format VARCHAR(1000)

Indexed? No

May be Null? Yes

The rental car company name for this car segment. 

CAR_RATE_CATEGORY

Format VARCHAR(7)

Indexed? No

May be Null? Yes

The rental rate category for this car segment. Values: 

CAR_SEGMENT_ID

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

 

CD_NUMBER

Format VARCHAR(9)

Indexed? No

May be Null? Yes

 

CONFIRMATION

Format VARCHAR(15)

Indexed? No

May be Null? Yes

The confirmation number for this car segment. 

DECLINED_AMT

Format NUMBER

Indexed? No

May be Null? Yes

 

DECLINED_VENDOR_CODE

Format VARCHAR(7)

Indexed? No

May be Null? Yes

 

DROPOFF_CITY_CODE

Format VARCHAR(3)

Indexed? Yes

May be Null? Yes

The dropoff city IATA code for this car segment. 

DROPOFF_CITY_NAME

Format VARCHAR(1000)

Indexed? No

May be Null? Yes

The dropoff city name for this car segment. 

DROPOFF_COUNTRY

Format VARCHAR2(1000)

Indexed? No

May be Null? Yes

The dropoff country name for this car segment. 

DROPOFF_COUNTRY_CODE

Format VARCHAR2(2)

Indexed? Yes

May be Null? Yes

The two character dropoff country code for this car segment. 

DROPOFF_DATE_TIME

Format DATE

Indexed? Yes

May be Null? Yes

The dropoff date/time for this car segment. 

DROPOFF_LOCATION_CODE

Format VARCHAR(9)

Indexed? Yes

May be Null? Yes

 

EXCEPTION_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

 

ID_NUMBER

Format VARCHAR(11)

Indexed? No

May be Null? Yes

 

IN_POLICY

Format VARCHAR(1)

Indexed? No

May be Null? Yes

 

MISC_1

Format VARCHAR(200)

Indexed? No

May be Null? Yes

 

MISC_2

Format VARCHAR(200)

Indexed? No

May be Null? Yes

 

PHONE_NUMBER

Format VARCHAR(12)

Indexed? No

May be Null? Yes

 

PICKUP_CITY_CODE

Format VARCHAR(3)

Indexed? Yes

May be Null? Yes

The pickup city IATA code for this car segment. 

PICKUP_CITY_NAME

Format VARCHAR(1000)

Indexed? No

May be Null? Yes

The pickup city name for this car segment. 

PICKUP_COUNTRY

Format VARCHAR2(1000)

Indexed? No

May be Null? Yes

The pickup country name for this car segment. 

PICKUP_COUNTRY_CODE

Format VARCHAR2(2)

Indexed? Yes

May be Null? Yes

The two character pickup country code for this car segment. 

PICKUP_DATE_TIME

Format DATE

Indexed? Yes

May be Null? Yes

The pickup date/time for this car segment. 

PICKUP_LOCATION_CODE

Format VARCHAR(25)

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

POLICY_EXCEPTION_RMK

Format VARCHAR(200)

Indexed? No

May be Null? Yes

 

POLICY_THRESHOLD

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

 

POLICY_VIOLATION_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

 

RATE_CODE

Format VARCHAR(6)

Indexed? No

May be Null? Yes

 

RATE_TEXT

Format VARCHAR(200)

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

STATUS

Format VARCHAR(2)

Indexed? No

May be Null? Yes

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

VEHICLE_CODE

Format VARCHAR(4)

Indexed? No

May be Null? Yes

 

 
CAR_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