Records

Browse PeopleSoft record (table) definitions with fields, indexes, related pages, components, PeopleCode, and live data preview.
Categories:
Tags:
Tailored Operational Context
  • Target Database: —
  • Context Type: —
  • Alert Severity: —
  • Triggered Time: —
  • Firing Context: —

What It Is

Records are PeopleSoft’s table/view definitions — every database table, SQL view, derived/work record, and dynamic view is registered in PSRECDEFN. psLens reads the record definition plus its field list from PSRECFIELD and stitches it together with everywhere the record is referenced in pages, components, PeopleCode, queries, projects, and trees. The Records page has 11 related-data panels (more than any other object type) covering pages, components, PeopleCode, queries, trees, prompt-table back-references, AE statements, project membership, and a live row sample.

Search Page

URL: /records?db={database}

Record search results for PSREC% showing PSRECDDLPARM, PSRECDEFN, and related records

Record search results for PSREC% — note the record type pill (Table/View) and field count on each card

Search auto-matches as starts with — typing JOB finds JOB, JOB_DATA, JOBCODE, etc. For more control, include % yourself: %DATA (ends with), %PERS% (contains), or just % to list every row. Each card shows record type, field count, the descriptive long name, and last-updated metadata. The Advanced Filters panel lets you filter by record type (Table, View, Derived/Work, Subrecord, Dynamic View, Query View, Temp Table), object owner, and last-updated date.

Detail Page

URL: /records/{RECNAME}?db={database}

Detail page for PSRECDEFN showing record properties and the field list

Record detail page for PSRECDEFN — default view with properties, field list, and the Related Data sidebar

The main pane shows Record Properties (type, owner, audit options, system table flag, description, audit timestamps) and a full Record Fields table with each field’s type, length, key indicators, default value, and Edit Table prompt — every detail you’d otherwise open App Designer to confirm. The Export button downloads the full record definition as Markdown. The Related Data sidebar holds 11 toggles — the broadest set of any object type — covering every place this record is referenced.

Pages Using This Record

Pages Using This Record panel listing pages that bind to PSRECDEFN

Pages that bind a control to this record

Lists pages with controls bound to this record (PSPNLFIELD join on RECNAME). Useful for impact analysis when changing the record schema.

Components Using This Record

Components Using This Record panel

Components whose pages reference this record

Lists every component containing a page bound to this record — gives you the user-facing transactions affected by the record.

PeopleCode Events

PeopleCode Events panel for PSRECDEFN

Record PeopleCode events defined on this record

Lists record-level PeopleCode events (FieldChange, RowInit, SaveEdit, etc.) attached to fields of this record. Sourced from PSPCMPROG.

Included in Projects

Included in Projects panel for PSRECDEFN

App Designer projects that include this record

Lists App Designer projects (PSPROJECTITEM) that include this record — useful for migration history and change tracking.

Used in App Engines

Used in App Engines panel for PSRECDEFN

Application Engine programs that reference this record

Lists Application Engine programs whose SQL or PeopleCode steps reference this record. Sourced from PSAESTMTDEFN text scans.

Component Interfaces Using This Record

Component Interfaces Using This Record panel

CIs whose underlying component is built on a page that uses this record

Lists Component Interfaces whose underlying component contains a page bound to this record — the integration surface area.

Record Data

Record Data sample showing the first rows from PSRECDEFN

Live sample data from the record itself

Pulls a live sample of rows from the record using the psoftQL API — first ~10 rows with every column. Lets you see what the data actually looks like without opening App Designer’s Run-In-Query or a separate SQL client.

PeopleCode References

PeopleCode References panel for PSRECDEFN

Any PeopleCode program that mentions this record by name

Broader than “Events” — finds any PeopleCode anywhere in the database that mentions this record by name (component, page, app package, app engine, message, signon, FieldFormula, etc.).

Queries Using This Record

Queries Using This Record panel

PeopleSoft Queries that include this record

Lists PeopleSoft Queries (PSQRYRECORD) that include this record in a FROM clause. Critical for audit work — “who is reporting from this table?”

Query Trees Using This Record

Query Trees Using This Record panel

Query Tree nodes that expose this record to query authors

Lists Query Tree nodes (PSTREENODE) where this record appears — determines which query authors can build queries against it.

Used as Prompt Table

Used as Prompt Table panel

Other records whose fields use this record as an Edit/Prompt table

Lists fields on other records that point to this record as their Edit Table / Prompt Table — shows the lookup relationships that hang off this record.

What This Consolidates

A complete impact assessment for a record change in App Designer requires:

  • Open the record in App Designer for properties, fields, and PeopleCode events
  • Right-click → Find Object References to find pages using it
  • Walk every found page to find its component
  • Run a separate Find In across PeopleCode for code references
  • Query PSAESTMTDEFN, PSQRYRECORD, PSTREENODE manually to find AE, query, and tree usage
  • Run SQL against PSDBFIELD joined to PSRECFIELD to find prompt-table usages
  • Open every owning project to see migration history
  • Open the database with SQL Developer / Toad to sample actual data

psLens shows all of that on one page, including a live row sample from the record.