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

CT_EXPENSE_TYPE Table

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

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

EXP_KEY

EXP_CAT_CODE
EXP_CODE
EXP_KEY
PARENT_EXP_KEY

CT_EXPENSE_CODE (DWGL)
CT_MERCHANT_CODE (DWGL)
CT_REPORT_ENTRY (DWGL)

Cautions

• For Penn accounting purposes, Expense Types have been mapped to General Ledger Object Codes; mapping may vary for faculty/staff and students, as well as for domestic and international travel, UPHS expenses and capital program expenses. Tables containing the mapping details by fiscal year can be found on the Comptroller's website.
• Expense Types (e.g., "Breakfast", "Lunch", "Dinner") may be rolled up into Expense Codes (e.g., "MEALS"), which are stored in CT_EXPENSE_CODE.
• The CT_EXPENSE_TYPE table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

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