Penn Computing

University of Pennsylvania
Penn Computing << go backback
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

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.

Primary Key Indexed Data Elements Related Tables
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).
COMP_ROLE_JOB_CLASS_XREF Table - Data Element Index   Tables and Data Elements   Salary 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