SQR for PeopleSoft Language Reference Preface This reference describes and demonstrates the structure, command set, and syntax of the Structured Query Report (SQR) language. It also provides a directory to the library of sample SQR programs, an overview of the SQR initialization file, and a listing of SQR messages. SQR Interview questions are asked commonly as most customers run SQRs. Have a look at SQR questions and answers here.

PeopleSoft, Inc. was a software company that provided HRM (human resource management), CRM (customer relationship management), Manufacturing, Financials, EPM (Enterprise Performance Management) and Student Administration software solutions to large corporations, governments, and organizations. Founded in 1987 by David Duffield and Ken Morris, originally headquartered in Walnut Creek, California, and eventually Pleasanton, California.

PeopleSoft's roots began with an idea Duffield had about a 'Client-Server' (then a new concept) version of Integral Systems's popular mainframe HRMS package.

In 2003, when PeopleSoft acquired J.D. Edwards, it decided to differentiate its former product line with those of Edwards by renaming both products. PeopleSoft's original flagship product was rebranded as PeopleSoft Enterprise. J.D. Edwards' ERP product was rebranded as PeopleSoft EnterpriseOne.

In January 2005, PeopleSoft was acquired in a hostile takeover by the Oracle Corporation. This takeover was resisted by PeopleSoft but Oracle overcame the legal challenge and after the approved merger, PeopleSoft ceased to be an independent company, although its products continue to be used by thousands of companies.

Both the Enterprise and EnterpriseOne products are considered ERP systems and modularized into specific components: HRMS (including payroll, human resources, benefits, etc.), Financials (including Accounts Payable, Accounts Receivable, General Ledger, Asset Management, EPM, etc), Manufacturing (including inventory, purchasing, billing, order management, production management, cost management), Student Administration, and CRM (including helpdesk, support, and sales).

PeopleSoft is well known for its ability to be easily customized or tailor-made, to fit the specific business needs of each client, while still being generic enough to meet corporate and governmental tracking requirements.

Product design:-

The whole software suite of PeopleSoft moved from the traditional client-server based design to web-centric design, called PeopleSoft Pure Internet Architecture (PIA) with their version 8 releases. The end result was that all of a company's business functions could be accessed and run on a web client. A small number of security and system setup functions, though, still needed to be performed on a fat client machine.

The inherent nature of Internet based applications allowed for a straightforward transition from a client-server model. One important feature of PeopleSoft's PIA is that no code is required on the client - there is no need for additional downloads of plugins, or JVMs such as the Jinitiator required for Oracle Applications.

The architecture is built around PeopleSoft’s own PeopleTools technology. PeopleTools is a proprietary development platform created by PeopleSoft. This platform includes many different components a developer theoretically needs to create an application including a scripting language, design tools to define various types of metadata, standard security structure, and batch processing tools. The metadata describes data for user interfaces, tables, messages, security, navigation, portals, and so forth.The benefit of creating their own development platform allowed PeopleSoft applications to run on top of many different operating systems and database platforms, It is not tied to a single database platform (though with the Oracle takeover, it is possible this could change in the future). PeopleSoft implementations exist on Oracle, Microsoft SQL Server, Informix, Sybase, and IBM DB2.

All of PeopleSoft’s modules (Human Resources, Supply Chain, Financials, CRM, etc.) are built with the PeopleTools technology. A benefit of the technology is that all the code which makes up a module can be customized to suit the owner’s business needs. An auxiliary product, PeopleCode, is an (ool) object-oriented proprietary language used to express business logic for PeopleSoft applications.

PeopleSoft Timeline:-

• 1987: PeopleSoft, Inc. founded by David Duffield and Ken Morris in Walnut Creek, CA, USA.
• 1988: PeopleSoft HRMS released.
• 1991: Begins opening international offices.
• 1994: Public distribution of Distribution and Financials modules.
• 1995: Launch of Student Administration System.
• 1996: Releases Manufacturing and PeopleSoft 6, their first ERP package.
• 1997: PeopleSoft 7 is released within upgraded ERP modules.
• 1998: PeopleSoft 7.5 is released with improved client/server technology. Acquired Intrepid Systems.
• 1999: Craig Conway named new CEO; release products to enable Internet transactions.
• 2000: Acquired Vantive Corporation.
• 2000: Deliver PeopleSoft 8 with an in-house application service provider.
• 2003: Acquired J.D. Edwards
• 2005: Acquired by Oracle Corporation.
• 2007: PeopleSoft HCM 9.0 is released.

