Posts

Showing posts from 2019

PeopleSoft - PeopleTools Configurations Records or Meta Tables

-
PeopleSoft - PeopleTools Configurations Records or Meta Tables PeopleSoft records/metadata tables, often referred to as "meta tables," store information about various PeopleSoft objects and configurations.  1. Object Definition Tables: PSRECDEFN : Contains definitions of records (tables) used in the application, including details like record type and description. PSDBFIELD : Stores field definitions, detailing the attributes of each field such as data type and length. PSPNLGROUP : Holds information about components, which are collections of pages that function together. PSPNLDEFN : Contains definitions of pages (interfaces) within the application. PSMENUDEFN : Stores menu definitions, organizing how components are presented to users. 2. Security Tables: PSOPRDEFN : Maintains user profile information, including user IDs and associated roles. PSROLEDEFN : Defines roles that group together permissions for easier security management. PSCLASSDEFN : Holds permission li...
Post a Comment
Read more

PeopleSoft Integration Broker Tables | IB Tables | PeopleSoft IB Meta Tables

-
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...
Post a Comment
Read more

PeopleSoft Meta Tables

-
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...
Post a Comment
Read more