Job History Tracking/Job History Window (P050421)

Purpose
Details
 Overview
 Accessing Job History Tracking/Job History Window
 Frequently Asked Questions

Purpose

 Comprehensive information regarding Job History Tracking/Job History Window (P050421)

Details

Overview

The Job History Tracking/Job History Window (P050421) shows records based off of two tables; F060119 (Employee Job History) and F08042(HR History).

The P050421 shows records from F060119 plus any records updated to the F08042 that are before the first record created in the F060119.

Only JBCD(Job Type), JBST(Job Step), PGRD(Pay Grade) and PGRS(Pay Grade Step) items are fetched from the F08042 to display in job history.  If a record exists for an old history record in the F08042 for any other data item then the system will not show a record in the Job History Tracking/Job History Window.

There are many fields in the F060119 that are not displayed in the P050421.  During an employee update a record is added to the F060119 when any of the fields within the F060119 are changed.  The Job History Tracking/Job History Window only shows the Job and/or Pay Grade fields and will show all the records even though Job or Pay Grade fields were not changed.  

Sometimes it appears that duplicate records are shown in the Job History Window.  Upon further investigation using UTB or Databrowser to view all the fields in the F060119, users will see that the records are not the same.

In Releases 8.11 and above, the F060119 fields are displayed in the P050421 allowing the user to differentiate records.

Also see document Employee History Tracking for frequently asked questions regard Employee History Tracking.

Accessing Job History Tracking/Job History Window

There are multiple ways to access the Job History Tracking/Job History Window (P050421).
1. Fast path to P050421.
2. Go to menu G05BH1 and select Employee History Inquiry (P050242).  Then take the Form exit to "Job/Pay History".
3. Go to menu G05BH3 and select Update Employee History( P050420).  Then take the Form exit to "Job/Pay History".
4. From the "Employee Information-Organization Assignment" form click inside the Job Type/Step field and then take the Form exit to "Job History Tracking". 

In order to see all the fields associated with Job History Tracking users will need to UTB (Data Browse) the F060119. Also, it is important to know that the Job History Tracking window is accessed via Employee Information-Organizational Assignment the Job Type/Step fields are displayed but Pay Grade/Step is not displayed. In order to view both Job Type/Step and Pay Grade/Step the P050421 must be accessed as described above (# 1-3) or through UTB (Data Browse) of F060119.

Users may notice that when accessing the Job History Window from 1, 2 or 3 shows fewer records then method 4. The Job History Window does not fetch any F08042 records when accessed through methods 1, 2 or 3. If employees have history in the F08042 that is prior to the first record in the F060119 for JBCD, JBST, PGRD or PGRS. These are the records that will only show when accessing the Job History Window with method 4.

Frequently Asked Questions

Question 1:  Why does the P050242 form (W050242C) history inquiry not allow users to search on data item Job Type (JBCD).  Currently, there is a form interconnect to the P050421 which will be used to view Pay Grade/Step & Job Type/Step history information.  The F08042 file has the data for JBCD hence the user should be able to query in P050242.  How can users update history? For example: Job Code.

Answer 1:  In the P050242 trying to inquire on JBCD users should receive an error "Invalid data item in field".  If inquiring on JBCD/JBST/PGRD/PGRS, enter the employee number and one of these data items and click the form exit to Job History Information.  The Job History Information is the Job/Pay History button in the form exit.  Once an employee is specified and the Job/Pay History button is clicked then the system will pull up the appropriate records.    Because the history data (the job code) is inquiry only, users would have to use SQL to change the job codes in both the F060119 and the F08042.  The system doesn't allow users to change the actual value of the history data anywhere in the system.  Currently, only the date and change reason may be updated for both the F060119 and F08042 via the P050420.