Reference
This section contains reference material for understanding psLens internals and the PeopleSoft tables it works with.
PeopleSoft Tables Used by psLens
The following tables list every PeopleSoft metadata and operational table that psLens queries through the SWS framework. All of these must be whitelisted (see Installation for the full whitelist SQL).
If you add a new query against a PeopleSoft record in the code, add it to the appropriate category below and add a matching INSERT to the installation guide.
Security Tables
| Table | Description | Used By |
|---|---|---|
PSCLASSDEFN | Permission list definitions | Permission Lists browser, Full Access report |
PSAUTHITEM | Menu / component authorizations per permission list | Permission Lists detail, Full Access report, Dangerous Permissions report |
PSAUTHAS | Application service authorization per permission list | Permission Lists detail |
PSAUTHBUSCOMP | Component Interface authorization per permission list | Permission Lists detail |
PSAUTHPRCS | Process group authorization per permission list | Permission Lists detail, Process Definitions detail |
PSAUTHWS | Web service / service operation authorization per permission list | Permission Lists detail, Service Operations detail |
PSMENUITEM | Menu bar / menu item structure | Menus detail, Permission Lists detail, Full Access report |
PSROLEDEFN | Role definitions | Roles browser, Component References |
PSROLECLASS | Role-to-permission-list assignments | Roles detail, Users detail, Full Access report |
PSROLEUSER | User-to-role assignments | Users detail, Roles detail, Full Access report |
PSOPRDEFN | User (operator) definitions | Users browser, Login Audit |
SCRTY_ACC_GRP | Query security access groups | Permission Lists detail, Query Trees detail |
SCRTY_QUERY | PS/Query security profile per permission list (capabilities, row/time limits, advanced SQL flags, output destinations) | Permission Lists detail |
PTACM_ACCESSTBL | Access Control Manager (ACM) template grants per permission list | Permission Lists detail |
PSPTSCRTY_ADS_A | ADS Access Group Security — read/write access to data-migration access groups per permission list | Permission Lists detail |
Metadata Tables
| Table | Description | Used By |
|---|---|---|
PSDBFIELD | Field definitions | Fields browser, Records detail |
PSDBFLDLABL | Field labels and translate value labels | Fields detail, Records detail |
PSXLATITEM | Translate (xlat) values | Fields detail |
PSRECDEFN | Record (table / view / derived) definitions | Records browser, Components detail, Message Catalog Usages report |
PSRECFIELD | Record-to-field assignments | Records detail, Fields detail, Component Interfaces detail, Message Definitions detail |
PSKEYDEFN | Record key / index definitions | Records detail |
PSPNLDEFN | Page definitions | Pages browser |
PSPNLFIELD | Fields placed on pages | Pages detail, Components detail, Component Interfaces detail, Message Catalog Usages report |
PSPNLGROUP | Component-to-page mappings | Components detail, Component Interfaces detail |
PSPNLGRPDEFN | Component definitions | Components browser |
PSMENUDEFN | Menu definitions | Menus browser |
PSXFERITEM | Menu item transfer destinations (target menu / component / page / portal / node) — keyed on MENUNAME + ITEMNAME only (no BARNAME). Populated for PSMENUITEM.ITEMTYPE = 12 (Transfer) items. | Menus detail |
PSPROJECTDEFN | Project definitions | Projects browser |
PSPROJECTITEM | Items contained in a project | Projects detail, App Packages detail |
PSBCDEFN | Component Interface definitions | Component Interfaces browser |
PSBCITEM | Component Interface property and method items | Component Interfaces detail |
PSPRSMDEFN | Component Reference (CREF) and folder definitions | Components detail, Component References |
PSPRSMSYSATTR | Component Reference system attributes | Component References detail |
PSPRSMSYSATTRVL | Component Reference system attribute values | Component References detail |
PSPRSMATTRVAL | Component Reference custom attribute values | Component References detail |
PSPRSMPERM | Component Reference permission list mappings | Component References detail |
PSPRUFDEFN | Portal user favorites | Users detail |
Integration Broker Tables
| Table | Description | Used By |
|---|---|---|
PSMSGNODEDEFN | Message node definitions | Nodes browser, Nodes No Password report, Users detail (Special Use: nodes whose USERID = this OPRID) |
PSNODECONPROP | Node connector properties | Nodes detail |
PSNODEURITEXT | Node URI text | Nodes detail |
PSNODESDOWN | Down message nodes and blocked transactions | Nodes detail, Nodes Down alert |
PSSERVICE | Service definitions | Services browser |
PSSERVICEOPR | Service operations within a service | Services detail |
PSOPERATION | Service operation definitions | Service Operations browser, Message Definitions detail |
PSOPERATIONAC | Service operation handler access (status) | Service Operations detail |
PSOPERATIONURI | Service operation URIs | Service Operations detail |
PSOPRVERDFN | Service operation version definitions | Service Operations detail |
PSOPRVERDFNPARM | Service operation version parameters | Service Operations detail, Queues detail |
PSOPRHDLR | Service operation handler definitions | Service Operations detail |
PSIBRTNGDEFN | Integration Broker routing definitions | Services detail, Nodes detail |
PSRTNGDFNPROP | Routing properties | Services detail, Nodes detail |
PSRTNGDFNPARM | Routing parameters | Services detail, Nodes detail |
PSQUEUEDEFN | Service operation queue definitions | Queues browser |
PSQUEUEPART | Queue partitions | Queues detail |
PSAPMSGDOMSTAT | Integration Broker message domain status | IB Monitor, IB Domain alerts |
PSAPMSGDSPSTAT | Integration Broker message dispatcher status | IB Monitor, IB Dispatcher alerts |
PSAPMSGPUBHDR | Async publication message headers | IB Monitor, IB Operation alerts |
PSAPMSGPUBCON | Async publication contracts | IB Monitor, IB Pub Contract alerts |
PSAPMSGSUBCON | Async subscription contracts | IB Monitor, IB Sub Contract alerts |
PSIBLOGHDR | Sync IB transaction log | IB Monitor (sync log tab + overview + sync detail page), Service Operations detail (sync history browser), IB Sync Exceptions alert, IB Daily Volume report |
Process Scheduler Tables
| Table | Description | Used By |
|---|---|---|
PRCSDEFN | Process definitions | Process Definitions browser |
PRCSDEFNGRP | Process server groups for processes | Process Definitions detail |
PRCSDEFNPNL | Process to component (panel) mappings | Process Definitions detail |
PSAUTHPRCS | Process group authorization per permission list | Permission Lists detail, Process Definitions detail |
PRCSJOBDEFN | Job definitions | Process Jobs browser |
PRCSJOBGRP | Process server groups for jobs | Process Jobs detail |
PRCSJOBITEM | Items (processes) within a job | Process Jobs detail |
PRCSJOBPNL | Job to component (panel) mappings | Process Jobs detail |
PRCSMUTUALEXCL | Mutually-exclusive process rules | Process Definitions detail |
PRCSRECUR | Recurrence definitions | Recurrences browser |
PRCSRECURDATE | Recurrence calendar exception dates | Recurrences detail |
PRCSRECUREXEMPT | Recurrence exemption ranges | Recurrences detail |
PSPRCSRQST | Process scheduler request (run history) | Process Monitor, Process alerts, Recurrences detail |
PRCSDEFNNOTIFY | Process notification settings (users/roles) | Users detail, Roles detail |
PRCSDEFNCNTDIST | Process content distribution list settings | Users detail, Roles detail |
PRCSJOBNOTIFY | Process job notification settings | Users detail, Roles detail |
PRCSJOBCNTDIST | Process job distribution list settings | Users detail, Roles detail |
SERVERDEFN | Process Scheduler server definitions | Server Definitions browser |
PSSERVERSTAT | Process Scheduler server status | Server Definitions detail |
SERVERCATEGORY | Process categories run on a server | Server Definitions detail |
SERVERCLASS | Process types run on a server | Server Definitions detail |
SERVERNOTIFY | Server status notification settings | Server Definitions detail |
SERVEROPRTN | Server operation windows schedule | Server Definitions detail |
DAEMONGROUP | Daemon group Application Engine member mappings | Daemon Groups detail |
DAEMONGROUP_VW | Distinct list of daemon groups | Daemon Groups browser |
Developer Tables
| Table | Description | Used By |
|---|---|---|
PSAEAPPLDEFN | Application Engine program definitions | App Engines browser |
PSAEAPPLSTATE | Application Engine state record assignments | App Engines detail |
PSAEAPPLTEMPTBL | Application Engine temp table assignments | App Engines detail |
PSAESECTDEFN | Application Engine sections | App Engines detail |
PSAESTEPDEFN | Application Engine steps | App Engines detail |
PSAESTMTDEFN | Application Engine SQL / action statements | App Engines detail |
PSPACKAGEDEFN | Application Package definitions | App Packages browser |
PSPCMPROG | PeopleCode program metadata | PeopleCode search, Pages detail, Components detail, App Packages detail, Component Interfaces detail |
PSPCMNAME | PeopleCode program name index | PeopleCode search |
PSPCMTXT | PeopleCode program source text | PeopleCode search, App Engines detail, App Packages detail, Roles detail, Message Catalog Usages report |
PSMSGCATDEFN | Message Catalog entries | Message Catalog browser |
PSMSGSETDEFN | Message Catalog set definitions | Message Catalog browser |
PSMSGDEFN | IB message definitions | Message Definitions browser |
PSMSGVER | IB message version definitions | Message Definitions detail |
PSMSGATTR | IB message attributes per version | Message Definitions detail |
PSMSGFLDOVR | IB message field overrides | Message Definitions detail |
PSMSGPARTS | IB message parts | Message Definitions detail |
PSMSGREC | IB message record references | Message Definitions detail |
PSCONTDEFN | Content definitions (HTML / Style / Image / File) | HTML Defs browser, Style Defs browser |
PSCONTENT | Content body storage | HTML Defs detail, Style Defs detail |
PSURLDEFN | URL object definitions | URLs browser |
PT_URL_PROPS | URL object properties | URLs detail |
PSSQLDEFN | SQL object definitions | SQL Objects browser, Records detail (views) |
PSSQLTEXTDEFN | SQL object source text | SQL Objects detail, Records detail (views) |
PSQRYDEFN | PeopleSoft Query definitions | Queries browser |
PSQRYFIELD | Query field selections | Queries detail |
PSQRYRECORD | Query record sources | Queries detail |
PSQRYSTATS | Aggregate query execution statistics | Queries detail (Query Stats panel) |
PSQRYEXECLOG | Individual query execution events | Queries detail (Execution Log panel) |
PSTREEDEFN | Query tree definitions | Query Trees browser |
PSTREENODE | Query tree node structure | Query Trees detail |
Audit & User Profile Tables
| Table | Description | Used By |
|---|---|---|
PSPTLOGINAUDIT | Sign-on / sign-off audit trail | Login Audit page |
PSUSEREMAIL | User email addresses | Users detail |
PSOPTIONS | System-wide options; OPRID is the user context for Signon PeopleCode pre-authentication | Users detail (Special Use card) |
Configuration Reference
For the full config.yaml reference, see Configuration.
Alert Reference
For details on all alert types, see the Alerts section.
Report Reference
For details on all available reports, see the Reports section.