Employee History Tracking FAQ

Purpose
Questions and Answers
 Question 1:  Is there functionality that tracks changes to the F060116 Employee Master, similar to the functionality that tracks changes to the Address Book?
 Question 2:  When trying to use History Tracking (menu G05BH4 - option 1- program P08041), why are there no data items and/or add ADD button.  The file F08041 is empty.
 Question 3:  Why does the Access History Icon for External Title (Alias – JBCX) and Position ID (Alias – POS) not display in the Individual Compensation Review Application (P08812)?
 Question 4:  What is the job history file?
 Question 5:  Is there a standard report to pull history changes to the employee master?
 Question 6:  Can you track Employee Name (ALPH) changes from Employee Information - [Personal] application P0801EMP from Form Exit History Tracking?
 Question 7:  How are sequence numbers created in the History Window (P050421)?
 Questions 8:  Why does the Job and Pay History tracking (P050421) show two lines (header and detail) when a salary is changed on the employee master through compensation management?
 Question 9:  When more than one change is made to an employee master field on the same day, only the first change is logged.  On the records that are logged to employee history (F08042), the following fields are written with blank values:  user id, work station id, program id, change reason.  Why is the F08042 not updating correctly?
 Question 10: When re-activating a terminated employee, based on the settings for future data fields being tracked, four records are written to the employee history table (F08042). When re-terminating the employee, only one or two records are written. Would like clarification why there is a difference in what records are written.

Purpose

This document describes functionality that tracks changes to the F060116 Employee Master.

Questions and Answers

Question 1:  Is there functionality that tracks changes to the F060116 Employee Master, similar to the functionality that tracks changes to the Address Book?

Answer 1:  The Employee History Inquiry R080423 accomplishes this.  The report is based on the F08042 (HR History) file. Within this report, the following can be specified:

  1. To print active, inactive or both types of employees.
  2. Specify a date range.
  3. Specify a specific data item or all data items tracked by history.

Question 2:  When trying to use History Tracking (menu G05BH4 - option 1- program P08041), why are there no data items and/or add ADD button.  The file F08041 is empty.

Answer 2:  When users do an install or a merge the table is set to Copy Data N.  To verify this, go to OMW and choose the tab Install/Merge.  Change the field Copy Data to a Y. 

Workaround:  Copy table (F08041) from OneWorld Local into the appropriate Data Source.

Question 3:  Why does the Access History Icon for External Title (Alias – JBCX) and Position ID (Alias – POS) not display in the Individual Compensation Review Application (P08812)?

Answer 3:  The appearance of the Access History Icon in P08812 is controlled by the Select Data Item for History Tracking Application (P08041). In this application, ‘Enable History Tracking’ must be set to Yes (Y) for POS in order for the Access History Icon to appear.  Since JBCX is not available for history tracking, an icon cannot be displayed.

Question 4:  What is the job history file?

Answer 4:  The job history file is the F08042.

Example:  JBCD Place the cursor on the Job Type/Step field in the Employee Organizational Assignment screen (P0801ORG) and take the row exit to Job History Tracking to view all records.

Question 5:  Is there a standard report to pull history changes to the employee master?

Answer 5:  The standard report is the R080423 (Employee History Inquiry).  The report is based of the F08042 (HR History) file. Within this report users can specify:

  1. To print active, inactive or both types of employees.
  2. Specify a date range.
  3. Specify a specific data item or all data items tracked by history.

Question 6:  Can you track Employee Name (ALPH) changes from Employee Information - [Personal] application P0801EMP from Form Exit History Tracking?

 Answer 6:  There is no application within the Employee Master that would allow for history tracking to be turned on for ALPH.  Although clients can track the ALPH, the employee master does not have an option for History Tracking to be enabled from the applications within employee master.  This is because the only place we see the actual field for ALPH is in Address Book that is owned by another group.  The only way around this is for the client to click another field that enables the History Tracking Field and then once in the History tracking change the alias to ALPH and click find. 

WORKAROUND:
Another option would be for the client to go to P050242 (Work with Employee History) and search by the alias ALPH.

Question 7:  How are sequence numbers created in the History Window (P050421)?

Answer 7:  The system creates sequence numbers based off effective date and if the date is the same then a new sequence number will be created.

Questions 8:  Why does the Job and Pay History tracking (P050421) show two lines (header and detail) when a salary is changed on the employee master through compensation management?

Answer 8:  The details of all these changes will be listed under the header record as detail records with each such record mentioning the change amount as well as the change reason. The header record will have a sequence number greater than or equal to 1 and the detail records will have sequence numbers less than 1.

Question 9:  When more than one change is made to an employee master field on the same day, only the first change is logged.  On the records that are logged to employee history (F08042), the following fields are written with blank values:  user id, work station id, program id, change reason.  Why is the F08042 not updating correctly?

Answer 9:  Check the OCM mapping for N0500060.  If the N0500060 is mapped to the server or local then deactivate or delete the mapping.  Sign out of Enterprise One and then sign back on.  This should resolve both issues.

Question 10: When re-activating a terminated employee, based on the settings for future data fields being tracked, four records are written to the employee history table (F08042). When re-terminating the employee, only one or two records are written. Would like clarification why there is a difference in what records are written.

Answer 10:  The reason that only two records are created is that the employee was re-terminated on the same day that they were reinstated. As a result of the user and the date being the same a new record is not created for all of the prior termination records in the F08042.