Overview
This job aid shows report administrators how to create queries with the CSU_DEPT_ROLL table.
Background
- Campuses run queries with division, department, and college fields.
- CHRS tables do not include these fields available for query.
- To add these fields, query builders must merge the CSU_DEPT_ROLL table with their queries.
This job aid is for users who have experience with creating PeopleSoft queries.
Remember to limit the results to your own campus. The table is not secured by business unit.
Create a simple query joined with the CSU_DEPT_ROLL table
Step 1: Open the Navbar button

Step 2: Navigate to Menu > Reporting Tools > Query > Query Manager
- You might need special permission to access this page.
Step 3: Click Create a New Query.

Step 4: Add a table to your query. In this example, we are searching for an EMPLOYEES table.
- Enter search criteria. You can use the percent sign (%) as a wildcard.
- Click Search.
Step 5: Click Add Record.

Step 6: Select the fields to include in your query by checking the check boxes.

Step 7: Open the Records tab.

Step 8: Search for the CSU_DEPT_ROLL - RPT table.
- Enter search criteria: CSU_DEPT_ROLL.
- Click Search.

Step 9: Click Join Record for the CSU_DEPT_ROLL - RTP Department Rollup Table

Step 10: Select the table that you want to join with.

Step 11: Click Add Criteria.

Step 12: Select the fields that you want to include in your query.
Step 13: Click Save.

0 Comments
Add your comment