TR_REGISTRANT_TASYNC_D (Trigger)

                 
    create trigger TR_REGISTRANT_TASYNC_D on dbo.REGISTRANT after delete not for replication
    as begin
      -- Excluding the normal condition that the delete 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.

      
      merge dbo.TA_REGISTRANT t
      using (select ID from DELETED) d
      on (d.ID = t.ID)
      when matched and t.ACTIONCODE = 1 then
        delete
      when matched then
        update set ACTIONCODE = 3;
    end