COMP_ROLE_JOB_CLASS_XREF Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

COMP_ROLE_JOB_CLASS_XREF Table

Note: This table is no longer updated, following the retirement of PennWorks and the implementation Workday@Penn in July 2019.

Explanation
Cross reference table to mapping PennWorks roles to job classes. There is one row per role/job class combination.

Common Uses
Determining the roles that could apply to a job class; typically used for faculty administrative roles.

COMP_ROLE_JOB_CLASS_ID

JOB_CLASS
ROLE_ID

COMP_PERSON_ROLE (DWCOMP)
COMP_ROLE_LOOKUP (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
JOB_CLASS (DWADMIN)
JOB_CLASS_GENERAL (DWADMIN)

Cautions

• Numerous Roles are associated with some Job Class Codes, such as Job Class Code 140010 (for example, Department Chair, Director of a center/institute, Graduate Group Chair, Lab Director).

• Refer to the DWCOMP.COMP_ROLE_LOOKUP table to further data about roles referred to in this table, and to DWADMIN.JOB_CLASS to find job classes.

COMP_ROLE_JOB_CLASS_XREF Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home