Query Outside References
Under this section are links and information from other sources, mostly HEUG (Higher Education Users Group), but also including some on-line instructions from other institutions.
Read about HEUG features and logging in to the HEUG website
These documents do not necessarily reference Campus Solutions. However, the general concepts are the same, and you may find some helpful tips.
- Click this link to go to the PROCEDURES – OVERALL [External References] page to see outside documentation on non-query related PeopleSoft processes.
- Click here to visit the Lists of Links page which contains these and other links to educational/training documents found throughout the SFIS Blog.
NOTE: If you choose to use the information in these links, please do so with the understanding that some of the elements described may not be applicable to Campus Solutions or to SFIS.
CS 9.0, PTools 8.52: PeopleSoft Campus Solutions 9.0 – PeopleTools Version 8.52
HEUG.ORG Links
- Making the Most of PeopleSoft Query (Alliance 2011 – Oracle) Improvements 8.48 – 8.51
Other Links
- Oracle – PeopleBook- PeopleTools 8.52 – October 2011
- Oracle – Mastering PS Query (Pivot Grids, Drilling Down, Connected Query)
____________________________________
CS 9.0, PTools 8.54: PeopleSoft Campus Solutions Version 9.0 – Bundles 24-34 and PeopleTools 8.54
_______________________________________
CS 9.2, PTools 8.55: PeopleSoft Campus Solutions Version 9.2 and PeopleTools 8.55
Overall Query Demonstrations
- HEUG.ORG Links
- Just a Few of My Favorite Queries (Student Financials) (Alliance 2015 – Boise State)
- Query Building Using Expressions, Subqueries and Drilling URLS (Alliance 2014 Workshop – Northern Illinois University)
- Stuck in the Middle -Querying Between Beginner To Advanced (MIDHEUG 2014 – Illinois State)
- Taking Query to the Next Level (including sample queries) (2014 Webinar – HTS)
- PeopleSoft Query – Subqueries (HEUGUM 2012 – Northern Illinois University)
- Query Manager 101 – Basics, Tips and Tricks (2017 Webinar – Capella University)
Hints, Tricks and Tips
- HEUG.ORG Links
- PS Query Expressions, tips, and tricks for improving popsels and data sources. For functional users (2016 Webinar – The University of Texas at Dallas)
- Tips & Tricks in Managing Queries and Using Expressions (2013 Webinar – Embry-Riddle)
- Query Tips and Tricks (CARHEUG 2012 – Sierra-Cedar)
- Quick Query Quips (Alliance 2013 – Washington State University)
- PS Query Tool: From Finding Data to Writing Expressions (Alliance 2013 Workshop – Brigham Young University)
Query Expressions / Functions page
- HEUG.ORG Links
- Query Expressions and Tips (CARHEUG 2012 – Northern Illinois University)
- Flexible Reporting Using Expressions (Alliance 2013 – Indiana Family & Social Services Administration)
- Expressions in Query: An In-Depth Exploration into Function Statements (Alliance 2007 – Central Washington University)
- Expressions in PS Query (Latin American HEUG 2014 Conference – University of Texas at Arlington)
Advanced Query Presentations
- HEUG.ORG Links
- Aggregate reporting in multiple dimensions using PS Query (Alliance 2016 – Lone Star College)
- PS Query: Advanced Tips Using Expressions (2015 Asia HEUG Conference – Singapore Institute of Management)
- Drilling URLs – More Information at Your Fingertips (2016 Webinar – Northern Illinois University)
- Expressions, Subqueries and Drilling URLs (MIDHEUG 2013 – Northern Illinois University) [This contains an excellent subquery demonstration]
- Advanced Query: Unions, Subqueries, and Joins (NEWHEUG 2014 – University of Massachusetts)
Connected Query
- For an overview of Connected Query, go to the Connected Query and BI Publisher page.
- To review some presentations on Connected Query, see the New & Notable Features > Query Features page.
Pivot Grid
- To review a number of presentations on Pivot Grid, go to the Query and Reporting Features page under – New & Notable Features –