Feed on







The documentation pages for Service Indicators (Holds) have been updated.  They are named:

Introduction to Service Indicator (Holds)

Managing Service Indicators

The first is an overview of Service Indicators and the second contains step-by-step, illustrated instructions in the areas of

  1. Service Indicator Search Page
  2. Manage Service Indicators Page
  3. Adding a Service Indicator
  4. Removing a Service Indicator
  5. Service Indicator Audit
  6. Service Indicator Buttons (Symbols)

As mentioned on the page, If you are having difficulties accessing the Service Indicator pages, be sure that your User Defaults are up to date. The code “WSLYN” must be entered in a number of fields on the pages User Defaults 1 and User Defaults 2.

Links to the Oracle/PeopleSoft publications and presentations in the SFIS Blog have been collected onto this page:

Oracle/PeopleSoft Publications and Presentations

Included are a number of general topics, as well as documentation on BI Publisher, Communication Generation, Population Selection, Mass Assign, and PeopleSoft Query.


students on the lawn

Below are links to a number of Oracle publications and presentations that you may find useful.

The following are found on the PROCEDURES – OVERALL [External References] page.  To access them directly, click these links:art installation

These Oracle documents are part of the QUERY – EXTERNAL REFERENCES page, which lists a number of useful sources on the topic, including:

For further information on the specific topics of  BI Publisher, CommGen and Pop Select, go to these pages:



darkening skies The November PeopleSoft Query Track 2 class has been rescheduled to Monday, November 24 at 3:00 p.m. in the Science Tower, Room 509a.




This is a review of our most recent Query Instruction meetings both of which concentrated on using Expressions and standard functions in Query.  This is also an overview of the content of the November classes which will be about using Wesleyan Functions in Expressions.

If you are unable to attend the classes, feel free to make use of any of the material in the SFIS Blog.  As always, I am available if you have any questions, general or specific, on working with Query.  Please send an email to cpike01@wesleyan.edu .


The October 9 Track 1 class introduced how to create expressions and reviewed examples of some of their uses.   Basically, expressions are calculations that PS Query performs as part of a query. For example, there can be mathematical calculations, SQL functions or Wesleyan functions utilized in expressions. Using common SQL functions increase the utility of expressions.   You can review Lesson 8 in the Query Manager module for more information, including a demonstration of concatenating fields and a page of notes on using expressions.

The next Track 1 class on November 6 continues with expressions (Lesson 8), introducing the use of Wesleyan Functions.


The October 16 Track 2 class reviewed the basics of working with expressions and expanded on the use of SQL functions.   If you go to the EXPRESSIONS page you will see a link to a document listing a number of Query Expressions Function Definitions and Examples. You will find similar expressions in Lesson 13 – Expressions – More Examples in the Advanced Concepts module.

The topic of the next Track 2 class on November 20 will be a review of Wesleyan Functions with illustrations of how they can be utilized.   An overview and examples of some Wes Functions can be found in Lesson 14 – Wes Functions Review.

Older Posts »

Log in

Powered By WordPress SEO Master