Data redundancy or not?

perhaps a bit off topic but i realy want to know what you rails people
think of the following situation:

i am building a shift trading application, so i have a table with shifts
and a table with transactions.

in the transactions table i keep track of the movement of shifts between
users. i have the fields from_user, to_user and status the status can be

  • offered for trade (1)
  • in negotiation (2)
  • transaction completed (3)

so, when i take a shift, i can always determine the status of it as
if there are no associated records in the transactions table, i can
offer it for trade.
i can also do this when there are no transactions with status 1 or 2

of course this is not too complicated to figure out, but adding an extra
status field on the shift recored is much easier to work with.

so: what would you do?
add the extra field or keep the design clean?