STRUCTURED QUERY REPORTING AND BATCH PROCESSING

Learn the basics of PeopleSoft's text-based reporting and batch processing tool

What you will learn

  •  SQR Basics
  •  Print Coordinates
  •  SQL SELECT Statements
  •  Conditional Statements
  •  Variables
  •  Built-in Functions
  •  Formatting
  •  Edit Masks
  •  Local and Global Procedures
  •  User Input and Parameters
  •  Lookup Tables and Arrays
  •  Graphics
  •  Text Editors
  •  Headers and Footers
  •  Column Variables
  •  Flow-control Statements
  •  Substitution Variables
  •  Print Commands
  •  Functions
  •  SQC Files
  •  Run Control Pages and Records
  •  Interfaces and Integration
  •  SQL Commands
  •  Debugging and Tracing

Note: This course includes Two days of video content and four days of textual instructions and hands-on activities.

Also Available as

WHO SHOULD ATTEND?

  • Report Writers

  • PeopleSoft Developers

Certificate

Each course includes a blockchain-enabled digital certificate of achievement to prove your participation in our online course. Since this is a digital certificate, you print it, add it to your LinkedIn profile, or share it on social media!

Duration

Students typically complete this material within 28 hours.

You will have access to the videos for 60 days after purchase and may keep the accompanying activity guide for life.

RECOMMENDED PREREQUISITES

