What's New & Changelog

Recent feature releases, PeopleTools object additions, security enhancements, and system updates in psLens.

Release & Change History

This page tracks major updates, new PeopleTools object handlers, security features, and configuration enhancements in psLens.

September 17, 2026 — Views Referencing Records in SQL

  • Record Related Data: Views Referencing in SQL:
    • Discover SQL views and dynamic views whose underlying SQL definitions reference a record or its SQL table.
    • View details include view name with direct link, view type badge, description, object owner, and last-updated metadata.
    • Included in the Record markdown export options for impact assessments.

September 6, 2026 — PeopleSoft Trace Analyzer

  • Trace Analyzer (/trace):
    • Upload, inspect, and analyze PeopleSoft trace files (.tracesql, .trc, and .aet).
    • Automatically reconstructs execution call hierarchies for PeopleCode methods, functions, and Application Engine steps with timing breakdown.
    • Interactive SQL statement analytics with slow query detection, bind variable substitution, and candidate N+1 loop detection.
    • Cross-references traced database tables with the live PeopleSoft catalog to display record types (SQL Table, SQL View, Dynamic View) and provide direct one-click links to Record definitions.
    • Links Application Package methods and Application Engine steps directly to their object inspectors in psLens.
    • Side-by-side execution path diffing to align and compare two trace runs (e.g. Test vs. Production or working vs. failing transactions) to pinpoint where logic branched.
    • Quick-reference modal for PeopleTools TraceSQL, TracePC, and TraceAE bitmask recipes.

September 4, 2026 — Security Comparisons Saved to Reports & Scheduled Audits

  • Automatic Report Persistence for Security Compares:
    • Running a security comparison for Permission Lists, Roles, or User Profiles now automatically saves the complete comparison results and Markdown report to the Reports repository.
    • Interactive comparison results now include a “View in Reports” button for easy navigation to stored comparison runs and historical review.
  • Scheduled Security Comparison Reports:
    • Added on-demand and scheduled reports for Permission List Comparison, Role Comparison, and User Profile Comparison under the Security reports category.
    • Run or schedule comparisons across environments (such as Production vs. Test) to detect security configuration changes and drift over time.

September 4, 2026 — Markdown Viewer Tool

  • Markdown Viewer (/markdown-viewer):
    • Open, inspect, format, and print PeopleSoft markdown exports directly in the browser.
    • Supports drag-and-drop file upload, file browsing, and direct text pasting for .md, .markdown, and .txt files.
    • Formats tables with spreadsheet styling, highlights code fences (PeopleCode, SQL, HTML, XML), and renders PeopleSoft alert callouts ([!NOTE], [!TIP], [!IMPORTANT], [!WARNING], [!CAUTION]).
    • Displays document reading metrics (word count, reading time, file size, table counts).
    • One-click toggle between rendered preview and raw markdown source.
    • One-click copy for markdown content and clean browser printing / PDF export.
    • Direct helper link added to all object definition “Export as Markdown” sidebar cards.

September 2, 2026 — Public Software Bill of Materials (SBOM) & License Compliance

  • Public Software Bill of Materials (SBOM): Automated CycloneDX v1.6 SBOM generation (/sbom.json) integrated directly into the documentation build and deployment pipeline.
  • License & Dependency Inventory: Published a dedicated SBOM & Licenses page detailing all compiled runtime packages and frontend asset licenses.

