Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by commish252
-
Using JOB record in an QUERY MANAGER outer join. Need help.
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?- commish252
- Post #3
- Forum: PeopleSoft ERP Solutions
-
Using JOB record in an QUERY MANAGER outer join. Need help.
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...- commish252
- Thread
- Replies: 3
- Forum: PeopleSoft ERP Solutions
