PeopleSoft Query
Part III – Advanced Concepts
Most lessons begin with an Overview and then the following sections:
Lesson 11: Improving Query Performance
- Run Time
- Columns
- Preventing a Runaway Query
- Joins
- Duplicates
- Views
- Table Ordering
- PS Query and Security
- Criteria – Constants and Prompts
- Multiple Criteria Values
- Return a Limited Number of Rows
Lesson 12: Join Variations
- Record Hierarchy Joins
- Related Record Joins
- Manual Joins/Un-joins
- Auto Joins
Lesson 13: Expressions – More Examples
- Expression with a formatted date
- Other Expression Text with formatted dates and results
- Expression Using Case
- Expression Using substr()
- Expressions and Prompts
- Expressions and Mathematical Calculations
Lesson 14: Wes Functions Review
- Wesleyan Function Examples
- EMPLID
- EMPLID Plus Other Fields
- Full Descriptions of Fields
- Today’s Date and Term
- Variation in Results
- Citizenship
- Name
Lesson 15: Prompts and Table Edits
- Restricting User Input with Table Edits
- Prompt Table Edit
- Translate Table Edit
- Yes/No Table Edit
- Unrestricted User Input
- No Table Edit
Lesson 16: Counts and Sums in Query (Aggregate Functions and Having Criteria)
- Describing Aggregate Functions and Having Criteria
- Using Aggregate Functions
- Having Criteria
- Using Predefined Aggregate Functions
- Using Having Criteria in Queries
Lesson 17: Mastering Outer Joins
- Outer Join selecting criteria that belongs to On Clause
- Outer Join using (+)
Lesson 18: Subqueries – Introduction
- Using a subquery to identify first term of enrollment
Lesson 19: Creating Union Queries
- Using Literals in Unions
Lesson 20: Supplementary Information
- Links to other documentation
Part I – Basic Query Concepts and Query Viewer