Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_POL_TR_EXP_CAT_MAP Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home

CT_POL_TR_EXP_CAT_MAP Table

Explanation
CT_POL_TR_EXP_CAT_MAP is a reference table containing associations between policies and expense categories.

Common Uses
Displaying policies related to particular expense categories.

Primary Key Indexed Data Elements Related Tables
EXP_CAT_CODE
POL_KEY
EXP_CAT_CODE
POL_KEY
CT_EXPENSE_TYPE (DWGL)
CT_POLICY (DWGL)

Cautions

  • The CT_POL_TR_EXP_CAT_MAP table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_POL_TR_EXP_CAT_MAP Table - Data Element Index   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