Archive for the ‘Peoplesoft Specific’ Category.

Reporting Changes In Peoplesoft With SQR, Part 2

Last week, we considered change reporting based on the effective dates and action dates of PS_JOB. Other Peoplesoft tables track history differently. We need other approaches to report those changes.
Continue reading ‘Reporting Changes In Peoplesoft With SQR, Part 2’ »

Reporting Changes In Peoplesoft With SQR, Part 1

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’ »

SQR Program File Names

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’ »

Never Fear A Database Refresh Again

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’ »

Analyze Peoplesoft Process Instances With SQR

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’ »

Real-Time SQR Process Monitor Dashboard 2

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’ »

Real-Time SQR Process Monitor Dashboard 1

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’ »

7 Little SQL Tricks

Here are some small but significant ways to speed up or streamline your SQR program. Continue reading ‘7 Little SQL Tricks’ »

4 Building Blocks Of SQR Log Files

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’ »

How To Read Peoplesoft Run Control Parameters In SQR

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’ »