Penn Computing

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

CT_CC_TRANS_TRAVEL Table - Data Element Index

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



Data element Definition
CCT_KEY

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

Indexed - no
Format - number
May be null? yes
Base fare amount.
CUSTOMER_CODE

Indexed - yes
Format - varchar2(30)
May be null? yes
 
DEPARTURE_DATE

Indexed - no
Format - date
May be null? yes
Date of departure.
ETICKET_FLAG

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the ticket was an electronic ticket.
EXCHANGED_TICKET_AMT

Indexed - no
Format - number
May be null? yes
Amount of the ticket that was exchanged.
EXCHANGED_TICKET_NUM

Indexed - no
Format - varchar2(30)
May be null? yes
Number of the ticket that was exchanged.
ISSUE_DATE

Indexed - no
Format - date
May be null? yes
Date of issue of the travel ticket.
ISSUING_CARRIER

Indexed - no
Format - varchar2(20)
May be null? yes
Name of the carrier that issued the travel ticket.
LAST_MODIFIED

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

Indexed - no
Format - number
May be null? yes
Number of legs associated with the travel transaction.
PASSENGER_NAME

Indexed - no
Format - varchar2(50)
May be null? yes
Name of the passenger associated with the travel transaction.
REFUND_TICKET_NUM

Indexed - no
Format - varchar2(30)
May be null? yes
Number of the ticket that was refunded.
RESTRICTED_FLAG

Indexed - no
Format - char(1)
May be null? yes
 
TICKET_NUM

Indexed - no
Format - varchar2(32)
May be null? yes
Travel ticket number associated with the transaction.
TOTAL_FARE

Indexed - no
Format - number
May be null? yes
Total fare amount.
TOTAL_FEE

Indexed - no
Format - number
May be null? yes
Total amount of fees.
TRAVEL_AGENCY_CODE

Indexed - yes
Format - varchar2(8)
May be null? yes
Travel agency code.
TRAVEL_AGENCY_NAME

Indexed - no
Format - varchar2(50)
May be null? yes
Travel agency code.

CT_CC_TRANS_TRAVEL 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