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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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?
  2. commish252

    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...

Part and Inventory Search

Back
Top