| Data element |
Definition |
ADJUSTMENT_AMT
Indexed - no
Format - number
May be null? yes |
Amount the car rental charge was adjusted. |
CCT_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies a credit card transaction. |
CCTC_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies a credit card car rental transaction. |
CLASS_CODE
Indexed - no
Format - varchar2(32)
May be null? yes |
Class of the car rental. |
DAILY_RATE
Indexed - no
Format - number
May be null? yes |
Car rental rate charged per date. |
EXTRA_CHRG_AMT
Indexed - no
Format - number
May be null? yes |
Amount of extra car rental charges. |
EXTRA_CHRG_CODE
Indexed - no
Format - varchar2(6)
May be null? yes |
Code indicating the reason for extra car rental charges. |
EXTRA_MILEAGE_CHRG
Indexed - no
Format - number
May be null? yes |
Charge for extra miles traveled. |
FUEL_CHRG
Indexed - no
Format - number
May be null? yes |
Charge for fuel for the car rental. |
INSURANCE_CHRG
Indexed - no
Format - number
May be null? yes |
Charge for insurance for the car rental. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the credit card car rental transaction record was last modified. |
LATE_CHRG
Indexed - no
Format - number
May be null? yes |
Charge for late return of the car rental. |
MILE_RATE
Indexed - no
Format - number
May be null? yes |
Car rental rate charged per mile. |
NO_SHOW_FLAG
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the car rental was picked up. |
NUM_OF_CARS
Indexed - no
Format - number
May be null? yes |
Number of cars rented. |
ONE_WAY_DROP_CHRG
Indexed - no
Format - number
May be null? yes |
Charge for renting the car for a one-way, rather than round trip. |
OTHER_CHRG
Indexed - no
Format - number
May be null? yes |
Other charge for the car rental. |
PICKUP_CITY
Indexed - no
Format - varchar2(64)
May be null? yes |
City in which the car rental was picked up. |
PICKUP_COUNTRY
Indexed - yes
Format - varchar2(64)
May be null? yes |
Country in which the car rental was picked up. |
PICKUP_DATE
Indexed - no
Format - date
May be null? yes |
Date on which the car rental was picked up. |
PICKUP_STATE
Indexed - no
Format - varchar2(64)
May be null? yes |
State in which the car rental was picked up. |
REGULAR_MILEAGE_CHRG
Indexed - no
Format - number
May be null? yes |
State in which the car rental was picked up. |
RENTAL_AGREEMENT_NUM
Indexed - no
Format - varchar2(30)
May be null? yes |
Car rental agreement number. |
RENTAL_DAYS
Indexed - no
Format - number
May be null? yes |
Number of days of the car rental. |
RENTER_NAME
Indexed - no
Format - varchar2(50)
May be null? yes |
Name of the individual who rented the car. |
RETURN_CITY
Indexed - no
Format - varchar2(64)
May be null? yes |
City in which the car rental was returned. |
RETURN_COUNTRY
Indexed - yes
Format - varchar2(64)
May be null? yes |
Country in which the car rental was returned. |
RETURN_DATE
Indexed - no
Format - date
May be null? yes |
Date on which the car rental was returned. |
RETURN_STATE
Indexed - no
Format - varchar2(64)
May be null? yes |
State in which the car rental was returned. |
TOTAL_MILES
Indexed - no
Format - number
May be null? yes |
Total miles the rental car traveled. |
WEEKLY_RATE
Indexed - no
Format - number
May be null? yes |
Car rental rate charged per week. |
