Group Build Job effective date
We're trying to configure group build to find all employees in a particular union as of a certain effective date. For examples all employees in union 28 as of 04-25-2020 and we want the group to return the maximum effective dated row less than or equal to 4/25/2020 for the employee. The issue we're running into is the the group build process is adding in it's own effective date criteria which says and job.effdt<=sysdate. So if the employee has a future dated row they're knocked out of the group. Any idea how to turn this "Bonus feature" off?
Here's the SQL group build is creating: