How You Make Multiple Updates to Date-Effective Objects in One Day

For most date-effective objects, only one physical record exists per day. Therefore, the object history shows only the latest update to each attribute in any one day. For example, if you update a location phone three times in one day, then only

For some objects, such as assignments, the update process creates a physical record for each update in a day. Such objects include an effective sequence number in each physical record to show the update order. Changes are cumulative, and the physical record with the highest effective sequence number is available to transactions for that date.

For example, this table shows multiple updates to a person's assignment working hours and job on 14 October, 2020 and 30 April, 2022.

Physical Record	Effective Sequence Number	Effective Start Date	Working Hours	Job
6	2	30 April, 2022	40	Lead Technician
5	1	30 April, 2022	42.5	Lead Technician
4	3	14 October, 2020	42.5	Senior Technician
3	2	14 October, 2020	42.5	Technician
2	1	14 October, 2020	40	Technician
1	1	17 June, 2020	40	Junior Technician

Object Correction

Effective sequence numbers apply only when you update an object. If you correct an object, then the new value overwrites the previous value. The correction process doesn't create a separate physical record for each change.

This table shows the person's assignment record when you correct rather than update the working hours and job attributes multiple time in one day.

Physical Record	Effective Start Date	Working Hours	Job
3	30 November, 2022	40	Lead Technician
2	14 October, 2020	42.5	Senior Technician
1	17 June, 2020	40	Junior Technician