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.

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