SQL Objects

Browse PeopleSoft SQL Object definitions — views, synonyms, and indexes — with source SQL and project membership.
Categories:
Tags:
Tailored Operational Context
  • Target Database: —
  • Context Type: —
  • Alert Severity: —
  • Triggered Time: —
  • Firing Context: —

What It Is

SQL Objects are the PeopleSoft application’s standalone SQL artifacts — view definitions and other named SQL fragments stored in PSSQLDEFN / PSSQLTEXTDEFN. Unlike a record’s automatically-generated DDL, these are SQL bodies the developer hand-wrote and PeopleSoft keeps versioned with the rest of the metadata. psLens pulls the source SQL plus the related record (when the SQL object is a view tied to a record definition) so you don’t switch into App Designer to read the SQL.

Search Page

URL: /sqlobjects?db={database}

SQL Object search results for PT% showing PTACEPRBMDL_DVW, PTACESRCHDVW, and others

SQL Object search results for PT%

Search auto-matches as starts with. Typing PT finds every SQL object whose ID begins with PT. Include % yourself for ends-with (%VW) or contains (%AUDIT%) patterns, or use % alone to list every row. Each result shows the object name, type, and last-updated info, useful when you’re tracing where a view body is defined or hunting for a delivered SQL fragment.

Detail Page

URL: /sqlobjects/{NAME}?db={database}

Detail page for PTACESRCHDVW showing the SQL view properties and full source SQL

SQL Object detail page for PTACESRCHDVW

The main pane shows the object’s properties and the full Source SQL body, syntax-highlighted and copyable, so you can see what the view SELECTs without an App Designer round-trip. The sidebar has two related-data toggles.

SQL Object detail page with all panels expanded

All panels expanded: Source Record and Project membership

Source Record

Source Record panel linking to PTACESRCHDVW

Direct link into the matching record detail page

When the SQL object is the body of a view-type record, this panel links into the parent record’s detail page so you can see the field list and the rest of the record metadata in one click.

Included in Projects

Included in Projects panel for the SQL object

App Designer projects that include this SQL object

Lists projects that contain this SQL object as a project item. Useful for tracing migration history of view DDL changes.

What This Consolidates

To see the same thing in App Designer:

  • Open Application Designer
  • Select File → Open → SQL and load the object
  • Read the SQL in the App Designer editor
  • Right-click to find which record it backs (if any)
  • Open every owning project separately to see migration history

psLens shows the source SQL inline in the browser, with one-click navigation into the related record. Same view DDL, viewable without App Designer.