PeopleSoft Query for Grants Management: An Unauthorized Trai ...

Herman J Pinto

• 14 december 2014
• 9781505882872

Samenvatting:

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.