V3 Seniority date pulling old assignment details

Summary:

We are currently building a report using the "Payroll - Payroll Run Results Real Time" subject area. When we add attributes from the "Workforce Management - Person Seniority Real Time" subject area (e.g., Bargaining Unit), we notice an issue:

• Fields like Assignment ID and Assignment Start Date correctly reflect the latest active assignment.
• However, Bargaining Unit is being pulled from a previous terminated assignment, not from the current one.

Has anyone encountered a similar issue when combining these subject areas? Is there a recommended way to ensure that attributes like Bargaining Unit are always aligned with the latest active assignment record? Any suggestions on how to resolve or work around this would be appreciated.