September 1, 2026 — Record/Field Reference Finder & Impact Analysis

  • Record/Field Reference Finder (/records/{recname}/fields/{fieldname}):
    • Launched directly from any record’s field listing or field detail record usage tables.
    • Full cross-object impact analysis across 7 PeopleTools metadata dimensions:
      • Pages (PSPNLFIELD): Lists all page definitions containing the record field, with page type and control type badges.
      • Components (PSPNLGROUP): Lists components hosting pages with the record field, including item name, search record, and marketplace info.
      • Component Interfaces (PSBCITEM): Lists CIs exposing the record field with property names and access modes.
      • PeopleCode Programs (PSPCMPROG & PSPCMNAME): Identifies direct record field events, component record field events, and where-used code references.
      • PSQueries (PSQRYFIELD): Finds queries selecting or filtering on the record field with column headings and criteria.
      • File Layouts (PSFLDFIELDDEFN): Finds file layout definitions and segments mapping the record field.
      • Search Definitions (PSPTSF_SD_DCATR): Identifies Search Framework definitions indexing the record field as search or display attributes.
    • Real-time parallel metrics summary badges and asynchronous SSE loading for high-scale databases.
    • Markdown report export (/records/{recname}/fields/{fieldname}.md) and MCP tool analyze_record_field_impact.
    • Permission List Query Tree Deep Links: Query Access Tree nodes on the Permission List detail page now link directly to the tree definition (/querytrees/{tree_name}).

August 31, 2026 — PeopleSoft Compare Report Analyzer

  • Compare Report Analyzer (/compare-reports):
    • Upload and analyze PeopleSoft Application Designer binary compare reports (.idx and .prt files).
    • Supports uploading a single .zip archive containing compare report files or multi-file drag-and-drop.
    • Generates compare summaries showing project metadata, source database, target database, release, run date, and total changed object counts across definition types.
    • Interactive definition diff viewer for 17-column definition reports (Records, Pages, Components, Menus, Roles, Permission Lists, Portal Registry, Routings, and Documents) with before/after attribute value comparisons.
    • Line-level PeopleCode diff viewer with unified diff formatting and side-by-side code comparisons for Application Package PeopleCode (Upg58).
    • Downloadable Markdown summary reports and CSV exports for definition differences.

August 30, 2026 — Cross-Database Security Object Compare (Roles & User Profiles)

  • Cross-Database Role Comparison (/roles/compare):
    • Expanded the cross-database security comparison toolset to diff PeopleSoft Role definitions (PSROLEDEFN) across environments (e.g., DEV vs. PROD) or within the same database.
    • Compares assigned permission lists (PSROLECLASS), assigned users (PSROLEUSER) with dynamic rule assignment flags (DYNAMIC_SW), Process Scheduler job notifications and distribution lists, and aggregate effective access across Pages, Web Libraries, Service Operations, and Component Interfaces.
    • Real-time SSE comparison stream with summary metric cards, deep links to detail pages in both databases, and full Markdown report export (/roles/compare/export).
    • Added “Compare Tool” header actions and “Compare” detail page shortcut buttons on Role browsing views.
  • Cross-Database User Profile Comparison (/users/compare):
    • Added full cross-database User Profile (PSOPRDEFN) diffing across environments or within the same database.
    • Field-by-field profile attribute comparison (description, emplID, account status, symbolic ID, language/currency, primary, row-security, process profile, default homepage, and password configuration).
    • Assigned roles comparison (PSROLEUSER), composite effective permission lists with back-references to granting roles, authorized Service Operations (PSAUTHWS), email accounts (PSUSEREMAIL), portal favorites (PSPRUFDEFN), and system Special Use bindings (Message Node default user and signon PeopleCode execution).
    • Real-time SSE comparison stream with summary metric cards, deep links to user and security detail views in both databases, and Markdown report export (/users/compare/export).
    • Added “Compare Tool” header actions and “Compare” detail page shortcut buttons on User browsing views.
  • Cross-Database Permission List Comparison (/permissionlists/compare):
    • Added multi-environment diffing for PeopleSoft Permission Lists (PSCLASSDEFN).
    • Comprehensive comparison across Component Authorizations, Web Libraries, Component Interfaces, Process Groups, Application Services, and Query Profiles with Markdown export.
  • OpenID Connect (OIDC) SSO & Discovery:
    • Native OIDC authentication mode supporting automated provider discovery, PKCE authorization flow, group-based authorization claims, and encrypted client secret storage.
  • Client IP Allowlist Security Enforcement:
    • Restrict access to psLens web interface and API endpoints by CIDR block or client IP address with fail-closed enforcement policies.
  • 30-Day Connection Uptime & Incident History:
    • Interactive 30-day availability timeline bars and incident history recording scheduled maintenance and unexpected connection outages.
  • PeopleTools Change Control & Object Lock Visibility:
    • Direct visibility into database Change Control status and active checkout locks (PSCHGCTLLOCK) across object detail views.
  • Live Notification Delivery Testing:
    • Interactive delivery testing modals in Settings to verify webhook endpoints (Slack, Microsoft Teams, generic JSON) and SMTP email dispatch in real-time.
  • In-App Database Credential Management:
    • Update PeopleSoft connection credentials securely from the Settings UI with encryption at rest and optional password changes.

