1)In the shift import, no shift is assigned for a particular date, but it is manually updated as leave.

2)An employee applied for leave in the morning, but it was incorrectly updated as evening leave.

3)Leave entries are not being updated properly.

4)On a holiday date, leave is updated, but no corresponding leave entry is recorded.

5)Shift import is duplicated for the same day.

6)For a weekoff date, leave is updated, but no corresponding leave entry is recorded.

7)Employee with code 1610 worked until January 13, but their last working date in the employee table is incorrectly recorded as 2024-01-31.

8)Employee with code 1628 was allocated a shift on January 7, but there is no corresponding time entry data.