# Records

> Browse PeopleSoft record (table) definitions with fields, indexes, related pages, components, PeopleCode, and live data preview.

---

LLMS index: [llms.txt](/llms.txt)

---

<div id="pslens-context-panel" class="card border-info mb-4 d-none">
  <div class="card-header bg-light text-info py-2 fw-bold d-flex align-items-center border-bottom border-info-subtle">
    <i class="bi bi-info-circle-fill me-2"></i>
    <span>Tailored Operational Context</span>
  </div>
  <div class="card-body p-0">
    <ul class="list-group list-group-flush">
      <li id="row-db" class="list-group-item d-flex align-items-center justify-content-between py-2 d-none">
        <strong>Target Database:</strong>
        <span id="ctx-db" class="badge bg-secondary font-monospace">&mdash;</span>
      </li>
      <li id="row-type" class="list-group-item d-flex align-items-center justify-content-between py-2 d-none">
        <strong>Context Type:</strong>
        <span id="ctx-type" class="badge bg-light text-dark border font-monospace text-uppercase">&mdash;</span>
      </li>
      <li id="row-severity" class="list-group-item d-flex align-items-center justify-content-between py-2 d-none">
        <strong>Alert Severity:</strong>
        <span id="ctx-severity" class="badge">&mdash;</span>
      </li>
      <li id="row-time" class="list-group-item d-flex align-items-center justify-content-between py-2 d-none">
        <strong>Triggered Time:</strong>
        <span id="ctx-time" class="text-muted small">&mdash;</span>
      </li>
      <li id="row-details" class="list-group-item py-2 d-none">
        <strong id="label-details" class="d-block mb-1">Firing Context:</strong>
        <code id="ctx-details" class="d-block p-2 bg-light border rounded small" style="white-space: pre-wrap; word-break: break-all;">&mdash;</code>
      </li>
    </ul>
  </div>
</div>

<script>
  (function() {
    const params = new URLSearchParams(window.location.search);
    const metadata = params.get('metadata');
    if (!metadata) return;

    try {
      
      const base64 = metadata.replace(/-/g, '+').replace(/_/g, '/');
      const jsonStr = decodeURIComponent(escape(window.atob(base64)));
      const data = JSON.parse(jsonStr);

      if (data) {
        let hasData = false;

        if (data.db) {
          document.getElementById('ctx-db').textContent = data.db;
          document.getElementById('row-db').classList.remove('d-none');
          hasData = true;
        }

        if (data.type) {
          document.getElementById('ctx-type').textContent = data.type;
          document.getElementById('row-type').classList.remove('d-none');
          hasData = true;
        }

        if (data.severity) {
          const severityBadge = document.getElementById('ctx-severity');
          const severity = data.severity.toLowerCase();
          severityBadge.textContent = severity.toUpperCase();
          if (severity === 'critical') {
            severityBadge.className = 'badge bg-danger';
          } else if (severity === 'warning') {
            severityBadge.className = 'badge bg-warning text-dark';
          } else {
            severityBadge.className = 'badge bg-info';
          }
          document.getElementById('row-severity').classList.remove('d-none');
          hasData = true;
        }

        if (data.t) {
          const date = new Date(data.t * 1000);
          document.getElementById('ctx-time').textContent = date.toLocaleString();
          document.getElementById('row-time').classList.remove('d-none');
          hasData = true;
        }

        if (data.details) {
          document.getElementById('ctx-details').textContent = data.details;

          
          const labelDetails = document.getElementById('label-details');
          if (data.type === 'object') {
            labelDetails.textContent = 'Object Metadata Details:';
          } else if (data.type === 'report') {
            labelDetails.textContent = 'Report Description:';
          } else {
            labelDetails.textContent = 'Firing Context:';
          }

          document.getElementById('row-details').classList.remove('d-none');
          hasData = true;
        }

        if (hasData) {
          document.getElementById('pslens-context-panel').classList.remove('d-none');
        }
      }
    } catch (e) {
      console.error('Failed to parse operational context metadata:', e);
    }
  })();
</script>


## 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}`

<figure><img src="/images/screenshots/metadata/records-search.png"
    alt="Record search results for PSREC% showing PSRECDDLPARM, PSRECDEFN, and related records"><figcaption>
      <p>Record search results for <code>PSREC%</code> — note the record type pill (Table/View) and field count on each card</p>
    </figcaption>
</figure>


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}`

<figure><img src="/images/screenshots/metadata/records-detail.png"
    alt="Detail page for PSRECDEFN showing record properties and the field list"><figcaption>
      <p>Record detail page for <code>PSRECDEFN</code> — default view with properties, field list, and the Related Data sidebar</p>
    </figcaption>
</figure>


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.

## Related Data Panels

### Pages Using This Record

<figure><img src="/images/screenshots/metadata/records-panel-pages.png"
    alt="Pages Using This Record panel listing pages that bind to PSRECDEFN"><figcaption>
      <p>Pages that bind a control to this record</p>
    </figcaption>
</figure>


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

<figure><img src="/images/screenshots/metadata/records-panel-components.png"
    alt="Components Using This Record panel"><figcaption>
      <p>Components whose pages reference this record</p>
    </figcaption>
</figure>


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

### PeopleCode Events

<figure><img src="/images/screenshots/metadata/records-panel-peoplecode-events.png"
    alt="PeopleCode Events panel for PSRECDEFN"><figcaption>
      <p>Record PeopleCode events defined on this record</p>
    </figcaption>
</figure>


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

### Included in Projects

<figure><img src="/images/screenshots/metadata/records-panel-projects.png"
    alt="Included in Projects panel for PSRECDEFN"><figcaption>
      <p>App Designer projects that include this record</p>
    </figcaption>
</figure>


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

### Used in App Engines

<figure><img src="/images/screenshots/metadata/records-panel-app-engines.png"
    alt="Used in App Engines panel for PSRECDEFN"><figcaption>
      <p>Application Engine programs that reference this record</p>
    </figcaption>
</figure>


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

### Component Interfaces Using This Record

<figure><img src="/images/screenshots/metadata/records-panel-componentinterfaces.png"
    alt="Component Interfaces Using This Record panel"><figcaption>
      <p>CIs whose underlying component is built on a page that uses this record</p>
    </figcaption>
</figure>


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

### Record Data

<figure><img src="/images/screenshots/metadata/records-panel-recorddata.png"
    alt="Record Data sample showing the first rows from PSRECDEFN"><figcaption>
      <p>Live sample data from the record itself</p>
    </figcaption>
</figure>


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

<figure><img src="/images/screenshots/metadata/records-panel-pc-references.png"
    alt="PeopleCode References panel for PSRECDEFN"><figcaption>
      <p>Any PeopleCode program that mentions this record by name</p>
    </figcaption>
</figure>


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

<figure><img src="/images/screenshots/metadata/records-panel-queries.png"
    alt="Queries Using This Record panel"><figcaption>
      <p>PeopleSoft Queries that include this record</p>
    </figcaption>
</figure>


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

<figure><img src="/images/screenshots/metadata/records-panel-querytrees.png"
    alt="Query Trees Using This Record panel"><figcaption>
      <p>Query Tree nodes that expose this record to query authors</p>
    </figcaption>
</figure>


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

### Used as Prompt Table

<figure><img src="/images/screenshots/metadata/records-panel-prompt-table.png"
    alt="Used as Prompt Table panel"><figcaption>
      <p>Other records whose fields use this record as an Edit/Prompt table</p>
    </figcaption>
</figure>


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.