On a T&A export, what are the definitions of the collumns StartDateTime, EndDateTime, Created On and Modified On?

@Rachel Sutton​ @Paul Oakley​ 

adding this for illustration.

Hi @Thomas Gold​ ,

Thanks for your question!

On this particular export, this is the breakdown of what the four different columns mean;

StartDateTime - What date and time the employee clocked in on

EndDateTime - What date and time the employee clocked out on

CreatedOn - This is the date that reflects when the T&A was last uploaded. So, in this instance, the original T&A data was uploaded again following the original time, which is why the date is later than the modified date/StartDateTime.

ModifiedOn - This is when the person who does the rota/checks the rota would have checked and authorised that particular day.

I hope this answers your question!

Thanks so much,

Veronica Tabatabai