1.What are the modules PeopleSoft offers?

PeopleSoft offers the following modules: Customer Relationship Management Financial Management Service Automation Human Capital Management Campus Solutions Supplier Relationship Management Enterprise Performance Management Supply Chain Management Supply Chain Planning Customer Order Management Logistics Management Manufacturing Supplier Relationship Management Asset Lifecycle Management and more...

1.What is PeopleSoft?

PeopleSoft is an integrated software package that provides a wide variety of business applications to assist in the day-to-day execution and operation of business processes. Each individual application, such as Financials, Customer Relationship Management and Human Resources, interacts with others to offer an effective and efficient means of working and reporting in an integrated fashion across the enterprise

1.What's the difference between PeopleSoft, SAP, Oracle and Siebel and Microsoft?

PeopleSoft, SAP and Oracle are the biggest 3 ERP vendors. They make Enterprise Resource Planning software. They also have a lot of larger customers as opposed to some of the smaller vendors. Siebel is primarily a software company that makes CRM (Customer Relationship Management) software. They have a lot of mid market clients as well as a few large ones. Microsoft...well, Microsoft are kinda in the ERP market with their Great Plains software but we are yet to figure out how much market share they plan to grab.

1.Why is PeopleSoft software so special in your opinion.

This is an interesting question. Well, one of the reasons is...because it's cool. PeopleSoft products continue to be very creative and innovative. They also tend to make simpler and more intuitive products. SAP is harder to learn and use while Oracle products are widely considered to be more buggy. PeopleSoft have really revolutionized ERP software with the introduction of their PIA (PeopleSoft Internet Architecture). This enabled their applications to be rolled out with no client footprint at all. The PeopleSoft community is actually a pretty small community where it feels like we all kinda know each other. Bottom line, it's a fun community.

1.Why did you guys build this site?

We built this site because we wanted to create a community where PeopleSoft employees, clients, contractors, consultants and even just the curious general public could come and learn about PeopleSoft. We are a bunch of workers in the PeopleSoft field and we love the product!

Peoplesoft Sqr Case Statement

1.How do you guys feel about the potential merger?

Hmm...well we are cautiously optimistic about the outcome of all this noise. The most important thing is that the spirit of PeopleSoft continues to dominate the company. That spirit is characterized by fun, freedom and continuous innovation. This is/was a fun company!! That's a lot of the reason why we love the product.

1.Why is the PeopleSoft skill set in such demand?

Well, relatively speaking, the demand for PeopleSoft expertise has declined substantially but in general, the skill set is still highly regarded and sought after. It is a highly specialized skillset. The free market economy kicks in here. The more complicated and specialized the software product is, the less resources have access to that expertise. That creates a supply and demand issue and the skill set becomes worth more. In addition training is an issue. It's more difficult (and expensive) to get trained on PeopleSoft or SAP than Microsoft Access or Lotus Notes. Microsoft Access developers or Lotus Notes developers get paid a lower rate than ERP resources because of the perceived complexity of ERP products relative to Notes or Access as well as the difference in the availability of training resources (books, CBT's etc).

1.Where is PeopleSoft headquartered?

Sqr Peoplebooks

PeopleSoft Inc.,
Worldwide Headquarters
4460 Hacienda Drive Pleasanton, CA 94588-8618
800-380-SOFT (7638) 925-225-3000 Fax: 925-694-4444

1.How do I get into PeopleSoft?

Sqr

There are two ways to do this: 1) By experience: Working at different client sites or companies and 2) By training: Getting trained on a plethora of PeopleSoft products by PeopleSoft professionals. PeopleSoft is starting to provide certifications for user but in our opinion, the horse has already bolted out of the barn. At the end of the day, experience is king. Certifications without experience = probably no employment. If you are just getting out of college and you'd like to get into PeopleSoft, your best hope is to join a consulting firm and try to get on a PeopleSoft project. That way, you can get valuable hands on experience that will get you started. Also, in a firm, they will probably pay for your training (pretty expensive). If you are an IT professional and would like to get into PeopleSoft, the advice above still applies to you but I would add that in your case (depending on the type and amount of IT experience you have), training and certifications may be helpful.