An aggregate function is a special type of operator that returns a single value based on multiple rows of data. When your query includes one or more aggregate functions, PeopleSoft Query collects related rows and displays a single row that summarizes their contents.

 

For example, suppose you create a query that includes Employee ID and Amount fields for each service indicator. You want to find out the total amount of fees owed from all the service indicators that have been placed on a person's records. Without any aggregate functions, this query would return one row for every employee and service indicator amount combination. If you apply the aggregate function Sum to the Amount field, the query can be narrowed down to display one row that summarizes the amount for each employee.

 

When you apply an aggregate function to a field, you are redefining how PeopleSoft Query uses the field throughout the query. Essentially, the application replaces the field, wherever it occurs, with the results of the function. If you select the field as a display column, PeopleSoft Query displays the aggregate values. However, if you use the field as an order by column, the application organizes the results in an order that is based on the aggregate values.

 

In this topic, you would like to know how many students are in each career for each academic term. You will perform an aggregate function of Count on the EMPLID field.

 


Table of Contents