AUDITACTIONS describes audit trail action type codes. This table can be used to map action type numbers to action type names. AUDITOPRID; AUDITSTAMP; AUDITACTN; The audit stamp field is a date/time field. However in order for it to be correctly populated, make sure that you set it to Auto-Update so that it is automatically set to the correct date/time stamp. If you are using the same audit record for multiple records then add the field AUDITRECNAME. Select. from psxlatitem where fieldname = 'AUDITACTN' - lists all of the defined system values for audit action. Audit actions are described in Enterprise PeopleTools 8.49 PeopleBook: PeopleSoft Application Designer, Chapter 6, p118, and 'O' is not described here. I scanned a production database and did not find any occurance of 'O' in the. Aug 22, 2013 PeopleSoft: Audit Actions. From the previous post, we have seen various ways of Auditing. Let's see the easy way to understand the Record Level Audit with below example. Below is the sample Transaction Record and Audit Record. Lets now do below transactions and see how data is stored for Record Level Audit.
Jul 22, 2015 PeopleSoft Audit To help us keep track of changes done to sensitive data by appropriate user, we use Audit. Later we can query the Audit record to see the list of changes happened. In PeopleSoft, we can set Audit at.
I could not find this else where and hence, I decided to build one myself – a complete list of PeopleSoft tables. Often a times when working on something like a PeopleSoft issue or a PeopleSoft upgrade, you feel the need to have a handly list of PeopleSoft tables.
What we’ve tried here is to provide a huge list of PeopleSoft Tables so that when you want to have quick access to PeopleSoft Tools Tables and their usage, then you can simply head over to this post.
PeopleSoft Object Definition Tables
| PSACTIVITYDEFN | Activity definitions are stored |
| PSAESECTDEFN | Stores the application engine section definitions |
| PSAESTEPDEFN | Stores the application engine step definitions |
| PSAESTEPMSGDEFN | Stores the messages of the AE programs |
| PSPCMPROG | Peoplecode programs stored |
| PSSQLTEXTDEFN | Application engine sql |
| PSAEAPPLDEFN | Application engine program name |
| PSMENUDEFN | Menu names |
| PSPNLDEFN | Page names |
| PSPNLGROUP | Stores Component definitions |
| PSBCDEFN | Stores component interface names |
| PSBUSPROCDEFN | Stores Business process definitions |
| PS_APPR_RULE_HDR | Stores Approval rule set definitions |
| PSCHNLDEFN | Stores channel definitions |
| PSEVENTDEFN | Changing the column value of active to 0 leads to disabling activities |
| PSFLDFIELDDEFN | Filelayout stored |
| PSFILEREDEFN | File reference stored |
| PSINDEXDEFN | Index information stored |
| PSIODEFN | Stores business interlink information |
| PSKEYDEFN | Stores the index key information |
| PSMPDEFN | Contains info about mobilepages |
| PSMSGAGTDEFN | Refers to the activity object |
| PSMSGCATDEFN | Related to Messages – Message catalogs |
| PSMSGDEFN | Stores Application Message definitions |
| PSDBFIELD | Contains field definitions |
| PSDDLDEFPARMS | This table holds the storage structure of the tables for db platforms |
| PSGATEWAY | This table hold the gateway url. |
| PSIDXDDLPARM | This table holds the storage structure of the indexes for db platforms |
| PSRECDEFN | This table holds the information of all the peoplesoft records. |
| PSPACKAGEDEFN | This table holds the application packages definitions |
| PSPNLGRPDEFN | Contains Panel group definitions |
| PSPRDMDEFN | Contains the portal information |
| PSPROJECTDEFN | Contains project definitions |
| PSPRSMDEFN | Detailed information of the portal objects |
| PSPRUFDEFN | Information about portal objects |
| PSPRUHDEFN | Information about portal objects |
| PSQRYDEFN | Holds the query definitions |
| PSROLEDEFN | Role definitions |
| PSSQLDEFN | SQL object definitions are stored |
| PSSQLTEXTDEFN | SQL object’s text are stored |
| PSSTEPDEFN | Contains stepnames with reference to the activity |
| PSSTYLEDEFN | Contains the styles definitions |
| PSSTYLSHEETDEFN | Contains the stylesheet definitions |
| PSSUBDEFN | Conatins Message subscription definitions |
| PSTOOLBARDEFN | Holds a single row provided by PS, which helps to view the toolbar |
| PSTREEDEFN | Contains the treename |
| PSCLASSDEFN | Gives info abt the peoplesoft permission lists |
| PSURLDEFN | To see which URL’s are used as fileservers for the file attachments |
| PS_AE_TEMPREC_VW | Tracks all temporary tablenames and their descriptions |
| PS_AE_TEMPLOCK_VW | Tracks how many locks are currently in effect for a particulartemporary table |
| PS_DATA_FIND_BASE | Used as search record for the panel. SHould always be empty. |
| PS_MSG_CATLG_VW | Contains text for all error messages and warnings. |
PeopleSoft Security Tables
| PSROLECLASS | Provides the permission lists associated to each role |
| PSROLEUSER | Gives info abt the roles assigned to the Oprid’s |
PeopleSoft Login Details and Authorization
| PSACCESSLOG | Login and logout information of the users |
| PSACCESSPRFL | Contains the symbolic id,accessid/password details. |
| PSCLOCK | Login fails if the table is empty |
| PSOPRDEFN | This table holds the peoplesoft Oprid’s/passwords info with symbolic id. |
PeopleSoft Audit Tables
| PSAUDIT | This table holds all the changes for panel/record modifications |
PeopleSoft Version Details
| PSRELEASE | This table holds the application release details |
| PSSTATUS | This table gives the peopletools information |
PeopleSoft Language Details
| PSLANGUAGES | Contains 1 for the column INSTALLED against the columnLANGUAGE_CD. |
PeopleSoft Modules Listed
| PS_INSTALLATION | List the modules in the database |
PeopleSoft Process Type Details
| PS_PRCSDEFN | Contains process type and process names |
| PSPRCSLOCK | Contains a single record, this gets updated when a process is submitted |
PeopleSoft Process Status
Peoplesoft Audit Actions Examples
| PSPRCSQUE | Holds the process rqst details should be in synch with psprcsrqst.Should be in synch with PSPRCSRQST |
| PSPRCSRQST | This table holds the process submitted details |
| PS_CDM_LIST | Contains the process instance details.Should be in synch withPS_CDM_AUTH |
| PS_CDM_AUTH | Contains the process instance details |
PeopleSoft Report Node Details
| PS_CDM_DIST_NODE | This table holds the report node information which contains the reportrepository details |
| PS_CDM_DISTSTATUS | Contains the definition of report status |
PeopleSoft Batch Server Details
| PS_SERVERDEFN | Contains the server definitions |
| PSSERVERSTAT | Gives information about the batch server status |
PeopleSoft RenServer Details
| PSREN | Holds the portnumber details of a renserver configured domain |
PeopleSoft Translate Value Details
| PSXLATDEFN | Holds the translate fieldname and version number for caching |
| PSXLATITEM | Holds the translate fieldname and their values |
PeopleSoft Object Versions
| PSLOCK | This table is used for version control |
| PSOPTIONS | This table is used to turn off or on the change control enabling feature |
| PSVERSION | This table holds the version number details |
Peoplesoft Audit Program
Though we tried to compile a comprehensive list of all PeopleSoft tools tables but we may have missed some of those. If you know of any other important tables which are not present in above list, please do share with us in comment section below.
Recent posts
How to Create Short Path for Windows Folders or Directories
April 15, 2019
Delivered PeopleSoft WorkCenter Pagelets
April 11, 2019
Psaudit Table In Peoplesoft
Shares
Never Again Google for PeopleSoft Tables.
Download COMPLETE LIST OF PEOPLETOOLS TABLES
This is the most exhaustive table list. Updated for PeopleTools 8.55