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

CT_PERSON_ROLE_MAP Table

Explanation
CT_PERSON_ROLE_MAP stores the relationship between individuals and Concur system roles.

Common Uses
Reviewing Concur roles assigned to particular individuals.

EMP_KEY
ROLE_CODE

EMP_KEY
HIER_NODE_KEY
PERSON_HOME_ORG
PERSON_HOME_SCHOOL_CTR
PERSON_PENN_ID
ROLE_CODE

COMP_PERSON (DWCOMP)
CT_PERSON (DWGL)
CT_ROLE (DWGL)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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