Author Info
Chris Malek

Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.

About Chris Work with Chris
PeopleSoft Simple Web Services (SWS)
Do you need a quick way to create web services?

Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.

Read More & Purchase
Contents

Integration Broker PeopleSoft Tables

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.

Configuration Tables

Node Related:

  • PSMSGNODEDEFN - Node Defn
  • PSNODECONPROP - Node Connection Properties

Services:

  • PSSERVICE
  • PSSERVICEOPR

Service Operation:

  • PSOPERATION
  • PSOPERATIONURI
  • PSOPRVERDFN
  • PSOPRVERDFNPARM
  • PSOPRVERQUEPARM
  • PSOPRGENRTGPARM
  • PSOPRVERDEPLOY
  • PSOPRVERDPLYVER

Service Operation Routings:

  • PSIBRTNGDEFN
  • PSRTNGDFNCONPRP
  • PSRTNGDFNPROP
  • PSIBRTNGSUBDEFN
  • PSRTNGDFNPARM

Service Operation Handlers:

  • PSOPRHDLR
  • PSOPERATIONAC

Message Related:

  • PSMSGDEFN - Message Defn
  • PSMSGATTR - Message Attribute Defn
  • PSMSGFLDOVR
  • PSMSGPARTS
  • PSMSGREC
  • PSMSGVER

Integration Broker Queues:

  • PSQUEUEDEFN
  • PSIBQUEUEINST
  • PSQUEUEOVRD
  • PSQUEUEPART

Transaction Tables

  • PSAPMSGPUBHDR
  • PSAPMSGPUBDATA
  • PSAPMSGPUBCON
  • PSAPMSGSUBCON
  • PSAPMSGPUBERR
  • PSAPMSGPUBERRP
  • PSAPMSGPUBCERR
  • PSAPMSGPUBCERRP
  • PSAPMSGSUBCERR
  • PSAPMSGSUBCERRP
  • PSAPMSGPCONDATA
  • PSAPMSGSCONDATA
  • PSIBERR
  • PSIBERRP
  • PSIBDEBUGLOG
  • PSAPMSGIBATTR
  • PSIBAEATTR
  • PSIBRELMSGSEQ
  • PSIBRELMSGHDR
  • PSIBRELMSGDATA
  • PSAPMSGDOMSTAT
  • PSAPMSGDSPSTAT

Synchronous Tables:

  • PSIBLOGHDR
  • PSIBLOGDATA
  • PSIBLOGERR
  • PSIBLOGERRP
  • PSIBLOGIBINFO

Archive Tables:

  • PSAPMSGARCHPH
  • PSAPMSGARCHPD
  • PSAPMSGARCHPC
  • PSAPMSGARCHSC
  • PSAPMSGARCHPT
  • PSAPMSGARCHST
  • PSIBLOGHDRARCH
  • PSIBLOGDATAARCH
  • PSIBLOGIBINFOAR

Others:

  • PSIBFCLOCK
  • PSIBADSLOCK
  • PSNODESDOWN