Student Faculty Information System

          Here is some updated documentation as well as new pages for the month of August.  Browsers and PeopleSoft Query Expressions Query Tip Sheet Query Troubleshooting Query – Wes Functions Chart Today’s Date in Query  

  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 […]