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

CT_CREDIT_CARD_ACCOUNT Table

Explanation
The CT_CREDIT_CARD_ACCOUNT table contains information about Penn Travel Cards relating to people in Concur Expense.

Common Uses
Reviewing basic information about Penn Travel Card accounts.

CCA_KEY

CCA_KEY
EMP_KEY
HIER_NODE_KEY
PAT_KEY
PERSON_HOME_ORG
PERSON_HOME_SCHOOL_CTR
PERSON_PENN_ID

COMP_PERSON (DWCOMP)
CT_PERSON (DWGL)
CT_PAYMENT_TYPE (DWGL)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

• CT_CREDIT_CARD_ACCOUNT contains only very basic, non-confidential information about Penn Travel Card accounts used in Concur.
• The CT_CREDIT_CARD_ACCOUNT table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

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