Understanding Effective Dates

PeopleSoft’s effective-dating logic enables you to maintain an accurate history of information in the database. Effective dating allows you to store historical data, see changes in your data over time, and enter future data. For example, you may want to track several events in the career of Tom Sawyer: when he was hired, transferred, and promoted. By inserting rows of data based on his employee ID, and significant dates, you can build a job history.

When you enter new information that is related to existing data (in this case about an employee), such as a transfer or pay rate change, you do not want to lose or overwrite the data already stored in the database. To retain history, add a data row identified by the date when the information goes into effect: the effective date. You can use the information to look at what has happened up to now and plan for the future. The PeopleSoft system categorizes effective-dated rows into the following basic types:

Term	Definition
Current	The data row with the date closest to—but not greater than—the system date. Only one row can be the current row.
History	Data rows that have effective dates earlier than the current data row.
Future	Data rows that have effective dates later than the system date.