Effective Dated Tables


In Varicent, we can create tables that include effective start and end dates. Multiple versions of the same record can be entered by setting different start and end dates for each record.

Biggest advantage of this feature: Varicent maintains the start and end dates for all records as changes occur to the data over time. For example, you can change the comp plan for an employee on Oct 1, 2020 and both comp plan for the employee can exist in the table with different start and end dates.

When Compared effective dated table with non-effective dated tables:

  • End dating previous version of record is done automatically for effective dated tables. The older version of record end dates a day before of the new record’s start date.
  • Effective dated table feature saves time and reduces error regarding “data do not end dated properly” like in non-effective dated tables.


Read more SPM Tech Tips: Varicent >>


Want to join our Tech Tip distribution? Join our community of SPM users to receive the latest information about SPM technology solutions.
Have a question for one of our SPM experts? We’re here to help! Submit your question and one of our experts will be in touch shortly
OpenSymmetry Favicon