software development, devops, and other drivel
Tree lined path

PeopleTools Tables

PeopleTools Object Version Tables

PeopleTools Object Versions Record Description PSLOCK This table is used for version control PSOPTIONS This table is used to turn the change control enabling feature on or off. PSVERSION This table holds the version number details

PeopleTools Process Scheduler Tables

PeopleTools Process Type Details Record Description PS_PRCSDEFN Contains process type and process names PSPRCSLOCK Contains a single record, this gets updated when a process is submitted PeopleTools Process Status Record Description PSPRCSQUE Holds the process request details and should be in sync with PSPRCSRQST. PSPRCSRQST This table holds the process submitted details PS_CDM_LIST Contains the process instance details. Should be in sync with PS_CDM_AUTH PS_CDM_AUTH Contains the process instance details PeopleTools Report Node Details Record Description PS_CDM_DIST_NODE This table holds the report node information which contains the report repository details PS_CDM_DISTSTATUS Contains the definition of report status PeopleTools Batch Server Details Record Description PS_SERVERDEFN Contains the server definitions PSSERVERSTAT Gives information about the batch server status

PeopleTools Security Tables

Page Nav User Tables Roles Permission Lists PeopleSoft Login Details and Authorization Query Security Tree Example SQL Queries Security is a very important part of any PeopleSoft application. It determines what pages users can see all the way down to which rows. It may seem overwhelming at first but don’t worry; it’s pretty straightforward once you learn all the pieces and how they’re connected. Below you will find a list of the Main PeopleTools Security Records along with a brief summary of their purpose. Read more...

PeopleTools Update User Password DataMover

Useful for when the main user id gets locked out. First log into Datamover in bootstrap mode. Then using the script below update the users password. Note: the script will vary depending on the peopletools version. I forget what the version is exactly, 8.54 I believe. For earlier versions of PeopleTools: update PSOPRDEFN set OPERPSWD = 'password', ENCRYPTED = 0 where OPRID = 'OPRID'; -- to encrypt the password encrypt_password OPRID; For later versions of PeopleTools Read more...

PeopleTools Version Details Tables

PeopleTools Version Details Record Description PSRELEASE This table holds the application release details PSSTATUS This table gives the peopletools information

Start Data Mover Bootstrap Mode

If the PS password has been lost or otherwise hosed, use bootstrap mode to make things right again. In order to start Datamover in bootstrap mode, use the system access ID and access password. For example by default it’s SYSADM. Learn how to update a user password including the PS password if needed.

User Security Join Table (SJT) Jobs

All of the SJT (Security Join Tables) jobs that that joins security information from other tables in the database into a temporary table on the application server for use in business rules. SJT_OPR_CLS: Contains the User IDs with their data permission lists. SJT_CLASS_ALL: Contains the data permission information for all the data permission lists that are given data access on the ‘Security by Dept Tree’ page or ‘Security by Permission List’ page. Read more...