Reference

psLens reference material: PeopleSoft tables, configuration options, and technical details.

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.