CT_EXPENSE_TYPE is a reference table for expense type values used in Concur, containing type codes and their descriptions.
Displaying the expense type description, rather than code that appears in a related table.
||Indexed Data Elements
- 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.
Concur Expense, in use at Penn since 2013.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania