November 15, 2006

Followup

"Followup" isn't really a word, but it should be! Maybe someday it will go into the dictionary and replace "follow-up." So today, a few followup items.

In response to last week's post, Duncan asked, "Doesn't PSRECFIELDDB do the expanding of PSRECFIELD subrecords for us? I always use that in preference to PSRECFIELD." He found this description of the table: "This record is an exact copy of PSRECFIELD. It is used to store only actual Record/Field combinations. No subrecords are stored. This table is not kept in sync with PSRECFIELD. It is loaded during the SYSAUDIT for performance reasons."

The description seems a little strange. It wouldn't be very useful if it were actually "an exact copy of PSRECFIELD." Instead, it's apparently an expansion of the subrecords in addition to the regular fields, as Duncan pointed out. I do remember references to this table, but for some reason it didn't exist during my recent upgrade (using Tools 8.47). There were references in the documentation to an App Engine program, but I didn't find that either. If SYSAUDIT builds the table, that would need to be run to get the up-to-date version of the record/field list. But certainly, if you have this table, it would be easier and more efficient to use it (rather than my method) for quick searches where 100% accuracy might not be required. Thanks, Duncan.

Remember "Dave's Next Move?" Dave Duffield came out of retirement to start another company, now called Workday. Well, the company has already released its first module, Workday Human Capital Management. As expected, it's an on-demand system based on the "software-as-a-service" model using web services.

So now those of us who support PeopleSoft systems are aligned with Oracle and Dave is the competitor. OK, that feels, um, weird...

As previously mentioned, version 1.6.2 of the SQR debugger has been released. I recommend that all customers upgrade to this version. Log in here. It takes just a couple of minutes to install and no reboot is needed.

There are a number of online forums that handle SQR questions. But it seems that the same few questions keep popping up over and over again. Next week I'll nominate a "top five" and briefly summarize or point to the answers. No, that won't prevent them from being asked again and again all over the place. But it might be helpful to some readers.

Until next time...