Archive for the ‘Peoplesoft Specific’ Category.
September 6, 2009, 6:00 pm
Most of my report and interface programs output snapshots of the database. Reports and interfaces about how the data has changed are more challenging. The effective date model of many Peoplesoft tables suggest that we can easily extract the history of data, but the difference between effective dates and action dates, and the availability of correction mode complicate the issue.
Continue reading ‘Reporting Changes In Peoplesoft With SQR, Part 1’ »
July 12, 2009, 6:00 pm
The only aspect of an SQR program that must be unique is its file name. The file name may also indicate something about the program within. There are restrictions on SQR program file names in the Peoplesoft environment, but there’s more flexibility than meets the eye. Continue reading ‘SQR Program File Names’ »
July 5, 2009, 6:00 pm
It is refreshing to have a new copy of the production database instance in the development database instance. It is also a bit frightening. Was anything important lost in the overwrite? Continue reading ‘Never Fear A Database Refresh Again’ »
June 14, 2009, 6:00 pm
We built and enhanced a real-time dashboard that alerted us to problems with Peoplesoft process instances. The next challenge is to investigate processes that fail, or processes that succeeded yet dissatisfied our co-workers (the output was not as expected). Let’s build an SQR toolkit to help us do that. Continue reading ‘Analyze Peoplesoft Process Instances With SQR’ »
June 7, 2009, 6:00 pm
Last week we wrote a real-time application in SQR. Yes, in SQR, the batch programming language. That should have been more thrilling than it turned out to be. Let’s try to make it more interesting, accessible, and informative. Continue reading ‘Real-Time SQR Process Monitor Dashboard 2’ »
May 31, 2009, 6:00 pm
SQR is a language primarily for batch processing, but it does have limited support for real time, interactive applications. Let’s build a process monitor that is better than (or at least different from) Peoplesoft’s version. Continue reading ‘Real-Time SQR Process Monitor Dashboard 1’ »
May 3, 2009, 6:00 pm
Here are some small but significant ways to speed up or streamline your SQR program. Continue reading ‘7 Little SQL Tricks’ »
April 26, 2009, 6:00 pm
The term “log file” implies that this file serves as a log; a diary; a record of significant events in the program. It’s a place for unofficial information or information about this instance of this program, not to be stored in the organization’s production database for widespread access and not to be printed in reports for the system’s customers. It’s information for the technical team to use for troubleshooting or analysis. Continue reading ‘4 Building Blocks Of SQR Log Files’ »
April 5, 2009, 6:00 pm
Peoplesoft allows the user to give direction to an SQR program by entering parameters on a webpage before the Process Scheduler runs PSSQR. Here is a new way to get those parameters to the SQR program. Continue reading ‘How To Read Peoplesoft Run Control Parameters In SQR’ »
February 15, 2009, 6:00 pm
There are two things we can do after we quicksort an array. First, we can read it row by row, and the data will be in order. Second, we can use a binary search to find a specific row very, very quickly. Continue reading ‘Array Searches in Peoplesoft SQR’ »