Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_CC_TRANS_TRAVEL_DTL Table   Tables and Data Elements   Travel & Expense Management Home    Data Warehouse Home

CT_CC_TRANS_TRAVEL_DTL Table - Data Element Index

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

 



Data element Definition
ARRIVAL_COUNTRY

Indexed - no
Format - varchar2(64)
May be null? yes
Country of arrival for this leg of travel.
ARRIVAL_DATE

Indexed - no
Format - date
May be null? yes
Arrival date for this leg of travel.
ARRIVAL_LOCATION

Indexed - no
Format - varchar2(64)
May be null? yes
Arrival location for this leg of travel.
CARRIER_CODE

Indexed - yes
Format - varchar2(2)
May be null? yes
Travel carrier code for this leg of travel.
CCT_KEY

Indexed - yes
Format - number
May be null? yes
Unique system-assigned key that identifies a credit card transaction.
CCTTD_KEY

Indexed - yes
Format - number
May be null? no
Unique system-assigned key that identifies a credit card travel detail transaction.
CONJUNCTION_TICKET_NUM

Indexed - no
Format - varchar2(32)
May be null? yes
Conjunction ticket number.
DEPARTURE_COUNTRY

Indexed - no
Format - varchar2(64)
May be null? yes
Country of departure for this leg of travel.
DEPARTURE_DATE

Indexed - no
Format - date
May be null? yes
Departure date for this leg of travel.
DEPARTURE_LOCATION

Indexed - no
Format - varchar2(64)
May be null? yes
Departure location for this leg of travel.
DESTINATION_FLAG

Indexed - no
Format - char(1)
May be null? yes
Indicates whether this leg was the overall trip destination point.
EXCHANGE_TICKET_NUM

Indexed - no
Format - varchar2(32)
May be null? yes
Exchanged ticket number.
FARE

Indexed - no
Format - number
May be null? yes
Fare amount for this leg of travel.
FEE

Indexed - no
Format - number
May be null? yes
Fee amount for this leg of travel.
FLIGHT_NUM

Indexed - no
Format - varchar2(5)
May be null? yes
Flight number for this leg of travel.
FOREIGN_ARRIVAL_FLAG

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the arrival for this leg of travel was in a foreign country.
FOREIGN_DEPARTURE_FLAG

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the departure for this leg of travel was from a foreign country.
LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the credit card travel transaction detail record was last modified.
ORIGINATION_FLAG

Indexed - no
Format - char(1)
May be null? yes
Indicates whether this leg was the overall trip origination point.
SERVICE_CLASS

Indexed - no
Format - varchar2(8)
May be null? yes
Class of travel service for this leg of travel.
TRAVEL_LEG_NUM

Indexed - no
Format - number
May be null? yes
Travel leg number associated with the detail transaction.

CT_CC_TRANS_TRAVEL_DTL Table   Tables and Data Elements   Travel & Expense Management 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