August 21, 2026 — MCP Operation Audit Logging & Live Activity Stream

  • MCP Operations Audit Stream: All MCP tool calls and operations executed by AI coding assistants (Google Antigravity, VS Code, Claude Desktop, Claude Code) are now recorded to an append-only persistent audit stream with automatic 30-day retention and storage protection.
  • Live Activity Feed in Settings: Added a real-time MCP Operations Audit Log table to the MCP Settings page (/settings/mcp) showing timestamps, caller identity, tools executed, target databases, arguments, duration, and execution status with refresh and log clearing capabilities.

August 18, 2026 — MCP Setup Guides for Google Antigravity and VS Code

  • Google Antigravity & VS Code Setup Guides: Added tabbed configuration guides and ready-to-paste JSON snippets for Google Antigravity (~/.gemini/config/mcp_config.json) and VS Code (.vscode/mcp.json and MCP extensions) on the MCP Settings page (/settings/mcp) and documentation.
  • Pre-Populated Token Configuration Modal: Token generation modal now displays copyable configuration snippets with personal access tokens pre-populated for Google Antigravity, VS Code, Claude Desktop, and Claude Code CLI.
  • Agent Skill Installation: Added setup commands for installing the pslens agent skill directly into Google Antigravity global and project skill directories.

August 17, 2026 — MCP Server v2: Cohesive 20-Tool Surface, Sizing Tiers & Embedded Agent Skills

  • Consolidated 20-Tool Surface: Redesigned the MCP tool suite from 27 dispersed tools into a cohesive 20-tool domain architecture (18 domain tools + 2 developer tools) with clear sizing tiers (Summary, Structured, Full).
  • Batch Record Introspection (batch_records_summary): Inspect schemas, primary keys, and prompt table relationships for up to 25 records in a single round-trip call, eliminating multi-turn join loops during SQL authoring.
  • Record Schema Consolidation (get_record_schema): Unified record field listings, subrecord flattening (expand_subrecords), DDL parameters (format='ddl'), and markdown documentation (format='markdown') into a single endpoint.
  • Embedded Agent Skills Distribution:
    • Embedded pslens Agent Skill package served at /skills/pslens.zip containing PeopleSoft naming conventions, status code decoders, and step-by-step diagnostic workflows.
    • Implemented Agent Skills Discovery specification (/.well-known/agent-skills/index.json) for discovery and auto-installation by autonomous agents.
    • Added Skill Download Card to the psLens MCP Settings page (/settings/mcp).
  • Unified Environment Comparison (compare_environments): Merged disparate comparison tools into a multi-modal comparison endpoint supporting project, single_object, recurrences, and missing_projects.
  • Integrated Operations Triage (triage_operations): Consolidated Process Scheduler queue analysis and Integration Broker contract diagnostics into a single call.
  • Automated DDL & DMS Generation (generate_dms_script, lint_dms_script): Tools for generating and linting PeopleSoft Data Mover export/import scripts.
  • Streamable HTTP endpoint works with sign-in enabled: https://<your-pslens>/mcp no longer redirects MCP clients to the login page when psLens authentication is turned on. Claude Code should be registered with claude mcp add --transport http pslens https://<your-pslens>/mcp --header "Authorization: Bearer <token>"; the older /mcp/sse endpoint still works but is deprecated by the MCP specification.
  • Token generation keeps your label and expiry: tokens created from Settings → MCP Tokens now record the label and expiration you chose. Revoke and delete require a POST.
  • More accurate tool results for AI agents:
    • Public PSQueries are found by get_object_definition and get_psquery_definition; mixed-case role names work in export_object_markdown and compare_object.
    • include_* options that document a default of true now default to true when omitted.
    • compare_object no longer reports a connectivity failure as “missing in the target”; existence is reported as unknown and the result carries comparisonComplete and warnings. Permission lists, App Engines, components, and pages are compared by content, not by counts.
    • compare_recurring_processes now diffs the two environments (only in source, only in target, matched with differences) instead of returning two raw lists.
    • get_system_health, export_health_snapshot, and the pslens://system/health/{db} resource share one health calculation; query failures surface as warnings and degrade the verdict instead of reading as healthy.
    • Capped lists (who_has_access, user_access_summary, get_object_dependencies, get_security_matrix, triage_process_scheduler) report hasMore/limit so an agent knows when a list is incomplete. get_security_matrix honors menu_name.
    • list_active_alerts and get_alert_history work for a configured database even while its PeopleSoft connection is down; database names match case-insensitively everywhere.
    • Very large tool results are cut at a fixed size with an explicit truncation marker instead of being rejected by the client.
  • Alert mutes created through MCP are attributed to the token owner and capped at 7 days.
  • Server hygiene: idle MCP sessions expire after 30 minutes; tools carry a display title; server instructions describe database discovery, name casing, pagination, and output limits.

