PeopleSoft Query Manager - isolating a row

Solution 1:

There are a couple of ways to do this. If you are on PeopleTools 8.56 or later, you can first write a query that pulls all active statuses. Drop the effective dated logic for this one. You would then use composite query to query your query. This will treat the inner query like an inline view. You would then apply effective dated logic in composite query.

Another option is to put the active status criteria in the effective dated logic. For this to work, you won't be able to use standard effective dated logic. You will need to create your own subquery criteria on the EFFDT field.