Position FTE Over Under - hr_all_positions_f_VL linked to position_fte_sum via position_id
We have a data model that was created by a third party and they are linking to HR_ALL_POSITIONS_F to get details on overunder FTE counts. It appears the link between two table shows a disconnect as a few positions are being omitted when linking position id.
Here is the code...
select hapf.position_code PositionCode
,'Y' Y,'N' N
,to_char(hapf.fte - (p.sum_value),'0.0000')OverUnderFTE
from per_jobs_f_tl pj