August 15, 2026 — MCP Server Enhancements: Proactive Health Sensor & Priority Intelligence Tools

Expanded the native embedded Model Context Protocol (MCP) Server with real-time proactive health sensor telemetry and deep diagnostic tooling for autonomous AI agents and pair-programming workflows:

  • Proactive System Health Sensor & Telemetry:
    • Enhanced get_system_health into a real-time health sensor evaluating Process Scheduler heartbeats (PSSERVERSTAT), Integration Broker domain dispatchers (PSAPMSGDOMSTAT), blocked message nodes (PSNODESDOWN), stalled/overdue process requests, locked-user process blockers, recent errors, and active firing alerts with automatic HEALTHY, DEGRADED, or CRITICAL categorization.
    • Added real-time passive resources pslens://alerts/active and pslens://system/health/{db}.
    • Introduced proactive_system_monitor prompt for autonomous AI agents monitoring production PeopleSoft instances.
  • Universal Markdown Export (export_object_markdown):
    • Export any of the 32+ PeopleSoft object types directly into LLM-optimized and structured Markdown with optional recursive PeopleCode reference resolution (recursive_pc: true).
  • Point-to-Point Object Comparison (compare_object):
    • Compare individual objects (records, SQL objects, PeopleCode programs, roles, permission lists, App Engines, components, pages, file layouts, messages, and service operations) cross-environment without requiring an Application Designer project definition.
  • Process Request Runtime Drilldown (get_process_request_details):
    • Inspect full runtime parameters, automatically discovered run control table parameters, and parent/child job trees for any Process Scheduler instance.
  • Portal Structure & Navigation Inspection (get_portal_structure):
    • Inspect Content References (CREFs), portal folder trees (PSPRSMDEFN), Fluid tiles, target URLs, breadcrumb ancestry, child items, and authorized permission lists.
  • Granular Component Security Matrix (get_security_matrix):
    • Breakdown component/menu action authorizations (Add, Update/Display, Update/Display All, Correction, Data Entry) across permission lists, roles, and user accounts.
  • DBA Storage & Index Inspection (get_record_ddl_and_indexes):
    • Inspect low-level table DDL parameters (PSRECDDLPARM), index structures (PSKEYDEFN primary and alternate keys), and tablespace assignments (PSRECTBLSPC).
  • Search Framework & OpenSearch Inspection (inspect_search_framework):
    • Deep inspection of PeopleSoft Search Framework definitions (PSPTSF_SD), source queries, mapped attributes (PSPTSF_SD_ATTR), facets, and parent categories.
  • Alert Execution History & Triage (get_alert_history):
    • Review historical background alert check runs, check durations, failure errors, and active firing incidents across databases.
  • Dynamic Alert Muting Rules (manage_alert_mute):
    • Enable agents to list, create, or remove temporary alert silences in NATS KV during planned maintenance or active incident triage without database modifications.
  • On-Demand Connection & Latency Probe (ping_database_connection):
    • Probe database SWS endpoints on demand, returning round-trip latency (ms), PIA responsiveness, database metadata, and PeopleTools release.
  • Markdown Operational Health Digest (export_health_snapshot):
    • Generate comprehensive Markdown health reports with comparative environment tables, Process Scheduler heartbeats, and active alert summaries formatted for Slack/Teams alerts or incident briefs.
  • PSQuery Definition & Schema Introspection (get_psquery_definition):
    • Inspect PeopleSoft Query definitions (PSQRYDEFN), participating records, output fields, WHERE criteria, custom expressions, bind prompts, and execution statistics.
  • Application Engine Execution Hierarchy (get_app_engine_structure):
    • Retrieve the full execution hierarchy of an Application Engine program (PSAEAPPLDEFN), state records, temp tables, section flow, and step action breakdown.
  • PeopleTools Event Mapping Discovery (inspect_event_mapping):
    • Inspect PeopleTools Event Mapping configurations (PSEVMAPLINK, PSEVMAPDATA) to discover custom Application Classes injected into standard Component, Page, and Record events.
  • Service Operation & Routing Graph (get_service_operation_routing):
    • Inspect Integration Broker Service Operations, Operation Versions, Handlers (with App Classes), Sender/Receiver Nodes, and transformation programs.
  • Specialized Multi-Step MCP Prompts:
    • Added security_compliance_audit and event_mapping_impact_analysis guided workflows for autonomous security and upgrade impact analysis.
  • Data Mover Script Linter & Parser (lint_dms_script):
    • Parse, lint, and validate PeopleSoft Data Mover scripts (.dms) checking command sequences, syntax validity, %DateTimeIn macros, and table references.
  • Application Designer Project Inspector (inspect_project_definition):
    • Deep inspection of Project definitions (PSPROJECTDEFN, PSPROJECTITEM) with object type groupings and upgrade action flags (UPGRADEACTION, TAKEACTION, COPYDONE).
  • Message Catalog Deep Search (search_message_catalog):
    • Query message catalog error codes and explanations (PSMSGCATDEFN) by set number, message number, or full text search.
  • Web Object & HTML Asset Explorer (get_web_object):
    • Fetch raw HTML definitions (PSHTMLDEFN), stylesheets (PSSTYLEDEFN), and freeform web assets.
  • DMS Migration Generator Workflow Prompt (dms_migration_generator):
    • Guided multi-step prompt for generating and validating Data Mover scripts.

August 14, 2026 — Embedded Model Context Protocol (MCP) Server & AI Assistant Integration

Added a native, high-performance embedded Model Context Protocol (MCP) Server running directly inside the psLens Go server process over HTTP/SSE, allowing AI assistants like Claude Desktop, Claude Code CLI, and Cursor to query, inspect, and analyze PeopleSoft metadata and runtime operations in real time.

  • Embedded Architecture: Zero external dependencies, python bridges, or local daemons to install. The MCP server runs natively inside the psLens binary alongside the web UI.
  • Personal Access Token Authentication: Built-in token engine under Settings → MCP Tokens (/settings/mcp) allowing users to generate revocable API tokens (psl_mcp_...) with configurable expiration windows and automatic last-used tracking.
  • One-Click AI Client Setup: Settings page provides copy-ready configuration snippets for Claude Desktop (claude_desktop_config.json) and Claude Code CLI (claude mcp add ...).
  • 20+ PeopleSoft Intelligence Tools:
    • Metadata & PeopleCode: Universal object search (search_objects), structured schema exploration with recursive subrecord flattening (get_object_definition), PeopleCode source retrieval across all event types (get_peoplecode), forward and reverse dependency where-used graph (get_object_dependencies), full-text SQL/PeopleCode search (search_code_sql), and safe table data sampling (get_table_sample_and_count).
    • Security & Access: Complete 360-degree user access profile (user_access_summary), reverse security path traversal (who_has_access), high-risk grant auditing (audit_dangerous_access), Query Security Tree authorizations (query_tree_access), and authentication history audit (user_login_audit).
    • Operational Triage: Multi-point system health check (get_system_health), Process Scheduler triage with human-readable run statuses (triage_process_scheduler), Integration Broker transaction triage (triage_integration_broker), and active alert review (list_active_alerts).
    • Cross-Database Comparison & Reports: Cross-environment project comparisons with PeopleCode diffs (compare_project), recurring schedule drift detection (compare_recurring_processes), missing projects detection (find_missing_projects), report catalog discovery (list_available_reports), and on-demand report execution (run_report).
  • Agent Ergonomics & Context Preservation: Built-in tool safety annotations to eliminate permission prompts, human-readable enum descriptors alongside numeric constants, and credential column protection for safe table inspection.
  • Guided Workflow Prompts & Passive Resources: Standardized prompts for post-migration verification, on-call incident triage, user security audits, and change impact analysis, plus passive context resources for connected databases and object catalogs. See MCP Server.

