Search

Blog Entry

PS Query Expressions

Hello everyone, your Admissions Advisory Group will be posting a series of blogs over a range of topics. We'll start our series by taking a look at PS Query Expressions! You can use expressions as fields, or within criteria. They can help in formatting output for your users and can also...

Library Entry

Materializing a Better PS Query - Improving Query Row Level Security Performance

Using Oracle and PeopleSoft (PS) Query provides a flexible end-user data analysis solution for a lot of business needs, all secured behind multiple levels of built in PeopleSoft security. Unfortunately, as some institutions increase in size and volume the underlying row-level security that is a...

Materializing a Better PS Query - MIDHEUG 2019.pptx

Library Entry

PS Query Building Using Student Academic & Demographic Data-Expressions, Subqueries, Drilling URLs

This pre-conference workshop will provide the opportunity for hands-on query building from the ground up. The workshop will integrate the use of different types of expressions, subqueries, and drilling URLs. Student academic and demographic data will be used. Please be sure to have appropriate...

13 attachments

Library Entry

3 Ways to "Flatten" Data for Reporting or Exporting

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

Library Entry

Managing PeopleSoft Queries at Newcastle for End-User support (the highs and lows!)

At the University of Newcastle (UON), our PeopleSoft queries are out of control. We have thousands of public queries built over 18 years with Campus Solutions. Users find it very confusing to find a query, resulting in many requests for data to our Student Systems functional team. Word of mouth...

Library Entry

Demystifying the Advisement Tables

This session will discuss the conversion and use of the Advisement tables at CSU Long Beach. We'll dive into the basics of the SAA tables from the administrative set-up to batch processing. Our goal is to provide service excellence to our students and advisors. Automation is vital to support...

CSULB_SWHEUG_Alliance_2018_AA_Session_Mitchell (1).pptx

Library Entry

Determining Title IV Non-Program Courses by querying the Academic Advising Analysis Database

In an effort to comply with the federal guideline that "...you cannot award [a] student aid for classes that do not count toward his degree, certificate, or other recognized credential”, Azusa Pacific University (APU) created a query which compares a student's enrollment to his/her academic...

Determining_Title_IV_Non-Program_Courses_by_querying_the_Academic_Advising_Analysis_Database.pptx

Library Entry

Tuning your PS Queries without DBA intervention

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.

Library Entry

PS Query Tips and Tricks

Come learn some helpful tips and tricks for utilizing PS Query like strategies for writing queries, various ways to write criteria to get exactly the data you need, and the effective use of prompts and prompt tables for reusable queries.

How-to-Querying records and fields on a component.docx

Library Entry

Budget Overview - Bypass the Drilldown with a Query

This presentation will describe the tables that are used in the various levels of the Budget Overview page and identify data elements used to populate the data displayed within the drilldown pages. The presentation will include the SQL scripts used to build the query within PS Query Manager.