Intermediate PS Query

This article provides helpful links to PeopleSoft® Query articles. This page is created for intermediate-level users. There are additional pages for the Beginners and Advanced users.

Start Here

• Finding Your Data
• Creating a New Query 
• Creating Record (Table) Join
• Join Types
• Effective Date
• Modify Query Exercise
  • CSPRD Query Exercise: Modify a Query (Easy to moderate)
  • CSRPT Exercise: Modify Enrollment Query (Easy to moderate)
  • FNPRD Exercise: Modify GL Query Exercise (Easy to moderate)

Additional Resources

• UMS Data Users' Resources
• PeopleSoft Training Files (Google Folder - Need UMS access)
• Troubleshooting PS Query
• Excel Tips

Join PS Query Group!

Have you joined the UMS PS Query User Group yet? You can ask questions or share tips and more.

Environment

• PeopleSoft Query (all databases)