PeopleSoft Wiki

I think the problem is to do with your effective date criteria. By default PS Query uses the criteria that the effective date is less than or equal to the current system date. If you have a look at the view SQL tab you'll probably see something like this in the sub-query that gets the maximum effective date (by the way this is for an Oracle database):

AND EFFDT <= SYSDATE

This is an example of what the criteria that performs this logic in your query might look like:

As the effective date has to be less than or equal to the current date, this rules out any rows with a future effective date which sounds like your problem.

Try changing the condition type from Eff Date <= to Last Eff Date. This should give you the maximum effective date regardless of whether it is in the future. This is how your query criteria might look after the change:

Hope that helps.