|
|
|
EDITCHK.SQR
LAST UPDATED: December 4, 2002
PeopleSoft Field Edit Checker. This program verifies to the best of its ability
that the data in those fields which have some type of Table Edit (Y/N Xlat, or
Prompt Table) are valid values, based on the edit table. Some
Prompt Table edits rely on key values being present on the panel,
but not necessarily on the current record. Since data necessary to
perform the check is not available, this program is unable to
determine the validity of the underlying data and will display a
message stating so. Other Prompt Table edits rely on dynamically
defined Prompt Tables (such as %EDITTABLE). This program is unable
to perform checks in this situation either and will display an
error message stating that the Prompt Table is invalid. Y/N and
Xlat checks should work correctly in all situations.
|
|
|
ALTAUDIT.SQR
LAST UPDATED: January 2, 2002
PeopleSoft SQR-Based Alter Audit. In addition to running the SYSAUDIT and
DDDAUDIT SQR, PeopleSoft clients should run the Alter Audit. Unforutnatly,
in the past, this has been a manual and long process. And, even then, the
results were not presented in a clean format. This has led me to develop
the SQR-Based Alter Audit. This program will compare the PeopleSoft Record
Definitions for Tables (RECTYPE = 0) and compare them to the ORACLE definition
for the record. Any differences will be reported.
|
|
|
