PeopleSoft database stores data in tables made up of columns (fields) and rows (records). This helps you to identify every individual piece of data that you need to specify. When you create a query, you select the data you want the system to retrieve by specifying from which columns and rows to retrieve.

 

When you run a query after selecting the fields, the system retrieves the data from every row in the table or tables. If you want the system to retrieve data from selective rows, you add selection criteria to the query.

 

The selection criteria serves as a test that the system applies to each row of data in the tables related to your query. If the row passes the test, the application retrieves it. If the row does not pass the test, however, the application does not retrieve the data.

 

For example, you need the names of all PeopleSoft customers who are not PeopleSoft employees. You start by creating a query that retrieves the Name and Company fields from the Customer table. You can then add a selection criterion that tells PeopleSoft Query to scan for rows in which the company name is not PeopleSoft. In most cases, a selection criterion compares the value in one of a row's fields to a reference value. In this example, you would compare the value in the Company field to the constant value of PeopleSoft.

 

Upon completion of this lesson, you will be able to:

• Enter selection criteria.

• Specify effective date criteria.

• Apply an aggregate function.

• Create a query using Having criteria.

 


Table of Contents