Aucun contrôle n’est mis en place, veillez donc à ne l’exécuter que sur le dossier ciblé.
set @id_dossier=<id du dossier MI>;
set @firstName="anonyme";
set @lastName="anonyme";
set @date_of_birth=now();
set @email = "anonyme@anonyme.fr";
set @phone = "0xxxxxxxxx";
set @address_line_1="anonyme";
update xlr_business_record xbr
join xlr_business_senario xbs on xbr.brcd_id = xbs.business_record_brcd_id
join xlr_insured_object xio on xio.iobj_business_senario_id = xbs.bscr_id
join xlr_insured xi on xi.insd_id = xio.iobj_id
join xlr_address xa on xa.adr_id = xi.insd_fk_adresse_actuelle_id
join xlr_person xp on xp.per_id = xi.insd_per_id
set xp.per_firstname=@firstName,
xp.per_lastname=@lastName,
xi.insd_date_of_birth_dt=@date_of_birth,
xi.EMAIL=@email,
xi.MOBILE_PHONE_NUMBER =@phone ,
xa.adr_addres_line_1=@address_line_1
where xbr.brcd_id = @id_dossier;