# Reference > psLens reference material: PeopleSoft tables, configuration options, and technical details. --- Site [llms.txt](/llms.txt) --- ## 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](/docs/getting-started/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, PeopleTools Access report, Permission List Table Access report | | `PSAUTHITEM` | Menu / component authorizations per permission list | Permission Lists detail, Full Access report, Dangerous Permissions report, PeopleTools Access report, Permission List Table Access report | | `PSAUTHAS` | Application service authorization per permission list | Permission Lists detail, Application Services detail | | `PSAUTHBUSCOMP` | Component Interface authorization per permission list | Permission Lists detail, Permission List Table Access report | | `PSAUTHPRCS` | Process group authorization per permission list | Permission Lists detail, Process Definitions detail | | `PSAUTHSIGNON` | Authorized signon days and times per permission list | Permission Lists compare | | `PSAUTHWS` | Web service / service operation authorization per permission list | Permission Lists detail, Service Operations detail | | `PSMENUITEM` | Menu bar / menu item structure | Menus detail, Components detail (search record overrides), Permission Lists detail, Full Access report, Permission List Table Access report | | `PSROLEDEFN` | Role definitions | Roles browser, Component References, SSO Bypass Password Audit | | `PSROLECLASS` | Role-to-permission-list assignments | Roles detail, Users detail, Full Access report, PeopleTools Access report | | `PSROLEUSER` | User-to-role assignments | Users detail, Roles detail, Full Access report, SSO Bypass Password Audit, PeopleTools Access report | | `PSOPRDEFN` | User (operator) definitions | Users browser, Login Audit, SSO Bypass Password Audit, PeopleTools Access report | | `PSOPROBJ` | Definition Security grants: permission list to object group, with edit vs read-only (`DISPLAYONLY`) | PeopleTools Access report | | `PSOBJGROUP` | Definition Security object group membership (which definitions belong to a group) | PeopleTools Access report | | `SCRTY_ACC_GRP` | Query security access groups | Permission Lists detail, Query Trees detail, Permission List Table Access report | | `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, Permission List Table Access report | | `SQLSTMT_TBL` | Stored SQL statements for COBOL programs (`PGM_NAME`, `STMT_TYPE`, `STMT_NAME`, `STMT_TEXT`) | Records detail | | `PSRECFIELD` | Record-to-field assignments | Records detail, Fields detail, Component Interfaces detail, Message Definitions detail | | `PSPTSF_SD` | Search Framework Search Definition headers | Search Definitions browser | | `PSPTSF_SD_ATTR` | Search Framework Search Definition field mappings and search attributes (all fields included in index, attribute names, faceting flags) | Search Definitions detail | | `PSPTSF_SD_DCATR` | Search Framework Search Definition document category attributes | Search Definitions detail | | `PSPTSF_SRCCAT` | Search Framework Search Category definitions | Search Definitions detail | | `PSPTSF_SRCCATAT` | Search Framework Search Category definition mappings | Search 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, Permission List Table Access report | | `PSPNLGROUP` | Component-to-page mappings | Components detail, Component Interfaces detail, Permission List Table Access report | | `PSPNLGRPDEFN` | Component definitions | Components browser, Permission List Table Access report | | `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, DB Home | | `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, Permission List Table Access report | | `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 | | `PSRECDDLPARM` | Record DDL parameter overrides per database platform | Records detail | | `PSIDXDDLPARM` | Index DDL parameter overrides per database platform | Records detail | | `PSSPCDDLPARM` | Tablespace DDL parameter overrides per database platform | Records detail | | `PSDDLMODEL` | DDL statement model creation templates per database platform | Records detail | | `PSDDLDEFPARMS` | Default DDL model parameters per database platform | Records detail | | `PSOPTIONSADDL` | Additional platform DDL build options | Records detail | | `PSTBLSPCCAT` | Database tablespace catalog definitions | Records detail | | `PSRECTBLSPC` | Explicit record-to-tablespace assignments per database | Records detail | | `PSFLDDEFN` | File Layout header definition table | File Layouts browser & detail | | `PSFLDSEGDEFN` | File Layout segment hierarchy and file-record mapping table | File Layouts detail | | `PSFLDFIELDDEFN` | File Layout field attributes, positions, and formatting masks table | File Layouts detail | | `PSXPRPTDEFN` | BI Publisher report definitions | BI Publisher browser & detail | | `PSXPDATASRC` | BI Publisher data source definitions | BI Publisher detail | | `PSXPTMPLDEFN` | BI Publisher template definitions | BI Publisher detail | | `PSXPTMPLFILEDEF` | BI Publisher template file definitions | BI Publisher detail | | `PSXPRPTVIEWER` | BI Publisher report security viewers (Role/User distribution) | BI Publisher 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, DB Home | | `PSSERVICE` | Service definitions | Services browser | | `PSSERVICEOPR` | Service operations within a service | Services detail, Application 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 | | `PSIBAPPLDEFN` | Application service (ASF) definitions | Application Services browser | | `PSIBAPPLOPR` | Application service operations and handler classes | Application Services detail | | `PSIBAPPURI` | Application service URI templates | Application Services detail | | `PSIBAPPMETHOD` | Application service REST method configuration | Application Services detail | | `PSIBPARAM` | Application service method parameters | Application Services detail | | `PSIBBASEPARAM` | Application service base parameters | Application Services detail | | `PSIBTEMPLPARAM` | Application service template parameters | Application Services detail | | `PSIBBASETMPLPRM` | Application service base template parameters | Application Services detail | | `PSIBAPPLSTATES` | Application service result state to HTTP status mappings | Application Services detail | | `PSIBAPPLHDRPROP` | Application service header properties | Application Services 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, DB Home | | `PSAPMSGDSPSTAT` | Integration Broker message dispatcher status | IB Monitor, IB Dispatcher alerts, DB Home | | `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, DB Home | #### Process Scheduler Tables | Table | Description | Used By | | ----------------- | ----------------------------------------------- | -------------------------------------------------------------------------- | | `PRCSDEFN` | Process definitions | Process Definitions browser, Components detail | | `PRCSDEFNGRP` | Process server groups for processes | Process Definitions detail | | `PRCSDEFNPNL` | Process to component (panel) mappings | Process Definitions detail, Components 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 | | `PRCSJOBMESSAGE` | Messages logged against job events | 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, Users detail, DB Home | | `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, DB Home | | `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 references on Records, Fields, Component Interfaces, App Packages, File Layouts, and SQL Objects detail pages | | `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 | | `PSQRYSELECT` | Query select blocks structure | Queries detail | | `PSQRYCRITERIA` | Query selection criteria | Queries detail | | `PSQRYEXPR` | Query expressions | Queries detail | | `PSQRYBIND` | Query prompt variables | Queries detail | | `PSQRYSTATS` | Aggregate query execution statistics | Queries detail (Query Stats panel) | | `PSQRYEXECLOG` | Individual query execution events | Queries detail (Execution Log panel), Users detail (Query History panel) | | `PSTREEDEFN` | Query tree definitions | Query Trees browser, Permission List Table Access report | | `PSTREENODE` | Query tree node structure | Query Trees detail, Permission List Table Access report | | `PSCHGCTLDEF` | System-wide PeopleTools Change Control settings | Projects detail (Change Control Status panel) | | `PSCHGCTLLOCK` | PeopleTools Change Control object checkout locks | Projects detail (Object Lock Info panel) | #### Audit & User Profile Tables | Table | Description | Used By | | ---------------- | ------------------------------------------------------------------------------------------- | ------------------------------- | | `PSPTLOGINAUDIT` | Sign-on / sign-off audit trail | Login Audit page, DB Home | | `PSACCESSLOG` | Sign-on and sign-off history (one row per session, with client address and sign-out reason) | DB Home (Sign-in Activity) | | `PSUSEREMAIL` | User email addresses | Users detail | | `PSOPRALIAS` | User ID alias mappings (Employee, Customer, Vendor, etc.) | Users compare tool | | `PSOPTIONS` | System-wide options; `OPRID` is the user context for Signon PeopleCode pre-authentication | Users detail (Special Use card) | #### Campus Solutions Security Tables | Table | Description | Used By | | ----------------- | --------------------------------------------------------------------- | ----------------------------------- | | `OPR_DEF_TBL_CS` | User Defaults CS (Institution, Career, Term, Aid Year, Business Unit) | Users detail (Campus Security card) | | `OPR_DEFAULT_TBL` | 3C User Defaults (Business Unit, SetID) | Users detail (Campus Security card) | | `OPR_GRP_3C_TBL` | 3C Group Security (Checklists, Comments, Communications) | Users detail (Campus Security card) | | `SCRTY_TBL_INST` | Academic Institution Security per user ID | Users detail (Campus Security card) | | `SCRTY_TBL_CAR` | Institution and Academic Career Security per user ID | Users detail (Campus Security card) | | `SCRTY_TBL_PROG` | Academic Program Security per user ID | Users detail (Campus Security card) | | `SCRTY_TBL_PLAN` | Academic Plan Security per user ID | Users detail (Campus Security card) | | `SCRTY_TBL_ACAD` | Academic Organization Security per user ID | Users detail (Campus Security card) | | `SCRTY_TBL_STGP` | Student Group Security per user ID | Users detail (Campus Security card) | | `SCRTY_TBL_SRVC` | Service Indicator Security per user ID | Users detail (Campus Security card) | | `SCRTY_TBL_MLSTN` | Milestones Security per user ID | Users detail (Campus Security card) | | `SCC_STY_TBL_CMP` | Institution / Campus Security per user ID | Users detail (Campus Security card) | | `SCRTY_ADM_ACTN` | Admissions Action Security per user ID | Users detail (Campus Security card) | | `SCRTY_PROG_ACTN` | Program Action Security per user ID | Users detail (Campus Security card) | | `SCRTY_APPL_CTR` | Application Center Security per user ID | Users detail (Campus Security card) | | `SCRTY_RECR_CTR` | Recruiting Center Security per user ID | Users detail (Campus Security card) | | `SAD_TEST_SCTY` | Admissions Test Load Security per user ID | Users detail (Campus Security card) | | `SCRTY_TSCRPT` | Transcript Type Security per user ID | Users detail (Campus Security card) | | `SSR_SCRTY_TSRPT` | Transcript Report Security per user ID | Users detail (Campus Security card) | | `SAA_SCRTY_AARPT` | Advisement Report Security per user ID | Users detail (Campus Security card) | #### Applied Maintenance Tables | Table | Description | Used By | | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------- | | `MAINTENANCE_LOG` | Updates applied to this database: change packages, the bugs they applied, PeopleTools patches, and one-off fixes. The first line of `DESCRLONG` (`PI38BUG39071423 - CAMPUS SOLUTIONS 9.2 PI038`) gives each row's package and PUM image | Applied Maintenance page | | `PSRELEASE` | Application release history (`RELEASELABEL`, `RELEASEDTTM`) | Applied Maintenance page header | | `PSSTATUS` | PeopleTools release and patch (`TOOLSREL`, `PTPATCHREL`) and when the last Tools patch was applied (`PTLASTPTCHDTTM`) | Applied Maintenance page header | | `PSPROJECTDEFN` | Change Assistant leaves a project named after each change package; its object list shows what the package changed. Projects whose names start with the package name are listed as related | Applied Maintenance page (package links) | ### Configuration Reference For the full `config.yaml` reference, see [Configuration](/docs/getting-started/configuration/). ### Alert Reference For details on all alert types, see the [Alerts](/docs/alerts/) section. ### Report Reference For details on all available reports, see the [Reports](/docs/reports/) section.