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

CT_CREDIT_CARD_TRANSACTION Table

Explanation
The CT_CREDIT_CARD_TRANSACTION table contains information about transactions charged on the Penn Travel Card and applied to expense reports.

Common Uses
Reviewing charge expense details.

CCT_KEY

CA_KEY
CCA_KEY
CCT_KEY
CCT_TYPE
MC_CODE
MERCHANT_CTRY_CODE

CT_CC_TRANS_CAR_RENTAL (DWGL)
CT_CC_TRANS_LODGING (DWGL)
CT_CC_TRANS_PURCHASE (DWGL)
CT_CC_TRANS_TRAVEL (DWGL)
CT_REPORT_ENTRY (DWGL)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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