Position FTE Over Under - hr_all_positions_f_VL linked to position_fte_sum via position_id
Summary:
Content (required):
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
,pj.name JobTitle
,hapf.name PositionTitle
,'Y' Y,'N' N
,to_char(hapf.fte,'00.0000') AuthorizedFTE
,hapf.position_id
,to_char(hapf.fte - (p.sum_value),'0.0000')OverUnderFTE
from per_jobs_f_tl pj
,hr_all_positions_f_VL hapf