spHandleDeletedRERecord

            CREATE   PROCEDURE [dbo].[spHandleDeletedRERecord]
            (
            @ClientUsersID    int
            )
            AS
            BEGIN

            set nocount on

            begin transaction
            insert into ClientUsersDeletedRERecordMap
            SELECT id, isnull(dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(id), 0)
            from ClientUsers
            WHERE ID = @ClientUsersID

            UPDATE ClientUsers
            SET IsProvisional = 1
            WHERE ID = @ClientUsersID

            UPDATE BackOfficeSystemUsers
            SET [current] = 0
            FROM BackOfficeSystemUsers bosu
            INNER JOIN BackOfficeSystemPeople bosp on bosp.id = bosu.BackOfficePeopleID and bosp.BackOfficeSystemID = 0
            and bosu.ClientUsersID = @ClientUsersID
            and bosu.[current] = 1
            commit
            END