Data, data everywhere, and not a drop to drink!!! We’re surrounded by a wealth of data and the way we parse and present it to make data easily understandable and actionable is the theme of these following presentations. Learn best practice methods to make the most of presenting data. Find out...
Do you know how to find an existing similar query before creating a new one from scratch? The SQL text of PS query is not stored as it is in system but that is generated when you click on the tab of View SQL in Query Manager. If you have access privilege in Query Manager, you can find all...
3 Comments - no search term matches found in comments.
Note that the below is a link to a free podcast offered by The Tambellini Group as part of our ongoing strategic partnership. For more information on this partnership and The Tambellni Group, please visit here . The Tambellini Group’s Katelyn Ilkani interviews San Cannon, Associate...
COMMUNITY SPOTLIGHT Technical and Reporting The Technical and Reporting Communities are maintained by the Technical & Reporting Advisory Group (TRAG). The TRAG provides advice and guidance on the technology underpinning the (Oracle) software applications used by the Higher...
This presentation will define a framework for integrating student data from admissions to graduation and everything in between. Once the framework levels are defined, we will technically discuss how to populate the framework. We will then technically discuss how the framework drives the...
This session is designed for PSQuery writers familiar with the basics of PeopleSoft query manager reporting, but looking to get more out of the tool. The University of Texas at San Antonio has used PSQuery as its main reporting platform for almost 5 years since PeopleSoft implementation. Come...
SCHRUG_8126_190723_1110.pptx
If you have ever needed to include information in a report or dataset that is multiple rows in the database but you need it output as a single row, this session is for you. A common financial aid request is to show all of the student’s awards, but keep the output as a single row per student. I...
BGSU MidHEUG Flat Data.pdf
Once just an ad-hoc reporting and investigation tool, PeopleSoft Query is the foundation of critical PeopleSoft infrastructure including Approval Workflow Engine, Keyword search, Pivot Grid component search, Pivot Grids, and BI Publisher Reports. In this session you will learn tips and tricks to...
ADVISORY GROUP SPOTLIGHT Technical & Reporting (TRAG) Our Mission: Our aim is to support institutions in understanding and managing the heterogeneous systems landscape with a mixture of on-premise and ‘cloud’ applications, and the various integration, reporting strategy and governance...
The Strategic Advising Dashboard has different tiers of aggregation that summarize the student data at varying levels. The first view is a summarized count across six groups of metrics. The second view is a detailed table with student-level data providing additional information for the user. The...
Multitiered aggregation with advising data.pptx
Finance
HCM
Student Systems
CRM
Technical
Careers
Alliance
International / Regional
E-Academy
User Membership
Corporate Membership
Finance | HCM | Student Systems | CRM | Technical | Careers
Alliance / International / Regional / E-Academy
User Membership / Corporate Membership