Student Faculty Information System

The three sections of PeopleSoft Query Instructions are updated and available for your use.       You can take a look at the Overview or go to each section: Part I – Basic Query Concepts and Query Viewer Part II – Query Manager Part III – Advanced Concepts    They are in the form of […]

This article highlights the use of runtime prompts when creating criteria in Query.   One key benefit of prompts is that when you run the query, you can change the criteria as necessary, in various combinations as required, to achieve the desired results. An excerpt from PeopleBook:  PeopleSoft Query explains the use of prompts as follows: Adding a […]

  Now available on the SFIS Blog – PeopleSoft Query Advanced Concepts documentation. This on-line instruction follows up on the training presented in the Introduction to PS Query course.  It reviews and reinforces a number of topics previously presented and introduces additional subjects such as aggregate functions, having, outer joins, subqueries and union queries.   You can […]