Course curriculum

  • 1
    Introduction
    • © Copyright
    • 💡 Hints and Definitions
    • How to use this course
  • 2
    1. SQR Basics
    • Overview
    • Watch: What is SQR?
    • What is SQR?
    • SQR Tools
    • Watch: A Very Simple SQR
    • A Very Simple SQR
    • Launching an SQR
    • Common SQR Errors
    • Watch: Basic SQR Elements
    • Basic SQR Elements
    • Print Coordinates
    • Watch: The Page as a Grid
    • The Page as a Grid
    • Watch: Review a Delivered SQR
    • Watch: Headers and Footers
    • Headings and Footings
    • Watch: Numbering Pages
    • Numbering Pages
    • Test Your Learning
    • Summary
  • 3
    2. SQL SELECTs in SQR
    • Chapter Overview
    • Watch: SQL Select Statements
    • SQL SELECT Statements in SQR
    • Implicit and Explicit Print Commands
    • Watch: Procedures
    • Procedures
    • Begin-Select/End-Select
    • Watch: Column Variables
    • Column Variables with SQL Select Statements
    • Watch: Important SQL Concepts
    • Important SQL Concepts When Working with PS Data
    • Watch: Activity: Job Report
    • Activity 2-1: Job Report
    • Watch: Solution: Job Report
    • Test Your Learning
    • Summary
  • 4
    3. Flow Control Commands
    • Chapter Overview
    • Watch: Flow Control Commands
    • Flow Control Commands
    • If … Else … End-If
    • Evaluate
    • While Loops
    • Exit-Select
    • Do
    • Goto
    • Stop
    • Watch: Activity: Flow Control Report
    • Activity 3-1: Flow-control Report
    • Watch: Solution: Flow Control Report
    • Test Your Learning
    • Summary
  • 5
    4. Variables
    • Chapter Overview
    • Variables
    • Declaring Variables with Specific Data Types
    • Declaring Variables Explicitly
    • Assigning Values to Your Run-Time Variables
    • How to Trace the Values of Your Variables
    • SQR Reserved Variables
    • Substitution Variables
    • Watch: Activity: Variables Report
    • Activity 4-1: Using Variables
    • Watch: Solution: Variables Report
    • Test Your Learning
    • Summary
  • 6
    5. Built-in Functions and Commands
    • Chapter Overview
    • Watch: Built-in Functions and Commands
    • Working with Date Values
    • DateNow
    • DateAdd
    • DateDiff
    • StrToDate
    • DateToStr
    • Manipulating Text Strings
    • Miscellaneous String Functions
    • Manipulating Numeric Values
    • Watch: Activity: Using Functions
    • Activity 5-1: Using Functions
    • Watch: Solution: Using Functions
    • Test Your Learning
    • Summary
  • 7
    6. Print Commands
    • Chapter Overview
    • Watch: Print Commands
    • The Print Command – Beyond the Basics
    • Print Coordinates
    • Format Options with the Print Command
    • Edit and Edit Masks
    • On-Break
    • Watch: Activity: Print Commands
    • Activity 6-1: Using Print Command Switches
    • Watch: Solution: Print Commands
    • Test Your Learning
    • Summary
  • 8
    7. SQC
    • Chapter Overview
    • Watch: Understanding SQC
    • Include Files (A.K.A. “SQC” Files)
    • Activity 7-1: Create an SQC
    • Some of the Most Commonly Used PeopleSoft SQC Files
    • SQC Files that Select Data
    • SQC Files that Define Report Layouts
    • Activity 7-2: SQC Reporting
    • Test Your Learning
    • Summary
  • 9
    8. Global and Local Procedures
    • Chapter Overview
    • Watch: Global and Local Procedures
    • Global and Local Procedures
    • Declaring Local Procedures
    • Referencing Global Variables from Local Procedures
    • Activity 8-1: Local Variables
    • Test Your Learning
    • Chapter Overview
  • 10
    9. SQR Program Structure
    • Chapter Overview
    • Watch: Program Structure
    • Five Sections of an SQR Program
    • Setup Section
    • Heading Section
    • Footing Section
    • Procedure Section
    • An SQR Shell Program
    • Standards and Conventions
    • Processing Sequence – Compile Time
    • Processing Sequence – Run Time
    • Delivered SQRs/SQCs & SQR Help
    • Test Your Learning
    • Summary
  • 11
    10. Running SQR Programs
    • Chapter Overview
    • Watch: Running SQR Programs
    • Launching an SQR from the Command Line
    • Launching an SQR Program in PeopleSoft
    • Run Control Page
    • Run Control Record
    • Run Control Records and Pages: Reusing vs Creating
    • Component
    • Process Definition
    • Granting User Security Access to SQRs
    • Process Groups and Permission Lists
    • Associating Process Groups with Permission Lists
    • Test Your Learning
    • Summary
  • 12
    11. User Input & Report Parameters
    • Chapter Overview
    • User Input for SQRs – Report Parameters
    • Retrieving Report Parameters
    • Dynamic SQL
    • Activity 11-1: User Input and Dynamic SQL
    • Test Your Learning
    • Summary
  • 13
    12. Debugging and Tracing
    • Chapter Overview
    • Debugging Techniques
    • Limiting the Number of Loops for Begin-Select
    • Logging Your SQL Statements with the –S Argument
    • Temporary Hard-Coding of WHERE Clause Values
    • Compiler Directives
    • Additional Compiler Directives
    • Common Mistakes
    • The Rules for SELECT Paragraphs
    • My SQR ran without any errors, but it did not generate a report. What happened?
    • Test Your Learning
    • Summary
  • 14
    13. Lookup Tables & Arrays
    • Chapter Overview
    • Lookup Tables and Arrays
    • When Should Load-Lookup Be Used?
    • Load-Lookup
    • Lookup
    • How Does Load-Lookup Work?
    • Arrays
    • Creating Arrays
    • Populating Arrays
    • Retrieving Data Values from an Array
    • Clearing an Array
    • Using Arithmetic Operations on Elements of an Array
    • Test Your Learning
    • Summary
  • 15
    14. Interfaces and Integration
    • Chapter Overview
    • Flat File Manipulation
    • Activity 14-1: Generating a Tab-delimited File
    • Reading from a File
    • File Manipulation
    • Using Inserts, Updates, Deletes, & Other SQL Commands
    • Error Handling
    • Activity 14-2: Creating Fields
    • Generating Multiple Reports from a Single SQR Program
    • Multiple Reports and Process Scheduler
    • Test Your Learning
    • Summary
  • 16
    15. Using Graphics in SQR
    • Chapter Overview
    • Watch: Graphics
    • Graphics
    • Horizontal Lines
    • Vertical Lines
    • Boxes
    • Changing Font Style and Font Sizes
    • Bar Codes
    • Graphical Images
    • Activity 15-1: Creating Forms
    • Test Your Learning
    • Summary
  • 17
    16. Online References
    • Online References
  • 18
    17. Next Steps
    • Course Survey