(18647,9385,'maladies_intercurrentes','KARDEGIC 75 mg, poudre pour solution buvable en sachet-dose','1 / jour',0),(18648,9386,'maladies_intercurrentes','Hexamedine ','2 btes',0),(18649,9386,'maladies_intercurrentes','One touch delica aiguille','2 btes ',0),(18650,9386,'maladies_intercurrentes','Ventoline 2 B en cas de besoin','',0),(18651,9386,'maladies_intercurrentes','Bandelette','2 btes',0),(18652,9386,'maladies_intercurrentes','MOPRAL 20 mg, gélule gastro-résistante','m et s  2 btes',0),(18653,9387,'affection_exonorante','Kinésiethérapie respiratoire ','',0),(18654,9387,'affection_exonorante','5 séances / semaine','',0),(18655,9387,'affection_exonorante','Au domicile de la patiente','',0),(18656,9388,'maladies_intercurrentes','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(18657,9388,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(18658,9389,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18659,9389,'maladies_intercurrentes','Chambre d\'inhalation','',0),(18660,9389,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(18661,9389,'maladies_intercurrentes','Amoxicilline 1 g X3/j','pdt 7 jrs ',0),(18662,9389,'maladies_intercurrentes','Ultralevure 2 gel m et s ','pdt 7 jrs',0),(18663,9390,'maladies_intercurrentes','NFS-Plaquettes','',0),(18664,9390,'maladies_intercurrentes','IgE totales ','',0),(18665,9390,'maladies_intercurrentes','CLA 30 aux pneumallergènes,aliments et Mixte','',0),(18666,9391,'maladies_intercurrentes','TDM thoracique sans injection','',0),(18667,9392,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s ','',0),(18668,9392,'maladies_intercurrentes','Chambre d\'inhalation','',0),(18669,9392,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(18670,9393,'maladies_intercurrentes','Laroscorbine 1 G le m ','',0),(18671,9393,'maladies_intercurrentes','Magnesium marin 2 cp le m ','',0),(18672,9393,'maladies_intercurrentes','Symbicort rapihaler  b m et s avec rinçage','',0),(18673,9394,'maladies_intercurrentes','Glycémie à jeun','',0),(18674,9394,'maladies_intercurrentes','HbAC1','',0),(18675,9394,'maladies_intercurrentes','Urée/creatinine','',0),(18676,9394,'maladies_intercurrentes','NFS-Plaquettes','',0),(18677,9394,'maladies_intercurrentes','ASAT/ALAT','',0),(18678,9395,'maladies_intercurrentes','TDM thoracique sans injection','',0),(18679,9396,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(18680,9396,'maladies_intercurrentes','Symbicort rapihaler  B m et s avec rinçage','',0),(18681,9396,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(18682,9397,'maladies_intercurrentes','Amoxicilline 1g X3/j pendat 7 jrs ','',0),(18683,9397,'maladies_intercurrentes','CARBOLEVURE ADULTES, gélule','1 gel m et s pdt 7 jrs',0),(18684,9397,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(18685,9397,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent','m et s pdt 5 jrs ',0),(18686,9397,'maladies_intercurrentes','KETODERM 2 %, gel en récipient unidose','2 btes',0),(18687,9398,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3/ semaine',0),(18691,9399,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(18692,9399,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rtinçage','',0),(18694,9400,'maladies_intercurrentes','Relvar 184/22 1 B/j','',0),(18695,9400,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(18696,9401,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18697,9401,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(18698,9402,'maladies_intercurrentes','MIFLONIL 400 microgrammes, poudre pour inhalation en gélule','1 gel inh m et s',0),(18699,9402,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1 gel inh m et s ',0),(18700,9403,'maladies_intercurrentes','ANTIBIO SYNALAR, solution pour instillation auriculaire','3 gtesX3/j   1 bte',0),(18701,9403,'maladies_intercurrentes','SYMBICORT TURBUHALER 400/12 microgrammes/dose, poudre pour inhalation','1 B m et s avec rinçage',0),(18702,9404,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine 2 btes',0),(18703,9405,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(18704,9405,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1/j',0),(18705,9405,'maladies_intercurrentes','Ventoline 2 B en cas de besoin','',0),(18706,9406,'maladies_intercurrentes','NAPROSYNE 500 mg, 2 comprimé/j','2 btes',0),(18707,9406,'maladies_intercurrentes','DOLIPRANE 1000 mg, comprimé','1 cxp en cas de besoin 3 btes',0),(18708,9406,'maladies_intercurrentes','DAKTARIN 2 POUR CENT, gel buccal','1 tube',0),(18709,9406,'maladies_intercurrentes','ECONAZOLE ARROW 1 %, crème','1 bte',0),(18717,9407,'maladies_intercurrentes','RINOCLENIL 100 microgrammes/dose, suspension pour pulvérisation nasale','1pulv ds chq narine m et s  2 btes',0),(18718,9408,'maladies_intercurrentes','Electrophorése des proteines','',0),(18719,9408,'maladies_intercurrentes','Facteurs anti nucléaires ','',0),(18720,9408,'maladies_intercurrentes','Facteur rhumatoide','',0),(18721,9408,'maladies_intercurrentes','Anti -SSA/anti -SSB','',0),(18722,9408,'maladies_intercurrentes','Anticorps antisynthétases','',0),(18723,9408,'maladies_intercurrentes','CPK','',0),(18724,9408,'maladies_intercurrentes','Calcémie','',0),(18725,9408,'maladies_intercurrentes','ANCA','',0),(18726,9408,'maladies_intercurrentes','Enzyme de conversion de l','',0),(18727,9408,'maladies_intercurrentes','Précipitines vis à vis antigènes aviaires (maladie des eleveurs d\'oiseaux).','',0),(18728,9409,'maladies_intercurrentes','Cholesterol total ; LDL;HDL','',0),(18729,9409,'maladies_intercurrentes','Bilirubinémie','',0),(18730,9409,'maladies_intercurrentes','ASAT/ALAT','',0),(18731,9410,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 amp en IM',0),(18732,9411,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','1 B m et s ',0),(18733,9411,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','2 B 20 miunutes avant l',0),(18734,9411,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer','1 cp le s ',0),(18735,9412,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 amp en IM',0),(18736,9412,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(18737,9412,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18738,9412,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(18739,9413,'maladies_intercurrentes','TDM des sinus','',0),(18740,9414,'maladies_intercurrentes','Location d\'un appareil d\'aérsolthérapie','',0),(18741,9414,'maladies_intercurrentes','Aerosolthjérapie BUDESONIDE 1g/2ml m et s avec rinçage','',0),(18742,9414,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','2 B m et s avec rinçage',0),(18743,9414,'maladies_intercurrentes','Si gène respiratoire 2 B SERTETIDE ','',0),(18744,9414,'maladies_intercurrentes','Chambre d\'inhalation','',0),(18745,9415,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 amp en IM ',0),(18746,9415,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18747,9415,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(18748,9415,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(18749,9415,'maladies_intercurrentes','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1 cp x3/semaine',0),(18750,9416,'maladies_intercurrentes','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(18751,9417,'maladies_intercurrentes','TDM thoracique sans injection','',0),(18752,9418,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(18753,9418,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18755,9419,'maladies_intercurrentes','TDM TAP thoraco-abdomino-pelvien sans injection','',0),(18756,9420,'maladies_intercurrentes','NFS-Plaquettes','',0),(18757,9420,'maladies_intercurrentes','Urée/creatinine','',0),(18758,9420,'maladies_intercurrentes','ASAT/ALAT','',0),(18759,9421,'maladies_intercurrentes','TDM des sinus','',0),(18760,9421,'maladies_intercurrentes','Radiographie thoracique','',0),(18761,9422,'maladies_intercurrentes','NFS-Plaquettes','',0),(18762,9422,'maladies_intercurrentes','IgE Totales','',0),(18763,9423,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(18764,9423,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','2 B m et s avec rinçage',0),(18765,9423,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(18766,9424,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(18767,9424,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1 X 3/j',0),(18768,5825,'affection_exonorante','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1 cp X 3 / semaine',0),(18769,9425,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine/j',0),(18770,9425,'maladies_intercurrentes','Josacined sirop 1250 m/j soit 500 mg m et s et 250 mg matin ','',0),(18771,9426,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','1 cp m et s',0),(18772,9426,'maladies_intercurrentes','Gaviscon 1 sachet X3/j','',0),(18773,9427,'maladies_intercurrentes','Test respiratoire à l\'Urée 13 C','',0),(18774,9427,'maladies_intercurrentes','Se procurer à la Pharmacie le procole HELIKIT','',0),(18775,9427,'maladies_intercurrentes','A arreter les antibiotiques par voie générale au minimum 4 semaines auparavant','',0),(18776,9427,'maladies_intercurrentes','Inhibiteurs de la pompe à protons à arreter 2 semaines auparavant Par ex : ESOMEPRAZOLE,INEXIUM,PARIET...','',0),(18777,9427,'maladies_intercurrentes','Antiacides à arreter 24:00 auparavant: Gelox,Maalox,Rocgel,Phosphalugel','',0),(18778,9427,'maladies_intercurrentes','Sujet au repos au minimum 6:00 auparavant( sans manger , ni boire,ni fumer).','',0),(18779,9428,'maladies_intercurrentes','MAXIDROL, pommade ophtalmique','2 applict/j   2 tubes',0),(18780,9429,'maladies_intercurrentes','TDM thoracique sans injection','',0),(18781,9430,'maladies_intercurrentes','VENTOLINE 100 microgrammes/dose, suspension pour inhalation en flacon pressurisé','2 B si besoin 3 btes ',0),(18782,9430,'maladies_intercurrentes','LASILIX 40 mg, comprimé sécable','1 cp /j  1 bte ',0),(18783,9431,'maladies_intercurrentes','AUGMENTIN 1 g/125 mg ADULTES, poudre pour suspension buvable en sachet-dose (Rapport amoxicilline/acide clavulanique : 8/1)','1g X3/j  pdt 7 jrs',0),(18784,9431,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','1gel m et s pdt 7 jrs',0),(18785,9431,'maladies_intercurrentes','LAROSCORBINE 1 g, comprimé effervescent','le m ',0),(18786,9431,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent','jusqu',0),(18787,9431,'maladies_intercurrentes','Boire 2L d','',0),(18788,9431,'maladies_intercurrentes','Rseter bien au chaud','',0),(18789,9432,'maladies_intercurrentes','Alginate de sodium/Bicarbonate de sodium suspension buvable  Mylan','2 btes',0),(18790,9433,'maladies_intercurrentes','Echographie abdominale','',0),(18791,9434,'maladies_intercurrentes','NFS - Plaquettes ','',0),(18792,9435,'maladies_intercurrentes','Radiographie thoracique','',0),(18793,9435,'maladies_intercurrentes','TDM des sinus','',0),(18794,9436,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT m et s ','1 mois de traitement',0),(18795,9436,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2ml m et savec rinçage','1 mois de traitement',0),(18796,9436,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18797,8205,'affection_exonorante','Aerosoltherapie Bicarbonate 14 p.mille ','3 X/ semain,e',0),(18798,9437,'maladies_intercurrentes','Diagnostic biologique de grosesse','',0),(18799,9438,'maladies_intercurrentes','Echographie abdomino pelvien','',0),(18800,9439,'maladies_intercurrentes','Aérosolthérapie Atrovent m et s ','',0),(18801,9439,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','',0),(18802,9439,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','m et s ',0),(18803,9439,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv /j le m ',0),(18804,9439,'maladies_intercurrentes','Location d\'un appariel d\'aérosolthérapie','',0),(18805,9441,'maladies_intercurrentes','LANSOYL FRAMBOISE, gel oral en pot','2 btes',0),(18806,9441,'maladies_intercurrentes','EXACYL 500 mg, comprimé pelliculé','2 cp X3/j soit 3 g /j 2btes',0),(18807,9441,'maladies_intercurrentes','DAFLON 500 mg, comprimé pelliculé','6 cp le m 2 btes',0),(18808,9442,'maladies_intercurrentes','Kinésiethérapie de la main droite et de la jambe droite ','Cf Courrier',0),(18809,9442,'maladies_intercurrentes','2 séances/ semaine pendant 2 mois','',0),(18810,9443,'maladies_intercurrentes','','',0),(18811,9444,'maladies_intercurrentes','Aérsolthérapie ATROVENT X2/j','',0),(18812,9444,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','',0),(18813,9444,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','',0),(18814,9444,'maladies_intercurrentes','Paroex gargarisme m et s ','pdt 15 jrs',0),(18815,9444,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(18816,9445,'maladies_intercurrentes','AMOXICILLINE ACIDE CLAVULANIQUE ALMUS 100 mg/12,5 mg par ml NOURRISSONS, poudre pour suspension buvable (rapport amoxicilline/acide clavulanique : 8/1)','2 dose à 100 mg X3/jsoit 600 mg/j',0),(18817,9445,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie nourisson + masque bucco facial nourisson ','',0),(18818,9445,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 0.5 mg/ 2 ml m et s ','',0),(18819,9445,'maladies_intercurrentes','Ventoline 100 micro g UG /dose X3/j','',0),(18821,9446,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 amp en IM',0),(18822,9109,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie + 1 masque bucco-facial','',0),(18824,9447,'maladies_intercurrentes','Innovair ','1 B à la demande',0),(18825,9447,'maladies_intercurrentes','SURBRONC EXPECTORANT AMBROXOL SANS SUCRE, solution buvable édulcorée à l\'acésulfame potassique et au sorbitol','1 cuil mesure m et s ',0),(18826,9448,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2pulv ds chq narine/j',0),(18827,9448,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','garegarisme m et s ',0),(18828,8771,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1 gel 20 minutes avant l',0),(18829,9449,'maladies_intercurrentes','Echographie des voies urinaires ','',0),(18830,9449,'maladies_intercurrentes','Radiographie thoracique','',0),(18831,9450,'maladies_intercurrentes','Examen cyto bacteriologique des urines ','',0),(18832,9450,'maladies_intercurrentes','Examen direct,culture,antibiogramme','',0),(18833,9451,'maladies_intercurrentes','TDM thoracique avec comparaison à celle du 6/08/2019.','',0),(18834,9452,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2pulv ds chq narine/j',0),(18835,9452,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s',0),(18837,9453,'maladies_intercurrentes','Radiographie thoracique','',0),(18838,9453,'maladies_intercurrentes','TDM des sinus','',0),(18839,9454,'maladies_intercurrentes','NFS -plaquettes','',0),(18840,9454,'maladies_intercurrentes','IgE Totales','',0),(18841,9455,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche',' gargarisme m et s pdt 15 jrs ',0),(18842,9455,'maladies_intercurrentes','KESTIN 10 mg, comprimé pelliculé','1 cp /j',0),(18843,8258,'affection_exonorante','Aérosolthérapie BUDESONIDE 1 mg/2 ml m et s avec rinçage','',0),(18844,9456,'maladies_intercurrentes','Aerosolthérapie 1 appareil avec un masque bucco facial/ ùmois ','',0),(18845,9457,'maladies_intercurrentes','','',0),(18846,6027,'maladies_intercurrentes','Phosphorus 9 ch','5g 3 X/j',0),(18847,6027,'maladies_intercurrentes','Causticum 9 ch','5 g 3X/j',0),(18848,9458,'maladies_intercurrentes','NFS-Plaquettes','',0),(18849,9458,'maladies_intercurrentes','IgE Totales','',0),(18850,9459,'maladies_intercurrentes','TDM des sinus','',0),(18851,9460,'maladies_intercurrentes','Aérosolthérapie ATROVENT X 3 /j','',0),(18852,185,'affection_exonorante','Zithromax 250 mg X3/semaine','',0),(18854,9461,'maladies_intercurrentes','Symbicort rapihaler 2 b m et s avec rinçage','',0),(18856,9461,'maladies_intercurrentes','','=',0),(18857,9462,'maladies_intercurrentes','Masque bucco facial pour aérosolthérapie 1 / mois','',0),(18858,9463,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS FRANCE 40 mg, comprimé gastro-résistant','m et s ',0),(18859,9463,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1 sachet X 3/j',0),(18860,9464,'maladies_intercurrentes','NFS-Plaquettes','',0),(18861,9464,'maladies_intercurrentes','VS/CRP','',0),(18862,9465,'maladies_intercurrentes','Efferalgan pédiatrique 12ml X4/j','si temperature',0),(18863,9466,'maladies_intercurrentes','Seretide 250 2 B m et s avec rinçage','',0),(18865,9466,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1 B 20 mn avant l',0),(18866,9467,'maladies_intercurrentes','Echographie abdominale','',0),(18867,9468,'maladies_intercurrentes','Seretide 250 2 B m et s avec rinçage','',0),(18868,9468,'maladies_intercurrentes','Chambre d\'inhalation','',0),(18869,6792,'maladies_intercurrentes','Augmentin 1 g X3/j pendant 7  jrs','',0),(18870,6792,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','m et s pdt 7 jrs',0),(18871,9469,'maladies_intercurrentes','Kinésiethérapie respiratoire technique de ventoilation dirigée ','2 séances / semaine',0),(18872,9470,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(18873,9470,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18874,9470,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine',0),(18875,9471,'maladies_intercurrentes',' Goutte épaisse','',0),(18876,9472,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(18877,9472,'maladies_intercurrentes','Amoxicilline 1 g X3/j ','7 jrs de traitement ',0),(18878,9473,'maladies_intercurrentes','ACTISOUFRE, solution pour pulvérisation nasale et buccale','m,midi et s pdt 1 mois ',0),(18879,9473,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s ','pdt 2 mois',0),(18880,9473,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','pdt 2 mois ',0),(18881,9473,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','2 mois de traitement',0),(18882,9301,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18884,9474,'maladies_intercurrentes','GYNERGENE CAFEINE, comprimé 1 mg ','maxi 2 cp/j',0),(18885,9475,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 B ds chq narine/j',0),(18886,9476,'maladies_intercurrentes','Gril costale droite','',0),(18887,9477,'maladies_intercurrentes','Nioflugel pde 3 applications/j','1 tube',0),(18888,9478,'maladies_intercurrentes','IRM -thoracique','',0),(18889,9479,'maladies_intercurrentes','TDM  thoracique sans injection','',0),(18890,9480,'maladies_intercurrentes','NFS-Plaquettes','',0),(18891,9480,'maladies_intercurrentes','IgE Totales','',0),(18892,9481,'maladies_intercurrentes','TDM thoracique sans injection','',0),(18893,9482,'maladies_intercurrentes','TDM thortacique sans injection','',0),(18894,9483,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(18895,9483,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18896,9484,'maladies_intercurrentes','TDM des sinus','',0),(18897,9484,'maladies_intercurrentes','Radiographie thoracique','',0),(18898,9485,'maladies_intercurrentes','NFS-Plaquettes','',0),(18899,9485,'maladies_intercurrentes','IgE Totales','',0),(18900,9486,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé B m et s avec rinçage','',0),(18901,9486,'maladies_intercurrentes','Chambre d\'inhalation','',0),(18902,9486,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(18903,9487,'maladies_intercurrentes','Ventoline 2 B en cas de besoin ','',0),(18904,9488,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','3 btes',0),(18905,9489,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18906,9436,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(18907,9436,'maladies_intercurrentes','Zitromax 250 mg X3/ semaine ','',0),(18908,9490,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(18909,9490,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j',0),(18910,7898,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(18911,9491,'maladies_intercurrentes','Amoxicilline 1 gf X3/j','pendant 7 jrs',0),(18912,9491,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','1 X 2 pendant 7 jours',0),(18913,9491,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18914,9491,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(18915,9492,'maladies_intercurrentes','PINAVERIUM ARROW 100 mg, comprimé pelliculé','1cp m et s  3 btes ',0),(18916,9492,'maladies_intercurrentes','Efferalganmed 500 effervescent 1 g X3/j','3 btes ',0),(18917,9492,'maladies_intercurrentes','Acerola 1000  2 btes ','',0),(18918,9493,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s ','avec rinçage',0),(18919,9493,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(18920,9494,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18921,9494,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(18922,9495,'maladies_intercurrentes','Traitement interne :  les 3 remèdes principaux sont :  - Borax 9 CH : Aphtes localisés sur la langue et la face interne des joues, très douloureusx et brûlants avec saignement facile.  - Mercurius solubilis 9 CH : salivation importante, mauvaise haleine. ','',0),(18923,9496,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18924,9496,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(18925,9496,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(18926,9497,'maladies_intercurrentes','Pas de lait ou laitage','',0),(18927,9497,'maladies_intercurrentes','Rien de cru tout cru ','',0),(18928,9497,'maladies_intercurrentes','Riz bien en eau ','',0),(18929,9497,'maladies_intercurrentes','Tiorfan enfant 1 sachet dose X3/j pendant 5 jrs','',0),(18930,9497,'maladies_intercurrentes','Smecta 1 sachet/j','',0),(18931,9497,'maladies_intercurrentes','Efferalgan pediatrique pour 14 kilos 1 graduation X 3 ou 4/j','',0),(18932,9497,'maladies_intercurrentes','Soupe à carottes ','',0),(18933,9498,'maladies_intercurrentes','Ventoline 2 B en cas  de gène respiratoire ','2 btes',0),(18934,9498,'maladies_intercurrentes','Vogalène 1 gel X2/j','2 btes ',0),(18935,9498,'maladies_intercurrentes','MONAZOL 2 POUR CENT, crème','2 btes ',0),(18936,9498,'maladies_intercurrentes','GYNO PEVARYL LP 150 mg, ovule à libération prolongée','1/j',0),(18937,9499,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie ','avec 1 kit/mois',0),(18938,9499,'maladies_intercurrentes','Aérosolthérapie BRICANYL - ATROVENT m et s ','arret du BRICANYL si tachycardie',0),(18939,9499,'maladies_intercurrentes','Aérosolthérapie de BUDESONIDE 1 mg/2 ml m et s avec rinçage','',0),(18940,9500,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(18941,9500,'maladies_intercurrentes','Gaviscon 1 sachet X3/j','',0),(18942,9500,'maladies_intercurrentes','Acerola 1000 2 cp le m ','',0),(18943,9500,'maladies_intercurrentes','EFFERALGAN 500 mg, comprimé 2 cp X3/j si fièvre','2 btezs ',0),(18944,9501,'maladies_intercurrentes','RULID 150 mg, comprimé enrobé','1cp m et s 15 mns av le repas pendant 7 jrs ',0),(18945,9501,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage ','',0),(18946,9501,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(18947,9502,'maladies_intercurrentes','NFS-Plaquettes','',0),(18948,9502,'maladies_intercurrentes','IgE Totales','',0),(18949,9503,'maladies_intercurrentes','Radiographie thoracique','',0),(18950,9504,'maladies_intercurrentes','Radiogrtaphie thoracique','',0),(18951,9504,'maladies_intercurrentes','Echodoppler des M.I.','',0),(18952,9505,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(18953,9505,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1 X3/j',0),(18954,9506,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un masque bucco facial','',0),(18955,9506,'maladies_intercurrentes','Aérosolthérapie BRICANYL -ATROVENT m et s ','',0),(18956,9506,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2 ml m et s avec rinçage','',0),(18960,9507,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(18961,9507,'maladies_intercurrentes','Symbicort rapihaler  B m et s avec rinçage','',0),(18963,9508,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','',0),(18964,9509,'maladies_intercurrentes','Radiographie thoracique','',0),(18965,9510,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie ','',0),(18966,9510,'maladies_intercurrentes','Aérsolthérapie atrovent m et s','',0),(18967,9510,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml ','m et s avec rinçage',0),(18968,9510,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18969,9511,'maladies_intercurrentes','DICETEL 50 mg, comprimé pelliculé','1 cp m et bs ',0),(18970,9511,'maladies_intercurrentes','Amoxicilline 1 g X3/j','',0),(18971,9511,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','m et s ',0),(18972,9511,'maladies_intercurrentes','Acerola 1000 1cp X2 /j','',0),(18973,9511,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','m et s ',0),(18974,9511,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s ','',0),(18975,9511,'maladies_intercurrentes','Chambre d\'inhalation','',0),(18976,9512,'maladies_intercurrentes','Seretide 250 m et s avec rinçage','',0),(18977,9512,'maladies_intercurrentes','Chambre d\'inhalation','',0),(18978,9513,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit','',0),(18979,9513,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X2/j','arret BRICANYLsi tachycardie',0),(18980,9513,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml ','m et s avec rinçage',0),(18981,9513,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18982,9513,'maladies_intercurrentes','Chambre d\'inhalation','',0),(18983,9514,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(18984,9514,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1 X3/j',0),(18985,9515,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(18986,9515,'maladies_intercurrentes','Chambre d\'inhalation','',0),(18987,9515,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(18988,9516,'maladies_intercurrentes','HEXOMEDINE 0,1 POUR CENT, gel pour application locale','',0),(18989,9516,'maladies_intercurrentes','HEXOMEDINE 1 POUR MILLE, solution pour application locale','lmaisser tremper 10 mns X3/j au minimum',0),(18990,9517,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1x3 / jr.  1 bte',0),(18991,9517,'maladies_intercurrentes','CARBOLEVURE ADULTES, gélule','1x 3jr.   2 btes',0),(18992,9517,'maladies_intercurrentes','Actapulgite ou spectacle ','1x3/ jr',0),(18993,9517,'maladies_intercurrentes','Coca cola 1 btelle','',0),(18994,8810,'maladies_intercurrentes','Sereride 250  B m et s avec rinçage','',0),(18995,9518,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j',0),(18996,9518,'maladies_intercurrentes','Paroex gargarisme m et s ','',0),(18997,9519,'maladies_intercurrentes','Seretide 250 2 b m et s avec rinçage','',0),(18998,9519,'maladies_intercurrentes','Chambre d\'inhalation','',0),(18999,9520,'maladies_intercurrentes','DIPROSONE 0,05 POUR CENT, crème','1 bte',0),(19000,9521,'maladies_intercurrentes','Radiographie thoracique','',0),(19001,9522,'maladies_intercurrentes','GRAZAX 75 000 SQ-T, lyophilisat oral','déposé sous la langue garder 1 minute ',0),(19002,9522,'maladies_intercurrentes','Na pas manger ni boire pendant 5 minutes.','',0),(19003,9522,'maladies_intercurrentes','Paroex gargarisme m et s pendant 15 jrs','',0),(19004,9523,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(19005,9523,'maladies_intercurrentes','Relvar 1 B /j','',0),(19006,9524,'maladies_intercurrentes','Amoxicilline 1 g X 2/j','14 jrs de traitement',0),(19007,9524,'maladies_intercurrentes','Clarithromycine 500 mg X2/j','14 jrs de traitement ',0),(19008,9524,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s pendant 3 mois ',0),(19009,4550,'affection_exonorante','BUDESONIDE ARROW 1 mg/2 ml, suspension pour inhalation par nébuliseur en récipient unidose','m et s ',0),(19010,4550,'affection_exonorante','Paroex gargarisme m et s ','1 mois de traitement',0),(19011,9525,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec 1 masque buccofacial','',0),(19012,9525,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2 ml m et s ','',0),(19013,9525,'maladies_intercurrentes','Aérosolthérapie ATROVENT X3/j','',0),(19014,9525,'maladies_intercurrentes','Augmentin 1g X3pdt 7 jrs','',0),(19015,9525,'maladies_intercurrentes','Ultralevure m et s pdt 7 jrs ','',0),(19016,9526,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','',0),(19017,9527,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s ','avec rinçage',0),(19019,9527,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19020,9528,'maladies_intercurrentes','SPIRIVA RESPIMAT 2,5 microgrammes/dose, solution pour inhalation','2 B consécutives ',0),(19021,9528,'maladies_intercurrentes','PULMICORT TURBUHALER 400 microgrammes/dose, poudre pour inhalation','1 B m et s avec rinçage',0),(19022,9529,'maladies_intercurrentes','TDM thoracique','',0),(19023,9530,'maladies_intercurrentes','HELICIDINE 10 POUR CENT SANS SUCRE, sirop édulcoré à la saccharine sodique et au maltitol liquide','2 btes ',0),(19024,9530,'maladies_intercurrentes','ALGINATE DE SODIUM / BICARBONATE DE SODIUM BIOGARAN 250 mg/133,5 mg pour 5 ml, suspension buvable en flacon','m ,midi et s  2 btes ',0),(19025,9531,'maladies_intercurrentes','ULTRAVIST 300 (300 mg d\'Iode/mL), solution injectable en seringue préremplie pour injecteur automatique','1 bte',0),(19026,9532,'maladies_intercurrentes','Creatinine','',0),(19027,9533,'maladies_intercurrentes','Amoxicilline 1 g X2/j','14 jrs de traitement',0),(19028,9533,'maladies_intercurrentes','Clarithromycine 500 mg X2/j','14 jrs de traitement',0),(19029,9533,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s pdt 1 mois',0),(19030,9534,'maladies_intercurrentes','SPAGULAX MUCILAGE PUR, granulés en sachet dose','1 sachet/j 1 bte',0),(19031,9534,'maladies_intercurrentes','Amoxicilline 1 g X3/j','2 btes',0),(19032,9534,'maladies_intercurrentes','DAFLON 500 mg, comprimé pelliculé 1 x3/j','2 btes',0),(19033,9534,'maladies_intercurrentes','ULTRAPROCT, suppositoire','1 suppo /j 2btes ',0),(19034,9534,'maladies_intercurrentes','Acerola 1000 ','2 btes ',0),(19035,9535,'maladies_intercurrentes','Location d\'aérosolthérapie avec kit et masque bucco nasal','',0),(19036,9535,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X 2/j','',0),(19037,9535,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','',0),(19038,9536,'maladies_intercurrentes','Amoxicilline 1 g X2/j pdt 14 jrs','',0),(19039,9536,'maladies_intercurrentes','CLARITHROMYCINE ABBOTT 500 mg, comprimé pelliculé','1 X 2/j pdt 14 jrs',0),(19040,9536,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s pdt 1 !mois ',0),(19041,9537,'maladies_intercurrentes','Radiographie thoracique','',0),(19042,9537,'maladies_intercurrentes','TDM  des sinus','',0),(19043,9538,'maladies_intercurrentes','Location d\'un appareil d\'aérosoltherapie ','',0),(19044,9538,'maladies_intercurrentes','Aerosolthérapie BUDESONIDE 1mg/ 2 ml m et s avec rinçage','',0),(19045,9538,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(19046,9538,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(19047,9539,'maladies_intercurrentes','Radiographie thoracique','',0),(19048,9540,'maladies_intercurrentes','Radiographie thoracique','',0),(19049,9541,'maladies_intercurrentes','Relvar ellipta 184/22 ug 1 B /j accompagné d\'une 2 è B si aggravation','',0),(19050,9542,'maladies_intercurrentes','TUSSIPAX, comprimé pelliculé','1 à 3/j 2 btes',0),(19051,9542,'maladies_intercurrentes','DESLORATADINE ACTAVIS 5 mg, comprimé pelliculé','1 cp/j 2 btes',0),(19052,9543,'maladies_intercurrentes','Relvar ellipta 184/22 ug   1 B /j avec rinçage','',0),(19053,9543,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19054,9544,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(19055,9544,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1 X3/j',0),(19056,9545,'maladies_intercurrentes','Ionogramme avec calcémie','',0),(19057,9546,'maladies_intercurrentes','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1 cp X/semaine ',0),(19058,9546,'maladies_intercurrentes','Spiolto 2 b consécutives','',0),(19059,9547,'maladies_intercurrentes','Aerosolthérapie bricanyl-atrovent X2/j ','arret du bricanyl si tachycardie',0),(19060,9547,'maladies_intercurrentes','Aerosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage ','',0),(19061,9547,'maladies_intercurrentes','Trelegy ellipta 1 B/j ','',0),(19062,9548,'maladies_intercurrentes','Aertosolthérapie BRICANYL / ATROVENT 0.5 mg ','m et s ',0),(19063,9549,'maladies_intercurrentes','Relvar 184/22 ùmicrogrammes  1 B/j','',0),(19064,9549,'maladies_intercurrentes','Foradil 1 dgel inh 20 minutes avant l\'effort','',0),(19065,9550,'maladies_intercurrentes','Ventoline 20 B en cas de besoin','2 btes',0),(19066,9551,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19067,9552,'maladies_intercurrentes','Relvar ellipta 184/22 microgrammes 1B/j rinçage','',0),(19068,9552,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19069,9553,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19070,9553,'maladies_intercurrentes','Relvar 1 B/j ','',0),(19071,9554,'maladies_intercurrentes','Laroscorbine 1 g/j ','',0),(19072,9554,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1 X2/j',0),(19073,9555,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19074,9555,'maladies_intercurrentes','Relvar 184/22 1 B/j','',0),(19075,9555,'maladies_intercurrentes','Surbronc sirop 1 cuil mesure m et s','',0),(19076,9557,'maladies_intercurrentes','IRM cérébral','',0),(19077,9558,'maladies_intercurrentes','Infusion de camomille,Tilleul,Melisse et vervene','',0),(19078,9559,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','',0),(19079,9560,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19080,9561,'maladies_intercurrentes','Radiographie thoracique','',0),(19081,9561,'maladies_intercurrentes','TDM des sinus','',0),(19082,9562,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s au coucher',0),(19083,9563,'maladies_intercurrentes','Radiographie thoracique','',0),(19084,9563,'maladies_intercurrentes','TDM des sinus','',0),(19085,9564,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer','',0),(19086,9565,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','1 gel m et s pdt 5 jrs ',0),(19087,9565,'maladies_intercurrentes','AUGMENTIN 1 g/125 mg ADULTES, poudre pour suspension buvable en sachet-dose (Rapport amoxicilline/acide clavulanique : 8/1)','X3/j pendant 5 jrs ',0),(19088,9565,'maladies_intercurrentes','SMECTA, poudre pour suspension buvable en sachet','1 sachet /j si diarrhée 1 bte',0),(19089,9565,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2ml m et s pendant 10 jrs ','',0),(19090,9565,'maladies_intercurrentes','Aérosolthérapie bricanyl X2/j arret si tachycardie ','10 jrs de traitement',0),(19091,9565,'maladies_intercurrentes','Location d\'un appareil d\'aé&rosolthérapie avec un kit et masque ','10 jrs de traitement',0),(19093,9566,'maladies_intercurrentes','Aérsolthérapie BUDESONIDE 1 mg/2ml m et s avec rinçage','3 mois de traitement',0),(19094,9566,'maladies_intercurrentes','Aérsolthérapie ATROVENT m et s ','3 mois de traitement',0),(19095,9566,'maladies_intercurrentes','Location d','3 mois de traitement',0),(19096,9566,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','3 mois de traitement',0),(19097,9566,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 mp en IM',0),(19098,9567,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','',0),(19099,9568,'maladies_intercurrentes','IRM lombaire pour recher che discopathie L4-L5.','',0),(19100,9569,'maladies_intercurrentes','Kinésiethérapie pour discopathie L4-L5','2 séances / semaine pendant 2 mois',0),(19101,9570,'maladies_intercurrentes','TDM thoracique','',0),(19102,9571,'maladies_intercurrentes','TITANOREINE, suppositoire 1 suppo après chq selle','3 btes',0),(19103,9571,'maladies_intercurrentes','ACEROLA 1000','3 BTES',0),(19104,9571,'maladies_intercurrentes','DIPROSONE 0,05 POUR CENT, crème','1 BTE',0),(19105,9571,'maladies_intercurrentes','SPAGULAX, poudre effervescente pour suspension buvable en sachet dose','2 BTES',0),(19106,9573,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent','1 cp X3/j 2 btes ',0),(19107,9573,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s  2 btes',0),(19108,9573,'maladies_intercurrentes','Amoxicilline 1 g X3/j pendant 7 jrs','',0),(19109,9573,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','1 gel m et s pendant 7 jrs',0),(19110,9574,'maladies_intercurrentes','TDM thoracique','',0),(19111,9575,'maladies_intercurrentes','Radiographie thoracique','',0),(19112,9575,'maladies_intercurrentes','TDM des sinus','',0),(19113,9576,'maladies_intercurrentes','Relvar 184/22 microgrammes 1 B/j','',0),(19114,9577,'maladies_intercurrentes','Relvar 1 B le m avec rinçage','',0),(19115,9578,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19116,9579,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','m et s',0),(19117,9579,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent','X2/j',0),(19118,9183,'maladies_intercurrentes','Relvar 1 B/j','',0),(19119,9580,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 injection',0),(19120,9581,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19121,9582,'maladies_intercurrentes','Relvar 184/22 1 B /j avec rinçage ','',0),(19122,9582,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s 2 btes',0),(19123,9583,'maladies_intercurrentes','Amoxicilline 1 GX3/j','',0),(19124,9583,'maladies_intercurrentes','RULID 150 mg, comprimé enrobé X2/j','15 mns av les repas',0),(19125,9584,'maladies_intercurrentes','Radiographie thoracique','',0),(19126,9585,'maladies_intercurrentes','NFS-Plaquettes','',0),(19127,9585,'maladies_intercurrentes','IgE totales','',0),(19128,9586,'maladies_intercurrentes','Radiographie thoracique','',0),(19129,9586,'maladies_intercurrentes','TDM des sinus','',0),(19130,9587,'maladies_intercurrentes','Relvar 184/22 microg 1 B/j ','',0),(19131,9588,'maladies_intercurrentes','Echographie rénale et des voies urinaires','',0),(19132,9589,'maladies_intercurrentes','ECBU compte de germes et antibiogramme éventuel','',0),(19133,9589,'maladies_intercurrentes','Albuminurie et microalbumlinurie','',0),(19135,9590,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19136,9591,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j avec rinçage','',0),(19137,9592,'maladies_intercurrentes','GDS à AA','',0),(19138,9593,'maladies_intercurrentes','Radiographie thoracique','',0),(19139,9594,'maladies_intercurrentes','Kinésiethérapîe respiratoire ','3 séances / semaine',0),(19140,9595,'maladies_intercurrentes','IPRATROPIUM MYLAN 0,5 mg/2 ml ADULTES, solution pour inhalation par nébuliseur en récipient unidose','m et s  ',0),(19141,9596,'maladies_intercurrentes','Radiographie pulmonaire','',0),(19142,9596,'maladies_intercurrentes','TDM des sinus','',0),(19143,9597,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit et masque buccofacial','',0),(19144,9597,'maladies_intercurrentes','Aerosolthérapie BUDESONIDE 1 mg/2ml ','m et s pendant 10 jrs ',0),(19145,9597,'maladies_intercurrentes','Relvar 184/22 microg 1 B /j','',0),(19146,9598,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','',0),(19148,9598,'maladies_intercurrentes','RELVAR 184/22 microg 1 B /j','',0),(19149,9598,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 X3/ semaine ',0),(19150,9599,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte ',0),(19151,9600,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','1 gel m et s ',0),(19152,9600,'maladies_intercurrentes','Gaviscvon 1 sachet X3/j','',0),(19153,9600,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19154,9600,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte ',0),(19155,9601,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','',0),(19156,9601,'maladies_intercurrentes','Injection IM par IDE','',0),(19157,9602,'maladies_intercurrentes','Radiographie thpracique','',0),(19158,9602,'maladies_intercurrentes','TDM des sinus','',0),(19159,9603,'maladies_intercurrentes','NFS-Plaquettes','',0),(19160,9603,'maladies_intercurrentes','IgE Totales','',0),(19161,9604,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B /j ','',0),(19162,9605,'maladies_intercurrentes','Relvar ellipta 1 B /j ','',0),(19163,9606,'maladies_intercurrentes','NFS - Plaquettes','',0),(19164,9606,'maladies_intercurrentes','IgE totales','',0),(19165,9607,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19166,9607,'maladies_intercurrentes','Zithromax 250 mg 1 cp X3/semaine ','',0),(19167,9608,'maladies_intercurrentes','Spiolto 2B consécutives','',0),(19168,9608,'maladies_intercurrentes','Relvar ellipta 1B /j','',0),(19169,9609,'maladies_intercurrentes','Radiographie thoracique','',0),(19170,9609,'maladies_intercurrentes','Voir gril costal droit','',0),(19171,9610,'maladies_intercurrentes','Spiolto 2 B/j','1 bte',0),(19172,9610,'maladies_intercurrentes','Relvar ellipta 1 B/j','1 bte',0),(19173,9611,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19174,8998,'maladies_intercurrentes','Singulair 5 mg 1 cp le s ','',0),(19175,8999,'maladies_intercurrentes','Singulair 5 mg le s ','',0),(19176,9612,'maladies_intercurrentes','Echographie thyroidienne ','',0),(19177,9613,'maladies_intercurrentes','LEVOTHYROX 75 microgrammes, comprimé sécable','1 cp/j',0),(19178,9613,'maladies_intercurrentes','APROVEL 75 mg, comprimé pelliculé','1 cp/j',0),(19179,9613,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','2 btes ',0),(19180,9613,'maladies_intercurrentes','DEXERYL, crème en tube','2 tubes',0),(19181,9613,'maladies_intercurrentes','EFFERALGAN 500 mg, comprimé effervescent sécable','2 btes',0),(19182,9613,'maladies_intercurrentes','NIFLUGEL 2,5 %, gel','1 tube',0),(19184,9614,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19186,9614,'maladies_intercurrentes','Aérosolt hérapie BUDESONIDE 1 mg/8 2ml m et s ','',0),(19187,9615,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec masque buccofacial','',0),(19188,9615,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2 ml m et s avec rinçage','',0),(19189,9615,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19190,9616,'maladies_intercurrentes','Kinésiethérapie respiratoire 2 séances/ semaine','technique de Ventilation dirigée',0),(19191,9617,'maladies_intercurrentes','Efferalgan 500, comprimé effervescent','1 cp en cas de besoin 2 btes',0),(19192,9617,'maladies_intercurrentes','SERETIDE DISKUS 500 microgrammes/50 microgrammes/dose, poudre pour inhalation en récipient unidose','m et s 1 bte',0),(19193,9617,'maladies_intercurrentes','SOLUPRED 20 mg, comprimé orodispersible','1cp X2 en cas de besoin 2 btes',1),(19195,9618,'maladies_intercurrentes','Relvar Ellipta 1 B/j','',0),(19196,9618,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19197,9619,'maladies_intercurrentes','TDM thoracique','',0),(19198,9620,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1B/j','',0),(19199,9621,'maladies_intercurrentes','NFS- Plaquettes','',0),(19200,9621,'maladies_intercurrentes','IgE totales','',0),(19201,9622,'maladies_intercurrentes','Radiographie thoracique','',0),(19202,9622,'maladies_intercurrentes','TDM des sinus','',0),(19203,9623,'maladies_intercurrentes','Relvar ellipta 1 b/j ','',0),(19204,9624,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19205,9624,'maladies_intercurrentes','Foradil 1 gel inh m et s ','',0),(19206,9625,'maladies_intercurrentes','ECBU Examen cyto bacteriologique des urines','',0),(19207,9626,'maladies_intercurrentes','Spiolto 2 B consécutives','2 mois de traitement',0),(19208,9626,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','2 mois de traitement',0),(19209,9626,'maladies_intercurrentes','OFLOCET 200 mg, comprimé pelliculé sécable','1 cp m et s pendant 7 jrs',0),(19210,9627,'maladies_intercurrentes','Relvar ellipta 184/22 microg :1 B/j','',0),(19211,9628,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19212,9629,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19213,9629,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19214,9630,'maladies_intercurrentes','ASPIRINE MERCK MEDICATION FAMILIALE 500 mg, comprimé à croquer','1 c X3/j 1 bte ',0),(19215,9631,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19216,9632,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','rinçage',0),(19217,9633,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec masque bucco facial','',0),(19218,9633,'maladies_intercurrentes','Aérosolthérapie de BUDESONIDE 1mg/2ml m et s avec rinçage','',0),(19219,9634,'maladies_intercurrentes','Amoxicilline 1 g X3/j pdt 7 jrs','',0),(19220,9634,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule m et s pdt 7 jrs','',0),(19221,9634,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','pdt 1 mois ',0),(19222,9635,'maladies_intercurrentes','TDM toracique sans injection','',0),(19223,9636,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/jr','',0),(19224,9636,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19225,9638,'maladies_intercurrentes','Location d\'un appareil d\'arosolthérapie avec masque bucco facial ','',0),(19226,9639,'maladies_intercurrentes','Echographie abdominale et surtout pancréatique','',0),(19231,9640,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19232,9640,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j ','',0),(19233,9640,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3 / semaine',0),(19234,9641,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19235,9642,'maladies_intercurrentes','Glycémie à jeun','',0),(19236,9643,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie + 1 masque buccofacial','10 jrs de traitement',0),(19237,9643,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT ','10 jrs de traitement',0),(19238,9643,'maladies_intercurrentes','Arret BRICANYL si tachycardie','',0),(19239,9643,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','10 jrs de traitement',0),(19240,9643,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19241,9644,'maladies_intercurrentes','NFS-Plaquettes','',0),(19242,9644,'maladies_intercurrentes','IgE totales','',0),(19243,9645,'maladies_intercurrentes','Radiographie thoracique','',0),(19244,9645,'maladies_intercurrentes','TDM des sinus','',0),(19245,9646,'maladies_intercurrentes','.relvar ellipta 184/22 microg 1 B/j','',0),(19246,9646,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','à prendre 20 mns avant l\'effort',0),(19247,9647,'maladies_intercurrentes','Radiographie thoracique','',0),(19248,9647,'maladies_intercurrentes','TDM des sinus','',0),(19249,9648,'maladies_intercurrentes','NFS-Plaquettes','',0),(19250,9648,'maladies_intercurrentes','IgE Totales','',0),(19251,9649,'maladies_intercurrentes','Relvar 92/22 microg 1 B /j','',0),(19252,9649,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer le s ','',0),(19253,9650,'maladies_intercurrentes','AMLODIPINE ACTAVIS 5 mg, gélule','',0),(19254,9650,'maladies_intercurrentes','PERINDOPRIL ACTAVIS 4 mg, comprimé sécable','',0),(19255,9651,'maladies_intercurrentes','TDM thoracique','',0),(19256,9652,'maladies_intercurrentes','Ultibro 1 gel inhalée/j','',0),(19257,9653,'maladies_intercurrentes','TDM thoracique','',0),(19258,9654,'maladies_intercurrentes','AUGMENTIN 1 g/125 mg ADULTES, poudre pour suspension buvable en sachet-dose (Rapport amoxicilline/acide clavulanique : 8/1)','1 g X3 pendant 15 jrs ',0),(19259,9654,'maladies_intercurrentes','Rulid 150 mg m et s soit 50 mg X3 m et s ','',0),(19260,9654,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','1 gel X2/j',0),(19261,9654,'maladies_intercurrentes','Vitamine C  1 g le m','',0),(19262,9655,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(19263,9655,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1 X3/j',0),(19264,9656,'maladies_intercurrentes','Radiographie thoracique','',0),(19265,9657,'maladies_intercurrentes','Relvar ellipta 1 B/j ','',0),(19266,9657,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19267,9657,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','m et s pdt 15 jrs',0),(19268,8726,'maladies_intercurrentes','Vaccin antigrippal','1 bte',0),(19269,9658,'maladies_intercurrentes','Vaccin antigrippal ','',0),(19270,9658,'maladies_intercurrentes','IDE en IM','',0),(19271,9659,'maladies_intercurrentes','TDM thoracique et des sinus','',0),(19272,9660,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie + 1 kit avec masque bucco facial','15 jrs de traitement',0),(19273,9660,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X 2/j','',0),(19274,9660,'maladies_intercurrentes','Arret BRICANYL si tachycardie','',0),(19275,9660,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','',0),(19276,9660,'maladies_intercurrentes','Relvar 184/22 microg 1 B/j avec rinçage','2 mois de traitement',0),(19277,9661,'maladies_intercurrentes','Relvar 1 B/j avec rinçage','',0),(19278,9662,'maladies_intercurrentes','Relvar ellipta 184/22 microg  1 B /j','',0),(19279,9662,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19280,9663,'maladies_intercurrentes','Relvar 184/22 microg 1 B/j avec rinçage','2 btes',0),(19282,9664,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X2/j','',0),(19283,9664,'maladies_intercurrentes','Arret BRICANYL si tachycardie','',0),(19284,9664,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2ml m et s avec rinçage','',0),(19285,9664,'maladies_intercurrentes','Relvar ellipta 1 B /j avec rinçage','',0),(19286,9665,'maladies_intercurrentes','Relvar ellipta 184/22 microg  1 B/j','',0),(19287,9665,'maladies_intercurrentes','Ultibro 1 gel inh','',0),(19288,9666,'maladies_intercurrentes','Amylasémie','',0),(19289,9666,'maladies_intercurrentes','CRP','',0),(19290,9667,'maladies_intercurrentes','VENTOLINE 100 microgrammes/dose, suspension pour inhalation en flacon pressurisé','1bte',0),(19291,9667,'maladies_intercurrentes','Acerola ','3 btes ',0),(19292,9667,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent','2 btes',0),(19293,9667,'maladies_intercurrentes','DAFLON 500 mg, comprimé pelliculé','3 btes',1),(19294,9667,'maladies_intercurrentes','Titanoreine suppo','2 btes ',0),(19295,9667,'maladies_intercurrentes','SPAGULAX, poudre effervescente pour suspension buvable en sachet dose','2 btes ',0),(19296,9667,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s ','1bte',0),(19298,6970,'maladies_intercurrentes','BUDESONIDE ARROW 0,5 mg/2 ml, suspension pour inhalation par nébuliseur en récipient unidose','m et s avec rinçage ',0),(19299,6970,'maladies_intercurrentes','ACTISOUFRE, solution pour pulvérisation nasale et buccale','m,midi et s ',0),(19300,9668,'maladies_intercurrentes','TDM des sinus','',0),(19301,9668,'maladies_intercurrentes','Radiogrphie thoracique','',0),(19302,9669,'maladies_intercurrentes','NFS-Plaquettes','',0),(19303,9669,'maladies_intercurrentes','IgE Totales','',0),(19304,9670,'maladies_intercurrentes','SERETIDE 125 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','m eyt s avec rinçage',0),(19305,9670,'maladies_intercurrentes','SINGULAIR 4 mg, comprimé à croquer','le s au coucher',0),(19306,9670,'maladies_intercurrentes','Chambre d\'inhalation','',0),(19307,9672,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19308,9672,'maladies_intercurrentes','Relvar ellipta 1 B/j avec rinçage','',0),(19309,9673,'maladies_intercurrentes','IRM cérébral','',0),(19310,9673,'maladies_intercurrentes','TDM des sinus','',0),(19311,9674,'maladies_intercurrentes','RULID 150 mg, comprimé enrobé','1 cp m et s ',0),(19312,9674,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie + 1 masque bucco nasal','',0),(19313,9674,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2 ml m et s avec rinçage','',0),(19314,9674,'maladies_intercurrentes','ACTISOUFRE, solution pour pulvérisation nasale et buccale','m , midi et s ',0),(19315,9675,'maladies_intercurrentes','Efferalgan effervescent 1gX3/j','',0),(19316,9675,'maladies_intercurrentes','Amoxicilline 10 g X3/jour','',0),(19317,9675,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19318,9675,'maladies_intercurrentes','Laroscorbine 1 g/j','',0),(19319,9676,'maladies_intercurrentes','Echographie thyroidienne','',0),(19320,9678,'maladies_intercurrentes','Augmentin 1 g X3/j','',0),(19321,9678,'maladies_intercurrentes','RULID 150 mg, comprimé enrobé','1 cp m et s pdt 10jrs',0),(19322,9678,'maladies_intercurrentes','ULTRA-LEVURE 100 mg, poudre pour suspension buvable en sachet','m et s pdt 10 jrs ',0),(19323,9678,'maladies_intercurrentes','Paroex gargarisme m et s ','pdt 10jrs',0),(19325,9679,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19326,9679,'maladies_intercurrentes','Relvar 184/22 microg 1 B /j','',0),(19327,9680,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','',0),(19328,9680,'maladies_intercurrentes','Du 26/07/2019 au 22/10/2019','',0),(19329,9681,'maladies_intercurrentes','Relvar ellipte 1 B/j','',0),(19330,9681,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19331,8031,'affection_exonorante','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv /j 2 btes',0),(19332,8031,'affection_exonorante','EFFERALGAN 500 mg, comprimé','2 btes',0),(19333,9682,'maladies_intercurrentes','Radiographie thoracique','',0),(19334,9683,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19335,9684,'maladies_intercurrentes','Examen cyto bacteriologique des crachats','',0),(19336,9684,'maladies_intercurrentes','Examen direct,culture,antibiogramme','',0),(19337,9685,'maladies_intercurrentes','Augmentin 1 g x3/j pendant 7 jrs','',0),(19338,9685,'maladies_intercurrentes','RULID 150 mg, comprimé enrobé','1 cp m et s 15 mns av le repas pdt 7 jrs',0),(19339,9685,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule1 gel /jpdt 7 jrs ','',0),(19340,9685,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie + 1 masque bucco facial pendant 10 jrs','',0),(19341,9685,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2 ml m et s pdt 10 jrs ','',0),(19342,9685,'maladies_intercurrentes','LAROSCORBINE 1 g, comprimé effervescent le m  1 bte ','',0),(19343,9686,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1 gel inh m et s ',0),(19344,9687,'maladies_intercurrentes','Esomeprazole 40 mg m et s ','',0),(19345,9687,'maladies_intercurrentes','Amoxicilline 1 g X3/j ','',0),(19346,9687,'maladies_intercurrentes','CLARITHROMYCINE ABBOTT 500 mg, comprimé pelliculé','X2/j',0),(19347,9687,'maladies_intercurrentes','FLAGYL 500 mg, comprimé pelliculé X3/j','',0),(19348,9688,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(19349,9688,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1 X3/j',0),(19350,9689,'maladies_intercurrentes','Relvar ellipta 1 B/j avec rinçage','',0),(19351,9689,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19352,9690,'maladies_intercurrentes','Relvar ellipta 1 B/ j avec rinçage','',0),(19353,9690,'maladies_intercurrentes','Spiolto 2 B consécutives.','',0),(19354,9691,'maladies_intercurrentes','Relvar ellipta 92/22 microg 1 B/j ','avec rinçage',0),(19355,9692,'maladies_intercurrentes','Radiographie thoracique','',0),(19356,9692,'maladies_intercurrentes','TDM des sinus','',0),(19357,9693,'maladies_intercurrentes','Relvar ellipta 1 B/j avec rinçage','',0),(19358,9693,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19359,9695,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j ','',0),(19360,5779,'affection_exonorante','Spiolto 2 B consécutives','',0),(19361,5779,'affection_exonorante','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(19362,9696,'maladies_intercurrentes','Radiographie thoracique','',0),(19363,9697,'maladies_intercurrentes','Relvar ellipta 1 B/j avec rinçage','',0),(19364,9697,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(19365,9697,'maladies_intercurrentes','AERIUS 5 mg, comprimé pelliculé','1 cp le s ',0),(19366,8683,'affection_exonorante','Spiolto 2 B consécutives ','',0),(19367,8683,'affection_exonorante','ZITHROMAX 250 mg, comprimé pelliculé 1 cp X3/semaine','',0),(19368,8683,'affection_exonorante','BRONCHOKOD ADULTES, sirop jusqu\'à 4 prises /j','pdt 15 jrs',0),(19369,8683,'affection_exonorante','Niflugel pde 2 applications/j 3 btes','',0),(19370,9698,'maladies_intercurrentes','AMOXICILLINE BIOGARAN 125 mg/5 ml, poudre pour suspension buvable en flacon','250 mg m , midi et soir soit 750 mg/j pendant 5 jrs.',0),(19371,9698,'maladies_intercurrentes','Aerosoltherapie BUDESONIDE 0.5 mg m et s ','',0),(19372,9698,'maladies_intercurrentes','SERETIDE 125 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','m et s avec rinçage 2 B m et s ',0),(19373,9698,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(19374,9698,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie ','pdt 15 jrs',0),(19375,9699,'maladies_intercurrentes','Radiographie thoracique','',0),(19376,9699,'maladies_intercurrentes','TDM des sinus','',0),(19377,9701,'maladies_intercurrentes','Radiographie thoracique','',0),(19378,9702,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19379,9702,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19380,9703,'maladies_intercurrentes','Augmentin 1 g X3/j pendant 7 jrs ','',0),(19381,9703,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule 1 X2 pendant 7 jrs ','',0),(19382,9703,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X2/j ','',0),(19383,9703,'maladies_intercurrentes','Arret du BRICANYL si tachycardie et ATROVENT si dyspiurie','',0),(19384,9703,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie pedant 1 mois avec masque','',0),(19385,9704,'maladies_intercurrentes','TDM thoracique','',0),(19386,9705,'maladies_intercurrentes','GDS à AA','',0),(19387,9707,'maladies_intercurrentes','ACICLOVIR ARROW 5 %, crème','2 tubes ',0),(19388,9708,'maladies_intercurrentes','ACICLOVIR ARROW 5 %, crème','1 tube',0),(19389,9709,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19392,9710,'maladies_intercurrentes','TDM des sinus','',0),(19393,9711,'maladies_intercurrentes','Innovair 2 B m et s avec rinçage','3 mois de traitement',0),(19394,9711,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s pdt 15 jrs',0),(19396,9712,'maladies_intercurrentes','Scanner TAP thoraco-abdomino-pelvien sans injection','',0),(19397,9713,'maladies_intercurrentes','ULTRAVIST 300 (300 mg d','1 flacon de 100 ml en seringue pré remplie ',0),(19400,9714,'affection_exonorante','ULTRAVIST 300 (300 mg d\'Iode/mL), solution injectable en seringue préremplie pour injecteur automatique','',0),(19401,9715,'affection_exonorante','Créatinémie','',0),(19402,9716,'affection_exonorante','Réeducation des 4 membres en balnéothérapie','',0),(19403,9717,'maladies_intercurrentes','IRM pelvienne','',0),(19405,9718,'maladies_intercurrentes','PSA Total','',0),(19406,9719,'maladies_intercurrentes','Radiographie thoracique','',0),(19407,9719,'maladies_intercurrentes','TDM des sinus','',0),(19408,9604,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s pdt 15 jrs',0),(19410,9720,'maladies_intercurrentes','TDM des sinus','',0),(19411,9720,'maladies_intercurrentes','Radiographie thoracique','',0),(19412,9721,'maladies_intercurrentes','NFS - Plaquettes','',0),(19413,9721,'maladies_intercurrentes','IgE Totales','',0),(19414,9722,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer','le s ',0),(19415,9722,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','2 B m et s avec rinçage',0),(19416,9722,'maladies_intercurrentes','Chambre d\'inhalation','',0),(19417,9723,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage ','',0),(19418,9723,'maladies_intercurrentes','Location d\'un app d\'aérosolthérapie + 1 masque / mois','',0),(19419,9723,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19420,9723,'maladies_intercurrentes','Relvar 184/ 22 microg 1 B/j','',0),(19421,9725,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19422,9726,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s  2 btes ',0),(19423,9727,'maladies_intercurrentes','APROVEL 150 mg, comprimé pelliculé','1cp/j',0),(19424,9728,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit et masque buccofacial','15 jrs de traitement',0),(19425,9728,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2 ml m et s avec rinçage','15 jrs de traitement',0),(19426,9728,'maladies_intercurrentes','Aérosolthérapie ATROVENT m et s ','15 jrs de traitement',0),(19427,9728,'maladies_intercurrentes','RELVAR 184/22 microg 1 B/j avec rinçage','1 mois de traitement',0),(19428,9728,'maladies_intercurrentes','Augmentin 1 g X3/j pdt 7 jrs','',0),(19429,9728,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule m et spdt 7 jrs','',0),(19430,9729,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19432,9730,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit et masque bucco facial','',0),(19433,9731,'maladies_intercurrentes','Acerola 1000 1 cp le m ','2 btes',0),(19434,9732,'maladies_intercurrentes','OMEPRAZOLE ACTAVIS 20 mg, gélule gastro-résistante','2 cp m et s ',0),(19435,9733,'maladies_intercurrentes','DETURGYLONE, poudre et solvant pour solution pour pulvérisation nasale','1 bte',0),(19436,9734,'maladies_intercurrentes','Spiolto 2  consécutives','',0),(19437,9735,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19438,9735,'maladies_intercurrentes','Relvar 184/22 microg  B /j','',0),(19439,9736,'maladies_intercurrentes','Symbicort rapihaler  B m et s avec rinçage ','',0),(19440,9737,'maladies_intercurrentes','IRM de la colonne lombaire','',0),(19441,9738,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j avec rinçage','',0),(19442,9738,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19443,9738,'maladies_intercurrentes','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(19444,9739,'maladies_intercurrentes','AMOXICILLINE ALMUS 1 g, comprimé pelliculé dispersible','1 g X3/j 3 btes',0),(19445,9739,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent','1 g X3/j 3 btes ',0),(19446,9739,'maladies_intercurrentes','EFFERALGAN 500 mg, comprimé effervescent sécable','2 btes',0),(19447,9740,'maladies_intercurrentes','Aétrosolthérapie BRICANYL-ATROVENT X2/j','',0),(19448,7529,'affection_exonorante','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 bte',0),(19449,7529,'affection_exonorante','Augmentin 1 g x3/j pdt 5 jrs','',0),(19450,7529,'affection_exonorante','ULTRALEVURE 200 mg, gélule m et s pdt 5 jrs','',0),(19451,9742,'affection_exonorante','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 amp en IM ',0),(19452,9743,'maladies_intercurrentes','Colchicine 1 mg soit 1 cp puis 1 H plus tard 0.5 mg soit 1/2 cp ','le 1er jour',0),(19453,9743,'maladies_intercurrentes','COLCHICINE OPOCALCIUM 1 mg, comprimé sécable','1 cp /j  2 btes ',0),(19454,9743,'maladies_intercurrentes','Si diarrhée SMECTA jusqu','',0),(19455,9743,'maladies_intercurrentes','Charbon du Dr Belloc 1 cp X2/j','',0),(19456,9744,'maladies_intercurrentes','Glycémie à jeun','',0),(19457,9744,'maladies_intercurrentes','Hemoglobine glyqué','',0),(19458,9744,'maladies_intercurrentes','Ac urique','',0),(19459,9744,'maladies_intercurrentes','Cholestérol Total,HDL,LDL','',0),(19460,9745,'maladies_intercurrentes','AZITHROMYCINE BIOGARAN 250 mg, comprimé pelliculé','pdt 2 mois ',0),(19461,9745,'maladies_intercurrentes','Si diarrhee prendre charbon du Dr Belloc 1 cpX2/j','',0),(19463,9746,'maladies_intercurrentes','IRM cerebral','',0),(19464,9746,'maladies_intercurrentes','TDM TAP thoraco-abdomino-pelvien','',0),(19465,9747,'maladies_intercurrentes','Radiographie thoracique','',0),(19466,9747,'maladies_intercurrentes','TDM des sinus','',0),(19467,9748,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine/j',0),(19468,9748,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s',0),(19469,9749,'maladies_intercurrentes','Radiographie thoracique','',0),(19470,9750,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19471,9750,'maladies_intercurrentes','Relvar ellipta 1 B /j','',0),(19472,9750,'maladies_intercurrentes','Aérosoltherapie BUDESONIDE 1g/2ml m et s avec rinçage','',0),(19473,9751,'maladies_intercurrentes','Survie globale par TAGRISSO','',0),(19474,9752,'maladies_intercurrentes','SPAGULAX MUCILAGE PUR, granulés en sachet dose','1 sachet/j',0),(19475,9753,'maladies_intercurrentes','TDM thoracique','',0),(19476,9754,'maladies_intercurrentes','Trelegy ellipta 1 inhalation/j','',0),(19477,9755,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(19478,9755,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet 1 X3/j','',0),(19479,9756,'maladies_intercurrentes','Radiographie thoracique','',0),(19480,9756,'maladies_intercurrentes','TDM des sinus','',0),(19481,9757,'maladies_intercurrentes','NFS -Plaquettes','',0),(19482,9757,'maladies_intercurrentes','IgE Totales','',0),(19483,9758,'maladies_intercurrentes','Radiographie thoracique','',0),(19484,9758,'maladies_intercurrentes','TDM des sinus','',0),(19485,9759,'maladies_intercurrentes','Relvar 184/22 microg 1 B /j','',0),(19486,9760,'affection_exonorante','Location d\'un appareil d\'arosolthérapie avec kit et masque buccofacial','',0),(19487,9760,'affection_exonorante','Aerosolthérapie (BRICANYL-ATROVENT) X2/j ','',0),(19488,9760,'affection_exonorante','Aérosolthérapie BUDESONIDE 1 mg/2 ml m et s avezc rinçage','',0),(19489,9761,'maladies_intercurrentes','Relvar 184/22 microg 1 B/j','',0),(19490,9761,'maladies_intercurrentes','Foradil 1 gel inh m et s si effort et gène respiratoire','',0),(19491,9762,'maladies_intercurrentes','Aérosolthérapie BRI CANYL-ATROVENT m et s ','',0),(19492,9762,'maladies_intercurrentes','Aérsolthérapie BUDESONIDE 1 mg/2 ml m et s avec rinçage','',0),(19493,9763,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1bte',0),(19494,9764,'maladies_intercurrentes','Relvar 184/22 microg 1 B/j','',0),(19495,9765,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine',0),(19496,9765,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19497,9766,'maladies_intercurrentes','T DM thoracique','',0),(19498,9767,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit et masque buccofacial','',0),(19499,9691,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer le s ','',0),(19500,9591,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19501,9591,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j',0),(19502,9768,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s 3 btes',0),(19503,9768,'maladies_intercurrentes','SPAGULAX, poudre effervescente pour suspension buvable en sachet dose','2 btes',0),(19504,9769,'maladies_intercurrentes','Aérosolthérapie BRICANYL -ATROVENT X2/j','',0),(19505,9769,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','',0),(19506,9769,'maladies_intercurrentes','SYMBICORT TURBUHALER 400/12 microgrammes/dose, poudre pour inhalation','m et s avec rinçage',0),(19507,9769,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé ','1 cp X3/semaine ',0),(19508,9770,'maladies_intercurrentes','TDM thoracique','',0),(19509,9771,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19510,9771,'maladies_intercurrentes','PYRALVEX, solution buccale et gingivale','1 bte',0),(19511,9772,'maladies_intercurrentes','Radiographie thoracique','',0),(19512,9772,'maladies_intercurrentes','TDM des sinus','',0),(19515,9773,'maladies_intercurrentes','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1 cdp x3/semaine',0),(19517,9774,'maladies_intercurrentes','Radiographie thoracique','',0),(19518,9774,'maladies_intercurrentes','TDM des sinus','',0),(19519,9775,'maladies_intercurrentes','NFS-Plaquettes','',0),(19520,9775,'maladies_intercurrentes','IgE Totales','',0),(19521,9776,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(19522,9776,'maladies_intercurrentes','Relvar Ellipta 1 B /j ','',0),(19524,9777,'maladies_intercurrentes','Ultibro 1 B/j','',0),(19525,9777,'maladies_intercurrentes','SYMBICORT TURBUHALER 400/12 microgrammes/dose, poudre pour inhalation','1 b m et s ',0),(19526,9777,'maladies_intercurrentes','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1cp X 3/semaine',0),(19527,9778,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19528,9779,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X2/j','',0),(19529,9779,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','',0),(19530,9779,'maladies_intercurrentes','Ultibro 1 B/j','',0),(19531,9780,'maladies_intercurrentes','Radiographie thoracique','a',0),(19533,9781,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19534,9781,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19535,9782,'maladies_intercurrentes','FENOFIBRATE EG 145 mg, comprimé','1 cp/j',0),(19536,9782,'maladies_intercurrentes','BIOCALYPTOL 6,55 mg/5 ml SANS SUCRE, sirop édulcoré à la saccharine sodique et au maltitol liquide','m et s ',0),(19537,9783,'maladies_intercurrentes','FOSFOMYCINE ARROW ADULTES 3 g, granulé pour solution buvable en sachet','1 sachet dose en une fois',0),(19538,9783,'maladies_intercurrentes','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1cp X3/semaine',0),(19539,9783,'maladies_intercurrentes','AERIUS 5 mg, comprimé pelliculé','1 cp le s ',0),(19540,9783,'maladies_intercurrentes','Clinutren 1 /j','',0),(19541,9784,'maladies_intercurrentes','Mercuris solubilis 5 CH ','3 btes ',0),(19542,9784,'maladies_intercurrentes','TOPLEXIL 0,33 mg/ml SANS SUCRE, solution buvable édulcorée à l\'acésulfame potassique','2 btes',0),(19543,9785,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un masque bucco-facial','',0),(19544,9785,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X2/j','arret BRICANYL si tachycardie',0),(19545,9785,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2ml m et s avec rin çage','',0),(19546,9785,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19547,9785,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B /j','',0),(19548,9786,'maladies_intercurrentes','TDM thoracique','',0),(19549,9787,'maladies_intercurrentes','Tisane à base de Romarin,Fenouil, Camomille','',0),(19550,9788,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine/j 2 btes ',0),(19551,9788,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s  1 bte',0),(19552,9789,'maladies_intercurrentes','Radiographie thoracique','',0),(19553,9789,'maladies_intercurrentes','TDM des sinus','',0),(19554,9790,'maladies_intercurrentes','NFS-Plaquettes','',0),(19555,9790,'maladies_intercurrentes','IgE Totales','',0),(19556,7972,'maladies_intercurrentes','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1cp X 3/sermaine',0),(19557,7972,'maladies_intercurrentes','AUGMENTIN 500 mg/62,5 mg ADULTES, comprimé pelliculé (rapport amoxicilline/acide clavulanique : 8/1)','1 g X3/j pendant 7 jrs',0),(19558,7972,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','1X2 pdt 7 jrs',0),(19559,9791,'maladies_intercurrentes','Radiographie thoracique','',0),(19560,9791,'maladies_intercurrentes','TDM des sinus','',0),(19561,9792,'maladies_intercurrentes','NFS -Plaquettes','',0),(19562,9792,'maladies_intercurrentes','IgE totales','',0),(19563,9793,'maladies_intercurrentes','Relvar Ellipta 184/22 1 B /j','',0),(19564,9794,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(19565,9795,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j avec rinçage','',0),(19568,9796,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','1 B m et s avec rinçage',0),(19569,9796,'maladies_intercurrentes','Chambre d\'inhalation','',0),(19570,9797,'maladies_intercurrentes','Radiographie thoracique','',0),(19571,9798,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s 2 btes ',0),(19572,9798,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j ',0),(19573,9798,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19574,9799,'maladies_intercurrentes','Location d','',0),(19575,9799,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X2/j','',0),(19576,9799,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','',0),(19578,9800,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie + 1 kit avec masque buccofacial/mois','',0),(19579,1283,'affection_exonorante','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1cpX3/semaine',0),(19580,9801,'maladies_intercurrentes','LANSOYL FRAMBOISE, gel oral en pot','2 btes ',0),(19581,9801,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','2btes',0),(19582,9802,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s 1 mois de traitement',0),(19583,9802,'maladies_intercurrentes','Amoxicilline  1 g X3/j','',0),(19584,9802,'maladies_intercurrentes','CLARITHROMYCINE ABBOTT 500 mg, comprimé pelliculé','1 cp X 2/j',0),(19585,9802,'maladies_intercurrentes','SPIRAMYCINE METRONIDAZOLE ZENTIVA 1,5 MUI/250 mg, comprimé pelliculé','2 cp x 3/j',0),(19586,9803,'maladies_intercurrentes','Aérosolthérapie de BUDESONIDE 1mg/2 ml m et s avec rinçage','',0),(19587,9803,'maladies_intercurrentes','Location d\'un appareil d\'aerosolthérapie ','',0),(19588,9383,'maladies_intercurrentes','Spiolto 2 B consecutives','',0),(19589,9383,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j ','',0),(19590,9804,'maladies_intercurrentes','Radiographie thoracique','',0),(19591,9804,'maladies_intercurrentes','TDM des sinus','',0),(19592,9805,'maladies_intercurrentes','NFS-Plaquettes','',0),(19593,9805,'maladies_intercurrentes','IgE Totales','',0),(19594,9806,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1cp X 3/semaine',0),(19595,9807,'maladies_intercurrentes','IRM hépatique avec injection de Gadolinum','',0),(19596,9809,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','a',0),(19597,9809,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19598,9810,'maladies_intercurrentes','Augmentin 1 g X3/j','7 jrs de traitement',0),(19599,9810,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','1 X2 pdt 7 jrs ',0),(19600,9810,'maladies_intercurrentes','NIFLURIL 250 mg, gélule','1 bte',0),(19601,9811,'maladies_intercurrentes','TDM thoracique','',0),(19602,9812,'maladies_intercurrentes','Relvar Ellipta 1 B/j','',0),(19603,9812,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19604,9813,'maladies_intercurrentes','Goutte épaisse','',0),(19605,9814,'maladies_intercurrentes','Relvar ellipta 184/22 microg 1 B/j','',0),(19606,9815,'maladies_intercurrentes','Ultibro 1 B/j','',0),(19607,9815,'maladies_intercurrentes','Relvar ellipta 1 B/j avec rinçage','',0),(19608,9816,'maladies_intercurrentes','Location d\'un appareil d\'aérsolthérapie ','',0),(19609,9816,'maladies_intercurrentes','Aérosolthérapie BRICANYL -ATROVENT  m et s ','',0),(19610,9816,'maladies_intercurrentes','Aérsolthérapie BUDESONIDE 1 mg/ 2 ml m  et s avec rinçage ','',0),(19611,9817,'maladies_intercurrentes','Radiographie thoracique','',0),(19612,9817,'maladies_intercurrentes','TDM des sinus','',0),(19613,9818,'maladies_intercurrentes','NFS - Plaquettes','',0),(19614,9818,'maladies_intercurrentes','IgE Totales','',0),(19615,9819,'maladies_intercurrentes','SINGULAIR 4 mg, comprimé à croquer','le s ',0),(19616,9819,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','1 B m et s avec rinçage',0),(19617,9819,'maladies_intercurrentes','1 chambre d\'inhalation','',0),(19619,9820,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','',0),(19620,9820,'maladies_intercurrentes','Aertosolthérapie BUDESONIDE 1 mg/2 ml m et s avec rinçage','',0),(19621,9820,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s pendant 21jrs',0),(19622,9821,'maladies_intercurrentes','NFS-Plaquettes','',0),(19623,9821,'maladies_intercurrentes','IgE Totales','',0),(19624,9822,'maladies_intercurrentes','TDM thoracique','',0),(19625,9822,'maladies_intercurrentes','TDM des sinus','',0),(19626,9823,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec kit et masque bucco facial','',0),(19627,9823,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X2/j','',0),(19628,9823,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2ml m et s avec rinçage','',0),(19630,9824,'maladies_intercurrentes','VIRGAN 1,5 mg/g, gel ophtalmique','1 flacon',0),(19631,9824,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','2 flacons',0),(19632,9825,'maladies_intercurrentes','Symbicort rapihaler 2 B m et s avec rinçage','',0),(19633,9825,'maladies_intercurrentes','AERIUS 5 mg, comprimé pelliculé','1 cp le s ',0),(19634,9825,'maladies_intercurrentes','Cacit 1g/j pdt 7 jrs','',0),(19635,9826,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19636,9826,'maladies_intercurrentes','Avamys','2 pulv ds chq narine/j',0),(19637,9826,'maladies_intercurrentes','Aerosolthérapie BRICANYL-ATROVENT X 2/j','',0),(19638,9826,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage ','',0),(19639,9827,'maladies_intercurrentes','Bicarbonate de soude 4 cuil à soupe ds 1L d','2 btes ',0),(19640,9827,'maladies_intercurrentes','Mycosatatine pommade 10 M m et s ','2 btes ',0),(19641,9827,'maladies_intercurrentes','Relvar 1 B/j ','',0),(19642,9828,'maladies_intercurrentes','Radiographie thoracique','',0),(19643,9828,'maladies_intercurrentes','TDM des sinus','',0),(19644,9829,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','',0),(19645,9829,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pmulv /j ds chq narine',0),(19646,9829,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19647,9830,'maladies_intercurrentes','SINGULAIR 4 mg, granulés','le s au coucher',0),(19648,9830,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','1 B m et s avec rinçage',0),(19649,9831,'maladies_intercurrentes','Radiographie thoracique','',0),(19650,9831,'maladies_intercurrentes','TDM des sinus','',0),(19651,9832,'maladies_intercurrentes','ACICLOVIR ALMUS 5 %, crème','1 tube',0),(19652,9833,'maladies_intercurrentes','TDM des sinus','',0),(19653,9834,'maladies_intercurrentes','Relvar 184/22 1 B/j ','',0),(19654,9835,'maladies_intercurrentes','Radiographie thoracique','',0),(19655,9835,'maladies_intercurrentes','TDM des sinus','',0),(19656,9836,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT mp et s ','',0),(19657,9836,'maladies_intercurrentes','Arret BRICANYL si tachycardie ','',0),(19658,9836,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2ml m et s avec rinçage','',0),(19659,9837,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 bte',0),(19660,9838,'maladies_intercurrentes','Relvar ellipta 184/22 1 B /j','',0),(19661,9839,'maladies_intercurrentes','Gazomètrie à AA','',0),(19662,9840,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','',0),(19663,9841,'maladies_intercurrentes','SINGULAIR 4 mg, granulés','1 sachet le s au coucher;',0),(19664,9841,'maladies_intercurrentes','SERETIDE 125 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','m et s avec rinçage',0),(19665,9841,'maladies_intercurrentes','1 chambre d\'inhalation','',0),(19666,9842,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie + masque bucco facial','',0),(19667,9843,'maladies_intercurrentes','IRM abdominal et prostatique','',0),(19668,9844,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec masque bucco-facial','',0),(19669,9844,'maladies_intercurrentes','Aérosolthérapie ATROVENT X2/j','',0),(19671,9844,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','',0),(19672,9845,'maladies_intercurrentes','Relvar ellipta 184/22  1 B/j','',0),(19673,9845,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(19674,9846,'maladies_intercurrentes','NFS-Plaquettes','',0),(19675,9846,'maladies_intercurrentes','TP','',0),(19676,9846,'maladies_intercurrentes','TCA','',0),(19677,9847,'maladies_intercurrentes','IRM cérébral','',0),(19678,9848,'maladies_intercurrentes','Relvar 184/22 1 B/j ','2 mois de trt',0),(19679,9848,'maladies_intercurrentes','Location d\'un appareil de\'aérosolthérapie avec kit et masque bucco-nasal','15 jrs de trt',0),(19680,9848,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2 mlm m et s avec rinçage','15 jrs de trt',0),(19681,9849,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(19682,9850,'maladies_intercurrentes','Radiographie thoracique','',0),(19683,9851,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19684,9852,'maladies_intercurrentes','Relvar 184/22 1 B /j','',0),(19685,9852,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19686,9853,'maladies_intercurrentes','Ragiographie thoracique','',0),(19687,9854,'maladies_intercurrentes','Relvar 184/22 1 B/j','1 mois de traitement',0),(19688,9854,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','m et s pdt 15 jrs',0),(19689,9855,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19690,9856,'maladies_intercurrentes','TDM thoracique','',0),(19691,8589,'maladies_intercurrentes','For(adil 1 gel inh 30 mns av l\'effort','',0),(19692,9857,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','3 btes',0),(19693,9857,'maladies_intercurrentes','SPAGULAX SANS SUCRE, poudre effervescente pour suspension buvable en sachet-dose','1bte',0),(19694,9857,'maladies_intercurrentes','Amoxicilline 1g X3/ ','6 jrs de traitement',0),(19695,9857,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','1gelX2 pdt 6jrs',0),(19696,9858,'maladies_intercurrentes','NFS-Plaquettes','',0),(19697,9858,'maladies_intercurrentes','T.P','',0),(19698,9858,'maladies_intercurrentes','TCA','',0),(19699,9859,'maladies_intercurrentes','IRM cérébral','',0),(19700,9860,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer','',0),(19701,9860,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','1 B m ets ',0),(19702,9860,'maladies_intercurrentes','Chambre d\'inhalation','',0),(19703,9861,'maladies_intercurrentes','Location','',0),(19704,9861,'maladies_intercurrentes','Aerosolthérapie BRICANYL-ATROVENT m et s ','',0),(19705,9861,'maladies_intercurrentes','Arret du BRICANYL si tachycardie','',0),(19706,9861,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s ','',0),(19707,9861,'maladies_intercurrentes','Des test respiratoire à l','',0),(19708,9861,'maladies_intercurrentes','Oesomeprazole 40 mg m et s ','',0),(19709,9861,'maladies_intercurrentes','Gaviscon 1sachet X3/j','',0),(19710,9862,'maladies_intercurrentes','ECBU Examen Cyto Bacteriologique des urines','',0),(19711,9863,'maladies_intercurrentes','TDM thoracique','',0),(19712,9864,'maladies_intercurrentes','Relvar ellipta 1 B/j','',0),(19713,9864,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19714,9865,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit et masque bucco facial','',0),(19715,9866,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j',0),(19716,9867,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante',' m et s ',0),(19717,9867,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet X 3/j','',0),(19718,9869,'maladies_intercurrentes','Examen cyto bacteriologique des crachats ','',0),(19719,9869,'maladies_intercurrentes','Examen direct,culture , antibiogramme','',0),(19720,9870,'maladies_intercurrentes','IRM abdominal et prostatique','',0),(19721,9871,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j','',0),(19722,9871,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(19723,9872,'maladies_intercurrentes','PSA','',0),(19724,7830,'affection_exonorante','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1 cp X3./semaine',0),(19725,9873,'maladies_intercurrentes','T.P Taux de prothrombine','',0),(19726,9873,'maladies_intercurrentes','TCA','',0),(19727,9874,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s',0),(19728,9874,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j',0),(19729,9875,'maladies_intercurrentes','Creatinine','',0),(19730,9875,'maladies_intercurrentes','DFG','',0),(19731,9876,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','en sertingue preremplie',0),(19732,9878,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','m e',0),(19733,9878,'maladies_intercurrentes','LAROSCORBINE 1 g, comprimé effervescent','le m',0),(19734,9879,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un masque bucco nasal','',0),(19735,9879,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2ml m et s avec rinçage','',0),(19736,9879,'maladies_intercurrentes','Paroex gargarisme m et s ','',0),(19737,9879,'maladies_intercurrentes','Actisoufre spray nasal m,midi et s ','',0),(19739,9880,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2pulv ds chq narine/j',0),(19740,9880,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19741,9881,'maladies_intercurrentes','IRM cérébral','',0),(19742,9882,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j','',0),(19743,9883,'maladies_intercurrentes','T3/T4','',0),(19744,9883,'maladies_intercurrentes','TSH','',0),(19746,9884,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19747,9884,'maladies_intercurrentes','Ultibro 1gel inh /j','',0),(19748,9885,'maladies_intercurrentes','K mnO4 Permanganate de K 1 sachet ds i bassine d','15 jrs de traitement',0),(19749,9885,'maladies_intercurrentes','Relvar ellipta 184/22 1 B /j avec rinçage','',0),(19750,9885,'maladies_intercurrentes','Ultibro 1 B/j','',0),(19751,9886,'maladies_intercurrentes','IgE totales','',0),(19752,9887,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19753,9887,'maladies_intercurrentes','Ultibro  1 gel inh/j','',0),(19754,9888,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s pdt 10jrs',0),(19755,9888,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s pdt 1 mois ',0),(19756,9889,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(19757,9889,'maladies_intercurrentes','Ultibro 1 gel inh /j','',0),(19758,9889,'maladies_intercurrentes','Relvar ellipta 1 B/j ','',0),(19759,9890,'maladies_intercurrentes','Radiographie thoracique','',0),(19760,9890,'maladies_intercurrentes','TDM des sinus','',0),(19761,9891,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19762,9891,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','1 mois de traitement',0),(19763,9891,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(19764,9893,'maladies_intercurrentes','Radiographie thoracique','',0),(19765,9893,'maladies_intercurrentes','TDM des sinus','',0),(19766,9894,'maladies_intercurrentes','Amoxicilline 250mg/5ml matin,midi et soir en suspension buvable','',0),(19767,9894,'maladies_intercurrentes','Antibio-synalar3 gtes ds chq oreille X2/j','',0),(19768,9894,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec masque bucco nasal infantile','',0),(19769,9894,'maladies_intercurrentes','Aerosolthérapie BUDESONIDE 0.5 mg /2 ml m et s avec rinçage','',0),(19770,9895,'maladies_intercurrentes','NFS - Plaquettes','',0),(19772,9896,'maladies_intercurrentes','BIAFINE, émulsion pour application cutanée','3à 4 applications/j 1 bte',0),(19773,9897,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1 bte',0),(19774,9897,'maladies_intercurrentes','Symbicort rapihaler 2 B X2/j','2 btes',0),(19775,9897,'maladies_intercurrentes','VENTOLINE 100 microgrammes/dose, suspension pour inhalation en flacon pressurisé','3 btes',0),(19776,9898,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19777,9899,'maladies_intercurrentes','SERETIDE DISKUS 500 microgrammes/50 microgrammes/dose, poudre pour inhalation en récipient unidose','1 B m et s avec rinçage',0),(19778,9899,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(19779,9899,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1 X3/j',0),(19780,9900,'maladies_intercurrentes','PULMOFLUIDE SIMPLE, solution buvable','1 cui:l m et s',0),(19781,9900,'maladies_intercurrentes','PERUBORE INHALATION, capsule pour inhalation par vapeur','m et s pdt 10 mn',0),(19782,9901,'maladies_intercurrentes','TDM des sinus','',0),(19783,9902,'maladies_intercurrentes','NFS','',0),(19784,9902,'maladies_intercurrentes','IgE Totales','',0),(19785,9903,'maladies_intercurrentes','Relvar ellipta 1 /j','',0),(19786,9903,'maladies_intercurrentes','Ultibro 1 gel inh /j','',0),(19787,9904,'maladies_intercurrentes','Seretide 250 1 B m et avec rinçage','',0),(19788,9904,'maladies_intercurrentes','Chambre d\'inhalation','',0),(19789,9904,'maladies_intercurrentes','AERIUS 0,5 mg/ml, solution buvable 5 ml/j','',0),(19790,9906,'maladies_intercurrentes','TANGANIL 500 mg, comprimé','1 cp/j',0),(19791,9906,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent','1 bte',0),(19792,9906,'maladies_intercurrentes','Niflugel pde ','1 bte',0),(19793,9907,'maladies_intercurrentes','Hypaflix ','2 btes ',0),(19794,9907,'maladies_intercurrentes','Urgofix ','1 bte',0),(19795,9907,'maladies_intercurrentes','BORAX/ACIDE BORIQUE BIOGARAN 12 mg/18 mg/ml, solution pour lavage ophtalmique en récipient unidose','1 bte ',0),(19796,9907,'maladies_intercurrentes','Talc officinal babysoin','1 bte',0),(19797,9907,'maladies_intercurrentes','KmnO4 1 sachet ds 1 bol d\'eau tièd','2 btes',0),(19798,9908,'maladies_intercurrentes','FLAGYL 500 mg, comprimé pelliculé 3 cp en prise unique/j','',0),(19799,9909,'maladies_intercurrentes','Irbedartan 75 mg 1 cp/j','3 mois de traitement',0),(19800,9909,'maladies_intercurrentes','ECONAZOLE ARROW 1 %, émulsion pour application cutanée','1 tube',0),(19801,9909,'maladies_intercurrentes','EFFERALGAN 1 g, comprimé effervescent','3 btes',0),(19802,9910,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s',0),(19803,9910,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine/j',0),(19804,9911,'maladies_intercurrentes','Ultibro 1 gel inh /j','',0),(19805,9911,'maladies_intercurrentes','Relvar ellipta  1 B avec rinçage','',0),(19806,9912,'maladies_intercurrentes','TDM des sinus','',0),(19807,9913,'maladies_intercurrentes','NFS-Plqt','',0),(19808,9913,'maladies_intercurrentes','IgE totales','',0),(19809,9914,'maladies_intercurrentes','LOCATION d\'un appareil d\'aerosolthérapie','',0),(19810,9915,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X2/j ','',0),(19811,9915,'maladies_intercurrentes','Arret du BRICANYL si tachycardie','',0),(19812,9915,'maladies_intercurrentes','Aérsolthérapie BUDESONIDE 1mg/2 ml m et s avec rinçage ','',0),(19813,9916,'maladies_intercurrentes','Eosomeprazole 40 mg ','1 bte',0),(19814,9917,'maladies_intercurrentes','Echographie thyroidienne ','',0),(19815,9918,'maladies_intercurrentes','TSH','',0),(19816,9918,'maladies_intercurrentes','T3/T4','',0),(19817,9919,'maladies_intercurrentes','Relvar ellipta 1B/j avec rinçage','',0),(19818,9920,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','1 cp/j  1 bte',0),(19819,9920,'maladies_intercurrentes','UVEDOSE 100 000 UI, solution buvable en ampoule','X3/an',0),(19820,9920,'maladies_intercurrentes','LEVOTHYROX 75 microgrammes, comprimé sécable','1 cp/j',0),(19821,9920,'maladies_intercurrentes','APROVEL 150 mg, comprimé pelliculé','1cp/j',0),(19822,9921,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(19823,9922,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','2 gel X2/j',0),(19824,9922,'maladies_intercurrentes','BACILOR, poudre pour suspension buvable en sachet-dose','m et s',0),(19825,9922,'maladies_intercurrentes','LACTEOL 340 mg, poudre pour suspension buvable en sachet-dose','X3/j',0),(19826,9923,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(19827,9923,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','X3/j',0),(19828,9923,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1 gel inh m et s',0),(19829,9923,'maladies_intercurrentes','MIFLONIL 400 microgrammes, poudre pour inhalation en gélule','m et s avec rinçage',0),(19830,9924,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS FRANCE 40 mg, comprimé gastro-résistant','1 cp m et s ',0),(19831,9924,'maladies_intercurrentes','Amoxicilline 1 g X3/j','',0),(19832,9924,'maladies_intercurrentes','CLARITHROMYCINE ABBOTT 500 mg, comprimé pelliculé','1g m et s ',0),(19833,9924,'maladies_intercurrentes','SPIRAMYCINE METRONIDAZOLE GERDA 1,5 M.U.I./250 mg, comprimé pelliculé','2 cp X3/j',0),(19834,9925,'maladies_intercurrentes','Test respiratoire à l\'urée','',0),(19835,9925,'maladies_intercurrentes','A faire apres le 15février 2020','',0),(19836,9926,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3/j',0),(19837,9926,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','m et s  en cas d\'effort',0),(19838,9927,'maladies_intercurrentes','NFS-Plaquettes','',0),(19839,9927,'maladies_intercurrentes','IgE totales','',0),(19840,9927,'maladies_intercurrentes','IgE spécifiques RAST aux trophallergènes','',0),(19841,9928,'maladies_intercurrentes','Radiographie thoracique','',0),(19842,9928,'maladies_intercurrentes','TDM des sinus','',0),(19843,9929,'maladies_intercurrentes','NFS -Plaquettes','',0),(19844,9929,'maladies_intercurrentes','IgE Totales','',0),(19845,9930,'maladies_intercurrentes','Radiographie thopracique','',0),(19846,9930,'maladies_intercurrentes','TDM des sinus','',0),(19847,9931,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','1 BX2 en cas de gène respiratoire avec rinçage',0),(19850,9933,'maladies_intercurrentes','TDM abdomino-pelvien','',0),(19851,9934,'maladies_intercurrentes','Exacyl amp buv ','1 amp X3/j si saignement',0),(19852,9935,'maladies_intercurrentes','NFS-Plaquettes','',0),(19853,9935,'maladies_intercurrentes','IgE totales','',0),(19854,9936,'maladies_intercurrentes','BIOCIDAN 0,1 mg/0,4 ml, collyre en récipient unidose','1 goutte X3/j ',0),(19855,9937,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19856,9938,'maladies_intercurrentes','AZITHROMYCINE ARROW 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(19857,9938,'maladies_intercurrentes','Ultibro 1 gel inh/j','',0),(19858,9938,'maladies_intercurrentes','Relvar ellipta 180/22 1 B/j avec rinçage','',0),(19859,9939,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie','',0),(19860,9940,'maladies_intercurrentes','TDM thoracique','',0),(19861,9941,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit ','',0),(19862,9941,'maladies_intercurrentes','Budesonide 1 mg/2 ml m et s avec rinçage','',0),(19863,9942,'maladies_intercurrentes','Ultravist 300 1 flacon de 150 ml en seringue pré remplie','',0),(19864,9943,'maladies_intercurrentes','ESCITALOPRAM 10 mg un demi comprimé le soir.','2 btes',0),(19865,9944,'maladies_intercurrentes','SINGULAIR 4 mg, comprimé à croquer','le soir au coucher',0),(19866,9944,'maladies_intercurrentes','SERETIDE 125 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','1 B m et s avec rinçage',0),(19867,9944,'maladies_intercurrentes','Chambre d\'inhalation','',0),(19868,9946,'maladies_intercurrentes','Relvar ellipta 1 B/j avec rinçage','',0),(19869,9946,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(19870,9947,'maladies_intercurrentes','Radiographie thoracique','',0),(19871,9948,'maladies_intercurrentes','Ultibro 1 gel inh/j','',0),(19872,9948,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j ','',0),(19873,9949,'maladies_intercurrentes','Ionogramme sanguin','',0),(19874,9950,'maladies_intercurrentes','NFS-Plaquettes','',0),(19875,9950,'maladies_intercurrentes','IgE totales','',0),(19876,9950,'maladies_intercurrentes','IgE specifique aux pneumallergènes et aux trophallergènes','',0),(19877,9951,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec masque bucco-facial','',0),(19878,9951,'maladies_intercurrentes','Ultibro 1 gel inh m ','',0),(19879,9951,'maladies_intercurrentes','Relvar ellipta 184/22 1 b /j avec rinçage','',0),(19880,9951,'maladies_intercurrentes','Aérosolthérapie BRICANYL -ATROVENT m et s ','',0),(19881,9951,'maladies_intercurrentes','Arret BRICANYL si tachycardie','',0),(19882,9951,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/ 2 ml m et s avec rinçage','',0),(19883,9952,'maladies_intercurrentes','GDS à AA','',0),(19884,9953,'maladies_intercurrentes','Radiographie thoracique','',0),(19885,9954,'maladies_intercurrentes','NFS-Plaquettes','',0),(19886,9954,'maladies_intercurrentes','Urée / Creatinine','',0),(19887,9954,'maladies_intercurrentes','ASAT/ALAT','',0),(19888,9955,'maladies_intercurrentes','Augmentin 1 g X3/j ','',0),(19889,9955,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','1 gel/j',0),(19890,5367,'affection_exonorante','Ventoline 1 B en cas de besoin','',0),(19891,5367,'affection_exonorante','EFFERALGAN 1 g, comprimé effervescent','2 btes',0),(19892,9956,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19893,9956,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','2 btes',0),(19894,9957,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19895,9957,'maladies_intercurrentes','Ultibro 1 gel inh/j','',0),(19896,9957,'maladies_intercurrentes','DOLIPRANE 1000 mg, comprimé','1 cp/j',0),(19897,9958,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','seringue preremplie',0),(19898,9959,'maladies_intercurrentes','Relvar ellipta 184/22 1 B /j avec rinçage','2 btes ',0),(19899,9960,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19900,9960,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé',' 1 cp le s ',0),(19901,9961,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec  rinçage','',0),(19902,9961,'maladies_intercurrentes','Ultibro 1 gel inh /j','',0),(19903,9962,'maladies_intercurrentes','DOLIPRANE 1000 mg, comprimé','4 btes',0),(19904,9962,'maladies_intercurrentes','NAPROSYNE 500 mg, comprimé','1 bte ',0),(19905,9963,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(19906,9963,'maladies_intercurrentes','En IM','',0),(19907,9963,'maladies_intercurrentes','IDE à domicile','',0),(19909,9964,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','',0),(19910,6020,'affection_exonorante','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé','X2/j',0),(19911,9965,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19912,9965,'maladies_intercurrentes','Ultibro 1 gel inh /h','',0),(19913,9967,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19914,9968,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19915,9968,'maladies_intercurrentes','Ultibro 1 B/j','',0),(19916,9969,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','',0),(19917,9969,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','3 mois plus tard',0),(19918,9970,'maladies_intercurrentes','Location d','',0),(19919,9970,'maladies_intercurrentes','Aérsolthérapie BRICANYL-ATROVENT X2/j','',0),(19920,9970,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2ml m et s avec rinçage','',0),(19921,9970,'maladies_intercurrentes','Relvar 184/22 1 B/j avec rinçage','',0),(19922,9970,'maladies_intercurrentes','Ultibro 1 B/j ','',0),(19923,9970,'maladies_intercurrentes','Arret BRICANYL si tachycardi','',0),(19924,9970,'maladies_intercurrentes','Loperamide 2 mg 6 cp/j','',0),(19925,9970,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','m et vs pendant 15 jrs',0),(19926,9971,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19927,9972,'maladies_intercurrentes','CHAMPIX 0,5 mg, comprimé pelliculé','1 fois/j pdt 3 jrs',0),(19928,9972,'maladies_intercurrentes','CHAMPIX 0,5 mg, comprimé pelliculé','2 fois/j pdt 4 jrs',0),(19929,9972,'maladies_intercurrentes','Semaine 2 à 12','',0),(19930,9972,'maladies_intercurrentes','CHAMPIX 1 mg, comprimé pelliculé 2 fois/j','',0),(19931,9974,'maladies_intercurrentes','CHAMPIX 12 semaines','',0),(19932,9974,'maladies_intercurrentes','Semaine 1','',0),(19933,9974,'maladies_intercurrentes','CHAMPIX 0,5 mg, comprimé pelliculé 1 fois/j pdt 3 jrs','',0),(19934,9974,'maladies_intercurrentes','CHAMPIX 0,5 mg, comprimé pelliculé 2 fois/j pdt 4 jrs','',0),(19935,9974,'maladies_intercurrentes','Semaine 2 à 12','',0),(19936,9974,'maladies_intercurrentes','CHAMPIX 1 mg, comprimé pelliculé  2fois/j','',0),(19937,9975,'maladies_intercurrentes','PNEUMO 23, solution injectable en seringue pré-remplie. vaccin pneumococcique polyosidique','1 bte',0),(19938,9976,'maladies_intercurrentes','Radiographie thoracique','',0),(19939,9976,'maladies_intercurrentes','TDM des sinus','',0),(19940,9977,'maladies_intercurrentes','NFS-Plaquettes','',0),(19941,9977,'maladies_intercurrentes','IgE totales','',0),(19944,9978,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19945,9978,'maladies_intercurrentes','Ultibro 1 gel inh /j ','',0),(19946,9979,'maladies_intercurrentes','Seretide 250 2 B m et s avec rinçage','',0),(19947,9979,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer','',0),(19948,9979,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine le s ',0),(19949,9979,'maladies_intercurrentes','Paroex gargarisme m et s ','',0),(19950,9979,'maladies_intercurrentes','Budesonide aerosolthérapie 0.5mg/2 ml m et s ','',0),(19951,9979,'maladies_intercurrentes','Location d','',0),(19952,9981,'maladies_intercurrentes','Relvar ellipta 184/22 1 B /javec rinçage','',0),(19953,9981,'maladies_intercurrentes','Paroex gargarisme m et s ','',0),(19954,9981,'maladies_intercurrentes','Budesonide 0.5mg/2ml m et s avec rinçage','',0),(19955,9981,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer le s ','',0),(19956,9981,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un masque bucco nasal','',0),(19957,9981,'maladies_intercurrentes','Foradil 1 gel inh 20 mns av l','',0),(19958,9981,'maladies_intercurrentes','Ventoline 2 b en cas de gène respiratoire ','',0),(19959,9981,'maladies_intercurrentes','CELESTENE 2 mg, comprimé dispersible sécable','2 btes ',0),(19960,9982,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19961,9983,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19962,9984,'maladies_intercurrentes','Creatinémie avec calcul de la clairance','',0),(19963,9985,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19964,9985,'maladies_intercurrentes','VOLTARENE EMULGEL 1 %, gel','2 tubes',0),(19965,9986,'maladies_intercurrentes','ECBU Examen cyto bacteriologique des urines','',0),(19966,9986,'maladies_intercurrentes','Examen Direct,Cultiure,Antibiogramme','',0),(19967,9987,'maladies_intercurrentes','NIFLUGEL 2,5 %, gel','',0),(19968,9988,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s pdt 15 jrs ',0),(19969,9988,'maladies_intercurrentes','PERUBORE INHALATION, capsule pour inhalation par vapeur','2 btes',0),(19970,9988,'maladies_intercurrentes','VICKS VAPORUB, pommade','2 btes',0),(19971,9989,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19972,9990,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(19973,9990,'maladies_intercurrentes','Ultibro 1 gel inh /j','',0),(19974,9991,'maladies_intercurrentes','TDM des sinus','',0),(19975,9992,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','en seringue preremplie',0),(19976,9993,'maladies_intercurrentes','IRM cérébral','',0),(19977,9994,'maladies_intercurrentes','TP ','',0),(19978,9994,'maladies_intercurrentes','TCA','',0),(19979,9995,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine 1 fois/j',0),(19980,9995,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19981,9995,'maladies_intercurrentes','AERIUS 5 mg, comprimé pelliculé','1 cp le s ',0),(19982,5875,'affection_exonorante','Relvar ellipta 184/22 1B/j','',0),(19983,8825,'maladies_intercurrentes','Aerius sirop 5 ml/j ','',1),(19984,9996,'maladies_intercurrentes','Amoxicilline 1 g X3/j pdt 5 jrs ','',0),(19985,9996,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','m et s ',0),(19987,9891,'maladies_intercurrentes','Location d','',0),(19988,9997,'maladies_intercurrentes','AERIUS 5 mg, comprimé pelliculé','1 cp le s ',0),(19989,9997,'maladies_intercurrentes','Permanganate de potassium 2 sachets dans i cuvette d','',0),(19990,9997,'maladies_intercurrentes','Compresses ','3 btes ',0),(19991,9998,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2pulv ds chq narine/j',0),(19992,9998,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19993,9999,'maladies_intercurrentes','TDM thoracique sans injection','',0),(19994,10000,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte ',0),(19995,10000,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j',0),(19996,10000,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(19997,10001,'maladies_intercurrentes','SYMBICORT TURBUHALER 400/12 microgrammes/dose, poudre pour inhalation','1 B m et s ',0),(19998,10001,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(19999,10002,'maladies_intercurrentes','TDM thoracique sans injection','',0),(20000,10003,'maladies_intercurrentes','Relvar ellipta 1 B/j avec rinçage','',0),(20001,10003,'maladies_intercurrentes','Ultibro 1 gel inh /j','',0),(20002,10003,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(20003,10004,'maladies_intercurrentes','ANTIBIO SYNALAR, solution pour instillation auriculaire','6gtes X2/j',0),(20004,10004,'maladies_intercurrentes','Amoxicilline 1g X3/j','',0),(20005,10004,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(20006,10005,'maladies_intercurrentes','Lacation d\'un appareil d\'aérosolthérapie ','',0),(20007,10005,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2 ml m et s avec rinçage','',0),(20008,10005,'maladies_intercurrentes','RELVAR ELLIPTA 184/22 1 B/j avec rinçage','',0),(20009,10005,'maladies_intercurrentes','ULTIBRO 1 gel inh /j','',0),(20010,10006,'maladies_intercurrentes','PSA','',0),(20011,10006,'maladies_intercurrentes','TP','',0),(20012,10006,'maladies_intercurrentes','TCA','',0),(20013,10006,'maladies_intercurrentes','ECBU','',0),(20014,10006,'maladies_intercurrentes','NFS Plaquettes','',0),(20015,10007,'maladies_intercurrentes','EXACYL 500 mg, comprimé pelliculé','2 cp x 4 / j',0),(20016,10008,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','dès maintenant ',0),(20017,10008,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','dans 3 mois à compter du PREVENAR ',0),(20018,10009,'maladies_intercurrentes','Location d\'un appareil ','',0),(20020,10010,'maladies_intercurrentes','Aérosolthérapie Budesonide 1mg/2ml m et s ','pdt 15 jrs',0),(20021,10010,'maladies_intercurrentes','Location ','',0),(20022,10010,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2pulv ds chq narine /j',0),(20024,10012,'maladies_intercurrentes','TDM thoracique','',0),(20025,10013,'maladies_intercurrentes','Relvar ellipta 188/22  1B/j avec rinçage','',0),(20026,10013,'maladies_intercurrentes','Ultibro 1 gel inh /j','',0),(20027,10014,'maladies_intercurrentes','NFS-Plaquettes','',0),(20028,10014,'maladies_intercurrentes','IgE Totales','',0),(20029,10015,'maladies_intercurrentes','NFS Plaquettes','',0),(20030,10015,'maladies_intercurrentes','TP','',0),(20031,10015,'maladies_intercurrentes','TCA','',0),(20032,10016,'maladies_intercurrentes','TARDYFERON B9, comprimé pelliculé','1cp/j 1 bte',0),(20033,10017,'maladies_intercurrentes','TDM thoracique sans injection','',0),(20034,10017,'maladies_intercurrentes','En juillet 2020','',0),(20035,10018,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20036,10018,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(20037,10019,'maladies_intercurrentes','TDM TAP sans injection ','',0),(20038,10020,'maladies_intercurrentes','CHARBON DE BELLOC 125 mg, capsule molle','1 capsule x2/j',0),(20039,10021,'maladies_intercurrentes','MOVICOL, poudre pour solution buvable en sachet','1 sachet/j',0),(20040,10021,'maladies_intercurrentes','Spiolto respimat 2 B consécutives','',0),(20041,10022,'maladies_intercurrentes','TDM thoracique sans injection','',0),(20042,10023,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(20043,10023,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20044,9010,'maladies_intercurrentes','Ventoline 2 B en cas de besoin','',0),(20045,10024,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(20046,10024,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','à faire dans 3 mois',0),(20047,10025,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 bte à faire au mois d',0),(20048,10025,'maladies_intercurrentes','Ultibro 1 gel inh/j','',0),(20049,10025,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20050,10026,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20051,10027,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 20 mg, gélule gastro-résistante','m et s ',0),(20052,10027,'maladies_intercurrentes','Amoxicilline 1 g m et s ','',0),(20053,10027,'maladies_intercurrentes','Clarithromycine 500 mg m et s ','',0),(20054,10027,'maladies_intercurrentes','Metronidazole 500 mg m et s ','',0),(20055,10028,'maladies_intercurrentes','ESOMEPRAZOLE ARROW 40 mg, gélule gastro-résistante','1 cp m et zs',0),(20056,10028,'maladies_intercurrentes','GAVISCON, suspension buvable en sachet','1 schtX3',0),(20057,10029,'maladies_intercurrentes','Relvar ellipta 184/22 1 B /j avec rinçage','',0),(20058,10029,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(20059,10029,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1cp X3/semaine',0),(20060,10029,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(20061,10030,'maladies_intercurrentes','NFS-Plaquettes','',0),(20062,10030,'maladies_intercurrentes','IgE Totales','',0),(20063,10031,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s   2 btes ',0),(20064,10032,'maladies_intercurrentes','IRM colonne dorso lombaire','',0),(20065,10033,'maladies_intercurrentes','Kinésie thérapie dorso lombaire ','',0),(20066,10033,'maladies_intercurrentes','2 séances/semaine pendant 2 mois ','',0),(20067,10034,'maladies_intercurrentes','Loxen LP 100 mg en 2 prises ,soit 50 mg X2 ce jour 1 bte','',0),(20068,10035,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2pulv /j ds chq narine',0),(20069,10035,'maladies_intercurrentes','Paroex gargarisme m et s','',0),(20070,10036,'maladies_intercurrentes','LANSOYL SANS SUCRE 78,23 g POUR CENT, gel oral en pot édulcoré à la saccharine sodique','1 bte',0),(20071,10036,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s 3 btes',0),(20072,10037,'maladies_intercurrentes','TP','',0),(20073,10037,'maladies_intercurrentes','TCA','',0),(20074,10037,'maladies_intercurrentes','NFS-Plaquettes','',0),(20075,10038,'maladies_intercurrentes','Aérosolthérapie TERBUTALINE 5mg/2ml m et s ','',0),(20076,10039,'maladies_intercurrentes','Electrophorèse des proteines','',0),(20077,10041,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20078,10041,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp/j ',0),(20079,10042,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20080,10042,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(20081,10043,'maladies_intercurrentes','ESOMEPRAZOLE ARROW 20 mg, comprimé gastro-résistant','m et s',0),(20082,10044,'maladies_intercurrentes','SPAGULAX SANS SUCRE, poudre effervescente pour suspension buvable en sachet-dose','2 btes',0),(20083,10044,'maladies_intercurrentes','Titanoreine suppositoires','2 btes',0),(20084,10045,'maladies_intercurrentes','TDM thoracique début mai 2020.','',0),(20085,10046,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2ml m et s avec rinçage ','',0),(20086,10046,'maladies_intercurrentes','Location d\'un ','',0),(20087,10047,'maladies_intercurrentes','Aérsosolthérapie BRICANYL-ATROVENT X2/j','15 jrs de traitement',0),(20088,10047,'maladies_intercurrentes','Aérsolthérapie BUDESONIDE 1 mg/2ml m et s aavec rinçage','15 jrs de trt',0),(20090,10047,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine 1 fois/j',0),(20091,10047,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(20092,10047,'maladies_intercurrentes','LAROSCORBINE 1 g, comprimé effervescent','le m  pdt 15jrs',0),(20093,10048,'maladies_intercurrentes','Radiographie thoracique','',0),(20094,10049,'maladies_intercurrentes','NFS-Plaquettes','',0),(20095,10050,'maladies_intercurrentes','Seretide 250 2 B m et s avec rinçage','',0),(20096,10050,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer','le s',0),(20097,10051,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(20098,10051,'maladies_intercurrentes','Relvar ellipta 184/22 1 B /j avec trinçage','',0),(20099,10052,'maladies_intercurrentes','Locationd\'un appareil d\'aerosolthérapie avec un masque','15 jrs de traitement',0),(20100,10052,'maladies_intercurrentes','Aérosolthérapie BU8DESONIDE 1 mg/ 2ml m et s avec rinçage','15 jrs de traitement',0),(20101,10052,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j ','',0),(20102,10052,'maladies_intercurrentes','Aersoltheapie BRICANYL  m et s ','15 jrs de traitement',0),(20103,10053,'maladies_intercurrentes','Exacyl 4 G /j soit 1 amp buv X4/j ','1 amp toutes les 3 H  pendant 7 jours ',0),(20104,10054,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(20105,10054,'maladies_intercurrentes','Relvar ellipta 184/22 1 B avec rinçage','',0),(20106,10055,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s pdt 10 jrs',0),(20107,10055,'maladies_intercurrentes','Amoxicilline 1 g X3/j pdt 5 jrs ','',0),(20108,10055,'maladies_intercurrentes','EFFERALGAN 500 mg, comprimé effervescent sécable','m et s  pendant 5 jrs',0),(20109,10055,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(20110,10055,'maladies_intercurrentes','Aérsolthérapie BUDESONIDE 1mg/2 ml m te s ','',0),(20111,10055,'maladies_intercurrentes','Aérosolthérapie BRICANYL  m et s ','',0),(20112,10056,'maladies_intercurrentes','Radiographie thoracique','',0),(20113,10057,'maladies_intercurrentes','EXACYL 1 g/10 ml, solution buvable','4 amp/j',0),(20114,6260,'affection_exonorante','Ultibro 1 gel inh/j','',0),(20115,10058,'maladies_intercurrentes','Location d\'un appareil d\'aérsolthérapie avec kit','',0),(20116,10059,'maladies_intercurrentes','Aerosolthérapie BUDESONIDE 1 mg/ 2 ml m et s ','avec rinçage',0),(20117,10059,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(20118,10060,'maladies_intercurrentes','NFS-Plaquettes','',0),(20119,10060,'maladies_intercurrentes','Urée/ creatinine','',0),(20120,10060,'maladies_intercurrentes','ASAT/ ALAT','',0),(20121,10060,'maladies_intercurrentes','Glycémie/HbA1C','',0),(20122,10061,'maladies_intercurrentes','Aérosolthérapie BRICANYL-ATROVENT X2/j','',0),(20123,10061,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2 ml m et s avec rinçage','',0),(20124,10061,'maladies_intercurrentes','Arret BRICANYL si Tachycardie','',0),(20125,10062,'maladies_intercurrentes','IgE Totales','',0),(20126,10063,'maladies_intercurrentes','FORADIL 12 microgrammes, poudre pour inhalation en gélule','1 gel inh 20 mns avant l\'effort',0),(20127,10064,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(20128,10064,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j ',0),(20129,10064,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit et masque bucco nasal','',0),(20130,10064,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/ 2 ml m et s avec rinçage','',0),(20131,9931,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer','1 cp le s au coucher',0),(20132,8646,'affection_exonorante','Location d\'un appareil d\'aerosolthérapie + kit avec masque/mois','',0),(20133,8646,'affection_exonorante','ZITHROMAX 250 mg, comprimé pelliculé','1cp X3/semaine',0),(20134,10065,'maladies_intercurrentes','NFS-Plaquettes','',0),(20135,10065,'maladies_intercurrentes','IgE Totales','',0),(20136,10066,'maladies_intercurrentes','TDM des sinus','',0),(20137,10066,'maladies_intercurrentes','Radiographie thoracique','',0),(20138,10067,'maladies_intercurrentes','Relvar ellipta 184/22 1B/j','',0),(20139,10067,'maladies_intercurrentes','SINGULAIR 10 mg, comprimé pelliculé','1 cp le s ',0),(20140,10068,'maladies_intercurrentes','TDM thoracique sans injection','',0),(20141,10069,'maladies_intercurrentes','DOLIPRANE 1000 mg, comprimé','1 cp /j',0),(20142,10070,'maladies_intercurrentes','Kardegic 75 1cp/j','',0),(20143,10072,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s ',0),(20144,10073,'maladies_intercurrentes','Radiographie thoracique','',0),(20145,10073,'maladies_intercurrentes','TDM des sinus','',0),(20146,10074,'maladies_intercurrentes','NFS-Plaquettes','',0),(20147,10074,'maladies_intercurrentes','IgE Totales','',0),(20148,10075,'maladies_intercurrentes','Antibiosynalar gtes auriculaires ','3gtes X2/j ds chq oreille ',0),(20149,10075,'maladies_intercurrentes','SINGULAIR 4 mg, granulés','le sqoir au coucher',0),(20150,10076,'maladies_intercurrentes','NICOTINELL TTS 21 mg/24 h, dispositif transdermique','pdt 4 semaines',0),(20151,10076,'maladies_intercurrentes','NICOTINELL TTS 14 mg/24 h, dispositif transdermique','pdt 4 semaines',0),(20152,10076,'maladies_intercurrentes','NICOTINELL TTS 7 mg/24 H, dispositif transdermique','pdt 4 semaines',0),(20153,10077,'maladies_intercurrentes','Amoxicilline 200mg m , midi et s espacèes de 8:00.','',0),(20154,10077,'maladies_intercurrentes','Soupe à carottes m et s','',0),(20155,10078,'maladies_intercurrentes','Relvar ellipta 184/22  1 B/j avec rinçage','',0),(20156,10078,'maladies_intercurrentes','Spiolto  2 B consécutives','',0),(20157,10079,'maladies_intercurrentes','TDM thoracique sans injection','',0),(20158,10080,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20159,10080,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(20160,10081,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20161,10081,'maladies_intercurrentes','Spiloto 2 B consécutives','',0),(20162,10081,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2ml m et s avec rinçage','',0),(20163,10081,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit et un masque bucco facial','',0),(20164,10082,'maladies_intercurrentes','NFS-Plaquettes','',0),(20165,10082,'maladies_intercurrentes','IgE Totales','',0),(20166,10083,'maladies_intercurrentes','Seretide 125 1 B m et s avec rinçage','',0),(20167,10083,'maladies_intercurrentes','SINGULAIR 4 mg, comprimé à croquer','',0),(20168,10084,'maladies_intercurrentes','GDS à AA','',0),(20169,10085,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 amp en IM',0),(20170,10085,'maladies_intercurrentes','Vaccin antigrippal à faire en avril 2020','',0),(20172,10086,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j','',0),(20173,10086,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(20174,10087,'maladies_intercurrentes','Magnesium marin 2 cp/j','',0),(20175,10088,'maladies_intercurrentes','TDM des sinus','',0),(20176,10088,'maladies_intercurrentes','Radiographie thoracique','',0),(20177,10089,'maladies_intercurrentes','NFS -plaquettes','',0),(20178,10089,'maladies_intercurrentes','IgE Totales','',0),(20179,10090,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20180,10091,'maladies_intercurrentes','Radiographie des 2 poignets','',0),(20181,10091,'maladies_intercurrentes','Radiographie thoracique ','',0),(20182,10091,'maladies_intercurrentes','Echographie thoraco abdominal','',0),(20183,10092,'maladies_intercurrentes','NIFLUGEL 2,5 %, gel','3 applications/j 2 btes',0),(20184,10093,'maladies_intercurrentes','Aérosolthérapie BRICANYL m et s ','',0),(20185,10093,'maladies_intercurrentes','Aérsolthérapie BUDESONIDE 1 mg/2ml m et s avec rinçage ','',0),(20186,10094,'maladies_intercurrentes','NIFLUGEL 2,5 %, gel','2 applications/j  2 btes',0),(20187,10095,'maladies_intercurrentes','Radiographie thoracique','',0),(20188,10096,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','2 btes',0),(20189,10097,'maladies_intercurrentes','IRM des deux épaules','',0),(20190,10098,'maladies_intercurrentes','NIFLUGEL 2,5 %, gel','3 applications/j',0),(20191,10099,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec kit et masque buccofacial','',0),(20192,10099,'maladies_intercurrentes','Aérosolthérapie ATROVENT m et s ','',0),(20193,10099,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1mg/2ml m et s avec rinçage','',0),(20194,10100,'maladies_intercurrentes','Radiographie thoracique','',0),(20195,10101,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie ','',0),(20196,10101,'maladies_intercurrentes','Aérosolthérapie ATROVENT m et s ','',0),(20197,10101,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2 ùml m et s avec rinçage','',0),(20198,10101,'maladies_intercurrentes','Relvar ellipta 184/22 1 B /j avec rinçage','',0),(20199,10102,'maladies_intercurrentes','Aérsolthérapie ATROVENT m et s ','',0),(20200,10102,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2 ml m et s avec rinçage','',0),(20201,10102,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit et masque buccofacial','',0),(20202,10102,'maladies_intercurrentes','Relvar  ellipta 184/22 1 B/j avec rinçage','',0),(20203,10103,'maladies_intercurrentes','NFS -Plaquiettes','',0),(20204,10103,'maladies_intercurrentes','IgE totales','',0),(20205,10104,'maladies_intercurrentes','Radiographie thoracique','',0),(20206,10104,'maladies_intercurrentes','TDM des sinus','',0),(20207,10105,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20208,10106,'maladies_intercurrentes','Radiographie thoracique','',0),(20209,10107,'maladies_intercurrentes','NFS-plaquettes','',0),(20210,10107,'maladies_intercurrentes','IgE totales','',0),(20211,10108,'maladies_intercurrentes','Relvar ellipta 184/22 1B/j avec rtinçage','',0),(20212,10109,'maladies_intercurrentes','Faire pratiquer par une infirmière à domicile','',0),(20213,10109,'maladies_intercurrentes','Aérsoslthérapie BRICANYL m et s ','',0),(20214,10109,'maladies_intercurrentes','Aérsolthérapie BUDESONIDE 1mg/2 ml m et s avec rinçage ','',0),(20215,10109,'maladies_intercurrentes','Dimanche et jours feriés compris ','',0),(20216,10110,'maladies_intercurrentes','Radiographie thoracique','',0),(20217,10111,'maladies_intercurrentes','Radiographie thoracique','',0),(20218,10112,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s',0),(20219,10113,'maladies_intercurrentes','Oxygène thérapie de courte durée ','',0),(20220,10113,'maladies_intercurrentes','2L/mn','',0),(20221,10114,'maladies_intercurrentes','KmnO4 Permanganate de potassium ','2 btes avec pllusieurs sachets',0),(20222,10114,'maladies_intercurrentes','1 sachet ds 1 bol d','',0),(20223,10114,'maladies_intercurrentes','Y tremper plusieurs  compresses ','',0),(20224,10114,'maladies_intercurrentes','Pour nettoyer les vesicules et laisser sur place m et s 30 mns.','',0),(20225,10114,'maladies_intercurrentes','Compresses steriles ','3 btes ',0),(20226,10115,'maladies_intercurrentes','EUCALYPTINE LE BRUN, sirop','1 cuil mesure le s ',0),(20227,10116,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','en IM a1 amp',0),(20228,10117,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20229,10117,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(20230,10118,'maladies_intercurrentes','Magnesium marin 2 cp/j','',0),(20233,10120,'maladies_intercurrentes','NFS-Plaquettes','',0),(20234,10120,'maladies_intercurrentes','IgE Totales','',0),(20235,10121,'maladies_intercurrentes','Seretide 250 1 B m et s','',0),(20236,10121,'maladies_intercurrentes','Chambre','',0),(20237,10121,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer','le soir au couucher',0),(20238,10122,'maladies_intercurrentes','Radiographie thoracique','',0),(20239,10122,'maladies_intercurrentes','TDM des sinus','',0),(20240,10123,'maladies_intercurrentes','NFS-Plaquettes','',0),(20241,10123,'maladies_intercurrentes','IgE Totales','',0),(20242,10124,'maladies_intercurrentes','Seretide 250 1 B m et s','',0),(20243,10124,'maladies_intercurrentes','Chambre','',0),(20244,10124,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer','',0),(20245,10125,'maladies_intercurrentes','NFS-Plaquettes','',0),(20246,10125,'maladies_intercurrentes','TP','',0),(20247,10125,'maladies_intercurrentes','TCA','',0),(20248,10126,'maladies_intercurrentes','Loxen LP 50 mg m et s avant les repas','',0),(20249,10127,'maladies_intercurrentes','RAST aux trophallergènes','',0),(20250,10128,'maladies_intercurrentes','TDM des sinus','',0),(20251,10129,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j',0),(20252,10129,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(20253,10130,'maladies_intercurrentes','TDM des sinus','',0),(20254,10131,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie ','',0),(20255,10131,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2ml m et s avec rinçage','',0),(20256,10131,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(20257,10132,'maladies_intercurrentes','TDM thoracique sans injection ','',0),(20258,10133,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 amp en IM',0),(20259,10134,'maladies_intercurrentes','Radiographie thoracique','',0),(20260,10135,'maladies_intercurrentes','NFS-Plaquettes','',0),(20261,10135,'maladies_intercurrentes','IgE Totales','',0),(20262,10136,'maladies_intercurrentes','Seretide 250 1B m et s avec rinçage','',0),(20263,10136,'maladies_intercurrentes','Chambre d\'inhalation','',0),(20264,10136,'maladies_intercurrentes','SINGULAIR 5 mg, comprimé à croquer le s ','',0),(20265,10137,'maladies_intercurrentes','TDM des sinus','',0),(20266,10137,'maladies_intercurrentes','Panorex dentaire','',0),(20267,10138,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthérapie avec un kit','',0),(20268,10138,'maladies_intercurrentes','Aérsololthérapie BUDESONIDE 1 mg/2ml m et s pendant 15 jrs ','',0),(20269,10140,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine/j',0),(20270,10140,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(20271,10141,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','en IM',0),(20272,10141,'maladies_intercurrentes','Spioloto 2 B consécutives','',0),(20273,10141,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé X3/semaine','',0),(20274,10142,'maladies_intercurrentes','ECBC examen Cyto Bacteriologique des crachats','',0),(20275,10143,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 bte',0),(20276,10144,'maladies_intercurrentes','Glycémie à jeun','',0),(20277,10144,'maladies_intercurrentes','HbA1C','',0),(20278,10144,'maladies_intercurrentes','Urée/Creatinine/MDRL','',0),(20279,10144,'maladies_intercurrentes','ASAT/ALAT','',0),(20281,10145,'maladies_intercurrentes','SYMBICORT TURBUHALER 400/12 microgrammes/dose, poudre pour inhalation','2 B m et s ',0),(20282,10145,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(20283,10146,'maladies_intercurrentes','EXACYL 1 g/10 ml, solution buvable',' 1 amp X4/j',0),(20284,10147,'maladies_intercurrentes','Urée/creatinine','',0),(20285,10147,'maladies_intercurrentes','MDRD','',0),(20286,10148,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(20287,10149,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20288,10149,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(20289,10150,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(20290,10150,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine/j',0),(20291,10150,'maladies_intercurrentes','LAROSCORBINE 1 g, comprimé effervescent','le m ',0),(20292,10150,'maladies_intercurrentes','Amoxicilline 1 g X3/j','',0),(20293,10150,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s pdt 3 mois ',0),(20294,10151,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s',0),(20295,10151,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j',0),(20296,10152,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','1 amp en IM',0),(20297,10152,'maladies_intercurrentes','PNEUMOVAX en flacon. Vaccin pneumococcique polyosidique','1 amp en IM à fairedans 3 mois ',0),(20298,10153,'maladies_intercurrentes','ESOMEPRAZOLE ACTAVIS 40 mg, gélule gastro-résistante','m et s',0),(20299,10153,'maladies_intercurrentes','Amoxicilline 1gX3/j','',0),(20300,10153,'maladies_intercurrentes','CLARITHROMYCINE ABBOTT 500 mg, comprimé pelliculé','2cp m et s',0),(20301,10153,'maladies_intercurrentes','Metronidazole 1.5 g/j soit 3 cp à 500mg/j','',0),(20302,10154,'maladies_intercurrentes','Radiographie thoracique','',0),(20303,10155,'maladies_intercurrentes','TDM thoracique','',0),(20304,10156,'maladies_intercurrentes','Augmentin 1 g X3/j pendant 7 jrs','',0),(20305,10156,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule 1 gel X2/j peendant 7 jrs','',0),(20306,10156,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s pdt 7 jrs',0),(20307,10156,'maladies_intercurrentes','PREVENAR 13 suspension injectable Vaccin pneumococcique polyosidique conjugué (13-valent, adsorbé)','dans 15 jrs.',0),(20308,10157,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s ',0),(20309,10157,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine/j',0),(20310,10158,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20311,10158,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(20312,10158,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j pdt 1 mois',0),(20313,10158,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','gargarisme m et s pdt 15 jrs ',0),(20314,10159,'maladies_intercurrentes','Amoxicilline 1G X3/j pendant 5 jrs ','',0),(20315,10159,'maladies_intercurrentes','ULTRALEVURE 200 mg, gélule','1 gel pdt 5 jrs',0),(20316,10159,'maladies_intercurrentes','SERETIDE 250 microgrammes/25 microgrammes/dose, suspension pour inhalation en flacon pressurisé B m et s avec rinçage ','',0),(20317,10159,'maladies_intercurrentes','Chambre d\'inhalation ','',0),(20318,10160,'maladies_intercurrentes','PSA ','',0),(20319,10160,'maladies_intercurrentes','Rapport Libre /total','',0),(20320,10161,'maladies_intercurrentes','Relvar ellipta 184/22 1 B /j avec rinçage','',0),(20321,10161,'maladies_intercurrentes','Spiolto 2 B consécutives ','',0),(20322,10162,'maladies_intercurrentes','TDM thoracique sans injection','',0),(20323,9762,'maladies_intercurrentes','BIOCALYPTOL 6,55 mg/5 ml SANS SUCRE, sirop édulcoré à la saccharine sodique et au maltitol liquide',' cuil mesure/j',0),(20324,9762,'maladies_intercurrentes','Kmno4 Permanganate de K 1 sachet ds 1 cuvette d','',0),(20325,9762,'maladies_intercurrentes','DACRYOSERUM, solution pour lavage oculaire','1/j',0),(20326,10163,'maladies_intercurrentes','Kinésiethérapie respiratoire TVD ','',0),(20327,10163,'maladies_intercurrentes','3 séances / semaine','',0),(20328,10164,'maladies_intercurrentes','TDM sans injection','',0),(20329,10165,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1cp X3/semaine',0),(20330,10165,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(20331,10165,'maladies_intercurrentes','Relvcar Ellipta 184/22 1 B/j avec rinçage','',0),(20332,10166,'maladies_intercurrentes','TDM thoraco abdominal','',0),(20333,10167,'maladies_intercurrentes','ZITHROMAX 250 mg, comprimé pelliculé','1 cp X3/semaine',0),(20334,10167,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20335,10167,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(20336,10168,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20337,10168,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(20338,10169,'maladies_intercurrentes','TSH','',0),(20339,10169,'maladies_intercurrentes','T3/T4','',0),(20340,9891,'maladies_intercurrentes','AERIUS 5 mg, comprimé pelliculé','1 cp le s ',0),(20341,9891,'maladies_intercurrentes','AVAMYS 27,5 microgrammes/pulvérisation, suspension pour pulvérisation nasale','2 pulv ds chq narine /j',0),(20342,10170,'maladies_intercurrentes','NFS - Plaquettes','',0),(20343,10170,'maladies_intercurrentes','IgE totales','',0),(20344,10171,'maladies_intercurrentes','TDM thoracique sans injection ','',0),(20345,10172,'maladies_intercurrentes','Relvar ellipta 184/22 1 B /j avec rinçage','',0),(20346,10173,'maladies_intercurrentes','Relvar ellipta 184/22 1 B/j avec rinçage','',0),(20347,10173,'maladies_intercurrentes','Spiolto 2 B consécutives','',0),(20348,10173,'maladies_intercurrentes','Aérosolthérapie BUDESONIDE 1 mg/2 ml m e s avec rinçage','',0),(20349,10173,'maladies_intercurrentes','Location d\'un appareil d\'aérosolthyérapie avec un kit et masque bucco facial','',0),(20350,10175,'affection_exonorante','PROZAC 20 mg, comprimé dispersible sécable','1/j',0),(20351,10175,'affection_exonorante','EFFERALGAN 1 g, comprimé effervescent','3/j',0),(20352,10175,'maladies_intercurrentes','KARDEGIC 75 mg, poudre pour solution buvable en sachet-dose','1/j',0),(20353,10175,'maladies_intercurrentes','FLECAÏNE L.P. 100 mg, gélule à libération prolongée','1/j',0),(20354,10176,'maladies_intercurrentes','KARDEGIC 75 mg, poudre pour solution buvable en sachet-dose','1/j',0),(20355,10177,'maladies_intercurrentes','','',0),(20356,10178,'maladies_intercurrentes','AMOXICILLINE ACIDE CLAVULANIQUE MYLAN 1g/200mg ADULTES, poudre pour solution injectable','1g*3 ',0),(20357,10178,'maladies_intercurrentes','PAROEX 0,12 POUR CENT, solution pour bain de bouche','1 bb m et s',0),(20358,10179,'maladies_intercurrentes','AMOXICILLINE ALMUS 1 g, comprimé pelliculé dispersible','3g/j soit 1gx3',0),(20359,10179,'maladies_intercurrentes','BETADINE 10 POUR CENT, solution pour bain de bouche','1',0);

--
-- Table structure for table `papeterie_contact`
--

CREATE TABLE `papeterie_contact` (
  `id_papeterie_contact` int(11) NOT NULL AUTO_INCREMENT,
  `titre` varchar(20) NOT NULL,
  `nom` varchar(100) NOT NULL,
  `prenom` varchar(100) NOT NULL,
  `telephone` varchar(30) NOT NULL,
  `fax` varchar(30) NOT NULL,
  `email` varchar(100) NOT NULL,
  `qualite_ligne_1` varchar(100) NOT NULL,
  `qualite_ligne_2` varchar(100) NOT NULL,
  `qualite_ligne_3` varchar(100) NOT NULL,
  `qualite_ligne_cv_1` varchar(100) NOT NULL,
  `qualite_ligne_cv_2` varchar(100) NOT NULL,
  `qualite_ligne_cv_3` varchar(100) NOT NULL,
  `qualite_ligne_cv_4` varchar(100) NOT NULL,
  `qualite_ligne_cv_5` varchar(100) NOT NULL,
  `qualite_ligne_cv_6` varchar(100) NOT NULL,
  `lieu_cv_1` varchar(100) NOT NULL,
  `lieu_cv_2` varchar(100) NOT NULL,
  `QRCode` enum('recto','verso') NOT NULL,
  PRIMARY KEY (`id_papeterie_contact`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `papeterie_contact`
--

INSERT INTO `papeterie_contact` VALUES (1,'Docteur','TANGUY','Bernard','02 62 41 77 53','0 970 630 637','bmtanguy@gmail.com','Médaille d\'Argent de l\'Académie Nationale de Médecine','Ancien chef de Service au CHU de BellePierre','Médecin Honoraire des Hôpitaux','Pneumologue','Médaille d\'Argent de l\'Académie Nationale de Médecine','Ancien chef de Service au CHU de BellePierre','Médecin Honoraire des Hôpitaux','Membre de la Société de Pneumologie de Langue Française','Membre de l\'European Respiratory Society','49, allée des Topazes','97400 Saint-Denis','verso'),(2,'','IMBOLA','Patrick','0692 27 51 37','','','','','','patrickijp2018@outlook.fr','','','','','','','','recto');

--
-- Table structure for table `params`
--

CREATE TABLE `params` (
  `id_param` varchar(40) NOT NULL DEFAULT '',
  `texte` text NOT NULL,
  `commentaire` text NOT NULL,
  PRIMARY KEY (`id_param`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `params`
--

INSERT INTO `params` VALUES ('AM','971404397',''),('commentaire','Vous êtes prié d’apporter vos attestations de prise en charge\r\n(Carte vitale, mutuelle, CMU, attestation ALD).\r\nEn cas d’empêchement, veuillez nous contacter 48h avant le rendez-vous','Commentaire ligne 2'),('delai_mois_entre_2_efr','4','Délai en mois entre 2 EFR'),('entete','Ancien chef de service au CHU de Bellepierre\r\nAncien Médecin des Hôpitaux\r\n8, allée des Turquoises 97400 SAINT DENIS\r\nTéléphone : 02 62 21 10 23',''),('lettre_debut','Cher confrère','Début de la lettre'),('lettre_fin','Confraternellement,','Fin de lettre'),('lieu','49, allée des Topazes 97400 Saint-Denis (en face du CHU)','Lieu'),('nom_docteur','Bernard TANGUY','Nom du docteur'),('pantone_enveloppe','363','Couleur 1'),('qualite_ligne_1','Médaille d\'Argent de l\'Académie Nationale de Médecine',''),('qualite_ligne_2','Ancien chef de Service au CHU de BellePierre',''),('qualite_ligne_3','Médecin Honoraire des Hôpitaux',''),('RPPS','10002317096',''),('specialite','Pneumologue','Spécialité'),('telephone_1','02 62 41 77 53','Téléphone 1'),('telephone_2','','Téléphone 2');

--
-- Table structure for table `paris_metro`
--

CREATE TABLE `paris_metro` (
  `numero` int(11) NOT NULL,
  `text_color` char(7) NOT NULL,
  `background_color` char(7) NOT NULL,
  PRIMARY KEY (`numero`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `paris_metro`
--

INSERT INTO `paris_metro` VALUES (1,'#000000','#F2C931'),(2,'#FFFFFF','#216EB4'),(3,'#FFFFFF','#9A9940'),(4,'#FFFFFF','#BB4D98'),(5,'#000000','#FF8B53'),(6,'#000000','#79BB92'),(7,'#000000','#DF9AB1'),(8,'#000000','#C5A3CA'),(9,'#000000','#CDC83F'),(10,'#000000','#DFB039'),(11,'#FFFFFF','#8E6538'),(12,'#FFFFFF','#328E5B'),(13,'#000000','#89C7D6'),(14,'#FFFFFF','#67328E'),(15,'#FFFFFF','#A90F32'),(16,'#FFFFFF','#EC7CAE'),(17,'#FFFFFF','#95BF32');

--
-- Table structure for table `personnel_conges`
--

CREATE TABLE `personnel_conges` (
  `id_personnel_conge` int(11) NOT NULL AUTO_INCREMENT,
  `id_personnel` int(11) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `datetime_debut` datetime NOT NULL,
  `datetime_fin` datetime NOT NULL,
  PRIMARY KEY (`id_personnel_conge`),
  KEY `id_personnel` (`id_personnel`),
  CONSTRAINT `personnel_conges_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=343 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_conges`
--

INSERT INTO `personnel_conges` VALUES (1,1,'Congrès','2014-03-10 00:00:00','2014-03-16 23:59:00'),(2,4,'Congés - Paris','2014-03-17 00:00:00','2014-03-23 23:59:00'),(3,1,'Congrès','2014-04-16 00:00:00','2014-04-20 23:59:00'),(4,2,'Congés','2014-04-23 00:00:00','2014-05-05 23:59:00'),(5,1,'Congrès SAV','2014-06-10 00:00:00','2014-06-16 23:59:00'),(6,6,'Assemblée Régionale','2014-07-18 00:00:00','2014-07-20 23:59:00'),(7,1,'Assemblée Régionale','2014-07-18 00:00:00','2014-07-20 23:59:00'),(8,2,'Assemblée Régionale','2014-07-18 00:00:00','2014-07-20 23:59:00'),(9,3,'Assemblée Régionale','2014-07-18 00:00:00','2014-07-20 23:59:00'),(10,3,'Permis de Conduire ;)','2014-08-07 00:00:00','2014-08-07 23:59:00'),(11,1,'Voyage MRU','2014-09-05 00:00:00','2014-09-07 23:59:00'),(12,6,'Dec2014 - Jan2015','2014-12-13 00:00:00','2015-01-11 23:59:00'),(13,3,'COGOHR','2014-09-15 00:00:00','2014-09-16 23:59:00'),(14,6,'Dentiste','2014-11-10 13:00:00','2014-11-10 18:00:00'),(15,6,'COGOHR','2014-09-15 00:00:00','2014-09-16 23:59:00'),(16,4,'Dec2014 - Jan2015 ','2014-12-13 00:00:00','2015-01-11 23:59:00'),(17,1,'La Rochelle / Paris / Nancy','2014-10-17 00:00:00','2014-10-22 23:59:00'),(18,1,'congrès spoi','2014-11-25 00:00:00','2014-11-28 23:59:00'),(19,1,'Congrès SPLF','2015-01-29 00:00:00','2015-02-04 23:59:00'),(20,2,'Voyage Nancy','2015-02-07 00:00:00','2015-02-26 23:59:00'),(21,2,'cs Dr Desgane niveau 4piece d\'identité, justificatif d\'adresse','2015-03-04 10:20:00','2015-03-04 11:20:00'),(22,6,'Formation sommeil','2015-06-13 00:00:00','2015-06-20 23:59:00'),(23,2,'Dentiste Akoon','2015-04-10 15:45:00','2015-04-10 16:45:00'),(24,6,'Formation AFGSU1','2015-08-27 00:00:00','2015-08-28 23:59:00'),(25,1,'Assemblée Régionale 2015','2015-07-24 00:00:00','2015-07-26 23:59:00'),(27,6,'Assemblée Régionale 2015','2015-07-24 00:00:00','2015-07-26 23:59:00'),(28,2,'Assemblée Régionale 2015','2015-07-24 00:00:00','2015-07-26 23:59:00'),(29,1,'congés pré-assemblée 2015','2015-07-23 00:00:00','2015-07-23 23:59:00'),(30,2,'congés pré-assemblée 2015','2015-07-23 00:00:00','2015-07-23 23:59:00'),(31,6,'congés pré-assemblée 2015','2015-07-23 00:00:00','2015-07-23 23:59:00'),(32,1,'congés post-assemblée 2015','2015-07-27 00:00:00','2015-07-27 23:59:00'),(33,2,'congés post-assemblée 2015','2015-07-27 00:00:00','2015-07-27 23:59:00'),(34,6,'congés post-assemblée 2015','2015-07-27 00:00:00','2015-07-27 23:59:00'),(35,2,'Formation AFGSU2','2015-09-16 00:00:00','2015-09-18 23:59:00'),(36,1,'Voyage Ile Maurice','2015-05-07 00:00:00','2015-05-10 23:59:00'),(37,3,'été 2015','2015-07-13 00:00:00','2015-07-26 23:59:00'),(38,6,'Dentiste','2015-05-18 14:30:00','2015-05-18 16:30:00'),(39,2,'Kiné','2015-05-26 15:00:00','2015-05-26 16:00:00'),(40,6,'Dentiste','2015-05-29 09:45:00','2015-05-29 11:45:00'),(41,6,'Semaine spéciale','2015-06-23 00:00:00','2015-06-28 23:59:00'),(42,2,'Dentiste','2015-06-25 14:45:00','2015-06-11 16:30:00'),(43,1,'Centre de Reeducation Fonctionnel - Bohringer','2015-06-25 13:00:00','2015-06-25 23:59:00'),(44,1,'RV Anesthésiste','2015-07-03 09:00:00','2015-07-03 10:30:00'),(47,2,'Rdv savs indispensable','2015-07-31 08:00:00','2015-07-31 13:05:00'),(48,2,'kiné','2015-07-17 10:30:00','2015-07-17 12:00:00'),(49,2,'kiné','2015-07-20 16:00:00','2015-07-20 16:30:00'),(50,6,'pas de rdv le jeudi matin','2015-09-24 00:00:00','2015-09-24 13:00:00'),(51,1,'ERS','2015-09-25 00:00:00','2015-10-04 23:59:00'),(53,1,'Congrès SPOI Tana','2015-12-09 00:00:00','2015-12-11 23:59:00'),(54,1,'AztraZeneca - Diabete et SAS','2015-10-08 16:30:00','2015-10-08 23:59:00'),(55,1,'Rdv Dr. Fremont','2015-08-28 09:00:00','2015-08-28 12:00:00'),(56,2,'Congrès SPOI Tana','2015-12-09 00:00:00','2015-12-11 23:59:00'),(57,2,'kine','2015-08-17 15:00:00','2015-08-17 15:30:00'),(58,2,'kiné','2015-08-24 15:00:00','2015-08-24 15:30:00'),(59,2,'kiné','2015-08-31 15:00:00','2015-08-31 15:30:00'),(60,1,'Arpentage terrain Jean Claude','2015-08-27 13:00:00','2015-08-27 14:00:00'),(61,1,'Rendez vous préparation de la Réunion du 8 octobre Dr. SOUYRIS 0262 94 12 88','2015-09-17 14:00:00','2015-09-17 15:00:00'),(62,6,'Congrès Sommeil Nantes','2015-11-16 00:00:00','2015-11-22 23:59:00'),(63,6,'Semaine spéciale, juin 2016','2016-05-31 00:00:00','2016-06-03 23:59:00'),(64,2,'dentiste','2015-08-27 14:00:00','2015-08-27 15:00:00'),(65,1,'kiné guéselin','2015-08-24 17:30:00','2015-08-24 18:00:00'),(66,1,'Kiné La Source','2015-09-08 17:00:00','2015-09-08 18:00:00'),(67,2,'Entretien infirmier','2015-09-15 13:40:00','2015-09-15 14:15:00'),(68,1,'kiné','2015-10-08 17:00:00','2015-10-08 18:00:00'),(69,1,'kiné','2015-10-09 17:00:00','2015-10-09 18:00:00'),(70,6,'Convocation : entretien infirmier','2015-10-22 13:00:00','2015-10-22 14:00:00'),(71,1,'CS Vaccination Madagascar','2015-10-26 11:50:00','2015-10-26 12:20:00'),(72,2,'CS Vaccin Madagas...','2015-10-26 11:30:00','2015-10-26 12:00:00'),(73,1,'semaine spéciale','2015-11-17 08:00:00','2015-10-25 18:59:00'),(74,1,'Dentiste','2015-11-06 12:45:00','2015-11-06 14:15:00'),(75,3,'Marche','2015-12-14 00:00:00','2015-12-14 23:59:00'),(76,1,'prédication salle','2015-11-20 16:00:00','2015-11-20 16:00:00'),(78,1,'kine','2015-10-30 10:00:00','2015-10-30 11:00:00'),(82,1,'kine','2015-11-05 17:00:00','2015-11-05 18:00:00'),(84,1,'kiné','2015-11-06 17:00:00','2015-11-06 18:00:00'),(86,2,'kiné','2015-10-27 15:00:00','2015-10-27 16:00:00'),(88,1,'kine','2015-11-03 17:00:00','2015-11-03 18:00:00'),(89,1,'kine','2015-11-10 17:00:00','2015-11-10 17:00:00'),(90,1,'kine','2015-11-12 17:30:00','2015-11-12 18:00:00'),(91,1,'kine','2015-11-13 17:00:00','2015-11-13 18:00:00'),(92,2,'WAI HOI','2015-12-18 00:00:00','2015-12-18 10:30:00'),(93,1,'CLH','2016-01-20 14:00:00','2016-01-20 23:59:00'),(94,1,'CPLH','2016-01-28 00:00:00','2016-02-02 23:59:00'),(95,6,'Congrès SFRMS, Strasbourg','2016-11-11 11:00:00','2016-11-20 20:20:00'),(96,1,'ERS, London','2016-09-03 00:00:00','2016-09-09 23:59:00'),(97,1,'Congrès SAV, La Rochelle - Quelle machine, quel réglage et accessoires','2016-06-16 00:00:00','2016-06-18 23:59:00'),(98,6,'La pratique de polygraphie et de la polysomnographie, Briancon','2016-02-29 00:00:00','2016-03-07 12:00:00'),(100,1,'soins dentaires','2016-01-11 16:40:00','2016-01-11 17:30:00'),(101,6,'apprentissage CIDELEC - SOS Oxy','2016-02-03 00:00:00','2016-02-03 23:59:00'),(102,1,'Assemblée District','2016-07-07 08:00:00','2016-07-10 23:00:00'),(103,2,'coiffeur','2016-01-15 16:00:00','2016-01-15 23:59:00'),(104,1,'Drentiste','2016-02-26 12:00:00','2016-02-26 15:00:00'),(105,2,'Rhumatholoque 23 J AUBERT F 21 65 34','2016-02-12 10:15:00','2016-02-12 12:00:00'),(106,6,'Dentiste','2016-03-18 00:00:00','2016-03-18 13:00:00'),(108,2,'Congés en métro Pierre','2016-04-30 06:45:00','2016-05-13 19:30:00'),(109,2,'prédication','2016-03-10 13:10:00','2016-03-10 15:15:00'),(110,2,'Prédication','2016-03-17 13:30:00','2016-03-17 15:15:00'),(112,1,'Cs O^phtalmo Dr villeroy','2016-04-06 11:00:00','2016-04-06 11:29:00'),(113,1,'Cs stomato Dr Vives','2016-04-15 11:31:00','2016-04-15 12:00:00'),(114,6,'Dentiste','2016-04-07 11:00:00','2016-04-07 14:30:00'),(115,6,'code','2016-05-25 14:00:00','2016-05-26 14:30:00'),(117,1,'Férié','2016-07-14 08:00:00','2016-07-14 18:00:00'),(118,1,'nouvellle locataire','2016-04-29 11:00:00','2016-04-29 12:00:00'),(119,6,'Dentiste','2016-09-02 08:00:00','2016-09-02 12:00:00'),(121,1,'vacances à Maurice','2016-07-14 08:00:00','2016-07-17 20:00:00'),(122,6,'prédication','2016-06-23 08:00:00','2016-06-23 23:59:00'),(123,1,'ass cir  ','2016-11-04 00:00:00','2016-11-05 23:59:00'),(126,2,'TPS','2016-08-01 14:15:00','2016-08-01 16:30:00'),(127,2,'TPS','2016-08-08 14:15:00','2016-08-08 17:00:00'),(128,1,'LONDRES','2016-09-02 08:00:00','2016-09-02 23:59:00'),(129,1,'congrès SPOI','2016-11-30 08:00:00','2016-12-03 20:20:00'),(130,1,'Fête Cafre','2016-12-20 08:00:00','2016-12-20 18:00:00'),(131,1,'RV Avocat','2016-09-15 16:35:00','2016-09-15 18:00:00'),(132,1,'TAMADOUM','2016-10-06 17:00:00','2016-10-06 18:30:00'),(133,2,'TPS','2016-09-25 16:00:00','2016-09-25 17:00:00'),(134,2,'TPS','2016-10-01 10:00:00','2016-10-01 11:00:00'),(135,1,'Kiné','2016-09-23 07:00:00','2016-09-23 07:30:00'),(136,5,'Congés','2016-12-19 08:30:00','2016-12-19 16:30:00'),(137,2,'dr Le Goc','2016-09-30 10:30:00','2016-09-30 23:59:00'),(138,2,'Dentiste','2016-10-24 15:45:00','2016-10-24 23:01:00'),(140,1,'SEMAINE SPÉCIALE','2017-02-02 00:00:00','2017-02-05 23:59:00'),(141,1,'Dominyc0262 204 402','2016-10-14 10:30:00','2016-10-14 11:45:00'),(142,2,'TPS','2016-10-26 15:00:00','2016-10-26 16:00:00'),(143,2,'séjour métropole','2017-02-06 00:00:00','2017-02-16 23:59:00'),(144,1,'congrès Strasbourg','2016-11-11 11:00:00','2016-11-19 20:20:00'),(146,5,'Congé réunion pour formation','2017-01-30 09:05:00','2017-01-30 15:30:00'),(147,6,'SAA - Semaine d\'Activité Acrue','2017-01-18 08:00:00','2017-01-22 17:00:00'),(148,1,'Congres CPLF Marseille','2017-01-26 08:00:00','2017-01-29 17:00:00'),(149,2,'mammographie : Mascarel','2017-01-23 07:45:00','2017-01-23 08:45:00'),(150,1,'Mémorial','2017-04-11 08:05:00','2017-04-11 17:00:00'),(151,6,'Rdv ophtalmo','2017-03-15 10:00:00','2017-03-15 13:00:00'),(152,6,'SAA','2017-05-24 00:00:00','2017-05-28 23:59:00'),(154,2,'Assemblée Régionale','2017-08-03 00:00:00','2017-08-07 23:59:00'),(155,6,'Assemblée Régionale','2017-08-03 00:00:00','2017-08-07 23:59:00'),(157,1,'Allergo Nancy NATA Florence','2017-04-17 00:00:00','2017-04-23 23:59:00'),(158,1,'jour férié','2017-06-05 00:00:00','2017-06-05 23:59:00'),(159,1,'Victoire 1945','2017-05-08 00:00:00','2017-05-08 23:30:00'),(160,5,'Rv médical important','2017-03-23 08:28:00','2017-03-23 16:30:00'),(161,1,'14 Juillet','2017-07-14 14:00:00','2017-07-14 17:15:00'),(163,1,'départ en métropole','2017-06-14 08:00:00','2017-06-16 23:59:00'),(164,1,'A Maurice et Eléonore','2017-05-05 10:15:00','2017-05-05 11:00:00'),(165,2,'dentiste','2017-05-10 15:00:00','2017-05-10 17:00:00'),(166,2,'dentiste','2017-05-17 15:00:00','2017-05-17 17:00:00'),(167,2,'dentiste','2017-05-24 15:00:00','2017-05-24 17:00:00'),(168,2,'dentiste','2017-05-31 15:00:00','2017-05-31 17:00:00'),(169,1,'congès métropole','2017-04-24 08:30:00','2017-04-24 12:00:00'),(170,2,'dentiste','2017-06-07 15:00:00','2017-06-07 17:00:00'),(171,2,'ORL','2017-04-27 14:30:00','2017-04-27 17:00:00'),(172,5,'Congés du à l\'absence  du Dr Tanguy','2017-04-19 09:00:00','2017-04-21 16:30:00'),(174,1,'départ maurice , éléonore','2017-05-25 22:30:00','2017-05-25 23:59:00'),(176,2,'kine','2017-05-11 10:00:00','2017-05-11 10:30:00'),(177,2,'Radio Masc','2017-05-10 09:30:00','2017-05-10 10:30:00'),(189,2,'Scanner Rocher ','2017-06-01 16:00:00','2017-06-01 17:00:00'),(193,2,'KINE','2017-06-15 17:00:00','2017-06-15 17:30:00'),(194,1,'SEPRODOM','2017-06-28 15:30:00','2017-06-28 16:00:00'),(195,1,'SEPRODOM','2017-06-28 15:30:00','2017-06-28 16:00:00'),(197,1,'ERS Milan','2017-09-11 08:30:00','2017-09-15 23:59:00'),(198,6,'Code','2017-07-20 00:00:00','2017-07-20 13:00:00'),(199,1,'Consultation','2017-08-11 15:45:00','2017-08-11 16:15:00'),(202,6,'Congés Août 2017','2017-08-29 12:30:00','2017-08-31 20:00:00'),(204,5,'Acte dentaire','2017-08-09 10:30:00','2017-08-09 16:00:00'),(205,1,'Congrès Quebec','2017-10-10 00:00:00','2017-10-20 23:59:00'),(206,6,'Congrès Quebec','2017-10-10 00:00:00','2017-10-20 23:59:00'),(207,1,'','2017-08-16 08:00:00','2017-08-17 18:00:00'),(208,1,'Congrès Bordeaux','2017-08-16 08:00:00','2017-08-17 18:00:00'),(211,1,'Spoi Inde','2017-11-27 00:00:00','2017-12-03 23:59:00'),(213,2,'SPOI Inde','2017-11-28 00:00:00','2017-12-05 23:59:00'),(214,1,'Cours Sommeil','2017-11-16 00:00:00','2017-11-17 23:59:00'),(216,2,'Visite médicale','2017-11-13 10:30:00','2017-11-13 12:00:00'),(217,2,'ORTHO','2017-11-16 14:00:00','2017-11-16 15:00:00'),(218,1,'jour férié','2017-12-20 07:00:00','2017-12-20 23:59:00'),(219,1,'jour férié','2017-12-20 07:00:00','2017-12-20 23:59:00'),(220,1,'entretien mr Boyer sur l\'asthme','2017-12-18 10:30:00','2017-12-18 11:15:00'),(221,1,'cgss','2017-12-14 08:00:00','2017-11-14 14:00:00'),(222,6,'Vacances à Mayotte','2018-05-06 00:00:00','2018-05-15 23:59:00'),(223,1,'Formation Acachon','2018-01-18 00:00:00','2018-01-19 23:59:00'),(224,1,'féte du travail','2018-05-01 00:00:00','2018-05-01 23:59:00'),(225,1,'Lundi de Pâques','2018-04-02 00:00:00','2018-04-02 23:59:00'),(226,1,'VICTOIRE 45','2018-05-08 00:00:00','2018-05-08 23:59:00'),(227,1,'VICTOIRE 45','2018-05-08 00:00:00','2018-05-08 23:59:00'),(228,1,'Pont du 1er mai.','2018-04-30 00:00:00','2018-04-30 23:59:00'),(229,1,'Pont du 1er mai.','2018-04-30 00:00:00','2018-04-30 23:59:00'),(230,6,'Réunion spécial pionniers','2018-03-30 00:00:00','2018-03-30 23:59:00'),(231,2,'Congés Février 2018','2018-02-21 18:00:00','2018-03-07 07:00:00'),(233,1,'St Francois','2018-03-15 14:00:00','2018-03-15 16:00:00'),(235,1,'Voyage','2018-03-19 00:00:00','2018-03-20 23:59:00'),(236,1,'Congé Arcachon','2018-03-22 00:00:00','2018-03-23 23:59:00'),(237,6,'Ecole des pionniers','2018-08-13 12:00:00','2018-08-26 23:59:00'),(238,6,'Assemblée Régionale','2018-07-26 00:00:00','2018-07-30 23:59:00'),(239,1,'Assemblée Régionale','2018-07-26 00:00:00','2018-07-30 23:59:00'),(240,2,'Assemblée Régionale','2018-07-26 00:00:00','2018-07-30 23:59:00'),(241,5,'Assemblée Régionale','2018-07-26 00:00:00','2018-07-30 23:59:00'),(242,1,'','2018-03-29 16:15:00','2018-03-29 23:59:00'),(243,1,'Départ de Maurice','2018-03-29 16:15:00','2018-03-29 23:59:00'),(244,1,'Formation PERIMETRE','2018-06-19 13:00:00','2018-06-23 18:00:00'),(245,6,'Formation PERIMETRE','2018-06-19 13:00:00','2018-06-25 23:59:00'),(246,1,'ASCENSION','2018-05-10 00:00:00','2018-05-10 23:59:00'),(247,1,'lundi de Pentecôte','2018-05-21 00:00:00','2018-05-21 23:59:00'),(248,6,'vacances à Mayotte','2018-05-14 00:00:00','2018-05-14 23:59:00'),(249,1,'Séjour à Maurice','2018-05-17 00:00:00','2018-05-20 23:59:00'),(250,6,'Séjour à Maurice','2018-05-17 00:00:00','2018-05-20 23:59:00'),(251,5,'Séjour à Maurice','2018-05-17 00:00:00','2018-05-20 23:59:00'),(252,1,'Rdv Kemnda','2018-05-22 16:00:00','2018-05-22 23:59:00'),(253,1,'Rdv Dr. BESNARD','2018-05-03 10:30:00','2018-05-03 14:00:00'),(254,1,'Rdv Dr. LEMBA','2018-05-16 11:00:00','2018-05-16 14:00:00'),(255,1,'15/05/2018','2018-05-15 11:30:00','2018-05-15 12:00:00'),(256,1,'15/05/2018','2018-05-15 11:30:00','2018-05-15 12:00:00'),(257,6,'Réunion de préparation à l’AR','2018-06-01 17:30:00','2018-06-01 23:59:00'),(258,1,'Atelier Arcachon','2018-05-31 08:00:00','2018-06-05 18:00:00'),(259,1,'Arcachon','2018-06-04 08:00:00','2018-06-05 14:00:00'),(260,1,'RV dr Veerapen','2018-05-24 13:00:00','2018-05-24 13:30:00'),(261,1,'RV dr Veerapen','2018-05-24 13:00:00','2018-05-24 13:30:00'),(262,1,'RV dr Veerapen','2018-05-24 13:00:00','2018-05-24 13:30:00'),(263,6,'Rdv Ophtamo','2018-07-02 13:00:00','2018-07-02 15:59:00'),(264,1,'Me Cauchepin','2018-07-16 11:00:00','2018-07-16 12:00:00'),(265,1,'Me Cauchepin','2018-07-16 11:00:00','2018-07-16 12:00:00'),(266,1,'Semaine Spéciale','2018-07-19 08:00:00','2018-07-20 23:59:00'),(267,1,'Dr Deganne','2018-07-09 09:00:00','2018-07-09 10:00:00'),(269,2,'Dr DEGANNE','2018-07-09 09:30:00','2018-07-09 10:00:00'),(270,2,'Cs Chd Rhumatologie','2018-11-05 11:30:00','2018-11-05 13:30:00'),(271,1,'Congés Paris ','2018-09-15 08:00:00','2018-09-20 18:00:00'),(272,1,'CPLF','2019-01-23 12:00:00','2019-02-02 23:59:00'),(273,6,'CPLF','2019-01-23 12:00:00','2019-02-02 23:59:00'),(275,1,'SPOI 2018 ','2018-12-04 00:00:00','2018-12-09 20:35:00'),(277,1,'CPLF (suite)','2019-01-28 00:00:00','2019-01-31 23:59:00'),(278,1,'Mémorial','2019-04-19 14:00:00','2019-04-19 20:00:00'),(279,1,'EAA','2019-06-24 00:00:00','2019-06-28 23:59:00'),(280,1,'Consultation anesthésique','2019-03-12 12:00:00','2019-03-12 23:59:00'),(281,1,'Coloscopie - Clinique Ste Clotilde. Dr. Blais','2019-04-01 11:00:00','2019-04-01 23:59:00'),(283,1,'Semaine Spéciale','2019-06-12 00:00:00','2019-06-14 23:59:00'),(284,1,'Crédit Agricole','2019-04-03 15:00:00','2019-04-03 23:59:00'),(285,6,'Crédit Agricole','2019-04-03 15:00:00','2019-04-03 23:59:00'),(286,3,'','2019-04-08 08:00:00','2019-04-04 18:00:00'),(287,3,'Voyage à Maurice.','2019-04-08 08:00:00','2019-04-04 18:00:00'),(288,1,'lundi de Pâques','2019-04-22 00:00:00','2019-04-22 23:59:00'),(289,1,'Anniversaire victoire 1945','2019-05-08 00:00:00','2019-05-08 23:59:00'),(294,1,'ASCENSION','2019-05-30 00:00:00','2019-05-30 23:59:00'),(295,1,'Lundi de Pentecôte','2019-06-10 00:00:00','2019-06-10 23:59:00'),(296,1,'Rdv M. Cauchepin & M. Gaillard','2019-06-03 15:00:00','2019-06-03 23:59:00'),(297,2,'Séjour en France','2019-06-17 08:00:00','2019-07-03 23:00:00'),(299,1,'RV Me MICHEL avec les enfants','2019-07-18 08:30:00','2019-07-18 09:30:00'),(300,1,'Soirée SEPRODOM Hotel Bellepierre','2019-07-18 19:30:00','2019-07-18 20:30:00'),(301,6,'Randonnée','2019-07-29 00:00:00','2019-08-01 00:00:00'),(303,4,'Congrès','2019-07-25 00:00:00','2019-07-29 23:59:00'),(304,1,'vacances avec Maurice','2019-07-09 00:00:00','2019-07-09 23:59:00'),(305,1,'vacance de Maurice à la Réunion','2019-07-09 00:00:00','2019-07-09 23:59:00'),(306,1,'vacance de Maurice à la Réunion','2019-07-19 08:30:00','2019-07-19 23:59:00'),(307,1,'CA','2019-08-12 15:00:00','2019-08-12 18:00:00'),(308,2,'TPS','2019-09-17 09:00:00','2019-09-17 10:00:00'),(309,2,'TPS','2019-09-30 10:00:00','2019-09-30 11:00:00'),(310,1,'RV Me Michel','2019-09-10 15:00:00','2019-08-14 18:59:00'),(311,1,'ERS Madrid','2019-09-28 08:00:00','2019-10-07 12:00:00'),(316,1,'Implant stomato CHU F.Guyon','2019-12-12 08:30:00','2019-12-12 10:00:00'),(317,1,'Congres SPOI','2019-12-05 14:00:00','2019-12-06 23:59:00'),(318,1,'Staff intrestitiel dossier Mme ROBERT Jeanine','2019-10-10 12:30:00','2019-10-10 12:45:00'),(320,1,'Staff intrestitiel dossier Mme ROBERT Jeanine','2019-10-10 12:30:00','2019-10-10 12:45:00'),(322,1,'Formation de Pathologie de sommeil','2019-10-31 00:00:00','2019-11-11 23:59:00'),(323,6,'Formation de Pathologie de sommeil','2019-10-31 00:00:00','2019-11-11 23:59:00'),(325,1,'Cs proctologie','2019-12-26 16:00:00','2019-12-26 23:00:00'),(331,1,'CPLF','2020-01-20 08:00:00','2020-01-31 23:59:00'),(338,1,'Maurice','2019-11-18 16:15:00','2019-11-18 17:00:00'),(339,1,'voyage a l\'Ile Maurice','2019-12-25 08:30:00','2019-12-30 23:59:00'),(340,6,'Réunion pionniers','2020-03-27 00:00:00','2020-03-27 23:59:00'),(341,1,'dentiste','2020-02-27 08:30:00','2020-02-27 12:00:00'),(342,1,'Stage à Angers et à Marseille','2020-03-05 08:00:00','2020-05-29 23:59:00');

--
-- Table structure for table `personnel_conges_cyclique`
--

CREATE TABLE `personnel_conges_cyclique` (
  `id_personnel_conge_cyclique` int(11) NOT NULL AUTO_INCREMENT,
  `id_personnel` int(11) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `date_debut` date NOT NULL,
  `date_fin` date DEFAULT NULL,
  `periodicite` enum('day','week','month') NOT NULL,
  `time_debut` time NOT NULL,
  `time_fin` time NOT NULL,
  PRIMARY KEY (`id_personnel_conge_cyclique`),
  KEY `id_personnel` (`id_personnel`),
  CONSTRAINT `personnel_conges_cyclique_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_conges_cyclique`
--

INSERT INTO `personnel_conges_cyclique` VALUES (1,6,'Matinée du vendredi matin','2019-11-15','2030-06-07','week','08:30:00','12:00:00');

--
-- Table structure for table `personnel_obligatoire_services`
--

CREATE TABLE `personnel_obligatoire_services` (
  `id_personnel` int(11) NOT NULL,
  `id_type_rendez_vous` int(11) NOT NULL,
  PRIMARY KEY (`id_personnel`,`id_type_rendez_vous`),
  KEY `id_service` (`id_type_rendez_vous`),
  CONSTRAINT `personnel_obligatoire_services_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE,
  CONSTRAINT `personnel_obligatoire_services_ibfk_2` FOREIGN KEY (`id_type_rendez_vous`) REFERENCES `type_rendez_vous` (`id_type_rendez_vous`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_obligatoire_services`
--

INSERT INTO `personnel_obligatoire_services` VALUES (1,1),(6,3),(6,4),(6,5);

--
-- Table structure for table `personnel_services`
--

CREATE TABLE `personnel_services` (
  `id_personnel` int(11) NOT NULL,
  `id_service` int(11) NOT NULL,
  PRIMARY KEY (`id_personnel`,`id_service`),
  KEY `id_service` (`id_service`),
  CONSTRAINT `personnel_services_ibfk_2` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE,
  CONSTRAINT `personnel_services_ibfk_3` FOREIGN KEY (`id_service`) REFERENCES `services` (`id_service`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_services`
--

INSERT INTO `personnel_services` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(1,3),(2,3),(3,3),(4,3),(5,3),(6,3),(1,4),(2,4),(3,4),(4,4),(5,4),(6,4),(1,5),(2,5),(3,5),(4,5),(5,5),(6,5),(1,6),(4,6),(7,6),(4,7);

--
-- Table structure for table `personnel_type_rendez_vous`
--

CREATE TABLE `personnel_type_rendez_vous` (
  `id_personnel` int(11) NOT NULL,
  `id_type_rendez_vous` int(11) NOT NULL,
  PRIMARY KEY (`id_personnel`,`id_type_rendez_vous`),
  KEY `id_type_rendez_vous` (`id_type_rendez_vous`),
  CONSTRAINT `personnel_type_rendez_vous_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE,
  CONSTRAINT `personnel_type_rendez_vous_ibfk_2` FOREIGN KEY (`id_type_rendez_vous`) REFERENCES `type_rendez_vous` (`id_type_rendez_vous`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_type_rendez_vous`
--

INSERT INTO `personnel_type_rendez_vous` VALUES (1,3),(1,4),(2,4),(3,4),(4,4),(6,4),(1,5),(2,5),(3,5),(4,5),(6,5);

--
-- Table structure for table `personnel_type_rendez_vous_groupe`
--

CREATE TABLE `personnel_type_rendez_vous_groupe` (
  `id_personnel` int(11) NOT NULL,
  `id_type_rendez_vous_groupe` int(11) NOT NULL,
  PRIMARY KEY (`id_personnel`,`id_type_rendez_vous_groupe`),
  KEY `id_type_rendez_vous_groupe` (`id_type_rendez_vous_groupe`),
  CONSTRAINT `personnel_type_rendez_vous_groupe_ibfk_1` FOREIGN KEY (`id_personnel`) REFERENCES `personnel` (`id_personnel`) ON UPDATE CASCADE,
  CONSTRAINT `personnel_type_rendez_vous_groupe_ibfk_2` FOREIGN KEY (`id_type_rendez_vous_groupe`) REFERENCES `type_rendez_vous_groupe` (`id_type_rendez_vous_groupe`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `personnel_type_rendez_vous_groupe`
--

INSERT INTO `personnel_type_rendez_vous_groupe` VALUES (1,1),(2,1),(3,1),(4,1),(6,1),(1,2),(2,2),(3,2),(4,2),(6,2),(1,3),(2,3),(3,3),(4,3),(6,3),(1,4),(2,4),(4,4),(6,4);

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id_service` int(11) NOT NULL AUTO_INCREMENT,
  `service` varchar(40) NOT NULL,
  `icon` varchar(100) NOT NULL,
  `icon_color` char(6) NOT NULL,
  PRIMARY KEY (`id_service`),
  KEY `service` (`service`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services`
--

INSERT INTO `services` VALUES (1,'home','fa-home','50CBEF'),(2,'recherche','fa-user','5982CF'),(3,'agenda','fa-calendar','E6564E'),(4,'courrier','fa-envelope-o','53B15B'),(5,'gestion','fa-wrench','50CBEF'),(6,'banque','fa-money','598D67'),(7,'admin','fa-cog','CFCFCF');

--
-- Table structure for table `services_menus`
--

CREATE TABLE `services_menus` (
  `id_menu` int(11) NOT NULL AUTO_INCREMENT,
  `id_service` int(11) NOT NULL,
  `menu` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`id_menu`),
  KEY `id_service` (`id_service`),
  CONSTRAINT `services_menus_ibfk_1` FOREIGN KEY (`id_service`) REFERENCES `services` (`id_service`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services_menus`
--

INSERT INTO `services_menus` VALUES (1,1,'Home','/cabinet/home/index.php'),(4,2,'Recherche','/cabinet/consultations/index.php'),(5,3,'Agenda','/cabinet/agenda/index.php'),(7,4,'Courrier medecin','/cabinet/medecins/courrier/index.php'),(8,5,'Statistiques','/cabinet/gestion/statistiques/index.php'),(9,5,'Actes','/cabinet/gestion/actes/index.php'),(10,5,'Médicaments','/cabinet/gestion/medicaments/index.php'),(11,5,'Alertes EFR','/cabinet/gestion/alertes/alertes_EFR.php'),(12,5,'Vos feuillets','/cabinet/gestion/vos_feuillets/index.php?id_papeterie_contact=1'),(13,5,'Paramètres','/cabinet/gestion/parametres/parametres/index.php'),(14,5,'Mutelles','/cabinet/gestion/mutuelles/index.php'),(15,5,'Congés','/cabinet/gestion/conges/index.php'),(16,5,'Doublons / Intellio','/cabinet/gestion/intellio/index.php?date_consultation%5B0%5D=1'),(17,6,'Comptes bancaires','/cabinet/comptes_bancaires/index.php'),(18,7,'Monitoring',''),(19,7,'Bibliothèques','/cabinet/admin/libraries/index.php'),(20,7,'Documentation','/cabinet/documentation/index.php'),(21,7,'Services / Menus','/cabinet/admin/menus/index.php'),(22,7,'Base de données','/cabinet/admin/base_de_donnee/index.php'),(23,7,'Sauvergarde','/cabinet/admin/file_cabinet/index.php?id_usage=backup');

--
-- Table structure for table `services_ss_menus`
--

CREATE TABLE `services_ss_menus` (
  `id_ss_menu` int(11) NOT NULL AUTO_INCREMENT,
  `id_menu` int(11) NOT NULL,
  `ss_menu` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `query_string` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  PRIMARY KEY (`id_ss_menu`),
  KEY `id_menu` (`id_menu`),
  CONSTRAINT `services_ss_menus_ibfk_1` FOREIGN KEY (`id_menu`) REFERENCES `services_menus` (`id_menu`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services_ss_menus`
--

INSERT INTO `services_ss_menus` VALUES (1,13,'Parametres','/cabinet/gestion/parametres/parametres/index.php','',''),(2,13,'Couleurs','/cabinet/gestion/parametres/couleurs/index.php','',''),(3,13,'Docteurs','/cabinet/gestion/parametres/docteurs/index.php','',''),(4,18,'Info sur le système','/cabinet/admin/monitoring/info_systeme/index.php','display_all_config_value=0',''),(5,18,'Log erreurs','/cabinet/admin/monitoring/error_log/index.php','',''),(6,18,'Erreurs SQL','/cabinet/admin/monitoring/sql_error_log/index.php','',''),(7,18,'Erreur num lignes SQL','/cabinet/admin/monitoring/sql_numrows_log/index.php','',''),(8,18,'Log PHP','/cabinet/admin/monitoring/php_errors/index.php','',''),(9,18,'Log apache','/cabinet/admin/monitoring/apache_errors/index.php','',''),(10,18,'Log authentification','/cabinet/admin/monitoring/authentification_log/index.php','',''),(11,18,'SNMP','/cabinet/admin/monitoring/snmp/index.php','ip=192.168.2.68','');

--
-- Table structure for table `type_rendez_vous`
--

CREATE TABLE `type_rendez_vous` (
  `id_type_rendez_vous` int(11) NOT NULL,
  `id_type_rendez_vous_groupe` int(11) NOT NULL,
  `intitule` varchar(50) NOT NULL,
  `abrege` varchar(5) NOT NULL,
  `duree_minutes` int(11) NOT NULL,
  `previsionnel` decimal(6,2) NOT NULL,
  `background_color` char(6) NOT NULL,
  `border_color` char(6) NOT NULL,
  PRIMARY KEY (`id_type_rendez_vous`),
  KEY `id_type_rendez_vous_groupe` (`id_type_rendez_vous_groupe`),
  CONSTRAINT `type_rendez_vous_ibfk_1` FOREIGN KEY (`id_type_rendez_vous_groupe`) REFERENCES `type_rendez_vous_groupe` (`id_type_rendez_vous_groupe`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `type_rendez_vous`
--

INSERT INTO `type_rendez_vous` VALUES (1,1,'Consultation','Cs',30,32.60,'9CC773','73C61F'),(2,1,'Dépression','Depr',30,69.12,'339900','336633'),(3,2,'EFR','EFR',30,76.80,'FFF7DE','FFC10A'),(4,2,'Polygraphie Ventilatoire','PV',60,145.92,'CECBE7','8277E5'),(5,2,'Polysomnographie','PSG',60,214.27,'CE80E7','8277E5'),(6,3,'PPC','PPC',60,32.60,'33CCFF','8277E5'),(7,3,'TM6','TM6',60,32.60,'66FFFF','8277E5'),(8,4,'Autre','Autr',60,32.60,'0094FF','004A7F');

--
-- Table structure for table `type_rendez_vous_groupe`
--

CREATE TABLE `type_rendez_vous_groupe` (
  `id_type_rendez_vous_groupe` int(11) NOT NULL,
  `intitule` varchar(50) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id_type_rendez_vous_groupe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `type_rendez_vous_groupe`
--

INSERT INTO `type_rendez_vous_groupe` VALUES (1,'Cs'),(2,'EFR Som'),(3,'PPC TM6'),(4,'Autre');


