Peoplesoft Queries Solutions

PeopleSoft Integration Broker Tables | IB Tables | PeopleSoft IB Meta Tables — 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; PSSERVICEO...

Application Engine Meta Data PSAEAPPLDEFN AE header record; 1 row per app engine PSAEAPPLSTATE AE state records (shows which one is the default) PSAEAPPLTEMPTBL AE temp tables assigned PSAESECTDEFN AE sections: public or private PSAESECTDTLDEFN AE section: descriptions, market, DB Type, EFFDT, EFF_STATUS, and auto commit PSAESTEPDEFN AE steps within section: description, market, DB Type, EFFDT, EFF_STATUS PSAESTMTDEFN AE actions within AE step: Step type (SQL, Do Select, etc.) with SQLID. PSAESTEPMSGDEFN AE message (parameters in each step) AEREQUESTPARM AE request parameters table behind the AE run control page. Find All Records Referenced in App Engine 1. Find the Temp Records (TAO) that are used: SELECT RECNAME FROM PSAEAPPLTEMPTBL WHERE AE_APPLID = 'MY_APP_PROGRAM_NAME' 2. If there are records, find the number of instances: SELECT TEMPTBLINSTANCES FROM PSAEAPPLDEFN WHERE AE_APPLID = 'MY_APP_PROGRAM_NAME...