Penn Computing

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

CT_LIST_ITEM_MAP Table - Data Element Index

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



Data element Definition
END_DATE

Indexed - no
Format - date
May be null? yes
 
IMPORT_STATUS

Indexed - no
Format - char(1)
May be null? yes
 
LAST_MODIFIED

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

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

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

Indexed - no
Format - date
May be null? yes
 
PARENT_LI_KEY

Indexed - no
Format - varchar2(64)
May be null? yes
Unique system-assigned key that identifies a the parent list  item for a particular list item.
START_DATE

Indexed - no
Format - date
May be null? yes
 

CT_LIST_ITEM_MAP 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