A Special Announcement
Please come back on Tuesday, April 6, 2010 for an exciting announcement.
Continue reading ‘A Special Announcement’ »
From Process To Peoplesoft Page
Last week we discussed finding the best Peoplesoft page, and the menu path to that page, for viewing and updating a particular database table. We have a similar need to find the menu path to the run control page for a particular batch process.
Continue reading ‘From Process To Peoplesoft Page’ »
From Database Table To Peoplesoft Page
When I discuss data with my colleagues in the Human Resources and Payroll departments, we speak different languages. I talk about tables and columns. They talk about menus, tabs, and pages. “You need to change EEO4CODE in PS_JOBCODE_TBL,” I’ll say. They’ll reply, “You mean, select Setup HRMS, Foundation Tables, Job Attributes, Job Code Table, and the Job Code Profile tab?” There are pages I’ve never visited and they’ve never used a SQL browser.
Continue reading ‘From Database Table To Peoplesoft Page’ »
PS_EMPLOYMENT Bug Report
PS_EMPLOYMENT used to be a SQL table. Now it is a SQL view that joins PS_PER_ORG_ASGN, PS_PER_ORG_INST, and PS_JOB. Of course, PS_JOB has two subselects to pick a single value of EFFDT and EFFSEQ for each value of EMPL_RCD. The subselect for EFFDT is unusual and it may not behave the way the designers intended.
Rounding Error
Some people use the term “rounding error” to indicate that an answer is right enough, although not perfectly right. Those people think “accurate” and “precise” are two different concepts. They may be experimental scientists or programmers, but they aren’t working in Accounting. Accountants cannot and should not leave journal entries alone with rounding errors.
Continue reading ‘Rounding Error’ »
Merging Bundles With Customized Peopletools Objects
We’re always happy yet apprehensive to get a new bundle of bug fixes for Peoplesoft. We anticipate that our applications will run more reliably, perhaps faster, and maybe with a few new features. The chore that nobody likes, though, is checking for Oracle’s changes that affect the Peopletools objects we have customized.
Continue reading ‘Merging Bundles With Customized Peopletools Objects’ »
The Rewrite And The Bug Fix
Last week I worked on two SQR program bugs. I rewrote the first one from scratch. I wanted to rewrite the second one but didn’t. Here is why.
Continue reading ‘The Rewrite And The Bug Fix’ »
Avoid Subqueries
I have nothing against subqueries, but there are times in the Peoplesoft environment that they are unnecessary. If we can get exactly the same results with simpler, faster SQL, let’s avoid subqueries.
Continue reading ‘Avoid Subqueries’ »
Dynamic Views in Application Designer
Views are a useful feature of SQL databases, letting us create virtual tables based on SQL select statements. The Peoplesoft Application Designer also lets us create dynamic views, which we may use within the page processor.
Views You Can Use: Position Data
Some organizations manage their workforces with positions. A position specifies a job and a place on an organization chart, which can exist without a person or with more than one person. Position management can give organizations more control over their structures, budgeting, and succession planning.
Continue reading ‘Views You Can Use: Position Data’ »