PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Need help figuring out a query

edited Nov 25, 2017 4:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

I am struggling with what should be a fairly easy query but cannot seem to figure it out so any help is appreciated.

to keep it simple I will not include everything in my query here, but just where the problem seems to lie.

I am selecting so basic fields from the JOB record, and then some fields from the LEAVE_ACCRUAL.

JOB.EMPLID, LEAVE_ACCRUAL.PLAN_TYPE, LEAVE_ACCRUAL.HRS_TAKEN_YTD where LEAVE_ACCRUAL plan type is in('50','51')

so for instance I could get

EMPLID     PLAN_TYPE     HRS_TAKEN_YTD

000001     50                              8

000001     51                              16

000002     50                              10

000003     51                              8

So not all employees have both sick and vacation ( plan types 50 and 51)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center