PeopleCode Metatables

Peoplecode Audit:
At times, we have the necessity to find audit details of a particular peoplecode on a particular object. When we check the LASTUPDDTTM of a record or a page or a component, it does not give us the required information since the definition itself hasn't got changed by writing peoplecode. However, there is an answer to this. Most of the PeopleSoft technical consultants know that PSPCMPROG table stores the peoplecode. PROGTXT field in PSPCMPROG record stores the peoplecode however it cannot be retrieved in a readable format since the code is saved in binary format in the database.
PSPCMPROG record provides us two fields - LASTUPDDTTM and LASTUPDOPRID which gives us information on when the peoplecode was last modified and by whom.

References to objects in peoplecode:
I found something more interesting while verifying this sometime back. PSPCMNAME table contains two fields RECNAME and REFNAME which caught my attention. For every reference to a PeopleTools object referenced from peoplecode, an entry is written into this table. For example, if a Record.Field.Fieldchange event references five different PeopleSoft objects then there will be five entries in this table. I believe this is how PeopleSoft's cross reference utility\Definition references works. Surely give this a shot, when you have to do a definition reference next time.

No comments:

Post a Comment

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month