jump to navigation

PeopleSoft Entity Relationship Diagrams (ERDs) February 10, 2010

Posted 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 …



1. William - February 10, 2010

Hi Duncan –

One thing to note – HCM is the only set that is loaded into the db, the rest are standalone PDF files.


2. Joe in VA - February 11, 2010

This sounds really cool..

but.. when I went to Note id 1051533.1, the only thing to download was a .zip file that contains just .PDF files.

What’s the secret code? 🙂

3. RR - February 22, 2010

Thanks Duncan,
I couldnt find the CA job to install the ERDs. Can you please point me to the right direction to get the CA job?

4. Tipster - February 22, 2010

RR, it may be because you are looking at ERDs for something other than HR. As William in the first comment pointed out, unless it’s the HR ERDs it’ll just be a bunch of PDFs.

5. RR - February 23, 2010

Thanks Duncan.

6. Dave - February 8, 2011

These look interesting, but the problem wuth pre-built models is that they never quite reflect what you want. We use a thing called Saphir that lets us scope the tables we want to see, then model them in a case tool. We use Sybase PowerDesigner, but I know it can do Erwin and a bunch of others. And it shows any tables we’ve added/modified oursleves too.

Sorry comments are closed for this entry

%d bloggers like this: