Penn Computing

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

CT_LIST_ITEM Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
IS_DELETED

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the list item record has been deleted from Concur.
LC_KEY

Indexed - yes
Format - char(4)
May be null? yes
Unique system-assigned key that identifies a system list category within Concur.
LI_CODE

Indexed - yes
Format - varchar2(329)
May be null? yes
Code associated with a system list item.
LI_KEY

Indexed - yes
Format - number
May be null? no
Unique system-assigned key that identifies a system list item record within Concur.
LI_SHORT_CODE

Indexed - yes
Format - varchar2(32)
May be null? yes
Short code associated with a system list item.
LIST_ITEM_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the list item record was last modified.
LIST_ITEM_VALUE

Indexed - no
Format - varchar2(64)
May be null? yes
Value or description of the system list item.
LIST_ITEM_VALUE_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the list item value record was last modified.

CT_LIST_ITEM Table   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