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