Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_PAYMENT_CODE Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home

CT_PAYMENT_CODE Table

Explanation
CT_PAYMENT_CODE is a reference table for payment code values used in Concur, containing codes and their descriptions.

Common Uses
Displaying the payment description, rather than code that appears in a related table.

Primary Key Indexed Data Elements Related Tables
PAT_CODE
PAT_CODE
CT_PAYMENT_TYPE (DWGL)

Cautions

  • Payment Codes (e.g., "Cash") are a roll up of Expense Types (e.g., "Cash/Personal Credit Card", "Out of Pocket") which are stored in CT_PAYMENT_TYPE.
  • The CT_PAYMENT_CODE table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_PAYMENT_CODE 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