This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Tools

Additional developer and operational utilities in psLens.

Tools

Developer and operational utilities that span multiple features and object types in psLens:

  • Global Search — Quick, keyboard-driven navigation across all PeopleSoft metadata and security definitions.
  • Deep Linking — Permanent shareable URLs, cross-object navigation, and structured markdown exports.
  • DMS Viewer — Inspect, query, and generate SQL INSERT statements from PeopleSoft Data Mover .dat files.

1 - Global Search

Global Search is a cross-object navigation tool in psLens. Rather than navigating to individual object search pages (like Fields, Components, or Users), Global Search allows you to search across all PeopleSoft metadata and security definitions simultaneously from a single search modal.


  • Global Search Icon: Click the search magnifying glass icon in the top navigation bar from any page within the psLens interface.
  • Keyboard Shortcut: Press Ctrl + K (Windows/Linux) or Cmd + K (Mac OS) to trigger the search modal instantly.

Search Coverage

Global Search queries the selected database in real time to return matches across multiple object categories:

Object TypeFields Searched
FieldsField Name (FIELDNAME), Short/Long Descriptions
RecordsRecord Name (RECNAME), Record Description
PagesPage Name (PNLNAME), Page Description
ComponentsComponent Name (PNLGRPNAME), Description
MenusMenu Name (MENUNAME)
Permission ListsClass ID (CLASSID), Description
RolesRole Name (ROLENAME), Description
UsersOPRID, User Description
Process DefinitionsProcess Name (PRCSNAME), Description
SQL ObjectsSQL Object Name (SQLID)
Application PackagesPackage Root (PACKAGEROOT)
Application EnginesApp Engine Name (AE_APPLID)

Key Features

  1. Categorized Results: Results are grouped dynamically by object type, allowing you to quickly scan through Records, Fields, or Users matching your query.
  2. Deep Linking: Clicking any search result takes you directly to that object’s detail page in the active database.
  3. Multi-Database Support: The search queries the active database selected in your nav bar. You can quickly switch databases from the top navigation to search the same term in a different environment.

2 - Deep Linking

Shareable URLs

Every PeopleSoft object in psLens has a permanent, shareable URL. Copy the address bar, paste it into a ticket or Slack, and anyone with psLens access lands on the same object in the same database.

PeopleSoft’s native URLs are session-bound and cannot be shared or bookmarked reliably. psLens URLs can.


URL Structure

All object URLs follow the same pattern:

/resource/{identifier}?db={database}
  • resource — the object type (e.g., records, fields, permissionlists)
  • identifier — the object name as it appears in PeopleSoft (e.g., JOB, EMPLID, HCDPALL0100)
  • db — the configured database name, so the link is unambiguous about which environment it points to

Linkable Object Types

psLens provides direct URLs for over 25 PeopleSoft object types:

CategoryObjects
SecurityPermission Lists, Roles, Users
ObjectsProjects, Project Import, Fields, Records, SQL Objects, Pages, Components, Component Interfaces, Menus, Content References (CREFs), Message Catalogs, Application Packages, URLs, HTML Definitions, Style Sheets, Queries, Query Trees, Nodes, Services, Service Operations, Messages, Queues, Application Engines, Process Definitions, Process Jobs, Recurrences

Every object listed above can be linked to directly. For example:

  • /records/JOB?db=PROD — the JOB record definition in your PROD database
  • /crefs/EMPLOYEE/PT_PORTAL_ROOT?db=PROD — a content reference (CREF) in the EMPLOYEE portal in PROD
  • /permissionlists/HCDPALL0100?db=DEV — a permission list in DEV
  • /serviceoperations/USER_PROFILE.v1?db=PROD — a service operation in PROD

Cross-Object Navigation

Detail pages link to related objects. When you view a record, the fields listed on that page link to their own detail pages. When you view a component, the pages within it are clickable. When you view a permission list, the roles that include it are linked.

This means you can navigate through the PeopleSoft object graph by clicking — from a record to its fields, from a field to the records that use it, from a component to its pages, and so on. Breadcrumbs at the top of each detail page show where you are in the hierarchy.

On Component detail pages, the portal navigation path shows clickable breadcrumb segments — each segment links to the CREF (Content Reference) definition for that folder or component, allowing you to navigate the portal registry hierarchy directly. The portal name itself links to browse all CREFs in that portal.

Clickable PeopleCode References

When viewing PeopleCode source code in psLens, references to Application Classes and Declared Functions are clickable.

  • An Application Class reference (e.g. PT_BRANDING:BrandingElement) links directly to the corresponding Application Package page.
  • A declared external function (e.g., Declare Function Get_Schedule PeopleCode RECORD.FIELD Event) links directly to the record field event containing the function definition.

