O'Reilly logo

PeopleSoft for the Oracle DBA by David Kurtz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

C H A P T E R  4

PeopleSoft Database Structure: A Tale of Two Data Dictionaries

One of the ways that PeopleSoft is able to deliver the same application to any platform is by having its own data dictionary. Different database platforms structure their data dictionaries differently, and platform independence is an overriding principle in PeopleSoft. Except when building DDL scripts and executing audit reports, PeopleTools never interrogates the database’s data dictionary, but instead relies on its own. PeopleTools is also a development environment, so it is necessary to have a way of defining a table before it is actually created in the database—the PeopleSoft data dictionary serves this function.

As introduced briefly in Chapter 1, a PeopleSoft ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required