Effective-dated tables have record definitions that include the Effective-date (EFFDT) field. This field, used throughout PeopleSoft applications, provides a historical perspective enabling you to see how the data has changed over time.


When you use a PeopleSoft application for day-to-day processing, you usually want the system to give you the currently effective rows of data—the rows where the effective-date is less than or equal to today’s date.


When you query an effective-dated table, however, you may want to see some rows that are not currently in effect. You might want to see all the rows, regardless of their effective dates. Or you might want to see the rows that were effective as of some date in the past.


In this topic, you will review effective-date criteria.

Table of Contents