Extract pulls wrong salary for new assignment

Summary

Salary Extract is pulling the wrong salary for new assignments

Content

We have a custom extract that pulls HCM data from persons, assignments, and salaries. Person is the "Root" data group. Next is assignments. For the assignments the Parent Group Database Item is "Extract Person ID" and the Database Item is "Extract Assignment Person ID". Then comes the salary where the Parent Group Database Item is "Extract Assignment ID" and the Database Item is "Assignment Salary Assignment ID". 

Our extract pulls all salary records for active and inactive assignments. This works fine for all employees with single assignments.