Audience :

  • Technical Consultants
  • Reports Developers
  • Project Team Members
  • Functional Implementers
  • Business Analysts

Topics :

  • Technology Overview
    • Learning Objectives
    • PeopleSoft Query
      • Why Use PeopleSoft Query?
      • Searching for Information to Build a Query
      • Ctrl + J
      • Keys
    • Query Manager
      • Query Viewer
      • Obtaining Information Using Query Manager
      • Common Terms Used in Query Manager
      • PeopleSoft Query Data Retrieval from Database to Report
    • Query Profile
    • Expressions
      • Why Use Expressions?
    • Any Join
      • Characteristics of an Any Join
    • Subquery
      • Subquery SQL and Results
    • Unions
    • Outer Joins
      • Why Use an Outer Join?
    • Drilling URLs
    • Summary
  • Using the Query Manager
    • Learning Objectives
    • Query Manager Basic Search Page
      • Searching and Managing Queries
    • Query Manager Advanced Search Page
      • Advanced Search
    • Organizing Queries
    • My Favorite Queries
      • Adding Queries to the My Favorite Queries List
      • Removing Queries from the My Favorite Queries List
      • Creating and Using Folders
      • Moving Queries to Folders
    • Query Manager Tool
      • Query Manager Pages
    • Editing Fields
      • Pages Used to Edit Fields in an Existing Query
      • Using the Fields Page
      • Displaying Image Fields
    • About the Activities
      • Required or Optional?
      • Which Part of the Activity Should I Read/Follow?
      • How Do I Know If I Did It Right?
      • Troubleshooting
    • Activity 1              Using Query Manager
      • Summary
    • Creating a Query
      • Learning Objectives
      • Creating a Query
        • Methods to Create a Query
      • Selecting Query Output and Editing Query Properties
        • Records Page
      • Query Page
      • Fields Page
      • Query Properties Page
      • Security Join Optimizer
    • Activity 2              Working with the Distinct Feature
      • Summary
    • Filtering Output with Criteria
      • Learning Objectives
      • Applying Criteria to Queries
      • Adding Criteria
        • Accessing the Edit Criteria Properties Page
        • Query Page
      • Expressions Page
      • Fields Page
        • Criteria Page
      • Defining Criteria
        • Using the Criteria Properties Page
      • Expression 1
      • Refining Criteria with Condition Types
        • Expression 2
      • Using Multiple Criteria Statements
      • Order of Processing Booleans
      • Process to Create Multiple Rows of Criteria
      • Effective Date
        • Effective Date Categories
        • Effective-Dated Record
      • Condition Types of the Effective Date Fields
    • Activity 3              Refining Queries with Effective-Dates and Complex Criteria
      • Summary
    • Filtering Output with Runtime Prompts
      • Learning Objectives
      • Runtime Prompts
        • Comparing Runtime Prompt Types
      • Creating Prompts
        • Prompts Page
        • Criteria Page
      • Edit Prompt Properties
      • Prompt Table Troubleshooting
        • Using Multiple Runtime Prompts
        • Editing a Runtime Prompt
      • Activity 4              Working with Prompts
        • Summary
      • Working with Multiple Tables
        • Learning Objectives
        • Joins in PeopleSoft Query
          • The Purpose of Joins
          • Differences between Tables and Views
        • How to Find the Tables for a Query
        • Predefined Joins
          • Record-Hierarchy Joins
        • Related-Record Join (Smart Join)
      • Activity 5              Using Record-Hierarchy and Related-Record Joins
        • Summary
      • Using Summary Calculations
        • Learning Objectives
        • Aggregate Functions
          • Using Predefined Aggregate Functions
        • Adding Aggregates
        • Aggregate Functions and Having Criteria
          • Having Criteria
          • Adding Criteria
        • Using the Having Criteria
      • Activity 6              Using Aggregates in a Query and Applying Having Criteria
        • Summary
      • Creating Expressions
        • Learning Objectives
        • Understanding Expressions
        • Using Links in Expressions
        • Query Runtime Prompts
          • Including Prompts in Expressions
          • Functions in Expressions
        • Including Literals in Expressions
      • Activity 7              Using Expressions in Queries
        • Summary
      • Implementing Any Joins
        • Learning Objectives
        • Understanding Any Joins
        • Identifying a Cartesian Join
        • Preventing Cartesian Joins
      • Activity 8              Creating an Any Join
        • Summary
      • Working with Unions
        • Learning Objectives
        • Explaining Unions
          • Rules of a Union
        • Why Use a Union?
        • Creating a Union
        • Using Literals as Placeholder Fields
          • Steps to Use Placeholders in Unions
          • Common Issues
        • Activity 9              Creating a Union
          • Summary
        • Outer Joins
          • Learning Objectives
          • Outer Joins
            • Purpose of an Outer Join
          • Creating an Outer Join
          • Outer Join Options on the Criteria Page
            • Criteria Outer Join Options
          • Activity 10           Creating an Outer Join
            • Summary
          • Using Subqueries
            • Learning Objectives
            • Subqueries
              • Subquery Rules
              • Uses of Subqueries
            • Single-Value and In List Subqueries
              • Navigation in a Subquery
            • Creating Single-Value or In List Subqueries
            • Exists or Does Not Exist Subqueries
          • Activity 11           Creating a Subquery
            • Summary
          • Drilling URLs
            • Learning Objectives
            • Drilling URLs
            • Steps to Create a Query Drilling URL
          • Activity 12           Using Drilling URLs
            • Summary
          • Introduction to Pivot Grids
            • Learning Objectives
            • Overview of Pivot Grids
            • Pivot Grid Flow Chart
            • Using PSQuery as a Data Source
            • Limitations of Using PSQuery as a Data Source
            • Pivot Grid Security
            • Create a New Pivot Grid
            • Fluid Mode for Pivot Grid
          • Activity 13           Creating Pivot Grids
            • Summary
          • Connected Query
            • Learning Objectives
            • Connected Query
            • Connected Query Quick Start
              • Steps for Using Connected Query Quick Start
            • Connected Query Manager
            • Connected Query Transformations
            • Connected Query Properties
            • Search for and Run a Connected Query
          • Activity 14           Using Connected Query
            • Summary
          • Composite Query
            • Learning Objectives
            • Composite Query
            • Composite Query Manager
              • Search for a Composite Query
            • Composite Query Manager Tool
            • Steps for Creating a Composite Query
            • Dependencies
          • Activity 15           Creating a Composite Query
            • Summary
          • Administrative Tasks
            • Learning Objectives
            • Reporting Console
          • Activity 16           Using the Reporting Console
            • Administrative Tasks for PSQuery
              • Query Viewer
            • Scheduling a Query
            • Query Administration Component
            • Collecting and Viewing Runtime Statistics
            • Disabling a Query
            • Query Administration - Executing and Settings
          • Activity 17           Using Administration Features
            • XSLT Transformations
              • Steps to Create PS Query Using Transformations
              • Getting Query Result in Defined Transformation Form
            • Summary
          • Final Activities
            • Learning Objectives
          • Activity 18           Using Any Join in Queries
          • Activity 19           Using Expressions in Queries
          • Activity 20           Using Prompts in Criteria
          • Activity 21           Create a Subquery
          • Activity 22           Team Exercise (Teams of Two)
            • Summary
          • Appendix
            • Abbreviation Glossary
              • HCM/HRMS Common Tables Used in Reporting
              • Hints
            • Common Campus Solutions Tables
              • Campus Community
              • Curriculum Management
              • Records and Enrollment
              • Set Up SACR
              • Security
              • Student Admissions/Recruiting
              • Student Financials