Hi,
I'm trying to work out the logic and meaning behind some of the fields in LT_NSCAN_ATTENDANCE, as some of the data in our table doesn't seem to make sense. In particular, does anyone know the logic behind the ticket_updated and exit_logged fields?
If ticket_updated is 'Y' does that mean that this physical database row has been updated, so if exit_logged now says 'Out' did it previously say 'In'? Also if exit_mode is 'N' then how can exit_logged still be set as 'Out'?
If anyone is able to help, or point me in the direction of some documentation, it would be greatly appreciated!
Tom:
There’s more than just one attendance-recording table these days. T_ATTENDANCE is the “sanitized” version of attendance data- it records the actual, successful attendance scans. If you’re looking for the raw data that goes with every attempt to scan a ticket, the table you’ll want to query is T_NSCAN_EVENT_CONTROL. Everything that’s T_ATTENDANCE is in T_NSCAN_EVENT_CONTROL, but not vice versa.
... speaking of T_NSCAN_EVENT_CONTROL. I've tried to find some documentation to explain what the different status mean. What is the difference between 'C', 'I' and 'N', that all appear on tickets with ticket_msg = 'OK'?
(if there are more than 'C','I','N' AND 'X') i'd like to know what they mean as well.
Thanks