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

COMP_CHANGE_LOG Table

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

Explanation
Contains the change history of an individual's PennWorks records, from record creation through individual element changes, with old and new values by element.

Common Uses
Tracking historical changes in employee records in the PennWorks system.

ACTION_CODE
ACTION_DATE
PENN_ID
TABLE_FIELD_NAME

ACTION_DATE 
CHANGE_LOG_ID
HOME_CENTER
HOME_ORG 
PENN_ID 

COMP_ACTION_TYPE_LOOKUP (DWCOMP)
COMP_DISTRIBUTION (DWCOMP)
COMP_DISTRIBUTION_EXT (DWCOMP)
COMP_PERSON (DWCOMP)
COMP_PERSON_ADDRESS (DWCOMP)
COMP_PERSON_ROLE (DWCOMP)
COMP_PERSON_ROLE_JOINT_ORG (DWCOMP)
COMP_PERSON_SALARY (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)
PAYROLL_CHANGE_LOG (DWADMIN)

Cautions

• COMP_CHANGE_LOG contains the history of PennWorks record changes from the point when PennWorks came into use in November 2009 until its retirement in June 2019. For the data elements that are manged by PennWorks and then fed to the mainframe Payroll system for processing, a similar change history of mainframe Payroll data elements is available in DWADMIN.PAYROLL_CHANGE_LOG. For employees with Payroll records prior to October 2009, and who were never managed by PennWorks, change history is available in the PAYROLL_CHANGE_LOG table only.

• Individuals must first have access to the Salary Management collection in order to be authorized to view the COMP_CHANGE_LOG tables.

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

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