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

COMP_PERSON_ROLE Table

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

Explanation
Contains data about employees and their roles as defined in PennWorks. There is one record per employee/role with the role organization and start/end dates for the role appointment..

Common Uses
To determine what roles an employee holds (or has held), the salary for each role, when the role appointment begins and ends, when the employee first began working in the role, the associated job class code, the pay cycle, the percentage of full-time hours spent in the role, and the organization responsible for the role appointment.

COMP_PERSON_ROLE_ID

HOME_CENTER
HOME_ORG

JOB_CLASS
PENN_ID
ROLE_CENTER
ROLE_ORG
ROLE_STATE
ROLE_TYPE
TERM_END_DATE
TERM_END_FISCAL_YEAR
TERM_END_YEAR
TERM_START_DATE
TERM_START_FISCAL_YEAR
TERM_START_YEAR

COMP_DISTRIBUTION (DWCOMP)
COMP_EMPLOYEE_TYPE_LIST
COMP_PERSON (DWCOMP)
COMP_PERSON_ADDRESS (DWCOMP)
COMP_ROLE_DIST_STATE_LOOKUP (DWCOMP)
COMP_TERM_LOOKUP (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
EMPLOYEE_JOB (DWADMIN)
JOB_CLASS (DWADMIN)
JOB_CLASS_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

• An employee may have several roles active at the same time. Role records are distinguished in COMP_PERSON_ROLE by the Role_ORG, Term_Start_Date and Term_End_Date. Roles from PennWorks are mapped to a maximum of four job records in the mainframe Payroll system, where they are used for Payroll processing. (Once fed to the Payroll system, the resulting job records are extracted to the DWADMIN.EMPLOYEE_JOB table in the Data Warehouse.) Note: the EMPLOYEE_JOB table includes job history for employees who had Payroll records on or after July 1, 1996. For employees with Payroll records prior to October 2009, job data is available in the EMPLOYEE_JOB table only.

• PennWorks allows users to indicate a state for a role, as "Final", "Projected", or "Disabled." Records with a "Projected" state can act as placeholders for planning purposes, and will be managed solely within PennWorks. The "Final" state indicates the record is ready to be processed by PennWorks and, when appropriate, updated in Payroll. "Disabled" records will no longer be visible in PennWorks, but are retained in the COMP_PERSON_ROLE table for historical purposes. Users may select to delete records from PennWorks; these rows are retained in in the Data Warehouse for historical purposes with a state of 'X'.

• Historical snapshots of job information are available in the COMP_PERSON_ROLE_SNAP table, beginning with the NOV-09 period.

• You can access a COMP_PERSON_ROLE row only if you are authorized to access data for the employee's home center or organization, the role center or organization, or a current joint organization for the employee.

• The COMP_PERSON_ROLE table can be found in the DWCOMP schema.

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