CT_EXPENSE_CODE Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home

CT_EXPENSE_CODE Table

Explanation
CT_EXPENSE_CODE is a reference table for expense code values used in Concur, containing codes and their descriptions.

Common Uses
Displaying the expense description, rather than code that appears in a related table.

EXP_CODE

EXP_CODE

CT_EXPENSE_TYPE (DWGL)
CT_REPORT_ENTRY (DWGL)

Cautions

• Expense Codes (e.g., "MEALS") are a roll up of Expense Types (e.g., "Breakfast", "Lunch", "Dinner") which are stored in CT_EXPENSE_TYPE.
• The CT_EXPENSE_CODE table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_EXPENSE_CODE Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home