Symptom
How is Job Level field synced between Job Code and Position? Why the as of date ad-hoc report does not reflect updated Job Level value when it is changed in Position?
Environment
Employee Central: Reporting
Employee Central: Metadata Framework
Reproducing the Issue
Job Level field is available in Job Code and Position object definitions. There is a rule to sync Job Code.Job Level to Position.Job Level (onChange rule on Position object’s Job Code field: JobClassification_Position. This rule is not pre-delivered and it has to be configured manually when configuring Position object definition). Because the field is not in Job Information, hence it is not possible to include it to the rules that sync data from Position to Job Information and Job Information to Position.
When we add a new record to Position by changing the Job Level value, the data doesn’t get synced to Job Information because Job Level field is not included in the business rule due to above mentioned reason. If you now run a report for the fields, the results are:
Job Information.Position.Job Level = Old value because there has not been any data refresh in Job Information table after the change in Position.Job Level
Job Information.Job Code.Job Level = Old value because there is no sync/rule from Position to Job Code and also because any data refresh in Job Information table after the change in Position.Job Level
Now if we add a new Job information record by editing any field, a HRIS sync is triggered and the data for Job Information table is refreshed. If you now run a report for the fields, the results are:
Job Information.Position.Job Level = New value because there has been data refresh in Job Information table after the change in Position.Job Level
Job Information.Job Code.Job Level = Old value because there is no sync/rule from Position to Job Code
Cause
Since there is no sync from Position to Job Code, the data will not be synced. This is an expected behavior.
Resolution
When there is a change in Job Level, it should be done first in Job Code so that the same change will flow to Position (but the reverse flow from Position to Job Code is not possible). If you want to see the updated values for Job Level in both Position and Job Code, please use Advanced Reporting that is used for MDF objects. The updated values will reflect in the Person and Employment Information (as of date) report only when there is a change in the existing Job Information record or a new Job Information record is added with effective date on or after the change in Job Code.
Keywords
ECT-74671 Job_code Job_level Position Sync Synchronization ad-hoc as-of-date , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-EC , Employee Central , LOD-SF-EC-MDF , MDF & EC2MDF Migration , Problem