We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Position FTE Over Under - hr_all_positions_f_VL linked to position_fte_sum via position_id

Received Response
4
Views
13
Comments
edited Sep 29, 2021 8:01PM in Reporting and Analytics for HCM 13 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!