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

CT_DELEGATION Table

Explanation
The CT_DELEGATION table contains information delagate/delgator relationships between people in Concur.

Common Uses
Determining who is a delegate for another person in Concur.

DELEGATION_KEY

DELEGATE_EMP_KEY
DELEGATE_HOME_ORG
DELEGATE_HOME_SCHOOL_CTR
DELEGATE_PENN_ID
DELEGATION_KEY
DELEGATOR_EMP_KEY
DELEGATOR_HOME_ORG
DELEGATOR_HOME_SCHOOL_CTR
DELEGATOR_PENN_ID

COMP_PERSON (DWCOMP)
CT_PERSON (DWGL)
CT_REPORT (DWGL)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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