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