Tracing Every Place a PeopleSoft Field Is Updated Using an AI Agent and the psLens MCP Server

One of the hardest everyday questions in PeopleSoft is also one of the simplest to ask: “Where in the system does this field get set to 'Y'?”

Unlike a standard codebase in Git where ripgrep gives you an answer in seconds, a PeopleSoft field can be modified across record field defaults (PSRECFIELD), Record and Component PeopleCode, UpdateValue() scroll buffer calls, updatable views, inline SQLExec statements, Application Packages, Application Engine SQL steps, and COBOL stored SQL (PS_SQLSTMT_TBL).

We just published a practical walkthrough on the psLens blog showing what happens when you give an AI coding agent connected to the psLens MCP Server a single one-line prompt:

Use pslens to find all areas where STDNT_CAR_TERM.TUITION_CALC_REQ gets set to "Y".

In under a minute—without writing manual SQL or opening Application Designer—the agent resolved the actual 13-character column name (TUIT_CALC_REQ), discovered the record default pointing to BUS_UNIT_TBL_SF.TERM_ACT_INIT_SET, traced every PeopleCode, App Package, App Engine, and COBOL SQL update across Campus Solutions, and even read the full PeopleCode event context to filter out a false positive inside a commented-out code block.

Read the full walkthrough on psLens