UIS is offering a Campus Solutions online course for the CU-SIS Campus Solutions Community. It will be four hours, not including the hour break for lunch on your own. The course will be led by renowned Campus Solutions expert and former CU Boulder employee, Vic Goldberg. It is $50 per participant and limited to 20 participants.
Campus Solutions PS Query 101
Course Description: Participants will learn the basics of the PS Query tool. While PS Query is available in all PeopleSoft applications, this training will be student centric and intended for Campus Solutions' functional users.
Topics:
- Learn what queries are, including some database and PeopleSoft terminology
- Running existing queries
- Building your own query
- Naming conventions
- Testing / Sanity checks
- Creating criteria
- Reordering fields
- Finding tables
- Joining tables
- Creating prompts
- Aggregates
- Running queries in batch
- Your requests and questions