What does "TEST 15: TXN13.Absence present after type end date" Diagnostic Test means?

Summary

What does "TEST 15: TXN13.Absence present after type end date" Diagnostic Test means?

Content

Hi Experts,

We had a Absence Type (Holiday) which we end-dated on 07/03/2020 and a new record started of 08/03/2020.

Since then we can see there are many records which show up in the "Master Report - Absence Data Integrity Report".

Although we could see that there are multiple records in "ANC_ABSENCE_TYPES_F" table but the absence_type_id value remains same.

We know the solution is to run "TEST 15: TXN13.Absence present after type end date" in COMMIT Mode but what we are interested to know is the root cause of this issue and how can that be mitigated.