Expressions are calculations that PeopleSoft Query performs as part of a query. Use expressions when you must calculate a value that PeopleSoft Query does not provide by default—for example, to add the values from two fields together or to multiply a field value by a constant.


You can work with an expression as if it were a field in the query: select it for output, change its column heading, or choose it as an “order by” column.


In Query Manager, you can use expressions in two ways:

• As comparison values in selection criteria.

• As columns in the query output.


In this topic, you will define expressions.

Table of Contents