PeopleSoft Query For Grants Management: An Unauthorized Training Resource

PeopleSoft Query For Grants Management is a guide to Query development based on a Grants case study. The goals of this book are a) Interest: To create an interest in Complex PeopleSoft Queries. Today many query users create basic queries – without covering complex applications. Some users download query results to Microsoft Excel to analyze their data. b) Structured Approach: To provide all PeopleSoft users with basic structured training on PeopleSoft Query by creating actual queries in each chapter with increasing complexity. c) Relationships: To provide an understanding of the importance of PeopleSoft Query to other tools and functions in PeopleSoft. This book is structured to provide step-by-step training under a case study, while explaining each step in context of PeopleSoft Financials. This book covers: a) Understanding the basics of SQL (Structured Query Language) – the basis of PeopleSoft Query. b) Creating a basic Query with “Joins” (XX_TRAIN_001) c) Creating a query with “Prompts” (XX_TRAIN_002) d) Creating a query with “Distinct” (XX_TRAIN_003) e) Creating a query with “Expressions” (XX_TRAIN_004) f) Reviewing the SQL behind the Queries that we created. g) Creating a query with a simple example of a new feature in PeopleSoft 9.2 - “Transformations” through XSLT formatting (XX_TRAIN_005) The author is a Peoplesoft Grants & Financials consultant with over 15 years in Peoplesoft Consulting and 25 years in Finance & Accounting. This book is written with a focus on Grants Reporting - for all existing and potential Peoplesoft users.