PeopleSoft Entity Relationship Diagrams (ERDs) February 10, 2010Posted by Duncan in PeopleTools.
A week or so ago PeopleSoft released Entity Relationship Diagrams (ERDs) to anyone with a My Oracle Support account. Although it has always been possible to source them, you had to go through your Account Manager or raise a ticket. Now (provided you have an account on My Oracle Support) you can download them (using note id 1051533.1).
So why are they useful? They are a visual representation of the schema of parts of the database, so they tell you – at a glance – how the tables relate to one another, which fields are within each table and what the keys are. If you have them to hand it can save you browsing record definitions in App Designer.
You install them by running the supplied Change Assistant job and then performing some manual additional steps from the included documentation. After a server bounce and cache clear there’ll be a new root menu ‘Data Models’. Providing your Environment Management infrastructure is up and running the install doesn’t take more than about 30 mins.
This should keep your Business Analysts/Functional Consultants happy. Now if only there was a PeopleTools ERD …