August 13, 2026 — Live Field Alias Discovery & Field Pages Pagination

Added live field alias discovery and pagination support to Field detail pages (/fields/{fieldname}).

  • Field Alias Discovery: Automatically inspects SWS prompt tables and record metadata to check if a field is an alias of a canonical entity, or to discover all alternative field names that act as aliases (e.g. AV_EMPLID, PARTNER_EMPLID, or INSTRUCTOR_ID as aliases for EMPLID).
  • Likely vs Confirmed Aliases: Softens the verdict to “Likely Field Alias Identified” and flags ambiguity when multiple matching keys are found on a prompt table.
  • Ambiguity Softening: Displays candidate canonical fields sorted deterministically by key priority.
  • Field Pages Pagination: Replaced the previous 200-item hard limit on the “Pages using field” list with infinite scroll offset-based pagination.
  • Markdown Export Integration: Extends the field exporter to include the aliases details in the generated Markdown file.
  • Optimized Performance: Reuses SWS client helpers to collapse sequential query calls by orders of magnitude.

Added native OpenID Connect (OIDC) authentication support for enterprise Single Sign-On (SSO).

  • Native OIDC Integration: Added native OIDC authentication (auth.mode: oidc), allowing direct integration with enterprise Identity Providers such as Microsoft Entra ID, Okta, Keycloak, Auth0, and Google Workspace without requiring a reverse proxy.
  • Automated OpenID Discovery & Token Verification: Uses standard OpenID Connect discovery (.well-known/openid-configuration), OAuth 2.0 PKCE, and automated JWKS key signature verification to validate user identity claims.
  • Group Claim Verification & User Authorization: Supports optional group claim enforcement (allowedGroups) and user allowlist matching (authorizedUsers).
  • 1Password Secret Resolution: Integrated op:// reference resolution for OIDC client ID (clientId) and client secret (clientSecret) settings.
  • Environment Overrides & Schema Update: Supported configuration via PSLENS_AUTH_MODE and PSLENS_OIDC_* environment variables. Updated configuration JSON schema verification. See Authentication & Access and Configuration.

