Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.

Primary Key Indexed Data Elements Related Tables
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

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