O'Reilly logo

PeopleSoft HRMS Reporting by Adam T. Bromwich

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

2 Effective Dating

One of the key concepts in PeopleSoft is effective dating. It is one of the unique features of a PeopleSoft database and is a critical item for understanding how HR data history is stored. Nearly every piece of data has an effective date value. This chapter will introduce effective dating, and will point out some of the things to look out for when working with effective dates. It is important not only to see how effective dates are used in the database, but also to consider the SQL code required to use effective dates accurately.

THE EFFECTIVE DATE DEFINED

Effective dates allow the storage of data for many points in time. With an effective date, data from the past, the present, and the future are stored together, in the same ...

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