TR_REGISTRANT_TASYNC_U

    CREATE trigger TR_REGISTRANT_TASYNC_U on dbo.REGISTRANT after update not for replication
    as begin
      -- Excluding the normal condition that the update is not performed by the sync.

      -- This table is mapped B2T to a different table than the original TA table, and this needs to behave

      -- in the same manner whether the row comes from TA or BBEC originally.


      update t
      set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
      from dbo.TA_REGISTRANT t
      inner join INSERTED i on i.ID = t.ID
    end