We have what is technically a ticketed performance but attendees are not given a physical ticket, attendance is tracked using paper lists of attendees. This year we would like to mark those who attend as having attended in the system but this will not happen until a couple of days after the event. I can mark them as attended using either N-Scan or Record Attendance but both ways the attend date is listed as the date I scanned/entered their ticket information, not the date of the performance.
Does anyone know if it is possible to set an attendance date so I can have the attendance date reflect the date they actually attended, not the date I entered their attendance?
Hey Scot,
After you mark the tickets Attended, you would just need to update the attend_dt column in the T_ATTENDANCE table using SQL Server Management Studio.
For example, if you wanted the Attended date/time to be at 5:30 PM on 6/12/2018, you (or your CRM) could use this:
BEGIN TRAN
UPDATE T_ATTENDANCE
SET attend_dt = ‘2018-06-12 5:30 PM’
--change date and/or time to what you want it to be.
WHERE perf_no =
--Enter the performance number above.
AND event_code = 22
--event_code = 22 means marked with Attended status.
COMMIT TRAN
If you wanted the Attended information to show up on the Order History tab within each order, you (or your CRM) would update the event_date column in the T_ORDER_SEAT_HIST.
UPDATE T_ORDER_SEAT_HIST
SET event_date = ‘2018-06-12 5:30 PM’
The reason I know this is that we are a general admission facility and have a customized procedure that marks the tickets as attended at the top of each hour for tickets sold onsite (by MOS) to our Zoo Daily Admission performance. For online tickets, people can use their general admission tickets on any day (since they already paid for them). The online tickets get marked attended when we use Record Attendance or NScan them.
We needed a way to change the attended date (because of the hourly procedure) when we had to correct or add to our overall daily attendance numbers (Zoo Daily Admission performance + any other ticketed performances on the same day). So, I figured out the transaction queries to make the needed updates (which I do by using the order_no column instead of using perf_no column in the WHERE clause).
Anyways, it now only takes less than 5 minutes to log into SSMS and run the update queries; the attendance is corrected/changed; and the attended date shows up correctly on the Order History tab of the order(s).
Hope this helps.
Neil
Also, as always, do this all in TEST first; as a proof of concept.