2

List of PeopleSoft Integration Broker Tables

Here is the list of PeopleSoft Integration Broker tables according to their categories. Please note that this list will not match completely your PeopleTools version because Oracle tends to add or remove tables with different PeopleTools release. However, the important Integration Broker tables will continue to find favor and will remain in the list. The list mentioned in this post pertains to PeopleTools 8.53 release.

Here is the list of PeopleSoft Integration Broker tables categorized as per their functions:

— Message Nodes

PSMSGNODEDEFN;
PSNODEDEFNLANG;
PSCONNECTSTRING;
PSNODEURITEXT;
PSNODECONPROP;
PSNODCONPRPLANG;
PSNODELOCKDOWN;
PSNODEPROP;
PSNODEPROPLANG;
PSNODESDOWN;
PSTRUSTNODES;

— Message Channels

PSCHNLDEFN;
PSCHNLDEFNLANG;
PSCHNLNODE;
PSSUBCHNL;

— Message Definitions

PSMSGATTR;
PSMSGDEFN;
PSMSGDEFNLANG;
PSMSGFLDOVR;
PSMSGPARTS;
PSMSGREC;
PSMSGVER;

— App Messaging

PSAPMSGARCHPC;
PSAPMSGARCHPD;
PSAPMSGARCHPH;
PSAPMSGARCHSC;
PSAPMSGARCHTMP;
PSAPMSGPUBATTR;
PSAPMSGPUBCERR;
PSAPMSGPUBCERRP;
PSAPMSGPUBCLOCK;
PSAPMSGPUBCON;
PSAPMSGPUBCSYNC;
PSAPMSGPUBDATA;
PSAPMSGPUBERR;
PSAPMSGPUBERRP;
PSAPMSGPUBHDR;
PSAPMSGPUBINST;
PSAPMSGPUBLOCK;
PSAPMSGPUBSYNC;
PSAPMSGSUBCERR;
PSAPMSGSUBCERRP;
PSAPMSGSUBCLOCK;
PSAPMSGSUBCON;
PSAPMSGSUBCSYNC;
PSAPMSGSUBPRCID;
PSAPMSGXTB;

— Services
PSSERVICE;
PSSERVICELANG;
PSSERVICEOPR;
PSSERVICEUDDI;

— Service Operation
PSOPERATION;
PSOPERATIONLANG;
PSOPERATIONURI;

— Service Operation Routings
PSIBRTNGDEFN;
PSRTNGDFNLANG;
PSRTNGDFNCONPRP;
PSRTNGDFNPROP;
PSRTNGDFNPROPLG;
PSIBRTNGSUBDEFN;
PSRTNGDFNPARM;

Click Here To Learn PeopleSoft Integration >>

— Service Operation Handlers
PSOPRHDLR;
PSOPRHDLRLANG;
PSOPERATIONAC;
PSOPERATIONAE;
PSOPERATIONCI;
PSOPERATIONDMS;

— Service Operation Versions
PSOPRVERDFN;
PSOPRVERDFNLANG;
PSOPRVERDFNPARM;
PSOPRVERQUEPARM;
PSOPRGENRTGPARM;
PSOPRVERDEPLOY;
PSOPRVERDPLYVER;

— Integration Broker Queues
PSQUEUEDEFN;
PSIBQUEUEINST;
PSQUEUEDEFNLANG;
PSQUEUEOVRD;
PSQUEUEPART;

— Integration Group
PSIBGROUPDEFN;
PSIBGROUPLANG;
PSIBSBGROUPLANG;
PSIBSRVGROUP;
PSIBSUBGROUP;
PSIBSUBSRVGROUP;

— Integration Broker Schema

PSIBSCMADFN;
PSIBSCMADATA;

— Integration Broker WSDL

PSIBWSDLDFN;
PSIBWSDLDATA;

— XML Publisher Data Source

PSXPDATASRC;
PSXPDATASRCLNG;
PSXPSCHEMAFLMN;
PSXPSMPLDTMN;

— XML Publisher File Definition

PSFILEDEFN;
PSFILEDATA;

— XML Publisher Report Definition

PSXPRPTDEFN;
PSXPRPTDEFNLNG;
PSXPRPTOUTFMT;
PSXPRPTPROP;
PSXPRPTSCOPEFLD;
PSXPRPTSRCHKEYS;
PSXPRPTTMPL;
PSXPRPTTMPLCTRL;
PSXPRPTVIEWER;

— XML Publisher Template Definition

PSXPTMPLDEFN;
PSXPTMPLDEFNLNG;
PSXPTMPLFILEDEF;
PSXPTMPLTRINFO;

— XML Service Info
PS_XMLSERVICEINFO;

Click Here To Learn PeopleSoft Integration >>