Body
This article provides an exercise to help learn the functions of the PS query by modifying an existing query.
Detailed Information
INFO: You need Query Manager access.
Please use the query in CSRPT, UMS_DTS_ENROLLMENT, and do these 10 exercises.
Exercise:
1. Log into CSRPT MaineStreet and search the query, UMS_DTS_ENROLLMENT. Click “Edit”.
2. Save the query as “UMS_DTS_ENROLLMENT_TEST” (as private)
3. Delete “STRM” field
4. Change the column name: “Acad Career” to “Academic Career” and change the translate value to "Long"
5. Change the order of the column: Move Credit hours to be the last column
6. Add new criteria: Credit hours "not equal to" 0
7. Sort data: sort credit hours (ascending order)
8. Add prompt for “ACAD_PROG” with the "Optional" box checked
9. Run the query
10. Delete the query you just created
- Running Reports with Query Viewer & Query Manager
- Saving & Organizing Queries
- Editing Queries - Delete a Field
- Editing Queries - Change Heading Text (fieldname)
- Editing Queries - Column Order
- Changing a Selection for Variables in a Criteria - Using Criteria
- Editing Queries - Sorting Order
- Adding a New Prompt
- Select the "Run" tab and the prompt screen will show up automatically. Enter values on prompts and then click OK.
- Saving & Organizing Queries - Deleting Queries
Environment
- PeopleSoft Campus Solutions Reporting (CSRPT)