Effective dating is used in PeopleSoft to allow you to store and maintain the same set of data over time so that you can see the past, current and future conditions of this set of data.  For example, think of currency conversion where you want to store not only what the conversion rate is now, but also what it was in the past so that you can accurately report your financial position.  Effective dating is not just where you have a date in your data like a Purchase Order Due Date or Employee Hire Date.

Effective dating is used in PeopleSoft to allow you to store and maintain the same set of data over time so that you can see the past, current and future conditions of this set of data. For example, think of currency conversion where you want to store not only what the conversion rate is now, but also what it was in the past so that you can accurately report your financial position. Effective dating is not just where you have a date in your data like a Purchase Order Due Date or Employee Hire Date.

Many developers, including PeopleSoft developes, do not fully understand the proper use of effective dating in writing SQL, PeopleCode or in Pages. This training document is to cover this issue so that no longer are developers not using the effective date incorrectly.

Who is this document for?
This presentation is designed to teach developers proper use of the effective dating field in records and pages as well as use of Metasql and PeopleCode functions. This presentation can also be used by functional analysts to help them understand what effective dating is so that they can write better specifications, or work with users on issues with effective dating within PeopleSoft. Even PeopleSoft help desk personnel can benefit from this presentation learning all about effective dating.

About the Author
Joseph Weessies originally joined PeopleSoft as the first Supply Chain consultant in the West Coast in 1995. He quickly earned many accolades and awards not only for his functional skills but his technical as well. Joe left PeopleSoft to become an independent consultant working at PeopleSoft and saw that many developers were struggling to learn PeopleTools. With his release of the only book for PeopleTools 8.1 Joe started on his career of writing books and aids for PeopleTools. Joe has released 3 books, 5 specialty chapters and 7 specialized cheat sheets that are being used all over the world.

This document is 22 pages long in 8.5 X 11 format. Screen shots, SQL and PeopleCode are included and fully explained.