Welcome to the “Peoplesoft and SQR” web log. My name is Steven Alexander. I worked on Peoplesoft HCM from November 1997 to October 2011 in various installations running with Oracle DBMS on UNIX file servers and Microsoft Windows client PCs.
I started this blog in January 2009 with the name “Peoplesoft SQR.” For the first year, it was about the SQR programming language and how best to use it. I wrote about techniques and algorithms, commands, and how to thrive within the Peopletools environment.
Adding a conjunction to the blog title reflected a wider range of topics. In 2010, I continued to write about the SQR programming language. I also wrote about Peopletools and using SQL (that’s an L, not an R) with the data in the Peoplesoft HCM modules (Human Resources, Base Benefits, Payroll, and Time & Labor).
I changed employers in April 2010. My new employer was a consulting firm where we earned our living by selling our intellectual property. I stopped this blog in deference to my new role.
I started my own business in November 2011, outside the world of Information Technology. My wife and I created and operate Pee Wee Bees, an indoor playground and birthday party place. We provide a comfortable environment and an enormous toy collection to children between 6 months and 7 years old. It is very exciting and enjoyable.
I am my own Information Technology department now. I created our website, www.PeeWeeBees.com. I created our customer database in the Microsoft SQL Server database that came with our Denali Accounting package. Since I don’t have access to a Peoplesoft environment, I cannot supply code samples. Also, the work I can share now pertains to SQL and Excel challenges.
I hope you, dear reader, will write for this blog as well. It’s not the best place to bring specific problems (e.g. how do I get my Application Engine program to send an e-mail with an encrypted attachment to Lotus Notes?). There are several other websites with worldwide legions of Peoplesoft developers who can respond to those questions around the clock. It is a good place to bring ideas that enhance a programmer’s productivity or a user’s Peoplesoft experience (e.g. here’s a SQL statement for finding the Portal path to the run control component for a given process), or to improve on my ideas in the weekly posts.