Multiple choice technology

Which field will enable you to keep historical, current and future information in tables?

  1. EFFDT

  2. SYSDATE

  3. ROW_ADDED_DTTM

  4. ROW_EFFDT
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

EFFDT (Effective Date) is the standard PeopleSoft field for tracking temporal data. It enables effective dating by storing different versions of records with different effective dates, allowing systems to maintain historical, current, and future data simultaneously. SYSDATE and ROW_ADDED_DTTM are audit fields, while ROW_EFFDT is not a standard field.

Keep practicing — related questions