Comment 2 for bug 1843339

I'm not sure the best solution, but this is a growing issue across the code base and interfaces. We similarly need the booking pull list to pull the preferred name if it exists.

I'm not sure on performance, but maybe there needs to be generated columns on actor.usr that coalesce the fields into an authoritative column. Then all interfaces can use that field without duplicating the conditional if statements or their own coalesce (like hold shelf).