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
Looking for pain-free PeopleSoft web services? 😀
PeopleSoft Simple Web Services (SWS)

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
0. About Book
1. Getting Started
2. Service Operations
3. REST Services
4. Security
5. Monitoring & Administration
6. Example Service Operations
7. Data Encoding/Decoding
8. Nodes
9. Services Delivered by Oracle
10. Listening Connectors
11. Handlers
12. Target Connectors
13. Syncing Data Between PeopleSoft Systems
14. API Gateways
15. Best Practices
Search

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 - Handlers
  • PSOPERATIONAC - Application Class Handlers

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
Copyright 2018-2024 Cedar Hills Group, Inc. All rights reserved.