Some detail pages support query parameters that pre-expand specific sections. This is useful when you want to share a link that shows exactly the information someone needs to see.

For example, on a Record detail page:

ParameterWhat it expands
show_pages=truePages that use this record
show_peoplecode=truePeopleCode programs attached to this record
show_projects=trueProjects that include this record
show_components=trueComponents that reference this record
show_parent_records=trueParent record relationships
expand_pc=FIELDNAME.EVENTNAMEA specific PeopleCode event, fully expanded

You can combine parameters:

/records/JOB?db=PROD&show_peoplecode=true&expand_pc=EMPLID.FieldChange

This link opens the JOB record in PROD with the PeopleCode section expanded and the EMPLID.FieldChange event visible — one click to the exact code your colleague needs to review.


Practical Use Cases

Audit and Compliance

In an audit workpaper, paste the psLens URL instead of a screenshot. The reviewer clicks through to the live object with no ambiguity about which permission list, which role, which version.

  • Reference the exact permission list, role, or user profile in an audit finding
  • Cite the exact URL in the finding; six months later the reviewer can re-open it
  • Eliminate the “which screen was that?” problem when revisiting findings months later

Incident Response and Troubleshooting

Instead of typing “open App Designer, find project XXXX, look at record YYYY,” paste a link into Slack or your incident channel. Everyone on the call arrives at the same view instantly.

  • Share the exact service operation that is failing
  • Link to the process definition that is stuck
  • Point teammates to the specific record or component under investigation

Change Management

When documenting changes in ServiceNow, Jira, or any ticketing system, include psLens links to the objects affected by the change.

  • Link to the project definition to show exactly what objects are included in a release
  • Reference specific components or records in change request descriptions
  • Build runbooks with clickable links instead of navigation instructions

Security Reviews

Security administrators can share direct links to the objects under review, making it easy for reviewers to verify configurations without navigating there themselves.

  • Link to permission lists with show_components=true to show what access they grant
  • Share user profile links showing role assignments
  • Reference exact objects in security audit reports and remediation tickets

Team Collaboration

A business analyst on the change call doesn’t need App Designer open. Paste the link, they see the record.


Markdown Export

Every PeopleSoft object detail page in psLens can export its full definition as a Markdown file. This exported file can be attached to documentation, included in a wiki, or stored alongside change records. Combined with deep links, you get both a static snapshot and a live reference back to psLens.

Look for the Export as Markdown card in the right-hand sidebar of any object detail page — records, fields, pages, components, menus, application packages, app engines, component interfaces, SQL objects, URLs, HTML and stylesheet definitions, projects, queries, query trees, message catalogs, CREFs, nodes, services, service operations, messages, queues, permission lists, roles, users, process definitions, process jobs, and recurrences.

Recursive PeopleCode Resolution

For objects containing PeopleCode (such as records, components, application packages, and app engines), the export card includes a Recursively resolve imports toggle. When enabled, psLens parses the source code for Application Class imports and external function declarations. It recursively retrieves the source code of those referenced classes and functions from the database and appends them to a dedicated references section in the exported document.

3 - DMS Viewer

Upload, inspect, and extract data from PeopleSoft Data Mover (.dat) export files.

What It Is

PeopleSoft Data Mover is commonly used to export data from tables to proprietary .dat binary files for backup, migration, or archiving.

The DMS Viewer in psLens allows you to upload and inspect these binary Data Mover .dat files directly in your web browser. You can inspect table counts, view schema columns, browse exported rows, and generate SQL INSERT statements for individual rows without launching Data Mover or running an import.

Uploading a DMS File

URL: /dms-viewer

To parse a DMS file:

  1. Go to the DMS Viewer page.
  2. Select or drag-and-drop your .dat file (up to 50MB) into the upload area.
  3. The server will parse the binary file structure and display its metadata.

File View

After parsing, the DMS file metadata is shown:

  • DMS File Metadata: Source database name, Data Mover export version, base language, export start timestamp, table count, and total row count.
  • Tables list: An index showing all tables exported in the .dat file along with the number of rows exported for each table. Clicking any table name opens its detail view.

Table detail and Row Browser

Inside a table’s view, you can browse its columns and rows:

  • Columns list: Shows the fields/columns defined for the table in the export.
  • Row Grid: Displays the exported rows in a paginated table (100 rows per page).
  • SQL INSERT Generator: Click the Generate SQL action on any row. psLens will reconstruct a standard SQL INSERT statement for that specific row’s data and display it in a copyable text area. Use this to grab a single config row out of a DAT file without running a full import.