Date Effectivity in Fusion Payroll

 Date effectivity preserves a history of changes made to the attributes of some objects. Date-effective objects include one or more physical records. Each record has effective start and end dates. One record is current and available to transactions. Others are past or take effect in the future. Together, these records constitute the logical record or object instance. For a date-effective logical row, which is a collection on contiguous temporal physical rows, each physical row CreatedBy (CREATED_BY) and CreationDate (CREATION_DATE) are the same.

Physical Record

Effective Start Date

Effective End Date

Department Manager

4

18 January, 2022

C. Woods

3

15 October, 2021

17 January, 2022

A. Chan

2

13 June, 2020

14 October, 2021

T. Romero

1

22 March, 2019

12 June, 2020

G. Martin

Every physical record except the last has an effective end date. The update process adds this date, which is the day before the effective start date of the next record, whenever you update the object.

Comments