Best practice to maintain retroactive rows
In PeopleSoft, what is the best practice for handling retroactive changes? We are working on a custom solution where we need to manage retroactive rows. Should we insert a new row for the retroactive change and then insert a new effective sequence (effseq) row for all subsequent rows, or should we insert a new row, open the data in correction history, and modify all subsequent rows? Which method is the best?
For example, if we have the following rows:
Effdt | effseq | salary | reportsto |
|---|---|---|---|
07/24/2024 | 0 | 50000 | 123 |
08/01/2024 | 0 | 50000 | 345 |
08/20/2024 | 0 | 50000 | 678 |
If there is a retroactive salary increase as of 07/26/2024 to 60000, which approach is better?
Approach 1:Insert new rows for each subsequent row.
Tagged:
0