Search

Library Entry

PS Query : Advanced Tips Using Expressions

The session will cover some advanced techniques which can be used while building the PS Query with expressions as part of it. Student record related tables were used as part of the examples. The session will benefit the super users/ business analysts who help to develop PS Query reports for the...

SIM_AdvancedTipsInExpression_20151109 v1.0.pptx

Library Entry

PeopleSoft Query – Expressions, Drilling URLs and Subqueries

#PSQuery #Expressions #Drilling URL #Subqueries #Dede Young

MIDHEUG 2013.pdf

Library Entry

TechOnTheNet.com Web Resource

#Daniel Labrecque #Website #resource #SQL #PSQuery #Expressions

Discussion Thread 8

TechOnTheNet.com SQL Function Resource

Library Entry

Queries, Checklists, and Things that go Bump in the Night

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. ...

9 attachments

Library Entry

Making PS Query aggregate and flatten your data like a champ

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...

PSQry Aggregate and Flatten- Final.pdf

Library Entry

Expressions & Subqueries Using Student Academic Data

Using the tools you have on-hand, you may enhance your queries and expand the functionality using expressions and subqueries. Learn how to exclude a group where more than one value may be possible (such as student groups, service indicators), select a first or last term and related data, list...

Session 3752 Alliance 2017_Expressions & Subqueries.pptx

Library Entry

PS Query Expressions

#Jamie Polizzi #PSQuery #Expressions #BlogPost

PS Query Expressions.pdf

Library Entry

PS Query for Functional Users – Expressions

Agenda Expressions Aggregates Drilling URLs Manipulating Dates Miscellaneous expressions Replace null values Substrings Concatenate Decode Case Statements Regular Expressions Meta-SQL What else can we do with queries? Creating Queries as content references,...

PS Query Expressions 9-20-2021.pptx

Library Entry

Expressions in PS Query

During the course of this presentation, we will cover some of the expressions supported by the Query tool, and provide some use cases which demonstrate why they are useful. https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=b1ca95b7-1108-4bb8-9c4b...

NERUG_query_expression_2019.pptx