Penn Computing

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

CT_EXPENSE_CODE Table - Data Element Index

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



Data element Definition
EXP_CODE

Indexed - yes
Format - varchar2(10)
May be null? no
Unique code identifying a collection of similarly grouped expense types in Concur.
EXP_CODE_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the expense code record was last modified.
EXP_CODE_NAME

Indexed - no
Format - varchar2(64)
May be null? yes
Description of the expense code.
EXP_CODE_NAME_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the expense code description record was last modified.
IS_PARTIALLY_APPROVABLE

Indexed - no
Format - char(1)
May be null? yes
Indicates  whether expenses with the expense code may be partially approved.

CT_EXPENSE_CODE 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