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..
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.
||Indexed Data Elements
- 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'.
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.
Questions about this page? Email us at email@example.com