FTE and Salary - Compensation Salary Details Real Time Subject area

Summary:

The FTE and Annualized Full Time Salary appear to be sourcing the FTE from the Assignment instead of the Salary row

Content (required):

I'm digging into an error we found where a user entered a change to the FTE on the Assignment but did not update the salary. We found that the reports out of Compensation - Salary Detail Real Time, reflected the NEW FTE and recalculated the annualized full time salary in line with the existing salary despite the FTE not having been changed in the salary table.

I've dug into the physical query through the query log to understand where the values are sourced and found that it's using