Categories of Effective-Dated Rows



  1. A current row of data within PeopleSoft displays the most up-to-date information available, or what is currently affecting a change to the data.


    John Smith got married on September 12, 1997. Human Resources inserted a data row in his record that indicated a change of status from single to married, effective September 12, 1997. If you were to access John's record today, the current row would show September 12, 1997. Unless John has a status change in the future, September 12, 1997 will remain his current data row.

    Step 1
  2. Future rows of data are categorized as rows of data that have not yet taken effect. They are future transactions. If John had advised Human Resources of his wedding prior to the date of the event, a row could have been inserted with an effective date of September 12, 1997. Until the effective date passed, the row would remain in the system as future.


    Future rows can eliminate paperwork stored for future transactions and avoid potential loss of records.

    Step 2
  3. The last category, History, is fairly self-explanatory. History rows are what current and future rows eventually become.


    If John's marriage didn't work out and he got divorced, a row would be inserted to his status field indicating a divorce, with an effective date defined by John. The marriage date, which was the current row, would then become the history row.


    History rows enable you to maintain an accurate online history of your data. This data can then be incorporated into reports or viewed online.

    Step 3
  4. Actions determine the rows of an effective-dated table that can be retrieved or modified. The table below displays the categories of effective-dated rows, along with the action types and associated page actions used online to retrieve, insert, or update effective-dated rows.

    Step 4
  5. Now that you have an understanding of row categories, you can view some of them online using PeopleSoft.


    The search page for the Degree Table component is displayed. A search page with Include History and Correct History check boxes displayed indicates that you are accessing effective-dated data. You can access a history row from the search page or from within the page. If neither history box is selected, the Update/Display option is the default.


    Enter the desired information into the Degree field. Enter

     a valid value

    Step 5
  6. Click the Search button.

    Step 6
  7. The Degree Table page is displayed. The records in this component are effective-dated.

    Step 7
  8. Notice that there is one row listed. This is the current row of information.

    Step 8
  9. Click the Include History button.

    Step 9
  10. Notice that the scroll area now displays 1 of 3 between the scroll arrows.

    Step 10
  11. You are looking at the current active information. When this data was entered in the table, the previous data was stored as historic rows. You want to view the previous information for this degree.


    Click the Next Row button.

    Step 11
  12. Notice the effective date on this page. This was the degree description in 2000.


    Click the Next Row button.

    Step 12
  13. Now you can see the initial degree description in 1995.


    In addition to using the scroll arrows to view multiple rows of data individually, you can use the View All function to view all of the rows together.


    Click the View All link.

    Step 13
  14. As you can see, View All displays the current row of data at the top of the page followed by the history rows. Also notice that View All has changed to View 1 in the scroll area. When displaying data using View All, you may need to use the vertical scroll bar to see multiple effective-dated rows.


    Click the View 1 link.

    Step 14
  15. You are returned to the last row that you were viewing before you clicked View All. You can scroll back, one page at a time, to the other data rows you were viewing by clicking the Previous Row arrow in the scroll area. However, if you wish to return to the current row immediately, you can simply click First in the scroll area.


    Click the First link.

    Step 15

You have successfully practiced navigating through effective-dated rows and have seen how they are used within PeopleSoft. By using effective dates in relation to other fields, you can keep a chronological history of data within the system.

Table of Contents  Start Topic