August 8, 2026 — Code & SQL Text Search & Auth Configuration

Added full-text search capabilities across SQL and PeopleCode and refined authentication configuration.

  • Code & SQL Text Search Report: Introduced a new report (code-sql-search) that allows searching for specific text strings across all stored SQL statements and PeopleCode in the database. Added to the navigation sidebar under Definitions and in the command palette.

August 6, 2026 — Campus Solutions Row-Level Security Integration

Added support for Campus Solutions (CS) application-level security tables, user defaults inspection, responsive sidebar toggling, Markdown export integration, and Full User Access Report inclusion.

  • Campus Solutions Security Integration: Added discovery and inspection for 9 Campus Solutions security tables:
    • OPR_DEF_TBL_CS: User Defaults (Institution, Career, Program, Plan, Term, Aid Year, Business Unit, SetID, Campus, Admission Application/Recruiter Center)
    • SCRTY_TBL_INST: Academic Institution Security
    • SCRTY_TBL_CAR: Academic Career Security
    • SCRTY_TBL_PROG: Academic Program Security
    • SCRTY_TBL_PLAN: Academic Plan Security
    • SCRTY_TBL_ACAD: Academic Organization Security
    • SCRTY_TBL_STGP: Student Group Security
    • SCRTY_TBL_SRVC: Service Indicator Security
    • OPR_GRP_3C_TBL: 3C Group Security
  • User Detail Page Integration: Added a dedicated Campus Solutions Security panel on User detail pages (/users/{oprid}), accessible via an optional toggle switch under Related Data in the right sidebar.
  • Dynamic Direct Querying & Graceful Degradation: Direct SWS endpoint querying fetches active security grants in parallel without requiring upfront connection status cache updates. If no CS security tables are whitelisted for a database, an informative guidance card displays candidate table whitelist instructions.
  • Full User Access Report Integration: Extended SecurityUserAccessReport to concurrently query and include Campus Solutions row-level security grants in generated Full Access Reports.
  • Markdown Export: Integrated Campus Solutions Security tables into User detail Markdown exports (/users/{oprid}/export).
  • Documentation & Whitelist Tables: Updated Whitelist Tables documentation with Campus Solutions security table requirements. See Campus Solutions Security.

August 1, 2026 — COBOL SQL Statements (SQLSTMT_TBL)

Added COBOL SQL statement discovery and inspection to Record detail pages (/records/{recname}).

  • COBOL SQL Statements Panel: Sourced from SQLSTMT_TBL, this panel displays stored SQL statements (PGM_NAME, STMT_TYPE, STMT_NAME) used by COBOL programs that reference the record in statement text, program names, or statement names.
  • Syntax Highlighting & Type Badges: Displays formatted SQL statement text with syntax highlighting alongside color-coded badges for statement types (Select, Update, Insert, Delete).
  • Markdown Export: Integrated COBOL SQL statements into Record Markdown exports for documentation and offline review.
  • Whitelist Table Requirements: Added SQLSTMT_TBL to system table requirements and Whitelist Tables. See Records.

August 1, 2026 — Process Definition Recurrence History & Schedule Variance

Added recurrence execution history analysis and start delay variance visualization to Process Definitions (PRCSDEFN).

  • Recurrence History & Variance Panel: Automatically analyzes process requests in PSPRCSRQST executed via recurrence schedules (RECURNAME <> ' ').
  • Start Delay Variance (BEGINDTTM - RUNDTTM): Calculates and displays schedule latency, comparing target scheduled run times against actual execution start times.
  • Aggregate KPI Metrics: Displays summary metrics for Total Recurring Runs, Average Start Delay, Maximum Start Delay (with instance reference), and On-Time Rate percentage.
  • Visual Delay Breakdown: Progress bar categorizing runs into On-Time (≤ 1m), Minor Delay (1-5m), and Significant Delay (> 5m).
  • Historical Run Log: Detailed table listing process instance numbers, recurrence schedule links (/recurrences/{recurname}), scheduled run times, actual start times, color-coded variance badges, execution durations, run statuses, and executing servers.
  • Markdown Export: Integrated recurrence history summary metrics and recent recurring run logs into Process Definition Markdown exports. See Process Definitions.

