Penn Computing

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

CT_LIST_ITEM Table

Explanation
The CT_LIST_ITEM table contains codes and descriptions for individual items in Concur lists of values.

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

Primary Key Indexed Data Elements Related Tables
LI_KEY
LC_KEY
LI_CODE
LI_KEY
LI_SHORT_CODE
CT_LIST_CATEGORY (DWGL)
CT_LIST_ITEM_MAP (DWGL)

Cautions

  • The CT_LIST_ITEM table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_LIST_ITEM 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