Student Faculty Information System

Wesleyan is upgrading our PeopleSoft SFIS Database

 Click here to view the SFIS Upgrade blog.

The SFIS Upgrade blog contains links to the upgrade timeline, testing scripts, testing guidelines, and other documentation to aid you in testing and learning about the upgrade features.

Click the following link to see the latest HEUG Webinar schedule for August:

August 2017 HEUG Education Series Schedule

Upcoming August Webinars

• What’s New in Payroll and Benefits
• HEUG President Town Hall Meeting
• Special Reporting – Soup to Nuts!
• Metadata is Your Best Friend in Reporting I and II
• Agile Doesn’t Mean Sloppy
• Rethink your Queries with Simplified Analytics
• Oracle Product Strategy – PeopleTools Security
• Beyond Fluid:  A holistic approach (First steps) to modernizing Student System Experience
• Dashboards as the springboard for student success

Tags: HEUG

Below are updates about the upcoming NEWHEUG Conference and the recently presented HEUG Webinar on Query Manager.

NEWHEUG Conference Workshops

NEWHEUG (New England Regional User Group) has announced four workshops at the NEWHEUG Alliance 2017 Conference.  The workshops will be offered on Monday, August 14 prior to the main conference.

Click here to see details about the workshops.

Two of the workshops will be looking at:

3Cs Communication Generation Step by Step by Step (Speaker:  Christopher Tatro, Tufts University)

In this workshop we will dive deep into the setup of 3Cs Communications, covering all steps necessary to produce either letters or emails. We will look at some of the common problems or issues in Communications and resources to solve them.

Intro to PS Query Workshop (Speakers:  Gregg Jenczyk and Criss Laidlaw, Williams College)

This two-hour workshop will introduce attendees to PeopleSoft’s Query application, once of the most widely-used reporting tools in the PeopleSoft environment.

Attendees will learn how to create simple queries, select and sort query results, join tables together, define expressions and prompts, and generate results in several formats using the web version of PeopleSoft Query.

This workshop will be most helpful for novice Query users who want to understand the basics.

July 13 HEUG Webinar Available for Download

The webinar Taking PS Query Manager to the Limit is now available for download on HEUG.  Click on the link and log in to the HEUG website.

Have you ever run into a roadblock using Query Manager and wondered if you could get the job done without direct SQL access? Are you transitioning away from Crystal Reports and want to utilize PS Query as much as possible? Do you enjoy using creativity to push a tool to its limit? If so, you will find value in this presentation of lesser-known PS Query capabilities. We will explore query criteria and prompts that allow you and your users to filter by a pasted list of desired values. We will dive deep into subqueries to filter out a variety of duplicate data. An array of expression functions will be discussed, including ones that can flatten your output data.

(During the webinar, a recommendation was made to view an Alliance presentation that contains a lot of very useful material on working with query expressions.  HEUG sent a link to that presentation to the participants which you might want to take look at:  Expressions In Query:  An In-Depth Exploration Into Function Statements.  You will also see examples from this Alliance offering in the SFIS Blog:  Query – EXPRESSIONS / FUNCTIONS.)

Tags: HEUG

The most recently offered HEUG webinars are now available for viewing and download.  Among them are these.  Click on the links and log in to the HEUG website:

• Enrollment Requirements for Beginners: Simple and Advanced Ways to Prevent and Allow Enrollment
  (which was presented Wednesday, June 28)
  • Pre? Co? Anti-requisites? Learn the difference and how to enforce course enrollment policy without customization to your Campus Solutions environment. Novice users will understand how to create Enrollment Requirement Groups and the different ways you can apply them in Curriculum Management. The University at Buffalo (UB) has been using Enrollment Requirement Groups since they went live with Campus Solutions in 2011; their experience in this area provides the basis for this high-level overview which will cover options available, set-up tips, and use case scenarios. Get a glimpse into how UB increased functionality by adding Academic Requirements into their Enrollment Requirement Groups and feel empowered to begin creating and using Enrollment Requirement Groups.
• Campus Community 101
  (which was presented Thursday, June 29)
  • This session, an offering of the Young Professionals Group (YPG) 101 webinar series, will cover the basics of the Campus Community module. We will explore common terminology while navigating through the most common and helpful pages of the Campus Community modules. Whether you are new to a Campus Community position, are interested in increasing cross-module efficiency, or are just looking for an overview of the delivered functionality available, this session will provide a greater understanding of the module. Specific areas of focus will include person identification, affiliations, search/match, checklists, communications, comments, service indicators, delegated access, and student activity guides.

Also available on the HEUG site is this webinar from May 17 on the use of Pivot Grids with PeopleSoft Query:

• Pivot Grids 101
  • Pivot grids have been extremely useful at UT Dallas, both as standalone pivot grids, and as reporting dashboards, and have saved us a lot of time. We’ll examine query best practices, pivot grid basics, pivot grid features in PeopleTools 8.53 and those that are new for 8.54/8.55. We’ll also look at some more in depth examples, and security needs and tips and tricks/lessons learned.

And this coming week, on July 13, the following webinar on Query is being offered which offers a”presentation of lesser-known PS Query capabilities.”

• Taking PS Query Manager to the Limit
• Thursday, July 13
  • Have you ever run into a roadblock using Query Manager and wondered if you could get the job done without direct SQL access? Are you transitioning away from Crystal Reports and want to utilize PS Query as much as possible? Do you enjoy using creativity to push a tool to its limit? If so, you will find value in this presentation of lesser-known PS Query capabilities. We will explore query criteria and prompts that allow you and your users to filter by a pasted list of desired values. We will dive deep into subqueries to filter out a variety of duplicate data. An array of expression functions will be discussed, including ones that can flatten your output data.

To review the Education Series Webinars archives and upcoming presentations, visit the HEUG Education Series Overview page.

Tags: Enrollment, HEUG