Recently the Student Records team at Azusa Pacific University discovered a few advanced PeopleSoft Query tricks to do things that only seemed possible with other tools. This session will cover some of those expressions in depth, and show how APU uses them to their advantage. Examples will be from Student Records and Campus Community, although the tools can be applied to all areas.There will be a look at custom GROUP BY/PARTITION BY logic for Aggregate and Analytical functions. Next, a close look will be taken at two expressions: LISTAGG and NTH_VALUE, and how they've saved APU a ton of unnecessary work in Excel, BI Publisher, and Connected Query.
https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=fcc8c68f-6ca5-4496-bd73-558a0f1c7fc1
The Higher Education User Group (HEUG) is a 501(c)(3) nonprofit dedicated to helping member institutions effectively manage administrative technologies to improve the student and user experience. We support executives, managers, and staff who select, deploy, integrate, and manage multiple systems by providing education, professional resources, and opportunities to connect with peers. As the digital landscape continues to evolve, HEUG adapts to meet the changing needs of its members while remaining committed to its core mission of connection, education, and advocacy.
Higher Education User GroupMesa, AZ 85212 United States
support@heug.org
M-F 8 AM to 5 PM MST
Join HEUG
Community Council
Interest Areas
Resources
Alliance Conference
Global Meetings
Online Webinars
Code of Conduct
Privacy Policy
Terms of Service
Copyright 2026 Higher Education User Group, Inc.
Copyright © 2026 Higher Education User Group, Inc.