Below is a quick reference of the PeopleSoft tables used by Integration Broker. This is not a complete list, but it should help you get started with your own queries. There are some nuanced ones that I have left off that might provide functionality that no one uses or is not directly tied to integration broker functionality. For example, Nodes are used for other things like linking between PeopleSoft systems for PIA. Any “language” records are removed.
Node Related:
Services:
Service Operation:
Service Operation Routings:
Service Operation Handlers:
Message Related:
Integration Broker Queues:
Synchronous Tables:
Archive Tables:
Others:
Chris Malek is a PeopleTools® Technical Consultant with over two decades of experience. He is available for consulting engagements.
Work with ChrisSWS turns SQL into production REST APIs — ready for AI, modern apps, and partner integrations. One install, unlimited potential.
A powerful PeopleSoft bolt-on that makes REST web services easy. You bring the SQL, SWS handles the rest.
Traditional PeopleSoft web services cost $3,600–$13,000 each to develop. SWS deploys production REST APIs in under 5 minutes through configuration alone.
Turn PeopleSoft data into clean REST APIs for AI integrations, modern applications, and vendor data feeds. Configuration-driven — no PeopleCode required.
Look up any record, field, page, or component, audit security, and monitor Integration Broker across every database — in seconds.
A web console built for the PeopleSoft community — operational monitoring, security auditing, and metadata browsing in one tool.
On-demand security and operational reports for your PeopleSoft environment — no client install required.
Research any PeopleSoft object and monitor system health from a single browser tab — no App Designer, no SQL.