This presentation will give an overview of the steps for creating Connected and Composite queries, as well as the potential uses for each and examples of how they have been used at McMaster University.
Connected vs. Composite Queries - 2019 HEUG CANADA-final upload to HEUG with notes - on Nov 11.pptx
This presentation will look at some of the key problematic situations which have arisen at McMaster and might also flare up at other institutions. The relevant queries will be reviewed, as will the administrative processes which track the query results.
Forward With Integrity Reports.pptx
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
Some of the topics to be covered include: - Assignment and completion of checklist items when new ISIRs load after packaging. The checklist items hold award letter viewing/printing and disbursements, as well as alert processing staff that the student’s aid package must be reviewed. - Designing...
SWHEUG_20180702 (1).pptx
Do your queries run long and you don’t how to tune them without getting a DBA involved? This presentation will cover how an Oracle database processes your query, and will show you how to tune your query with little DBA intervention.
This presentation will provide concepts and procedures related to the PeopleSoft Query tool set. The PS Query tool set provides an easy mechanism to create and generate simple reports from PeopleSoft.
Moody Bible Institute needed a systematic approach to finding students’ enrollments that were not required for their degree programs. In using the delivered Academic Advisement components in Campus Solutions, the Institute added a “drip pan” to all Academic Advisement reports to select extra...
In this presentation WSU will show you the importance of using subqueries and or unions. At WSU unions are used greatly for automated processes and when combining multiple similar queries. Subqueries are used when refining search parameters and finding max effective dated/sequenced rows.
Boise State University has been on PeopleSoft since 1999 and the Student Financials and Financial Aid teams use the query tool heavily. Learn about favorite tables and data fields critical to day-to-day work in Student Financials and Financial Aid. We will also look at the basic joins, outer...
Moody Bible Institute needed to find students who were dropping from courses during a payment period in a term. Moody has multiple campuses with various sessions throughout a term; therefore, the Student Records office needed a more robust way of finding and tracking these students in the...
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