Penn Computing

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

CT_LIST Table

Explanation
CT_LIST is a reference table for lists of values used in the Concur system.

Common Uses
Displaying the names of Concur system lists, rather than code that appears in a related table.

Primary Key Indexed Data Elements Related Tables
LIST_KEY
LC_KEY
LIST_KEY
CT_LIST_CATEGORY (DWGL)
CT_LIST_ITEM_MAP (DWGL)

Cautions

  • Lists may be grouped in categories as stored in the CT_LIST_CATEGORY table.
  • The CT_LIST table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_LIST 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