The structure of the audit tables will be: AUDIT_OPRID (key field and required) AUDIT_STAMP (key field and required) AUDIT_ACTN (key field and required) Relevant fields from the user profile tables The following are screenshots of the structure of the audit records used in this example. No...
The answer in this particular case is to fix the code. We have to go back to the user, explain why it is necessary to join parent and child tables and get them to correct their PS/Query. Finding PS/Queries Without Joins on Related Records In PeopleSoft, the parent of a child record ...
Use this procedure to build the project and create PeopleSoft views and tables in the database.To build the project using the Application Designer:Building the Project Select Build—>Project. The Build dialog appears. In the Build Options area, select the Create Tables and Create Views options....
The user has the ability to personalize his or her grid by hiding columns and tabs, reordering columns and tabs, and freezing columns of their choice. This tables list the delivered eight tab names and fields within those tabs for the Direct Line Reports pagelet: Note: Unless otherwise noted...
This is an attempt to list PeopleSoft meta-tables along with some kind of description for every table. The list will be broken into categories (pages, records, components, and so forth). Please feel free to add to or correct the list, this is a wiki page, so jump in!
There is some really interesting information in these tables from a security perspective. What would be the one item you’d add to PeopleSoft if you could? I would like to see some built-in functionality to make it easier to identify sensitive data (bank account numbers, SSNs, etc.) ...
Code to query PeopleTools tables to discover where and how some of the new objects are stored. Useful for behind the scenes compares. What would be the one item you’d add to PeopleSoft if you could? A guarantee of longevity. What everyday thing are you better at than anyone else?
31、g;CREATE_TRIGGER *;REM - CREATE VIEWS/SET LOG D:PT8.53logviews.log;REPLACE_VIEW *;REM - CREATE TEMP TABLES/SET LOG D:PT8.53logtemptbls.log;CREATE_TEMP_TABLE *;截图如下:3、更新数据库最新PeopleTools发布(1)更新PeopleTools系统表1 登录linux系统的sqlplus,以access Id(SYSADM)运行rel851un....
When I did, the import said it’s successful but when I check from the backend, nothing was copied in all the tables I imported. Did I miss anythinng?. Please advise. As always, thanks so much. Reply Celtess # Hi Rakesh, Doing some research, I figure out my issue data miving...
A rule is not a customization but rather data stored in the PeopleSoft Enterprise tables. Customer-created rules are portable between the various versions of the product, leading to a lower TCO when upgrading to a new release. This is the strategy of all the recently delivered features ...