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.