PeopleSoft Query For Grants Management: An Unauthorized Training Resource

By Herman J Pinto

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.

• Format: Paperback
• Language: English
• ISBN: 1505882877
• ISBN13: 9781505882872
• Release Date: December 2014
• Publisher: Createspace Independent Publishing Platform
• Length: 108 Pages
• Weight: 0.34 lbs.
• Dimensions: 0.2" x 6.0" x 9.0"