A patron called stating they were confused by our SYOS map on TNEW when selecting a seat in one of our boxes. For example, when hovering over the seat it displays "Row 22 Seat 1", when they are used to referring to it as "Box 22 Seat 1". My question is, is it possible to change the value in T_SEAT, updating seat_row from '22' to 'Box 22'? Would this work and not cause damage to anything?
Thanks,
Steve
Hopefully someone else will confirm this, but seat row appears in quite a few places (TX_PERF_SEAT, T_SPECIAL_REQ, TX_COMPOSITE_SEAT among others). I don't see any triggers that would make me think that changing T_SEAT would flow downhill into the other tables.
I don't know a ton about ticket design, but for tickets that have already been sold, you might be better off trying to mask the row description in the design itself (or in a report dataset if that's more appropriate.)