Creating Related Record Joins

In a related record join, you can automatically join two records based on a relationship that has been predefined in the record designer. For example, if a field has a prompt table defined for it, PeopleSoft Query displays a join link to the right of the shared field.

This example shows the Query page. Use the Join <record name> link to join record. The QEDMO Employee record can join to the JobCode record by using the by QE_JOBCODE field, or the QEDMO Employee record can join the Data Department record by using the DEPTID field.

To create a related record join:

1. In Query Manager (Reporting Tools, and then Query, and then Query Manager), select the base record for your query.

2. Select the appropriate fields and criteria.

3. From the Query page, click the Related Record Join link.

4. From the Select Join Type page, select the standard join option and click the OK button.

   The join is reflected on the Query page.