Publisher's Synopsis
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.
