{"product_id":"peoplesoft-query-for-grants-management-herman-j-pinto-9781505882872","title":"PeopleSoft Query For Grants Management: An Unauthorized Training Resource","description":"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 \u0026amp; Financials consultant with over 15 years in Peoplesoft Consulting and 25 years in Finance \u0026amp; Accounting. This book is written with a focus on Grants Reporting - for all existing and potential Peoplesoft users.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Herman J. Pinto\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1505882877\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781505882872\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Createspace Independent Publishing Platform\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 12\/14\/2014\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 108\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.34lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.02h x 5.98w x 0.22d","brand":"Herman J. Pinto","offers":[{"title":"Paperback","offer_id":48217433866495,"sku":"9781505882872","price":9.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_a4817e6e-ea0c-4c82-a42f-2fbde1162b3b.jpg?v=1771997188","url":"https:\/\/www.whiterainbookhouse.com\/products\/peoplesoft-query-for-grants-management-herman-j-pinto-9781505882872","provider":"WR Book House","version":"1.0","type":"link"}