If you enter the word “date” or the phrases “effective date” or “effective dating” in the Search box over to the right, you will receive a number of hits. This is because dates are an important element when entering information into the pages in SFIS and when extracting information through Query. The concept of […]
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 […]
You’re working with PeopleSoft Query and would like to display the Wesleyan Class Year for each student without having to add in another table. Or the Query that you’re updating displays the student name as Last Name, First Name. You would like to show it as First Name then Last Name. Or you need to […]
Since the introduction of the SFIS Blog last week, there have been three additions to the Query section that you should know about: First, there is a Query Tip Sheet that has hints, suggestions, and ideas. Among the topics discussed are joins, table ordering and criteria. This page will be added to as needed. […]