August 1, 2026 — File Layout Definitions (PSFLDDEFN)

Added full metadata browsing, definition hierarchy visualization, and Markdown export for PeopleSoft File Layout definitions.

  • New Object Handler: Dedicated File Layouts browser at /filelayouts and detail page at /filelayouts/{flname}.
  • Definition Hierarchy (App Designer View): Visual tree representation mapping parent-child segment hierarchies (PSFLDSEGDEFN via FLDSEGPARENT), field data types (PSFLDFIELDDEFN), start positions, lengths, and date formatting masks.
  • Related Data Sidebar Toggles: On-demand SSE toggles for Application Designer Projects (PSPROJECTITEM where OBJECTTYPE = 31) and PeopleCode Cross-References (PSPCMNAME).
  • PeopleCode Cross-References: Discovery of all PeopleCode programs referencing the File Layout via PSPCMNAME.
  • Markdown Export: One-click Markdown export (/filelayouts/{flname}/export) generating structured documentation with ASCII definition hierarchy trees, projects, and PeopleCode references.
  • Global Search & Navigation: Integrated into the ⌘K command palette and sidebar under Definitions.
  • Whitelist Table Requirements: Added PSFLDDEFN, PSFLDSEGDEFN, and PSFLDFIELDDEFN to system table requirements and Whitelist Tables. See File Layouts.

July 31, 2026 — Hot-Reload Configuration & SWS Whitelist Management

Enhanced live NATS KV configuration management and database connection synchronization.

  • Live Config Hot-Reload: Real-time NATS KV configuration updates for database connections, alert thresholds, and notification rules without restarting the server.
  • Air Hot-Reload File Guard: Excluded config.yaml from live-reload file watchers to prevent infinite build loops during automated config sync.
  • Report Link Generation: Standardized deep-link URL generation across security and object comparison reports using appBaseURL.
  • SWS Whitelist Discovery: Updated CHG_PSLENS_WL runtime discovery to validate table authorizations on startup. See Configuration.

July 28, 2026 — Component Record Hierarchy & Menu Market Metadata

Expanded component data hierarchy analysis and menu item metadata inspection.

  • Component Record Hierarchy: Enhanced the /components/{compname} record hierarchy panel with scroll levels, page access types, and updatable record identification. See Components.
  • Menu Market Metadata: Added Market metadata parsing to menu item detail views for cross-market navigation analysis.

July 27, 2026 — Search Definitions, DDL Parameters & Granular Page Security

Introduced Search Definitions browsing, database DDL parameter inspection, 1Password secret resolution, and granular item-level security grants.

  • Search Definitions (PSPTSF_SD): New metadata browser for Search Framework definitions, document category attributes (PSPTSF_SD_DCATR), search categories (PSPTSF_SRCCAT), and OpenSearch/Elasticsearch index mappings.
  • Database DDL Storage Parameters: Added DDL parameter inspection (PSRECDDLPARM, PSIDXDDLPARM, PSSPCDDLPARM) to record detail pages (/records/{recname}) for Oracle, SQL Server, and DB2 table storage verification.
  • Item-Level Page Security (PNLITEMNAME): Added PNLITEMNAME field resolution across PSAUTHITEM security queries to detect page-item-level authorization overrides in Permission Lists. See Permission Lists.
  • 1Password Secret Resolution: Native resolution of op:// secret references in database credentials and SMTP notification settings.

July 22 - 23, 2026 — Infrastructure Enhancements

Optimized container deployment options and background notification delivery.

  • SMTP Notification Pipeline: Upgraded background notification delivery and retry logic for scheduled audit report distribution.