
--
-- Table structure for table `oauth_consumer`
--

CREATE TABLE `oauth_consumer` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `c_key` varchar(255) DEFAULT NULL,
  `c_secret` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ckey` (`c_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `oauth_consumer`
--


--
-- Table structure for table `oauth_nonce`
--

CREATE TABLE `oauth_nonce` (
  `conskey` varchar(32) NOT NULL,
  `nonce` varchar(32) NOT NULL,
  `nonce_ts` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`conskey`,`nonce`),
  KEY `oauth_nonce_keyts` (`conskey`,`nonce_ts`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `oauth_nonce`
--


--
-- Table structure for table `oauth_tokens`
--

CREATE TABLE `oauth_tokens` (
  `id` char(36) NOT NULL,
  `secret` varchar(32) DEFAULT NULL,
  `tstate` varchar(1) DEFAULT NULL,
  `consumer` char(36) NOT NULL,
  `token_ts` bigint(20) DEFAULT NULL,
  `verify` varchar(32) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  `callback_url` varchar(255) DEFAULT NULL,
  `assigned_user_id` char(36) DEFAULT NULL,
  PRIMARY KEY (`id`,`deleted`),
  KEY `oauth_state_ts` (`tstate`,`token_ts`),
  KEY `constoken_key` (`consumer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `oauth_tokens`
--


--
-- Table structure for table `opportunities`
--

CREATE TABLE `opportunities` (
  `id` char(36) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `opportunity_type` varchar(255) DEFAULT NULL,
  `campaign_id` char(36) DEFAULT NULL,
  `lead_source` varchar(50) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `amount_usdollar` double DEFAULT NULL,
  `currency_id` char(36) DEFAULT NULL,
  `date_closed` date DEFAULT NULL,
  `next_step` varchar(100) DEFAULT NULL,
  `sales_stage` varchar(255) DEFAULT NULL,
  `probability` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_opp_name` (`name`),
  KEY `idx_opp_assigned` (`assigned_user_id`),
  KEY `idx_opp_id_deleted` (`id`,`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `opportunities`
--


--
-- Table structure for table `opportunities_audit`
--

CREATE TABLE `opportunities_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_opportunities_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `opportunities_audit`
--


--
-- Table structure for table `opportunities_contacts`
--

CREATE TABLE `opportunities_contacts` (
  `id` varchar(36) NOT NULL,
  `contact_id` varchar(36) DEFAULT NULL,
  `opportunity_id` varchar(36) DEFAULT NULL,
  `contact_role` varchar(50) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `idx_con_opp_con` (`contact_id`),
  KEY `idx_con_opp_opp` (`opportunity_id`),
  KEY `idx_opportunities_contacts` (`opportunity_id`,`contact_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `opportunities_contacts`
--


--
-- Table structure for table `opportunities_cstm`
--

CREATE TABLE `opportunities_cstm` (
  `id_c` char(36) NOT NULL,
  `jjwg_maps_lng_c` float(11,8) DEFAULT 0.00000000,
  `jjwg_maps_lat_c` float(10,8) DEFAULT 0.00000000,
  `jjwg_maps_geocode_status_c` varchar(255) DEFAULT NULL,
  `jjwg_maps_address_c` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_c`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `opportunities_cstm`
--


--
-- Table structure for table `ops_action_retarde`
--

CREATE TABLE `ops_action_retarde` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `ops_action_id` char(36) DEFAULT NULL,
  `ops_dossier_id` char(36) DEFAULT NULL,
  `ops_statut_id` char(36) DEFAULT NULL,
  `date_declenchement` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_action_retarde`
--

INSERT INTO `ops_action_retarde` VALUES ('c2d669d7-1e17-c7d3-9eb3-6509b220f180','Relance justificatifs','2023-09-19 14:38:28','2023-09-19 14:38:28','1','1',NULL,0,NULL,NULL,'3573056e-f3d4-5abb-7dd0-64e70d48964c','609c14a3-5d36-4f67-56bd-64819a1d26f7','2023-09-20 07:45:00'),('cebcc676-1ba8-24b2-3332-6509b26b8261','Notification','2023-09-19 14:37:26','2023-09-19 14:37:26','1','1',NULL,0,NULL,NULL,'efd2480c-54cd-8e37-9538-65044da1b799','29e0a6c8-61ab-1401-9793-64819a59451c','2023-09-20 09:00:00'),('cee94578-4f02-74a7-7c26-6509b20e9576','Notification','2023-09-19 14:37:54','2023-09-19 14:37:54','1','1',NULL,0,NULL,NULL,'66f600d4-5449-c136-fedc-6504573ac0d2','2d63b2e9-ce37-b4c4-efa8-64819af9e50b','2023-09-21 04:30:00');

--
-- Table structure for table `ops_action_retarde_audit`
--

CREATE TABLE `ops_action_retarde_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_action_retarde_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_action_retarde_audit`
--


--
-- Table structure for table `ops_action_statut`
--

CREATE TABLE `ops_action_statut` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `active` tinyint(1) DEFAULT 0,
  `fonction` varchar(100) DEFAULT NULL,
  `ext_valeur_1` text DEFAULT NULL,
  `ext_valeur_2` text DEFAULT NULL,
  `ext_valeur_3` text DEFAULT NULL,
  `ext_valeur_4` text DEFAULT NULL,
  `ext_valeur_5` text DEFAULT NULL,
  `ext_valeur_text` text DEFAULT NULL,
  `ext_valeur_6` text DEFAULT NULL,
  `execution_retarde` tinyint(1) DEFAULT 0,
  `jours` int(255) DEFAULT 0,
  `heures` int(255) DEFAULT 0,
  `minutes` int(255) DEFAULT 0,
  `ordre` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_action_statut`
--

INSERT INTO `ops_action_statut` VALUES ('e9aec68e-5e00-be02-59f2-6425e46fa5a0','Maj adresse','2023-03-30 19:37:02','2023-03-30 21:05:59','1','1',NULL,0,'',1,'modifieradressedomiciliationaction',NULL,NULL,'eyJhZHJlc3NlIjoiQWRyZXNzZSIsImFkcmVzc2VfZGF0ZV92YWxpZGl0ZSI6IkFkcmVzc2UgdmFsaWRlIFx1MDBlMCBwYXJ0aXIgZGUifQ==',NULL,'eyI3NTgzYTFjOS1lNGE3LWY5MDYtMGJkZS02NDI1Y2VjZWExZWIiOiJBY3Rpdml0XHUwMGU5IHNwb3J0aXZlIiwiN2FmNjk5ZTItYzY1ZC1lOTA4LTgyNmUtNjQyNTdjMzI5Nzg3IjoiQWRyZXNzZSIsImI0MzkwNzdmLWU0YmMtZWNiMS00MzdmLTY0MjFmNGMwMGRjMCI6IkFkcmVzc2UgZGUgY29ycmVzcG9uZGFuY2UgaWRlbnRpcXVlIiw','adresse_date_validite;21227a75-0ec6-8867-8bf2-64258d21e0a7|adresse;43b605c2-e987-3079-ea6e-64258d0b9722',NULL,0,0,0,0,1),('97ebc4c1-3467-67ba-24b3-6425f183d037','doc','2023-03-30 20:32:04','2023-03-30 20:33:10','1','1',NULL,0,'',1,'envoyermailaction','demandeur','off',NULL,'74f8a9a0-e579-c903-5292-624183e9e698',NULL,NULL,'off',0,0,0,0,1),('13c742ac-e4ea-ccbb-43cf-643ab0d21507','Réponse accueil mail complet','2023-04-15 14:12:42','2023-04-15 14:12:42','6f8ff2e0-a1c9-778f-332a-643aa04a16d7','6f8ff2e0-a1c9-778f-332a-643aa04a16d7','',0,NULL,1,'envoyermailaction','demandeur','','','26286b60-cc9f-8c02-dbf1-643ab0c966b4','','','off',0,0,0,0,10),('43b85234-efaf-ff8d-3431-643ab2bc496e','Réponse accueil mail BDC','2023-04-15 14:19:44','2023-04-15 14:19:44','6f8ff2e0-a1c9-778f-332a-643aa04a16d7','6f8ff2e0-a1c9-778f-332a-643aa04a16d7','',0,NULL,1,'envoyermailaction','demandeur','','','e7b31350-4b9d-3dbb-05de-643ab15a0cd3','','','off',0,0,0,0,10),('86a91640-f6e9-04ab-e4a3-643ab204c849','Réponse accueil compte','2023-04-15 14:20:55','2023-04-15 14:20:55','6f8ff2e0-a1c9-778f-332a-643aa04a16d7','6f8ff2e0-a1c9-778f-332a-643aa04a16d7','',0,NULL,1,'envoyermailaction','demandeur','','','bb538706-158a-b727-24ca-643ab158a1dd','','','off',0,0,0,0,10),('189b6009-e5db-0888-e650-643bdedba4c8','Ajouter une ligne de suivi','2023-04-16 11:38:22','2023-04-16 11:51:37','eb11b140-bfc7-7d6d-fdac-643bd1bebcd1','eb11b140-bfc7-7d6d-fdac-643bd1bebcd1',NULL,0,'',1,'creersuividossieraction','Réponse à l\'usager','10','reponse_apportee',NULL,'on',NULL,'on',0,0,0,0,5),('ce34d868-4636-25d0-7f74-643d35f487e2','recopie du champ réponse','2023-04-17 12:01:38','2023-04-17 12:01:38','eb11b140-bfc7-7d6d-fdac-643bd1bebcd1','eb11b140-bfc7-7d6d-fdac-643bd1bebcd1','',0,NULL,1,'alimenterchampparunautreaction','champs_personnalises',NULL,'b48e5058-97da-1b48-a96b-643cf5f7c452','d5f06e33-fcbf-3bba-3106-643958ba573e',NULL,'[encoded data, 47176 characters]',NULL,0,0,0,0,10),('c9fef6fe-5888-a3bf-9de9-643fd8a923b6','Réponse accueil accession propriété','2023-04-19 12:04:28','2023-04-19 12:04:28','6f8ff2e0-a1c9-778f-332a-643aa04a16d7','6f8ff2e0-a1c9-778f-332a-643aa04a16d7','',0,NULL,1,'envoyermailaction','demandeur','','','562a75d6-e27d-3d13-50c3-643fd804379e','','','off',0,0,0,0,10),('cbd1b22b-8847-b4b4-e9f7-643fde60a3b4','Mail automatique FSL','2023-04-19 12:26:58','2023-11-04 08:48:23','1','6f8ff2e0-a1c9-778f-332a-643aa04a16d7',NULL,0,'',1,'envoyermailaction','demandeur',NULL,NULL,'22e0b055-a68b-a465-7f74-643fddd29c6c',NULL,'eyJqdXN0aWZpY2F0aWZzIjoib2ZmIiwianVzdGlmaWNhdGlmX3R5cGUiOiIifQ==','off',0,0,0,0,10),('407cf4d8-2dae-d1f1-1788-64a709e8cf0d','Envoi formulaire Appui Logement','2023-07-06 18:37:32','2023-07-06 18:37:32','1','1','',0,NULL,1,'envoyermailaction','demandeur','','','60a6c6aa-5eb2-b5cf-bf57-64a70881b79b','','','off',0,0,0,0,10),('d902c665-9ceb-3f25-6465-64a7bb148d34','Préparer le mail FSL','2023-07-07 07:15:58','2023-11-04 08:41:38','1','6f8ff2e0-a1c9-778f-332a-643aa04a16d7','',1,NULL,1,'modifierchampdossieraction','6158c681-ba52-7d18-70f0-643bdf5bc12c','Réponse du service :  Concernant cette aide, la constitution de ce dossier se fait directement auprès du travailleur social de votre secteur. Consulter / télécharger la liste des points d\'accueil ici    Lien vers la fiche complète du dispositif :  https:',NULL,NULL,NULL,NULL,NULL,0,0,0,0,20),('269382b8-8e64-58ce-64a8-65099f2d47fd','Suivi complet','2023-09-19 13:19:34','2023-09-19 13:19:34','1','1','',0,NULL,1,'creersuividossieraction','Votre dossier est complet et peut être instruit par nos services (cela ne préjuge en rien de la décision finale qui sera prise par la commission)','10','','','on',NULL,'on',0,0,0,0,1),('b7299034-8f39-ad90-688a-6509a0f40d82','Montant voté','2023-09-19 13:20:46','2023-09-19 13:20:46','1','1','',0,NULL,1,'creersuividossieraction','La commission s\'est réunie et a décidé de donner une suite favorable à votre demande en vous attribuant une aide d\'un montant (€) de','30','montant_vote','','on',NULL,'on',0,0,0,0,1),('efeffad7-5da3-92f4-443f-6546189e82f8','Réponse intégrant réponse apportée','2023-11-04 10:08:38','2023-11-04 10:08:38','1','1','',0,NULL,1,'envoyermailaction','demandeur','','','26286b60-cc9f-8c02-dbf1-643ab0c966b4','','','off',0,0,0,0,10),('e1153024-cfca-87fc-381a-655b113ac57a','Mise en cloture du dossier','2023-11-20 07:58:11','2023-11-20 07:58:11','1','1','',0,NULL,1,'modifierchampdossieraction','9f437e8c-6262-0011-5456-655b1160071f','1',NULL,NULL,NULL,NULL,NULL,0,0,0,0,1),('841ad90c-6a80-7ff8-7266-655b12c0031e','Mise en cloture du dossier','2023-11-20 08:01:25','2023-11-20 08:01:25','1','1','',0,NULL,1,'modifierchampdossieraction','9f437e8c-6262-0011-5456-655b1160071f','1',NULL,NULL,NULL,NULL,NULL,0,0,0,0,2),('819fa6f0-94a8-0be0-0395-659131f74302','Onglets_non_modifiables','2023-12-31 09:16:00','2023-12-31 09:16:00','1','1',NULL,0,NULL,1,'rendrevisiblemodifiableongletaction','eyI3NTAzMjA2MS04NGE2LTEyNmYtN2ZiNy02NGYwOTlmZDQ2MTgiOiJDb250cmF0IGRlIHByb2pldHMgY29tbXVuYXV4IC0gRG9zc2llciBwYWllbWVudCIsIjdhMjliZWUwLTg1MWQtZmQ0My02MzUyLTY1MDJmNDMzZDRjNyI6Ik1PREVMRSBDb250cmF0IC0gRG9zc2llciBhdHRyaWJ1dGlvbiIsImEzNmI5YWRhLTk2NDAtODU2Mi1kZDB','modif_onglet','eyI3NTAzMjA2MS04NGE2LTEyNmYtN2ZiNy02NGYwOTlmZDQ2MTgiOnsiNDhjYWVlYjktZjVmNy0zNjg5LTgxYjItNjRmMDk5NTFjNjUwIjoiQ1JNIiwiN2E4ZjU1MGQtODA2YS01MWM5LWU0Y2YtNjRmMDk5NWIzZDBmIjoiSW50ZXJuZXQifSwiN2EyOWJlZTAtODUxZC1mZDQzLTYzNTItNjUwMmY0MzNkNGM3Ijp7ImVmYzgzMWYzLTdlZWU','eyI0OGNhZWViOS1mNWY3LTM2ODktODFiMi02NGYwOTk1MWM2NTAiOnsiNGYzNDlhZDAtNzJhMy1lYzc5LTQ3MDgtNjRmMDk5ZDMwNWUzIjoiRGVtYW5kZSBkZSBwYWllbWVudCIsIjM3OWVkMWRlLTYxMjYtMWM5Mi1lYTFlLTY1NWYxNjVhNjQ3ZiI6IlBsYW4gZGUgZmluYW5jZW1lbnQgZFx1MDBlOWZpbml0aWYiLCI4MTdkZTJlZi05MmV','','visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|modele_dossier;7a29bee0-851d-fd43-6352-6502f433d4c7|onglet_crm;a0050057-a4a2-4448-c6ca-6502f44a810d,5c3ea98f-c85b-2fdc-4e93-6502f4c0484c,caa29604-5e34-cb5c-78a0-6502f479d9e5,ed85ab78-df1e-91a0-ee51-6502f4175ecd,8fc1043c-560b-e3ae-26ae-6502f499a982,b7c46516-cabc-a43a-d811-651fdc640e00,d6c4000e-7928-6c06-6eb4-65311d8178b5,3ca54879-0336-4060-3ee3-6502f4ca7ec4','',0,0,0,0,15),('977cf537-40c0-132b-1f6d-6591311b3c6e','Onglets_non_modifiables','2023-12-31 09:16:00','2023-12-31 09:16:00','1','1',NULL,0,NULL,1,'rendrevisiblemodifiableongletaction','eyI3NTAzMjA2MS04NGE2LTEyNmYtN2ZiNy02NGYwOTlmZDQ2MTgiOiJDb250cmF0IGRlIHByb2pldHMgY29tbXVuYXV4IC0gRG9zc2llciBwYWllbWVudCIsIjdhMjliZWUwLTg1MWQtZmQ0My02MzUyLTY1MDJmNDMzZDRjNyI6Ik1PREVMRSBDb250cmF0IC0gRG9zc2llciBhdHRyaWJ1dGlvbiIsImEzNmI5YWRhLTk2NDAtODU2Mi1kZDB','modif_onglet','eyI3NTAzMjA2MS04NGE2LTEyNmYtN2ZiNy02NGYwOTlmZDQ2MTgiOnsiNDhjYWVlYjktZjVmNy0zNjg5LTgxYjItNjRmMDk5NTFjNjUwIjoiQ1JNIiwiN2E4ZjU1MGQtODA2YS01MWM5LWU0Y2YtNjRmMDk5NWIzZDBmIjoiSW50ZXJuZXQifSwiN2EyOWJlZTAtODUxZC1mZDQzLTYzNTItNjUwMmY0MzNkNGM3Ijp7ImVmYzgzMWYzLTdlZWU','eyI0OGNhZWViOS1mNWY3LTM2ODktODFiMi02NGYwOTk1MWM2NTAiOnsiNGYzNDlhZDAtNzJhMy1lYzc5LTQ3MDgtNjRmMDk5ZDMwNWUzIjoiRGVtYW5kZSBkZSBwYWllbWVudCIsIjM3OWVkMWRlLTYxMjYtMWM5Mi1lYTFlLTY1NWYxNjVhNjQ3ZiI6IlBsYW4gZGUgZmluYW5jZW1lbnQgZFx1MDBlOWZpbml0aWYiLCI4MTdkZTJlZi05MmV','','visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|modele_dossier;7a29bee0-851d-fd43-6352-6502f433d4c7|onglet_crm;a0050057-a4a2-4448-c6ca-6502f44a810d,5c3ea98f-c85b-2fdc-4e93-6502f4c0484c,caa29604-5e34-cb5c-78a0-6502f479d9e5,ed85ab78-df1e-91a0-ee51-6502f4175ecd,8fc1043c-560b-e3ae-26ae-6502f499a982,b7c46516-cabc-a43a-d811-651fdc640e00,d6c4000e-7928-6c06-6eb4-65311d8178b5,3ca54879-0336-4060-3ee3-6502f4ca7ec4','',0,0,0,0,15),('a162f3ca-72c8-c5c1-eaad-6591310e260f','Decision_comm=Mt_proposé va mt vote','2023-12-31 09:16:00','2023-12-31 09:21:17','1','1',NULL,0,'',0,'alimenterchampparunautreaction','champs_standards',NULL,NULL,'montant_vote',NULL,'[encoded data, 65535 characters]',NULL,0,0,0,0,10),('b025477b-d050-874a-f593-65913179162a','Decision_comm=favorable','2023-12-31 09:16:00','2023-12-31 09:21:12','1','1',NULL,0,'',0,'modifierchampdossieraction',NULL,'favorable',NULL,NULL,NULL,NULL,NULL,0,0,0,0,5),('b8ad323d-8aac-ff4d-769f-659131b666e0','3_Onglets_non_modifiables','2023-12-31 09:16:00','2023-12-31 10:01:48','1','1',NULL,0,'',1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;365abffa-81d6-52dd-b247-659131b336c5|onglet_crm;8bdb8b64-22bd-9dad-1980-6591315fbd70,15afb121-f709-51e2-4d34-65913196a299',NULL,0,0,0,0,15),('c387933e-6e2b-73cc-008b-65913182a07f','5_Onglets_non_modifiables','2023-12-31 09:16:00','2023-12-31 09:23:37','1','1',NULL,0,'',1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;365abffa-81d6-52dd-b247-659131b336c5|onglet_crm;8bdb8b64-22bd-9dad-1980-6591315fbd70,15afb121-f709-51e2-4d34-65913196a299,6f4980d3-482d-f094-be5a-659131d1d2e3,e46a7372-06ee-0829-8a97-659131ba08b1,b7540c7b-3346-2e3d-5ca2-659131ff28d4',NULL,0,0,0,0,15),('d9675e0b-9c34-ed1c-e0b6-6591313184ad','Onglets_non_modifiables','2023-12-31 09:16:00','2023-12-31 09:22:55','1','1',NULL,0,'',1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;off|modifiable_internet;off|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;365abffa-81d6-52dd-b247-659131b336c5|onglet_crm;8bdb8b64-22bd-9dad-1980-6591315fbd70,15afb121-f709-51e2-4d34-65913196a299,6f4980d3-482d-f094-be5a-659131d1d2e3,e46a7372-06ee-0829-8a97-659131ba08b1,b7540c7b-3346-2e3d-5ca2-659131ff28d4',NULL,0,0,0,0,5),('e3cb73c8-b913-160f-e764-659131ce6f70','5_Onglets_non_modifiables','2023-12-31 09:16:00','2023-12-31 10:12:37','1','1',NULL,0,'',0,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;365abffa-81d6-52dd-b247-659131b336c5|onglet_crm;8bdb8b64-22bd-9dad-1980-6591315fbd70,15afb121-f709-51e2-4d34-65913196a299',NULL,0,0,0,0,5),('bb4dfd94-f200-b0c5-28e6-65bfd2fe78c6','recopier tableau','2024-02-04 18:08:45','2024-03-17 08:16:08','1','1','',1,NULL,1,'alimenterchampparunautreaction','champs_personnalises',NULL,'331afa6f-7ece-168f-59a1-65bfcc78254f','c5c8348a-169c-bea3-63d3-65bfcf7f2266',NULL,'[encoded data, 65535 characters]',NULL,0,0,0,0,10),('f33ad01b-d5c4-da5d-9119-6591318ed746','Onglets_non_modifiables','2023-12-31 09:16:00','2023-12-31 09:16:00','1','1',NULL,0,NULL,1,'rendrevisiblemodifiableongletaction','eyI3NTAzMjA2MS04NGE2LTEyNmYtN2ZiNy02NGYwOTlmZDQ2MTgiOiJDb250cmF0IGRlIHByb2pldHMgY29tbXVuYXV4IC0gRG9zc2llciBwYWllbWVudCIsIjdhMjliZWUwLTg1MWQtZmQ0My02MzUyLTY1MDJmNDMzZDRjNyI6Ik1PREVMRSBDb250cmF0IC0gRG9zc2llciBhdHRyaWJ1dGlvbiIsImEzNmI5YWRhLTk2NDAtODU2Mi1kZDB','modif_onglet','eyI3NTAzMjA2MS04NGE2LTEyNmYtN2ZiNy02NGYwOTlmZDQ2MTgiOnsiNDhjYWVlYjktZjVmNy0zNjg5LTgxYjItNjRmMDk5NTFjNjUwIjoiQ1JNIiwiN2E4ZjU1MGQtODA2YS01MWM5LWU0Y2YtNjRmMDk5NWIzZDBmIjoiSW50ZXJuZXQifSwiN2EyOWJlZTAtODUxZC1mZDQzLTYzNTItNjUwMmY0MzNkNGM3Ijp7ImVmYzgzMWYzLTdlZWU','eyI0OGNhZWViOS1mNWY3LTM2ODktODFiMi02NGYwOTk1MWM2NTAiOnsiNGYzNDlhZDAtNzJhMy1lYzc5LTQ3MDgtNjRmMDk5ZDMwNWUzIjoiRGVtYW5kZSBkZSBwYWllbWVudCIsIjVjY2Y3NzZkLWY1NDktOTdlNS0yN2RkLTY1MjNiZTI4MjVkYSI6IlBsYW4gZGUgZmluYW5jZW1lbnQgZFx1MDBlOWZpbml0aWYiLCI4MTdkZTJlZi05MmV','','visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|modele_dossier;7a29bee0-851d-fd43-6352-6502f433d4c7|onglet_crm;a0050057-a4a2-4448-c6ca-6502f44a810d,5c3ea98f-c85b-2fdc-4e93-6502f4c0484c,caa29604-5e34-cb5c-78a0-6502f479d9e5,ed85ab78-df1e-91a0-ee51-6502f4175ecd,8fc1043c-560b-e3ae-26ae-6502f499a982,b7c46516-cabc-a43a-d811-651fdc640e00,d6c4000e-7928-6c06-6eb4-65311d8178b5,3ca54879-0336-4060-3ee3-6502f4ca7ec4','',0,0,0,0,15),('e6ce0d04-0413-aaa0-1bce-65913183f147','3_Onglets_non_modifiables','2023-12-31 09:16:00','2023-12-31 09:59:15','1','1',NULL,0,'',1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;365abffa-81d6-52dd-b247-659131b336c5|onglet_crm;8bdb8b64-22bd-9dad-1980-6591315fbd70,15afb121-f709-51e2-4d34-65913196a299',NULL,0,0,0,0,15),('1e10c443-740b-4b4b-8332-659131fc6966','Affecter le territoire','2023-12-31 09:16:00','2023-12-31 09:18:50','1','1',NULL,0,'',1,'affectersecteuraction','6ffe1d03-39a0-ac08-aa36-6429964b42f4','50e82722-2b5a-4aae-9611-6591310973df',NULL,'yes',NULL,'bnVsbA==',NULL,0,0,0,0,1),('228ae80e-f1f8-1496-6d3c-659131f0e6e8','Envoi des courrier','2023-12-31 09:16:00','2023-12-31 09:19:05','1','1',NULL,0,'',0,'declenchertraitementaction',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,2),('2d39e3eb-85c2-23f2-ac74-65913154146f','Localisation auto des dossiers sur adresse operation','2023-12-31 09:16:00','2023-12-31 09:16:00','1','1',NULL,0,NULL,1,'affectersecteuraction','564ce484-5aed-a773-b715-64258aed138f','d1e82a69-1adb-ec0a-b68a-637e03707e11','','yes','','bnVsbA==','',0,0,0,0,20),('30eb9ac6-d4cb-43a1-2223-65913190fba0','Onglets_non_modifiables','2023-12-31 09:16:00','2023-12-31 09:16:00','1','1',NULL,0,NULL,1,'rendrevisiblemodifiableongletaction','eyI3NTAzMjA2MS04NGE2LTEyNmYtN2ZiNy02NGYwOTlmZDQ2MTgiOiJDb250cmF0IGRlIHByb2pldHMgY29tbXVuYXV4IC0gRG9zc2llciBwYWllbWVudCIsIjdhMjliZWUwLTg1MWQtZmQ0My02MzUyLTY1MDJmNDMzZDRjNyI6Ik1PREVMRSBDb250cmF0IC0gRG9zc2llciBhdHRyaWJ1dGlvbiIsImEzNmI5YWRhLTk2NDAtODU2Mi1kZDB','modif_onglet','eyI3NTAzMjA2MS04NGE2LTEyNmYtN2ZiNy02NGYwOTlmZDQ2MTgiOnsiNDhjYWVlYjktZjVmNy0zNjg5LTgxYjItNjRmMDk5NTFjNjUwIjoiQ1JNIiwiN2E4ZjU1MGQtODA2YS01MWM5LWU0Y2YtNjRmMDk5NWIzZDBmIjoiSW50ZXJuZXQifSwiN2EyOWJlZTAtODUxZC1mZDQzLTYzNTItNjUwMmY0MzNkNGM3Ijp7ImVmYzgzMWYzLTdlZWU','eyI0OGNhZWViOS1mNWY3LTM2ODktODFiMi02NGYwOTk1MWM2NTAiOnsiNGYzNDlhZDAtNzJhMy1lYzc5LTQ3MDgtNjRmMDk5ZDMwNWUzIjoiRGVtYW5kZSBkZSBwYWllbWVudCIsIjVjY2Y3NzZkLWY1NDktOTdlNS0yN2RkLTY1MjNiZTI4MjVkYSI6IlBsYW4gZGUgZmluYW5jZW1lbnQgZFx1MDBlOWZpbml0aWYiLCI4MTdkZTJlZi05MmV','','visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|modele_dossier;7a29bee0-851d-fd43-6352-6502f433d4c7|onglet_crm;a0050057-a4a2-4448-c6ca-6502f44a810d,5c3ea98f-c85b-2fdc-4e93-6502f4c0484c,caa29604-5e34-cb5c-78a0-6502f479d9e5,ed85ab78-df1e-91a0-ee51-6502f4175ecd,8fc1043c-560b-e3ae-26ae-6502f499a982,b7c46516-cabc-a43a-d811-651fdc640e00,d6c4000e-7928-6c06-6eb4-65311d8178b5,3ca54879-0336-4060-3ee3-6502f4ca7ec4','',0,0,0,0,10),('359e716e-67d0-2ca4-1011-6591311149e8','Mail + PDF attestation depot','2023-12-31 09:16:00','2023-12-31 09:16:32','1','1',NULL,0,'',1,'genererdocumentaction','ef21c997-6bde-c58c-bf1e-64f3843db9ee','on',NULL,'73d84f63-2db6-53c7-3c56-621f915f3572',NULL,'eyJqdXN0aWZpY2F0aWZzIjoib2ZmIiwianVzdGlmaWNhdGlmX3R5cGUiOiIifQ==','on',0,0,0,0,1),('884f6eac-8234-068f-5444-65bfd93213c2','Générer convocation','2024-02-04 18:36:30','2024-02-04 18:37:28','1','1',NULL,0,'',1,'genererdocumentaction','3f567d14-b277-a2b5-b926-65bfd4e7e7ab','off',NULL,NULL,NULL,NULL,NULL,0,0,0,0,10),('8bf5f5b6-f1a9-6072-42a5-65c058978251','Rappel SMS','2024-02-05 03:38:51','2024-02-05 03:38:51','1','1','',0,NULL,1,'envoyersmsaction','demandeur','','a3b90301-fa33-0779-9e85-65c056d744fe',NULL,NULL,NULL,NULL,0,0,0,0,10),('b6b4a50c-c69d-93d9-982c-65f2e2be388e','Recopie tableau valo','2024-03-14 11:43:31','2024-03-14 11:43:31','1','1','',0,NULL,1,'alimenterchampparunautreaction','champs_personnalises',NULL,'96e803b6-ab72-a987-794e-65f206211ef2','d7067e07-5a72-66ce-a6b7-65f2d3896946',NULL,'[encoded data, 65535 characters]',NULL,0,0,0,0,10),('35a112b9-d74a-0cc4-f3c8-65f6a4e71ee7','Notif usager courrier','2024-03-17 08:07:21','2024-03-17 08:07:21','1','1','',0,NULL,1,'envoyermailaction','dossier','email','','5bfe7606-5dcd-9122-540c-6223bca99933','','','off',0,0,0,0,20),('db390a71-d8ad-334f-3ff6-65f6a650c115','Relancer par SMS','2024-03-17 08:13:28','2024-03-17 08:13:28','1','1','',0,NULL,1,'envoyersmsaction','demandeur','','a3b90301-fa33-0779-9e85-65c056d744fe',NULL,NULL,NULL,NULL,0,0,0,0,10),('738dcd43-e195-f904-3702-65f6a7868f82','recopier tableau inscrits','2024-03-17 08:18:42','2024-03-17 08:18:42','1','1','',0,NULL,1,'alimenterchampparunautreaction','champs_personnalises',NULL,'331afa6f-7ece-168f-59a1-65bfcc78254f','c5c8348a-169c-bea3-63d3-65bfcf7f2266',NULL,'[encoded data, 65535 characters]',NULL,0,0,0,0,10),('6eb62270-d8cf-110f-a2f4-65f6ac8ea2d4','Générer courrier de remerciements','2024-03-17 08:42:08','2024-03-17 08:42:08','1','1','',0,NULL,1,'genererdocumentaction','8f2a659b-4430-6d2e-701e-65f6a9e3f44e','on',NULL,NULL,NULL,NULL,NULL,0,0,0,0,10),('8d64f6fe-bd67-c3a5-d366-65f6adea0471','Notif usager courrier','2024-03-17 08:42:43','2024-03-17 08:42:43','1','1','',0,NULL,1,'envoyermailaction','dossier','email','','5bfe7606-5dcd-9122-540c-6223bca99933','','','off',0,0,0,0,20),('453891aa-8535-afdc-fd7e-6605943f0329','vers_cloture_annule','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','dd99eb7e-9356-2db3-5ca9-644934736cf4','Annulé à l\'étape paiement','8fee9c63-25d2-97c9-b228-6449343057b6','','','','',1,0,0,3,10),('4be856d9-ec8d-9095-d5fb-6605948c97ee','vers_revision_conseil','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','62760c86-03f5-2129-8be3-64492f16199f','','3395099d-c888-fb69-506b-644930ebc5b9','','','','',0,0,0,0,10),('50acee6f-56ec-6c49-7cc2-660594f93d43','vers_cloture_solde','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','dd99eb7e-9356-2db3-5ca9-644934736cf4','','d08bcfc6-6286-37c5-3079-64493496b0a6','','','','',1,0,0,3,10),('55951a5a-de84-a082-ea0c-660594267232','mail_demandeur_accompte_paye','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'envoyermailaction','demandeur','','','30c815be-d54e-a9a4-386d-648c6515e017','','','off',0,0,0,0,1),('5ab1fe7d-5d0d-48df-73c7-660594c94e16','mail_demandeur_subvention_payee','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'envoyermailaction','demandeur','','','130d3ba8-aec4-cc41-d27f-648c610fc6b0','','','off',0,0,0,0,1),('6cb008ca-35c4-4f55-b664-660594f6c902','vers_cloture_defavorable','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','dd99eb7e-9356-2db3-5ca9-644934736cf4','','75aaa364-fbbd-58ed-f97a-644934e784a5','','','','',1,0,0,3,10),('7171e267-2ede-63bb-93db-660594ffdb3c','vers_cloture_annule','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','dd99eb7e-9356-2db3-5ca9-644934736cf4','','8fee9c63-25d2-97c9-b228-6449343057b6','','','','',1,0,0,3,10),('7c4f754e-7b9d-7bf3-c262-6605949d262c','vers_retour_direction','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','e3e202bd-bada-69cd-fee4-6446412c5a63','Erreur sur le choix de la direction','3aaa91ab-d569-f58f-928e-644642bdf9ac','','','','',0,0,0,0,40),('80255cef-5e60-7adb-37b4-66059499aad0','mail_agent_retour_direction','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'envoyermailaction','autre','agent_mva_test@yopmail.com','','','','','off',0,0,0,0,1),('867297da-1d9f-9a48-3874-6605949ce518','vers_cloture_annule','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','dd99eb7e-9356-2db3-5ca9-644934736cf4','','8fee9c63-25d2-97c9-b228-6449343057b6','','','','',1,0,0,3,10),('93a51369-3867-4de0-0206-66059473abb4','vers_cloture_defavorable','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','dd99eb7e-9356-2db3-5ca9-644934736cf4','','75aaa364-fbbd-58ed-f97a-644934e784a5','','','','',1,0,0,3,10),('969ede3c-1711-113d-0baf-6605945c5122','mail_demandeur_dossier_avis_defavorable','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'envoyermailaction','demandeur','','','b287090c-e969-038b-4674-648c5ed38298','','','off',0,0,0,0,1),('a0e526e1-cb88-b8a1-c1a3-660594a955cf','vers_cloture_annule','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','dd99eb7e-9356-2db3-5ca9-644934736cf4','','8fee9c63-25d2-97c9-b228-6449343057b6','','','','',1,0,0,3,10),('a62beee2-c8af-3935-01d2-66059454fed1','vers_cloture_defavorable','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','dd99eb7e-9356-2db3-5ca9-644934736cf4','','75aaa364-fbbd-58ed-f97a-644934e784a5','','','','',1,0,0,3,10),('bac4260d-2596-6f32-ca5c-66059429fee3','mail_demandeur_dossier_incomplet','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'envoyermailaction','demandeur','','','4dc88a33-5fc6-ce73-66dc-648c586b9620','','','off',0,0,0,0,1),('c026c825-6f31-64e1-f38c-660594310a09','mail_agent_retour_direction','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,0,'envoyermailaction','autre','agent_mva_test@yopmail.com','','906d0743-40dd-4fba-f654-648c5c872d5d','','','off',0,0,0,0,1),('c546c607-df97-9865-f021-66059491ac5a','mail_demandeur_dossier_ineligible','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'envoyermailaction','demandeur','','','9ad2dea9-4c81-da49-19df-648c597e2a22','','','off',0,0,0,0,1),('c7d6c681-9537-9258-dece-6605943710f3','vers_cloture_ineligible','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','dd99eb7e-9356-2db3-5ca9-644934736cf4','','58527722-bba4-f1ef-8b93-644a35951123','','','','',1,0,0,3,10),('ccd7a3c4-b36d-9b73-6a68-660594225ad0','vers complet-instruction','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierstatutdossieraction','80f737c5-c163-9ca7-f333-64491cdebb3d','','946210cb-3c8a-2797-fe72-6526aa9ee7c0','','','','',0,0,0,0,40),('cf972ac7-be7e-cc33-ba29-6605949dab70','ajouter_directeur','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'ajoutercontactaction','','','eyJzYWx1dGF0aW9uIjoiQ2l2aWxpdFx1MDBlOSIsImxhc3RfbmFtZSI6Ik5vbSBkZSBmYW1pbGxlIiwibm9tX3VzYWdlIjoiTm9tIGQndXNhZ2UiLCJmaXJzdF9uYW1lIjoiUHJcdTAwZTlub20iLCJlbWFpbDEiOiJFLW1haWwiLCJwaG9uZV9tb2JpbGUiOiJUXHUwMGU5bC4gcG9ydGFibGUiLCJwaG9uZV9ob21lIjoiVFx1MDBlOWwuIGZ','','IlxuPE9QVElPTiB2YWx1ZT0nJz4tIGF1Y3VuIC08XC9PUFRJT04+XG48T1BUSU9OIHZhbHVlPSc0YzU0OGNhNC00Njk5LWE2ZDItMWI1Zi02NDQyOWQ1NWJiMzQnPkEgKHByXHUwMGU5Y2lzZXogbGUgbGlldSkgKGxpZXVfZGVjbGFyYXRpb25fcHJlZmVjdCk8XC9PUFRJT04+XG48T1BUSU9OIHZhbHVlPSc3MTI2YzQ2Mi0yMzE2LWVjMWE','first_name;d1022635-cae2-7a58-2ac1-643fe9c9b686|email1;3ee95f70-cfa1-9c6a-e5a5-643fea4f212d|phone_mobile;177689cd-4aad-af33-864b-645a436f6049|last_name;24ad2aa2-c0b7-0acc-7780-643fe94b9c6f','',0,0,0,0,30),('d25c2fc6-68b7-a02c-76ed-660594a19827','ajouter_president','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'ajoutercontactaction','','','eyJzYWx1dGF0aW9uIjoiQ2l2aWxpdFx1MDBlOSIsImxhc3RfbmFtZSI6Ik5vbSBkZSBmYW1pbGxlIiwibm9tX3VzYWdlIjoiTm9tIGQndXNhZ2UiLCJmaXJzdF9uYW1lIjoiUHJcdTAwZTlub20iLCJlbWFpbDEiOiJFLW1haWwiLCJwaG9uZV9tb2JpbGUiOiJUXHUwMGU5bC4gcG9ydGFibGUiLCJwaG9uZV9ob21lIjoiVFx1MDBlOWwuIGZ','','IlxuPE9QVElPTiB2YWx1ZT0nJz4tIGF1Y3VuIC08XC9PUFRJT04+XG48T1BUSU9OIHZhbHVlPSc0YzU0OGNhNC00Njk5LWE2ZDItMWI1Zi02NDQyOWQ1NWJiMzQnPkEgKHByXHUwMGU5Y2lzZXogbGUgbGlldSkgKGxpZXVfZGVjbGFyYXRpb25fcHJlZmVjdCk8XC9PUFRJT04+XG48T1BUSU9OIHZhbHVlPSc3MTI2YzQ2Mi0yMzE2LWVjMWE','email1;c8347358-9e86-5e9b-4679-644296d86650|first_name;f0e5e14a-f515-fcd6-c1a6-64429501dada|last_name;69fe0a1d-2ce7-8f0a-ebb8-64429493641d|phone_home;5fa1c3ab-fd3c-6763-21b2-644296e31778','',0,0,0,0,35),('d4edf430-a385-96d4-409e-66059428aa1b','mail_demandeur_dossier_complet','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'','demandeur','','','b1b9f4ab-c31d-dfce-828a-6489d6d1b08d','','','off',0,0,0,0,5),('d7a4d74f-c0d8-6b7a-878c-660594f0ad11','assignation','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'assignerdossierthematiqueaction','','','eyJhZmZhaXJlc19qdXJpZGlxdWVzIjoiQWZmYWlyZXMganVyaWRpcXVlcyIsImNvbW11bmljYXRpb24iOiJDb21tdW5pY2F0aW9uIiwiY3Vncl9zY29sYWlyZV9lbmZhbmNlIjoiQ1VHUiBTY29sYWlyZSBldCBQZXRpdGUgZW5mYW5jZSIsImN1Z3JfdGVycml0b2lyZXMiOiJDVUdSIFRlcnJpdG9pcmVzIiwiY3Vncl92b2lyaWVfZWNsYWl','','eyJDQ0FTIjp7IkZhYmllbm5lIEhVU1NPTiI6IjE1OGQ3Zjk5LWYzZWQtYTM4Mi02MGJmLTY0ODFlNGM2OTY5NiIsIkZsb3JlbmNlIFJFR05JRVJFIjoiMTk1MjQyNTYtN2Q2Yi04NDlkLTg0YjItNjQ4MWU0YWUyNjBkIn0sIkNvbW11bmljYXRpb24iOnsiRmFiaWVuIFJPWUVSIjoiZGIyZTUzODItM2I3MC1mZThkLWY1YWUtNjQ4MWU1NjI','eduction;24160be3-e971-f0f6-0fc4-645227a8051e|sports;48789230-98a0-4dd8-03f7-64522444dcf1','',0,0,0,0,10),('df051091-06a4-3b92-c864-660594c28be8','non_assigne','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'modifierchampdossieraction','b21d20ac-2cc7-51eb-6c38-643e4c80a213','non_assigne','','','','','',0,0,0,0,3),('e1a61c35-cdab-18b8-7598-6605945dbcb4','demandeur_arc','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'envoyermailaction','demandeur','','','c231b0c5-70d6-97cd-1c6c-6489d5052f07','','','off',0,0,0,0,1),('e45913c2-52dc-b173-0e33-660594a44464','agent_nouveau_dossier','2024-03-28 16:02:58','2024-03-28 16:02:58','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,NULL,1,'envoyermailaction','autre','agent_mva_test@yopmail.com','','6e98ab36-f23a-56d0-8c07-6489b1ad518a','','','off',0,0,0,0,2),('a74d3d6e-942f-69dc-fe01-66165c07e874','notif mail usager','2024-04-10 09:32:07','2024-04-10 09:32:07','1','1','',0,NULL,1,'envoyermailaction','demandeur','','','5bfe7606-5dcd-9122-540c-6223bca99933','','','off',0,0,0,0,20),('aa41a9ad-1803-074f-3a4f-6622397f6a9f','Recopie du champ','2024-04-19 09:29:07','2024-04-19 09:29:07','1','1','',0,NULL,1,'alimenterchampparunautreaction','champs_personnalises',NULL,'f0d16533-3aec-7591-13a5-6622345589ac','8d2ed71c-cdd8-960a-e6e2-6622354b2872',NULL,'[encoded data, 65535 characters]',NULL,0,0,0,0,10),('bf4ed4ae-5143-3544-b2b2-66223a38b108','Mail demandeur','2024-04-19 09:33:16','2024-04-19 09:33:16','1','1','',0,NULL,1,'envoyermailaction','demandeur','','','7d347330-1e2f-4824-33a9-66223a453f34','','','off',0,0,0,0,10),('50ad3a95-64b7-bd14-ff8b-663277bbc6e8','Réponse négative après entretien','2024-05-01 17:11:26','2024-05-02 19:11:42','1','1',NULL,0,'',1,'genererdocumentaction','afda0bc3-ebcc-caea-5a74-6633d08bea52','off',NULL,NULL,NULL,NULL,NULL,0,0,0,0,10),('636c583e-759d-41e4-7f99-663277be4bda','Lettre d\'embauche','2024-05-01 17:11:26','2024-05-02 19:13:06','1','1',NULL,0,'',1,'genererdocumentaction','57b6365f-3478-74aa-6787-6633cf914e8d','off',NULL,NULL,NULL,NULL,NULL,0,0,0,0,10),('97dea05e-5a3b-12ec-7102-66327718bb42','Notification entretien visio','2024-05-01 17:11:26','2024-05-02 19:46:15','48a63cd2-75e2-483c-a664-6633b7dbeeb6','1',NULL,0,'',1,'envoyermailaction','dossier','email',NULL,'4b456d93-6b53-2096-b3ee-6633d5a24622',NULL,NULL,'off',0,0,0,0,10),('9cc63274-f5b7-f689-9507-663277ee7cf4','Générer courrier entretien','2024-05-01 17:11:26','2024-05-03 07:23:16','1','1',NULL,0,'',1,'genererdocumentaction','92170b31-9bcd-fee8-5131-6633d3aa7b54','on',NULL,NULL,NULL,NULL,NULL,0,0,0,0,20),('ae357b5a-e693-e499-3f71-663277f105b0','Réponse négative avant entretien','2024-05-01 17:11:26','2024-05-02 17:57:03','1','1',NULL,0,'',1,'genererdocumentaction','efa7462d-561f-c2d4-fb47-6633d127fc26','off',NULL,NULL,NULL,NULL,NULL,0,0,0,0,10),('b899dabc-7d1c-f554-7c3a-663277472ee1','AR candidature reçue','2024-05-01 17:11:26','2024-05-03 08:33:54','1','1',NULL,0,'',1,'envoyermailaction','dossier','email',NULL,'60d12d6a-efdd-d3d7-1582-6634a1aa7d95',NULL,NULL,'off',0,0,0,0,1),('b3ace4af-d6d1-60d2-473b-6633961d0a41','Lettre négative (pas de besoin)','2024-05-02 13:33:06','2024-05-02 13:33:06','1','1',NULL,0,NULL,1,'genererdocumentaction','9a5c7a2b-9686-e5b1-82b3-64e5f768369a','off','','','','','',0,0,0,0,10),('e7714742-700c-e51f-be92-6633962ee1be','Lettre d\'embauche','2024-05-02 13:33:06','2024-05-02 13:33:06','1','1',NULL,0,NULL,1,'genererdocumentaction','28e3f365-0a56-5ae4-0516-64e5c7a24cfa','off','','','','','',0,0,0,0,10),('e8290e65-f148-9e9c-dbbe-66339628f338','Lettre négative (pas de besoin)','2024-05-02 13:33:06','2024-05-02 13:33:06','1','1',NULL,0,NULL,1,'genererdocumentaction','9a5c7a2b-9686-e5b1-82b3-64e5f768369a','off','','','','','',0,0,0,0,10),('182b6726-7c1c-210e-8b45-663396f1ff56','AR candidature reçue','2024-05-02 13:33:06','2024-05-02 13:33:06','1','1',NULL,0,NULL,1,'envoyermailaction','dossier','email','','aaa8b292-fd07-8da1-ae46-64e32830a976','','','off',0,0,0,0,1),('7a9c44d3-17b2-a657-178b-66348bdbffbd','rendre onglets du dossier non modifiables','2024-05-03 07:01:53','2024-05-03 07:01:53','1','1','',0,NULL,1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;9716d35b-9b2d-ef2d-b850-6632778c417c|onglet_crm;527f46ad-8c27-9379-7329-6632770bf31f,9b228862-3b50-25e1-cf39-663277126a2e,7f014407-af79-6a20-b96e-663277b1ac12,4d84a993-f52f-a0d3-34d9-663277b54fa2',NULL,0,0,0,0,10),('d579ab64-c4d0-2428-94d2-66348c48ddb7','rendre onglets du dossier non modifiables','2024-05-03 07:02:35','2024-05-03 07:02:35','1','1','',0,NULL,1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;9716d35b-9b2d-ef2d-b850-6632778c417c|onglet_crm;527f46ad-8c27-9379-7329-6632770bf31f,9b228862-3b50-25e1-cf39-663277126a2e,7f014407-af79-6a20-b96e-663277b1ac12,4d84a993-f52f-a0d3-34d9-663277b54fa2',NULL,0,0,0,0,10),('5ea7c4df-90ef-976c-a53e-66348c646656','rendre onglets du dossier non modifiables','2024-05-03 07:03:23','2024-05-03 07:03:23','1','1','',0,NULL,1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;9716d35b-9b2d-ef2d-b850-6632778c417c|onglet_crm;527f46ad-8c27-9379-7329-6632770bf31f,9b228862-3b50-25e1-cf39-663277126a2e,7f014407-af79-6a20-b96e-663277b1ac12,4d84a993-f52f-a0d3-34d9-663277b54fa2',NULL,0,0,0,0,10),('57952ba6-736b-b833-0e6b-66348cd2a2e6','rendre onglets du dossier non modifiables','2024-05-03 07:03:53','2024-05-03 07:03:53','1','1','',0,NULL,1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;9716d35b-9b2d-ef2d-b850-6632778c417c|onglet_crm;527f46ad-8c27-9379-7329-6632770bf31f,9b228862-3b50-25e1-cf39-663277126a2e,7f014407-af79-6a20-b96e-663277b1ac12,4d84a993-f52f-a0d3-34d9-663277b54fa2',NULL,0,0,0,0,10),('870ba45d-ec59-4e51-0422-66348ccd1d7f','rendre onglets du dossier non modifiables','2024-05-03 07:04:38','2024-05-03 07:04:38','1','1','',0,NULL,1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;9716d35b-9b2d-ef2d-b850-6632778c417c|onglet_crm;527f46ad-8c27-9379-7329-6632770bf31f,9b228862-3b50-25e1-cf39-663277126a2e,7f014407-af79-6a20-b96e-663277b1ac12,4d84a993-f52f-a0d3-34d9-663277b54fa2',NULL,0,0,0,0,10),('5291027e-71d3-26e7-7a7e-66348c2106c3','rendre onglets du dossier non modifiables','2024-05-03 07:05:15','2024-05-03 07:05:15','1','1','',0,NULL,1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;9716d35b-9b2d-ef2d-b850-6632778c417c|onglet_crm;527f46ad-8c27-9379-7329-6632770bf31f,9b228862-3b50-25e1-cf39-663277126a2e,7f014407-af79-6a20-b96e-663277b1ac12,4d84a993-f52f-a0d3-34d9-663277b54fa2',NULL,0,0,0,0,10),('86459e58-2a36-3c24-661e-66348cbd2730','rendre onglets du dossier non modifiables','2024-05-03 07:05:51','2024-05-03 07:05:51','1','1','',0,NULL,1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;9716d35b-9b2d-ef2d-b850-6632778c417c|onglet_crm;527f46ad-8c27-9379-7329-6632770bf31f,9b228862-3b50-25e1-cf39-663277126a2e,7f014407-af79-6a20-b96e-663277b1ac12,4d84a993-f52f-a0d3-34d9-663277b54fa2',NULL,0,0,0,0,10),('e9d89e66-8a6f-ecf5-c091-66348cf22377','rendre onglets du dossier non modifiables','2024-05-03 07:06:16','2024-05-03 07:06:16','1','1','',0,NULL,1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;9716d35b-9b2d-ef2d-b850-6632778c417c|onglet_crm;527f46ad-8c27-9379-7329-6632770bf31f,9b228862-3b50-25e1-cf39-663277126a2e,7f014407-af79-6a20-b96e-663277b1ac12,4d84a993-f52f-a0d3-34d9-663277b54fa2',NULL,0,0,0,0,20),('bc599848-c4cb-3bab-a54b-66348d4b9d40','préchargement dossier','2024-05-03 07:09:08','2024-05-03 07:09:08','1','1','',0,NULL,1,'modifierchampdossieraction','6eaf893a-d352-24d8-2bf8-66327f7ba9a8','2',NULL,NULL,NULL,NULL,NULL,0,0,0,0,2),('23bbcb20-7bac-47f1-4be6-66348d2af602','préchargement dossier','2024-05-03 07:09:32','2024-05-03 07:09:32','1','1','',0,NULL,1,'modifierchampdossieraction','6eaf893a-d352-24d8-2bf8-66327f7ba9a8','1',NULL,NULL,NULL,NULL,NULL,0,0,0,0,2),('b20380d6-6a3a-5497-f2cc-66348e83d257','préchargement dossier','2024-05-03 07:13:50','2024-05-03 07:13:50','1','1','',0,NULL,1,'modifierchampdossieraction','b2a7470f-02f4-4234-5f98-6632837c984c','2',NULL,NULL,NULL,NULL,NULL,0,0,0,0,2),('5701fb71-25a6-9cc3-4662-66348eacfed1','préchargement dossier','2024-05-03 07:14:15','2024-05-03 07:14:15','1','1','',0,NULL,1,'modifierchampdossieraction','b2a7470f-02f4-4234-5f98-6632837c984c','1',NULL,NULL,NULL,NULL,NULL,0,0,0,0,2),('da7da004-3331-0300-5f34-66348f38b1c9','préchargement dossier','2024-05-03 07:16:04','2024-05-03 07:16:04','1','1','',0,NULL,1,'modifierchampdossieraction','de7fbe60-7fdb-a24b-b81b-66328594ce81','oui',NULL,NULL,NULL,NULL,NULL,0,0,0,0,2),('f02439ae-07de-4136-8b07-66348f4f8f29','préchargement dossier','2024-05-03 07:16:34','2024-05-03 07:16:34','1','1','',0,NULL,1,'modifierchampdossieraction','de7fbe60-7fdb-a24b-b81b-66328594ce81','non',NULL,NULL,NULL,NULL,NULL,0,0,0,0,2),('d903e615-0a69-97e2-4604-6634a000bd00','rendre onglets du dossier non modifiables','2024-05-03 08:31:04','2024-05-03 08:31:04','1','1','',0,NULL,1,'rendrevisiblemodifiableongletaction','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOiJBY2N1ZWlsIERIQUIiLCIxNGNkZDdkYS0yNTlkLTU5MTgtMDQ2Zi02NDI5ODRiZDBhNWQiOiJBY2N1ZWlsIHBoeXNpcXVlIiwiNzk3NDIxYzQtYmI3NS0xODFjLWU2OWQtNjRlYjhkZDQ5MzkwIjoiQWNjdWVpbCBwaHlzaXF1ZSIsIjg0ZjY0ZjNhLTlhNDgtNTBlOC0','modif_onglet','eyJhMDBjZWRiOC02Yzk2LWEzMTAtNDhmYS02NDM5NTg3MThiNjUiOnsiYzJiYWIxZjUtZDE0OC1lYmZmLTA3NDgtNjQzOTU4NjljYjMxIjoiQ1JNIiwiYTI1OTNiM2ItZjUzNC03OWQyLWM3ZmMtNjQzOTU4NGEyNGFlIjoiSW50ZXJuZXQiLCJhYzdmN2ViNy05MDYxLThiMDMtYjkzOC02NTgxNTU2NmNmYzMiOiJQYXJ0ZW5haXJlIn0sIjE','eyJjMmJhYjFmNS1kMTQ4LWViZmYtMDc0OC02NDM5NTg2OWNiMzEiOnsiMmRkMTViZWMtMGNiMS04N2IzLWNjNGMtNjQzOTU4MjQ0MTkwIjoiRGVtYW5kZXVyIiwiY2EzYWFmMzctZmEzNS03MmJiLWI2YWMtNjQzOTU4MDU4MDZlIjoiRGVtYW5kZSIsImFlZjA3MzdhLWNmZTYtYzA4Yy0xOTFhLTY0Mzk1ODYyZWM2NCI6IlJcdTAwZTlwb25',NULL,'visible_crm;on|modifiable_crm;off|visible_internet;on|modifiable_internet;on|visible_partenaire;on|modifiable_partenaire;on|modele_dossier;9716d35b-9b2d-ef2d-b850-6632778c417c|onglet_crm;527f46ad-8c27-9379-7329-6632770bf31f,9b228862-3b50-25e1-cf39-663277126a2e,7f014407-af79-6a20-b96e-663277b1ac12,4d84a993-f52f-a0d3-34d9-663277b54fa2',NULL,0,0,0,0,10),('b199a9e8-eb02-9d5b-9499-6634a7287b45','assignation par direction','2024-05-03 08:57:56','2024-05-03 08:57:56','48a63cd2-75e2-483c-a664-6633b7dbeeb6','48a63cd2-75e2-483c-a664-6633b7dbeeb6','',0,NULL,1,'assignerdossierthematiqueaction',NULL,NULL,'eyJEQUQiOiJEaXJlY3Rpb24gZGVzIGFyY2hpdmVzIGRcdTAwZTlwYXJ0ZW1lbnRhbGVzIiwiREFUQSI6IkRpcmVjdGlvbiBkZSBsXHUyMDE5YW5pbWF0aW9uIHRlcnJpdG9yaWFsZSBldCBkZSBsXHUyMDE5YXR0cmFjdGl2aXRcdTAwZTkiLCJEREVDIjoiRGlyZWN0aW9uIGR1IGRcdTAwZTl2ZWxvcHBlbWVudCBcdTAwZTlkdWNhdGlmLCB',NULL,'eyJBY2N1ZWlsIERIQUIiOnsiYWNjdWVpbCBESEFCIjoiNmY4ZmYyZTAtYTFjOS03NzhmLTMzMmEtNjQzYWEwNGExNmQ3In0sIkFjY3VlaWwgUkMiOnsiQ2xhcmljZSBUeS10aW5lIjoiNjY5NDAxYTItOGE3OS1jOGQ4LThmYjEtNjRhNzFiZmU4MGQwIiwiSm9obnkgTWluYXRjaHkiOiI1MTVkZDczMy1hMTk5LTA4MGYtNTUxMi02NGE3MWR','DIRFI;d01e621f-8690-a0d5-bd81-6633a83b7451|DSI;5d5b0982-9209-6491-695d-6633a86d9292',NULL,0,0,0,0,1),('d890b0d5-d2a8-a4aa-229b-667160036b22','Generation convention','2024-06-18 10:25:59','2024-06-18 10:25:59','604ce6b2-0113-9588-7fa6-65f42e2efabe','604ce6b2-0113-9588-7fa6-65f42e2efabe','',0,NULL,1,'genererdocumentaction','918a20cf-0ca0-5c29-e45f-6227cbd306dd','on',NULL,NULL,NULL,NULL,NULL,0,0,0,0,1),('5007e90d-8710-0a3d-0c41-66e15c462527','Recopie tableau valo','2024-09-11 09:03:00','2024-09-11 09:03:00','1','1',NULL,0,NULL,1,'alimenterchampparunautreaction','champs_personnalises','','96e803b6-ab72-a987-794e-65f206211ef2','d7067e07-5a72-66ce-a6b7-65f2d3896946','','[encoded data, 65535 characters]','',0,0,0,0,10),