"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. 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.