Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_CC_TRANS_CAR_RENTAL Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home

CT_CC_TRANS_CAR_RENTAL Table

Explanation
The CT_CC_TRANS_CAR_RENTAL table contains details related to car rentals charged on the Penn Travel Card and applied to expense reports.

Common Uses
Reviewing car rental expense details.

Primary Key Indexed Data Elements Related Tables
CCTC_KEY
CCT_KEY
CCTC_KEY
PICKUP_COUNTRY
RETURN_COUNTRY
CT_COUNTRY (DWGL)
CT_CREDIT_CARD_TRANSACTION (DWGL)
CT_REPORT_ENTRY (DWGL)

Cautions

  • CT_CC_TRANS_CAR_RENTAL contains only car rental transactions charged on the Penn Travel Card; charges incurred on other cards are not available in this table.
  • The CT_CC_TRANS_CAR_RENTAL table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_CC_TRANS_CAR_RENTAL Table - Data Element Index   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