Training Spotlight: Intermediate to PeopleSoft Query and Advanced PeopleSoft Query
Intermediate to PeopleSoft Query, Oct. 9
It is open to experienced PeopleSoft Query users who have completed the Introduction to PeopleSoft Query training. Topics covered will include expressions and functions (operators, data fields, data conversion), complex criteria (use of Like, In List, condition types, grouping), the XLAT table (what is it, how it works), advanced prompts using prompt tables, simple unions and subqueries and case studies of interesting queries. Learn more and register on Eventbrite.
Advanced PeopleSoft Query, Oct. 17
It is open to experienced PeopleSoft Query users who have completed the Intermediate PeopleSoft Query training. Topics covered will include subqueries (Exist/Not Exist, In List/Not In List, other condition types), the Case statement (If-Then-Else logic), union queries and outer joins, case studies (the “movement” queries and more), and aggregates (create and Q/C aggregate queries). Learn more and register on Eventbrite.