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

 

When you are using a PeopleSoft application for day-to-day processing, you usually want the application to give you the currently effective rows of data. Essentially, the application must return the row in which the effective date is less than or equal to the current date. You do not need to see the history rows, which are no longer accurate, nor do you need to see future-dated rows, which are not yet in effect.

 

When you are querying an effective-dated table, you may want to view some rows that are not currently in effect or, you may want to view all the rows, regardless of their effective dates. Additionally, you may want to view only the rows that were effective as of a specific date.

 

In this topic, you want to create a query of addresses for IDs who have campus address type in California. You will use the ADDRESSES record.

 


Table of Contents