Thanks, but I still get an automatic Max EFFDT criteria added within the Query Manager when I use PS_EMPLOYEES and it doesn't change my results. Any other ideas?
Within Peoplesoft Query Manager, I need to extract PSOPRDEFN fields OPRID and EMPLID, and if a JOB record is found extract DEPTID and EMPL_STATUS. Some EMPLID fields in the PSOPRDEFN are null. Research showed that I cannot do an outer join on a table that is effective-dated, and JOB is. Can...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.