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

COMP_CHANGE_LOG Table

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. 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