We have a Wage Code ‘HOLIDAYS’ for staff to book annual leave. On a few occasions, the Day Value column in time_pers_diary_result appears as 0 when it should state 1.
I have removed the timesheet entry and re-entered, the database then shows the correct value of 1. I am trying to understand the logic behind the value initially being 0.
We use this value in a lobby tile to show how many holidays a person has taken, but in this example, where the Day Value is 0, this will not appear in the lobby results.