CT_CC_TRANS_TRAVEL_DETAIL Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home

CT_CC_TRANS_TRAVEL_DETAIL Table

Explanation
The CT_CC_TRANS_TRAVEL_DETAIL table contacts additional details related to travel expenses charged on the Penn Travel Card and applied to expense reports.

Common Uses
Reviewing additional detail about travel charge expenses.

CCTTD_KEY

CARRIER_CODE
CCT_KEY
CCTTD_KEY

CT_CC_TRANS_TRAVEL (DWGL)
CT_CREDIT_CARD_TRANSACTION (DWGL)

Cautions

• CT_CC_TRANS_TRAVEL_DETAIL contains only travel detail transactions charged on the Penn Travel Card; charges incurred on other cards are not available in this table.
• The CT_CC_TRANS_TRAVEL table contains summary information (e.g., ticket number and fees) about travel charge transactions.
• The CT_CC_TRANS_TRAVEL_DETAIL table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_CC_TRANS_TRAVEL_DETAIL Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home