This question is a result of this question here. Basically I'm trying to find out if future hires already have their leave plans in the system. I'm limited to PeopleSoft's in built Query Manager.
I'm aware that there are limitations in reporting with regard to seeing future hires job data records. My team built a view into that table so that I can run reports off of it.
I've been trying to build reports regarding future hires leave plans and I want to know if this is another issue with PeopleSoft - in other words, is this an issue we'd have to build another view in order to see future leave plans?
This question is probably highly dependent on how your environment is setup and what kind of permissions your user has.
However, checking if you can see/if there are future leave plans in the system should be trivial:
SELECT * FROM PS_LEAVE_PLAN;
or via PSQuery in the records tab, select LEAVE_PLAN and select all fields.
Then check if you have EFFDT fields with future dates.