Penn Computing

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

CT_EXPENSE_TYPE Table - Data Element Index

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



Data element Definition
EXP_CAT_CODE

Indexed - yes
Format - varchar2(10)
May be null? yes
Expense category code.
EXP_CODE

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

Indexed - yes
Format - char(5)
May be null? no
Unique system-assigned key that identifies the expense type.
EXP_TYPE_LAST_MODIFIED

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

Indexed - no
Format - varchar2(64)
May be null? yes
Name of the expense type.
EXP_TYPE_NAME_LAST_MODIFIED

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

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the expense type record has been deleted from Concur.
PARENT_EXP_KEY

Indexed - yes
Format - char(5)
May be null? yes

Another expense type under which the entry's expense type has been grouped. For example, the expense types Breakfast, Lunch, and Dinner might be grouped under another expense type called Meals.

SYSTEM_RECORD

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

CT_EXPENSE_TYPE 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