Student Faculty Information System

Check out the HEUG Website!

HEUG, the Higher Education User Group, is an international organization consisting of higher education institutions that use application software from the Oracle Corporation, including PeopleSoft.

Wesleyan is an Institutional HEUG member, and as such, employees may access the HEUG website.

Among the benefits to the individual PeopleSoft user are:

• Access to HEUG online (HEUG.ORG) and the communication and collaboration tools available in the extensive HEUG online membership community.
• Unlimited free access to attend (and download) HEUG Education Series webinars.
  
• Access to Alliance session presentations and recordings.

To request a login for the HEUG website, from the HEUG home page, click on Request Login in the upper right-hand corner and follow the instructions.

Tags: Enrollment, HEUG

Click this link to see an updated document demonstrating Query Functions in Expressions on the QUERY – EXPRESSIONS page.  Listed are non-Wesleyan Functions along with examples.  You will see that these are available for viewing in four actual queries.

Functions are special types of command words (in the SQL Command set), usually one-word commands, which manipulate data items and return a single value which can be determined by various input parameters.

Below are some of the sample functions you’ll see in the documentation:

There is updated information – with lots of screen shots – on using BI Publisher for users with the Report Developer Role.  Those users with the Power User Role – except for the inability to register Data Sources – can generally perform the tasks below as well.

Outline of BI Publisher Steps:  BI Publisher Outline of Steps for Report Developer Role – This is a PDF of a PowerPoint presentation of the most common steps utilized in setting up a BI Publisher report from the creation of the query to the publication of the report.

The main steps are:

1.  Create a query
2.  Register Data Source * (only available to users with the Report Developer role)
3.  Create a template in Word
4.  Set up Report Definition – associate with Template
5.  Run, View and Save the BI Publisher Report

Detailed Documentation:   Using BI Publisher with PeopleSoft Query for Report Developers – This is a detailed document on how to use BI Publisher with PS Query.

In addition to demonstrating the basic steps, this document is divided into these main sections:

• BI Publisher Overview
• Installing Oracle BI Publisher Desktop
• How to Use BI Publisher through to the Query Viewer process or Query Report Scheduler
• Appendix A: Chart displaying access for Report Developer and Power User
• Appendix B: Links to other documentation

Would you like to create reports and emails and other correspondence based on PeopleSoft Query? Then you you might be interested in learning more about BI Publisher and Comm Gen (Communication Generation).  There is enhanced documentation in the SFIS Blog about both of these PeopleSoft Tools.

BI Publisher (formerly XML Publisher) is an an enterprise reporting solution that streamlines report and form generation. A primary feature of Oracle’s BI Publisher product is the separation of the data extraction process from the report layout. BI Publisher enables you to design and create report layout templates with the more common desktop applications of Microsoft Word and Adobe Acrobat, and renders XML data based on those templates. With a single template, it can generate reports in many formats. This approach to reporting can dramatically reduce report maintenance, enabling power business users to adjust report templates without involvement of IT resources.

The Comm Gen (Communication Generation) process enables you to select specific fields from which to extract critical data for a letter code assigned to the individual (or organization) IDs for whom you want to generate a communication. Communications in PeopleSoft is one of the “3Cs” which also includes Checklists and Comments. Communication management enables you to manage all forms of outgoing and incoming communications between the institution and constituents.  ( An outgoing communication can be in the form of a letter or an email.)   Campus Community provides the foundation of personal information, ID management, and 3Cs for all of the Campus Solutions applications.

If you are interested in exploring the potential uses of these tools for your office, you can contact Carolyn Pike at cpike01@wesleyan.edu.