Queries

Browse PeopleSoft Queries with record/field usage, query trees, security access, and ownership.
Categories:
Tags:
Tailored Operational Context
  • Target Database: —
  • Context Type: —
  • Alert Severity: —
  • Triggered Time: —
  • Firing Context: —

What It Is

Queries are PeopleSoft’s end-user reporting tool — saved SQL queries that users run from the PSQUERY interface, with optional prompts, output formats, and scheduled distribution. Each query is stored in PSQRYDEFN and broken out across PSQRYRECORD, PSQRYFIELD, and other tables for the records and fields it touches. psLens consolidates the query header, the records used, the field list, project membership, and (via the related-data toggles) the query tree placement and security access.

Search Page

URL: /queries?db={database}

Query search results for PT_% showing PTAI_GET_LISTITEM_RCD, PTCPQFIELD_VW, and others

Query search results for PT_%

Search auto-matches as starts with. Typing PT_ finds every query whose name begins with PT_. Include % yourself for ends-with (%_VW) or contains (%AUDIT%) patterns, or use % alone to list every row. Each card shows the query type (Public, Private, Archive, User), owner, and last-updated metadata. The Advanced Filters panel lets you filter by query type or owner.

Detail Page

URL: /queries/{QRYNAME}?db={database}

Detail page for PTCPQFIELD_VW query

Query detail page for PTCPQFIELD_VW

The main pane shows Query Properties (type, owner, description, last-run metadata, version), Records Used (every record in the FROM list), and Fields (the SELECT and ORDER BY columns). The sidebar has 3 related-data toggles.

Query detail page with all panels expanded

Full query detail page with all panels

Records Used

Records Used panel for the query

Every record in the query’s FROM clause

The list of records used by the query (PSQRYRECORD). Each record name deep-links into its own detail page so you can audit what the query reads.

Fields

Fields panel for the query

The fields the query SELECTs, with record context and order

The SELECT field list (PSQRYFIELD) with record and field references, each link-resolved.

Included in Projects

Included in Projects panel for the query

App Designer projects that include this query

App Designer projects containing this query as a project item.

What This Consolidates

In Query Manager / Query Viewer:

  • Search by name and open the query in Query Manager
  • Walk the Records tab to see the joined records
  • Walk the Fields tab to see SELECT and ORDER BY columns
  • Tab to Properties for owner and last-run info
  • Use a separate database query to find query tree placement and permission list access

psLens consolidates the structural view (records, fields, properties) on one page and adds project membership, useful for both audit work (which queries access sensitive tables?) and impact analysis (will deleting this record break any reports?).