Archive for September 2009

Elements of SQR Style

Elements of Style is the famous book by William Strunk, Jr. and E.B. White.  First written in 1918, it is a guide to writing well in American English.  Anything good about the prose on this blog should be credited to Strunk & White.  The flaws must be ascribed to me.  This week’s blog entry is dedicated to that short book.
Continue reading ‘Elements of SQR Style’ »

SQR Variable Roles

I’ve written about variables several times (notably in Bottom #Ten Worst Variable Names and SQR Without Literals), but a recent entry on a new blog gave me a new way to think about them.
Continue reading ‘SQR Variable Roles’ »

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