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

CT_POLICY Table

Explanation
CT_POLICY is a reference table for policies used in Concur, containing policy codes and their descriptions.

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

POL_KEY

POL_KEY
PROCESS_KEY

CT_POL_TR_EXP_CAT_MAP (DWGL)
CT_POLICY_EXPENSE_TYPE_MAP (DWGL)
CT_POLICY_HIST (DWGL)
CT_POLICY_LANG_HIST (DWGL)
CT_REPORT (DWGL)

Cautions

• CT_POLICY contains the current state of policy data used in Concur; CT_POLICY_HIST contains previous versions of policy data.
• The CT_POLICY table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

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