Understanding Equation Engine

Important:

Financial Aid Notification (FAN) letter is a deprecated product. It is strongly recommended that you use Communication Generation (Comm Gen) instead. For more information on Comm Gen, see Campus Community Fundamentals: Using the Communication Generation Process

Oracle Corporation provides the PeopleSoft Equation Engine as a means for you to specify rules or equations as part of your business process. Equation Engine works best when you can specify an IF-THEN-ELSE validation resulting from a single call to an equation. For example, you may want to specify selection criteria by emplID or obtain a single number, string, or Boolean operator for that emplID.

The new version of the Equation Engine extends the capabilities of the original Equation Processor by adding looping and other constructs. It now can read any table for which you have security access and can perform various arithmetic operations and external call subroutines. In addition, security was added to ensure that control can be allocated based on your need and job function, which determine whether you need the ability to add, use, view, and modify equations, tables, and external routines.

We added new syntax to enable you to perform mass actions—such as inserting, deleting, and updating rows in database tables—against the database using a single statement.

This section discusses:

• Online usage

• Architecture

• Language constructs

• Keyword syntax

• Basic language syntax