UPDATE codes SET code_text = 'TOUTES LES METHODES DE PLANIFICATION FAMILIALES' WHERE code_type = '11' AND code = '110000000';
UPDATE codes SET code_text = 'CONTRACEPTION - CONTRACEPTIFS ORAUX' WHERE code_type = '11' AND code = '111100000';
UPDATE codes SET code_text = 'Contraceptifs - Contraceptifs Oraux - Counseling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '111100119';
UPDATE codes SET code_text = 'Contraceptifs - Contraceptifs Oraux - AUTRE' WHERE code_type = '11' AND code = '111100999';
UPDATE codes SET code_text = 'CONTRACEPTIFS -  CONTRACEPTIFS ORAUX COMBINES ET LES CONTRACEPTIFS AU PROGESTATIF SEUL (CPS)' WHERE code_type = '11' AND code = '111101000';
UPDATE codes SET code_text = 'Contraceptifs - Contraceptifs Oraux - COC et CPS - Consultation Initiale' WHERE code_type = '11' AND code = '111101110';
UPDATE codes SET code_text = 'Contraceptifs  - Contraceptifs Oraux - COC & CPS - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '111101111';
UPDATE codes SET code_text = 'Contraceptifs - Contraceptifs Oraux - COC & CPS - AUTRE' WHERE code_type = '11' AND code = '111101999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - CONTRACEPTIFS INJECTABLES' WHERE code_type = '11' AND code = '111110000';
UPDATE codes SET code_text = 'Contraceptifs - Injectables - Counseling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '111110119';
UPDATE codes SET code_text = 'Contraceptifs - Injectables - AUTRE' WHERE code_type = '11' AND code = '111110999';
UPDATE codes SET code_text = 'CONTACEPTIFS - CONTRACEPTIFS INJECTABLES COMBINES - CIC' WHERE code_type = '11' AND code = '111111000';
UPDATE codes SET code_text = 'Contraceptifs - Injectable combiné (1 mois) - Consultation Initiale' WHERE code_type = '11' AND code = '111111110';
UPDATE codes SET code_text = 'Contraceptifs - Injectable combiné (1 mois) - Suivi / réapprovisionnement' WHERE code_type = '11' AND code = '111111111';
UPDATE codes SET code_text = 'Contraceptifs - Injectable combiné (1 mois) - AUTRE' WHERE code_type = '11' AND code = '111111999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - INJECTABLES A PROGESTATIF SEUL (2MOIS)' WHERE code_type = '11' AND code = '111112000';
UPDATE codes SET code_text = 'Contraceptifs - Injectables à progestatif seul (2 mois) - Consultation Initiale' WHERE code_type = '11' AND code = '111112110';
UPDATE codes SET code_text = 'Contraceptifs - Injectables à progestatif seul (2 mois) - suivi / réapprovisionnement' WHERE code_type = '11' AND code = '111112111';
UPDATE codes SET code_text = 'Contraceptifs - Injectables à progestatif seul (2 mois) - AUTRE' WHERE code_type = '11' AND code = '111112999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - INJECTABLES A PROGESTATIF SEUL (3MOIS)' WHERE code_type = '11' AND code = '111113000';
UPDATE codes SET code_text = 'Contraceptifs - Injectables à progestatif seul (3 mois) - Consultation Initiale' WHERE code_type = '11' AND code = '111113110';
UPDATE codes SET code_text = 'Contraceptifs - Injectables à progestatif seul (3 mois) - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '111113111';
UPDATE codes SET code_text = 'Contraceptifs - Injectables à progestatif seul (3 mois) - AUTRE' WHERE code_type = '11' AND code = '111113999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - IMPLANTS SOUS-CUTANES' WHERE code_type = '11' AND code = '111120000';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés - Retrait' WHERE code_type = '11' AND code = '111120112';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés - Counselling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '111120119';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés - AUTRE' WHERE code_type = '11' AND code = '111120999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - IMPLANTS SOUS-CUTANES à 6 CANULES' WHERE code_type = '11' AND code = '111122000';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés à 6 canules - Consultation Initiale / Insertion' WHERE code_type = '11' AND code = '111122110';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés à 6 canules - Suivi /Réinsertion' WHERE code_type = '11' AND code = '111122111';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés à 6 canules - AUTRE' WHERE code_type = '11' AND code = '111122999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - IMPLANTS SOUS-CUTANES à 2 CANULES' WHERE code_type = '11' AND code = '111123000';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés à 2 canules - Consultation Initiale / Insertion' WHERE code_type = '11' AND code = '111123110';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés à 2 canules - Suivi / réinsertion' WHERE code_type = '11' AND code = '111123111';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés à 2 canules - AUTRE' WHERE code_type = '11' AND code = '111123999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - IMPLANTS SOUS-CUTANES à 1 CANULE' WHERE code_type = '11' AND code = '111124000';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés à 1 canule - Consultation initiale / insertion' WHERE code_type = '11' AND code = '111124110';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés à 1 canule - Suivi / réinsertion' WHERE code_type = '11' AND code = '111124111';
UPDATE codes SET code_text = 'Contraceptifs - Implants sous-cutanés à 1 canule - AUTRE' WHERE code_type = '11' AND code = '111124999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - TOUTES LES AUTRES METHODES HORMONAUX' WHERE code_type = '11' AND code = '111130000';
UPDATE codes SET code_text = 'Contraceptifs - Autres méthodes hormonales - AUTRE' WHERE code_type = '11' AND code = '111130999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - AUTRES - LES TIMBRES TRANSEDERMIQUES (1 MOIS)' WHERE code_type = '11' AND code = '111132000';
UPDATE codes SET code_text = 'Contraceptifs - Timbre transdermique (1 mois) - Consultation Initiale' WHERE code_type = '11' AND code = '111132110';
UPDATE codes SET code_text = 'Contraceptifs - Timbre transdermique (1 mois) - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '111132111';
UPDATE codes SET code_text = 'Contraceptifs - Timbre transdermique (1 mois) - Counseling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '111132119';
UPDATE codes SET code_text = 'Contraceptifs - Timbre transdermique (1 mois) - AUTRE' WHERE code_type = '11' AND code = '111132999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - AUTRES - LES ANNEAUX VAGINAUX (1 MOIS)' WHERE code_type = '11' AND code = '111133000';
UPDATE codes SET code_text = 'Contraceptifs - Anneau Vaginal (1 mois) - Consultation Initiale' WHERE code_type = '11' AND code = '111133110';
UPDATE codes SET code_text = 'Contraceptifs - Anneau Vaginal (1 mois) - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '111133111';
UPDATE codes SET code_text = 'Contraceptifs - Anneau Vaginal (1 mois) - Counseling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '111133119';
UPDATE codes SET code_text = 'Contraceptifs - Anneau Vaginal (1 mois) - AUTRE' WHERE code_type = '11' AND code = '111133999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - PRESERVATIFS' WHERE code_type = '11' AND code = '112140000';
UPDATE codes SET code_text = 'Contraceptifs - Préservatifs (Masculins et Féminins) - AUTRE' WHERE code_type = '11' AND code = '112140999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - PRESERVATIFS MASCULINS' WHERE code_type = '11' AND code = '112141000';
UPDATE codes SET code_text = 'Contraceptifs - Préservatifs Masculins - Consultation Initiale' WHERE code_type = '11' AND code = '112141110';
UPDATE codes SET code_text = 'Contraceptifs - Préservatifs Masculins - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '112141111';
UPDATE codes SET code_text = 'Contraceptifs - Préservatifs Masculins - Counseling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '112141119';
UPDATE codes SET code_text = 'Contraceptifs - Préservatifs Masculins - AUTRE' WHERE code_type = '11' AND code = '112141999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - PRESERVATIFS FEMININS' WHERE code_type = '11' AND code = '112142000';
UPDATE codes SET code_text = 'Contraceptifs - Préservatifs Féminins - Consultation Initiale' WHERE code_type = '11' AND code = '112142110';
UPDATE codes SET code_text = 'Contraceptifs - Préservatifs Féminins - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '112142111';
UPDATE codes SET code_text = 'Contraceptifs - Préservatifs Féminins - Counseling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '112142119';
UPDATE codes SET code_text = 'Contraceptifs - Préservatifs Féminins - AUTRE' WHERE code_type = '11' AND code = '112142999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - LES DIAPHRAGMES/CAPES CERVICALES' WHERE code_type = '11' AND code = '112150000';
UPDATE codes SET code_text = 'Contraceptifs - Diaphragme / Cape cervicale - Counseling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '112150119';
UPDATE codes SET code_text = 'Contraceptifs - Diaphragme / Cape cervicale - AUTRE' WHERE code_type = '11' AND code = '112150999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - DIAPHRAGMES' WHERE code_type = '11' AND code = '112151000';
UPDATE codes SET code_text = 'Contraceptifs - Diaphragmes - Consultation Initiale' WHERE code_type = '11' AND code = '112151110';
UPDATE codes SET code_text = 'Contraceptifs - Diaphragmes - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '112151111';
UPDATE codes SET code_text = 'Contraceptifs - Diaphragmes - AUTRE' WHERE code_type = '11' AND code = '112151999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - CAPE CERVICALE' WHERE code_type = '11' AND code = '112152000';
UPDATE codes SET code_text = 'Contraceptifs - Cape Cervicale - Consultation Initiale' WHERE code_type = '11' AND code = '112152010';
UPDATE codes SET code_text = 'Contraceptifs - Cape Cervicale - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '112152011';
UPDATE codes SET code_text = 'Contraceptifs - Cape Cervicale - AUTRE' WHERE code_type = '11' AND code = '112152999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - SPERMICIDES' WHERE code_type = '11' AND code = '112160000';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Counselling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '112160119';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - AUTRE' WHERE code_type = '11' AND code = '112160999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - SPERMICIDES - LES COMPRIMES/ TUBES/ SUPPOSITOIRES MOUSSANTS' WHERE code_type = '11' AND code = '112161000';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Comprimés/Tubes / Suppositoires - Consultation Initiale' WHERE code_type = '11' AND code = '112161110';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Comprimés/Tubes / Suppositoires - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '112161111';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Comprimés/Tubes/Suppositoires - AUTRE' WHERE code_type = '11' AND code = '112161999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - SPERMICIDES - LES COMPRIMES/ BANDES MOUSSANTS' WHERE code_type = '11' AND code = '112162000';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Comprimés/Bandes moussants - Consultation Initiale' WHERE code_type = '11' AND code = '112162110';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Comprimés/Bandes moussants - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '112162111';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Comprimés/Bandes Moussants - AUTRE' WHERE code_type = '11' AND code = '112162999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - SPERMICIDES - LES AEROSOLS' WHERE code_type = '11' AND code = '112163000';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Comprimés/Tubes / Suppositoires - Consultation Initiale' WHERE code_type = '11' AND code = '112163110';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Aérosols- Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '112163111';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Aérosols - AUTRE' WHERE code_type = '11' AND code = '112163999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - SPERMICIDES - LES CREMES ET GELS' WHERE code_type = '11' AND code = '112164000';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Crèmes et gels - Consultation Initiale' WHERE code_type = '11' AND code = '112164110';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Crèmes et gels  - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '112164111';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Crèmes et Gels - AUTRE' WHERE code_type = '11' AND code = '112164999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - SPERMICIDES - LES PESSAIRES ET PELLICULES VAGINALES' WHERE code_type = '11' AND code = '112165000';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides 6 Pessaires / Pellicules vaginales - Consultation Initiale' WHERE code_type = '11' AND code = '112165110';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Pessaires / Pellicules vaginales - Suivi / Réapprovisionnement' WHERE code_type = '11' AND code = '112165111';
UPDATE codes SET code_text = 'Contraceptifs - Spermicides - Pessaires / Pellicules Vaginales - AUTRE' WHERE code_type = '11' AND code = '112165999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - DIU' WHERE code_type = '11' AND code = '113170000';
UPDATE codes SET code_text = 'Contraceptifs - DIU - Retrait' WHERE code_type = '11' AND code = '113170112';
UPDATE codes SET code_text = 'Contraceptifs - DIU - Counseling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '113170119';
UPDATE codes SET code_text = 'Contraceptifs - DIU - AUTRE' WHERE code_type = '11' AND code = '113170999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - DIU HORMONAUX (5 ans)' WHERE code_type = '11' AND code = '113171000';
UPDATE codes SET code_text = 'Contraceptifs - DIU Hormonaux (5 ans) - Consultation Initiale / Insertion' WHERE code_type = '11' AND code = '113171110';
UPDATE codes SET code_text = 'Contraceptifs - DIU Hormonaux (5 ans) - Suivi / Réinsertion' WHERE code_type = '11' AND code = '113171111';
UPDATE codes SET code_text = 'Contraceptifs - DIU Hormonaux (5 ans) - AUTRE' WHERE code_type = '11' AND code = '113171999';
UPDATE codes SET code_text = 'CONTRACEPTIFS - DIU AU CUIVRE (10 ans)' WHERE code_type = '11' AND code = '113172000';
UPDATE codes SET code_text = 'Contraceptifs - DIU au cuivre (10 ans) - Consultation Initiale / Insertion' WHERE code_type = '11' AND code = '113172110';
UPDATE codes SET code_text = 'Contraceptifs - DIU au cuivre (10ans) - Suivi / Réinsertion' WHERE code_type = '11' AND code = '113172111';
UPDATE codes SET code_text = 'Contraceptifs - DIU au cuivre (10 ans) - AUTRE' WHERE code_type = '11' AND code = '113172999';
UPDATE codes SET code_text = 'CONTRACEPTION - CONTRACEPTION CHIRURGICALE VOLONTAIRE (CCV)' WHERE code_type = '11' AND code = '120180000';
UPDATE codes SET code_text = 'Contraception - Contraception Chirurgicale Volontaire (CCV) - AUTRE' WHERE code_type = '11' AND code = '120180999';
UPDATE codes SET code_text = 'CONTRACEPTION - CONTRACEPTION CHIRURGICALE VOLONTAIRE DE LA FEMME (CCVF)' WHERE code_type = '11' AND code = '121181000';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVF - Réversibilité' WHERE code_type = '11' AND code = '121181112';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVF - Counselling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '121181119';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVF - Ligature des trompes - Suivi' WHERE code_type = '11' AND code = '121181211';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVF - Ligature des trompes - Chirurgie contraceptive' WHERE code_type = '11' AND code = '121181213';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVF  - Coelioscopie - Suivi' WHERE code_type = '11' AND code = '121181311';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVF- Coelioscopie - Chirurgie contraceptive' WHERE code_type = '11' AND code = '121181313';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVF - Coeliotomie - Suivi' WHERE code_type = '11' AND code = '121181411';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVF - Coeliotomie  - Chirurgie contraceptive' WHERE code_type = '11' AND code = '121181413';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVF - AUTRE' WHERE code_type = '11' AND code = '121181999';
UPDATE codes SET code_text = 'CONTRACEPTION - CONTRACEPTION CHIRURGICALE VOLONTAIRE DE L`HOMME (CCVH)' WHERE code_type = '11' AND code = '122182000';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVH - Réversibilité' WHERE code_type = '11' AND code = '122182112';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVH - Counselling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '122182119';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVH - Vasectomie incisionnelle - Suivi (numérotation des spe' WHERE code_type = '11' AND code = '122182211';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVH - Vasectomie incisionnelle - Chirurgie contraceptive' WHERE code_type = '11' AND code = '122182213';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVH - Vasectomie sans scalpel - Suivi (Numérotation des sper' WHERE code_type = '11' AND code = '122182311';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVH - Vasectomie sans scalpel - Chirurgie Contraceptive' WHERE code_type = '11' AND code = '122182313';
UPDATE codes SET code_text = 'Contraception - Chirurgicale - CCVH - AUTRE' WHERE code_type = '11' AND code = '122182999';
UPDATE codes SET code_text = 'CONTRACEPTION - METHODES D`ABSTINENCE PERIODIQUE' WHERE code_type = '11' AND code = '130190000';
UPDATE codes SET code_text = 'Contraception - Méthodes d`abstinence périodique - AUTRE' WHERE code_type = '11' AND code = '130190999';
UPDATE codes SET code_text = 'CONTRACEPTION - METHODES D`ABSTINENCE PERIODIQUE DE LA STERILITE' WHERE code_type = '11' AND code = '131191000';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Counseling Spécifique pour la Méthode' WHERE code_type = '11' AND code = '131191119';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Méthode de la glaire - Consultation initiale / Formation' WHERE code_type = '11' AND code = '131191210';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Méthode de la glaire - Suivi/ formation' WHERE code_type = '11' AND code = '131191211';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Méthode du calendrier - Consultation Initiale / Formation' WHERE code_type = '11' AND code = '131191310';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Méthode du calendrier  - Suivi/Formation' WHERE code_type = '11' AND code = '131191311';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Méthode sympto-thermique - Consultation Initiale/Formation' WHERE code_type = '11' AND code = '131191410';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Méthode sympto-thermique - Suivi/Formation' WHERE code_type = '11' AND code = '131191411';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Méthode des jours fixes - Consultation Initiale / Formation' WHERE code_type = '11' AND code = '131191510';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Méthode des jours fixes - Suivi/ Formation' WHERE code_type = '11' AND code = '131191511';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Température basale du corps - Consultation Initiale / Format' WHERE code_type = '11' AND code = '131191610';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - Température basale du corps - Suivi/Formation' WHERE code_type = '11' AND code = '131191611';
UPDATE codes SET code_text = 'Contraception - Abstinence périodique - AUTRE' WHERE code_type = '11' AND code = '131191999';
UPDATE codes SET code_text = 'CONSEILS SUR LA CONTRACEPTION' WHERE code_type = '11' AND code = '141200000';
UPDATE codes SET code_text = 'Contraception - Counseling général en PF' WHERE code_type = '11' AND code = '141200118';
UPDATE codes SET code_text = 'Contraception - Counseling général en PF - Counselling mixte (PF - VIH/sida), y compris protection' WHERE code_type = '11' AND code = '141200218';
UPDATE codes SET code_text = 'Contraception - Counseling général en PF - Autre' WHERE code_type = '11' AND code = '141200999';
UPDATE codes SET code_text = 'LES SERVICES DE CONTRACEPTION D`URGENCE' WHERE code_type = '11' AND code = '145210000';
UPDATE codes SET code_text = 'CU - AUTRE' WHERE code_type = '11' AND code = '145210999';
UPDATE codes SET code_text = 'LES SERVICES DE CU - COUNSELLING' WHERE code_type = '11' AND code = '145211000';
UPDATE codes SET code_text = 'CU - Counselling' WHERE code_type = '11' AND code = '145211119';
UPDATE codes SET code_text = 'CU - Counselling - AUTRE' WHERE code_type = '11' AND code = '145211999';
UPDATE codes SET code_text = 'CU - THERAPEUTIQUE' WHERE code_type = '11' AND code = '145212000';
UPDATE codes SET code_text = 'CU - Contraceptifs oraux combinés - Yuzpe - (Traitement)' WHERE code_type = '11' AND code = '145212110';
UPDATE codes SET code_text = 'CU - Contraceptifs oraux combinés - Yuzpe - Suivi' WHERE code_type = '11' AND code = '145212111';
UPDATE codes SET code_text = 'CU - Progestatif seul - Offre contraceptive (Traitement)' WHERE code_type = '11' AND code = '145212210';
UPDATE codes SET code_text = 'CU - Progestatif seul - Suivi' WHERE code_type = '11' AND code = '145212211';
UPDATE codes SET code_text = 'CU - Produit Dédié - Offre contraceptive (Traitement)' WHERE code_type = '11' AND code = '145212310';
UPDATE codes SET code_text = 'CU - Produit Dédié - Suivi' WHERE code_type = '11' AND code = '145212311';
UPDATE codes SET code_text = 'CU - DIU au cuivre - Insertion du DIU (Traitement)' WHERE code_type = '11' AND code = '145212410';
UPDATE codes SET code_text = 'CU - DIU au cuivre - Suivi' WHERE code_type = '11' AND code = '145212411';
UPDATE codes SET code_text = 'CU - Thérapeutique - AUTRE' WHERE code_type = '11' AND code = '145212999';
UPDATE codes SET code_text = 'LES SERVICES DE SSR (SAUF PLANIFICATION FAMILIALE)' WHERE code_type = '11' AND code = '250000000';
UPDATE codes SET code_text = 'LES SERVICES D`AVORTEMENT' WHERE code_type = '11' AND code = '252220000';
UPDATE codes SET code_text = 'Services d`avortement - AUTRE' WHERE code_type = '11' AND code = '252220999';
UPDATE codes SET code_text = 'AVORTEMENT - COUNSELING PRE AVORTEMENT' WHERE code_type = '11' AND code = '252221000';
UPDATE codes SET code_text = 'Avortement - Counseling - Counseling pré avortement' WHERE code_type = '11' AND code = '252221129';
UPDATE codes SET code_text = 'Avortement - Counseling - Counseling sur le dépistage du VIH' WHERE code_type = '11' AND code = '252221229';
UPDATE codes SET code_text = 'Avortement - Counseling - Consultation Initiale sur la R éduction des Risques' WHERE code_type = '11' AND code = '252221329';
UPDATE codes SET code_text = 'Avortement - Counseling - Autre' WHERE code_type = '11' AND code = '252221999';
UPDATE codes SET code_text = 'AVORTEMENT - CONSULTATION PRE AVORTEMENT (DIAGNOSTIC)' WHERE code_type = '11' AND code = '252222000';
UPDATE codes SET code_text = 'Avortement - Diagnostic - Exclusion de l`anémie (Test hémoglobine/hématocrite)' WHERE code_type = '11' AND code = '252222121';
UPDATE codes SET code_text = 'Avortement - Diagnostic - Groupe sanguins et rhésus (épreuve Beth Vincent)' WHERE code_type = '11' AND code = '252222221';
UPDATE codes SET code_text = 'Avortement - Diagnostic - Grossesse extra-utérine (échographie)' WHERE code_type = '11' AND code = '252222321';
UPDATE codes SET code_text = 'Avortement - Diagnostic - Cytologie cervicale (test de papanicolaou, IVA)' WHERE code_type = '11' AND code = '252222421';
UPDATE codes SET code_text = 'Avortement - Diagnostic - Dépistage VIH' WHERE code_type = '11' AND code = '252222521';
UPDATE codes SET code_text = 'Avortement - Diagnostic - AUTRE' WHERE code_type = '11' AND code = '252222999';
UPDATE codes SET code_text = 'AVORTEMENT - AVORTEMENT PROVOQUE (CHIRURGICAL)' WHERE code_type = '11' AND code = '252223000';
UPDATE codes SET code_text = 'Avortement Provoqué (Chirurgical) - Dilatation & curetage (D&C)' WHERE code_type = '11' AND code = '252223123';
UPDATE codes SET code_text = 'Avortement Provoqué (Chirurgical) - Dilatation & évacuation (D&E)' WHERE code_type = '11' AND code = '252223223';
UPDATE codes SET code_text = 'Avortement Provoqué (Chirurgical) - Aspiration manuelle  par le vide (AMV)' WHERE code_type = '11' AND code = '252223323';
UPDATE codes SET code_text = 'Avortement Provoqué (Chirurgical) - AUTRE' WHERE code_type = '11' AND code = '252223999';
UPDATE codes SET code_text = 'AVORTEMENT (MEDICAL)' WHERE code_type = '11' AND code = '252224000';
UPDATE codes SET code_text = 'Avortement Provoqué (Médical) - Pharmaceutique (Mifepristone et Misoprostol)' WHERE code_type = '11' AND code = '252224122';
UPDATE codes SET code_text = 'Avortement Provoqué (Médical) - Pharmaceutique (Misoprostol seulement)' WHERE code_type = '11' AND code = '252224222';
UPDATE codes SET code_text = 'Avortement Provoqué (Médical) - AUTRE' WHERE code_type = '11' AND code = '252224999';
UPDATE codes SET code_text = 'AVORTEMENT - TRAITEMENT DE L`AVORTEMENT INCOMPLET (CHIRURGIQUE/MEDICAL)' WHERE code_type = '11' AND code = '252225000';
UPDATE codes SET code_text = 'Avortement - Avortement incomplet - Chirurgical / D&C' WHERE code_type = '11' AND code = '252225123';
UPDATE codes SET code_text = 'Avortement - Avortement incomplet - Chirurgical / AMV' WHERE code_type = '11' AND code = '252225223';
UPDATE codes SET code_text = 'Avortement - Avortement incomplet - Médical / Pharmaceutique' WHERE code_type = '11' AND code = '252225722';
UPDATE codes SET code_text = 'Avortement - Avortement incomplet - Chirurgical / Médical - Autre' WHERE code_type = '11' AND code = '252225999';
UPDATE codes SET code_text = 'AVORTEMENT - SOINS POST AVORTEMENT' WHERE code_type = '11' AND code = '252226000';
UPDATE codes SET code_text = 'Avortement - Soins post avortement - Suivi, y compris suivi  involution utérine et examen pelvien bi' WHERE code_type = '11' AND code = '252226120';
UPDATE codes SET code_text = 'Avortement - Soins post avortement - Autre' WHERE code_type = '11' AND code = '252226999';
UPDATE codes SET code_text = 'AVORTEMENT - COUNSELING POST AVORTEMENT' WHERE code_type = '11' AND code = '252227000';
UPDATE codes SET code_text = 'Avortement - Counseling - Counseling post avortement - y compris planification familiale' WHERE code_type = '11' AND code = '252227129';
UPDATE codes SET code_text = 'Avortement - Counseling - Consultation de suivi sur la reduction des risques' WHERE code_type = '11' AND code = '252227229';
UPDATE codes SET code_text = 'Avortement - Counseling - Counseling post avortement' WHERE code_type = '11' AND code = '252227999';
UPDATE codes SET code_text = 'VIH/SIDA  - SERVICES' WHERE code_type = '11' AND code = '253230000';
UPDATE codes SET code_text = 'VIH/SIDA - Services - AUTRE' WHERE code_type = '11' AND code = '253230999';
UPDATE codes SET code_text = 'VIH/SIDA - CONSULTATION TRAITEMENT' WHERE code_type = '11' AND code = '253231000';
UPDATE codes SET code_text = 'VIH/SIDA - Consultation  - Traitement - Antirétroviral' WHERE code_type = '11' AND code = '253231122';
UPDATE codes SET code_text = 'VIH/SIDA - Consultation - Traitement - Infections opportunistes' WHERE code_type = '11' AND code = '253231222';
UPDATE codes SET code_text = 'VIH/SIDA - Consultation - Traitement - Prophylaxie du lendemain' WHERE code_type = '11' AND code = '253231322';
UPDATE codes SET code_text = 'VIH/SIDA - Consultation - Traitement - Prise en charge psychosociale' WHERE code_type = '11' AND code = '253231422';
UPDATE codes SET code_text = 'VIH/SIDA - Consultation - Traitement - Soins à la maison' WHERE code_type = '11' AND code = '253231522';
UPDATE codes SET code_text = 'VIH/SIDA - Consultation - Traitement - AUTRE' WHERE code_type = '11' AND code = '253231999';
UPDATE codes SET code_text = 'VIH/SIDA - TESTS SEROLOGIQUES EN LABORATOIRE' WHERE code_type = '11' AND code = '253232000';
UPDATE codes SET code_text = 'VIH/SIDA - Test anticorps en labo - Test sanguin ELISA' WHERE code_type = '11' AND code = '253232121';
UPDATE codes SET code_text = 'VIH/SIDA - Test anticorps en labo - Test Western Blot' WHERE code_type = '11' AND code = '253232221';
UPDATE codes SET code_text = 'VIH/SIDA - Test anticorps en labo - Immunofluorescence indirecte' WHERE code_type = '11' AND code = '253232321';
UPDATE codes SET code_text = 'VIH/SIDA - Autres tests en labo - Tests rapides (Murex - SUDS)' WHERE code_type = '11' AND code = '253232421';
UPDATE codes SET code_text = 'VIH/SIDA - Autres tests en labo - Status Sero - AUTRE' WHERE code_type = '11' AND code = '253232999';
UPDATE codes SET code_text = 'VIH/SIDA - TESTS EN LABO - AUTRE' WHERE code_type = '11' AND code = '253233000';
UPDATE codes SET code_text = 'VIH/SIDA - Autres tests en labo -  Analyse d`urine à fins de dépistage du VIH' WHERE code_type = '11' AND code = '253233121';
UPDATE codes SET code_text = 'VIH/SIDA - Autres tests en labo - Evaluation de la fonction immunologique (charge virale)' WHERE code_type = '11' AND code = '253233221';
UPDATE codes SET code_text = 'VIH/SIDA - Autres tests en labo - Evaluation de la fonction immunologique' WHERE code_type = '11' AND code = '253233321';
UPDATE codes SET code_text = 'VIH/SIDA - Autres tests en labo - AUTRE' WHERE code_type = '11' AND code = '253233999';
UPDATE codes SET code_text = 'VIH/SIDA - COUNSELLING POUR LA PREVENTION' WHERE code_type = '11' AND code = '253234000';
UPDATE codes SET code_text = 'VIH/SIDA - Consultation pour la prévention du VIH/SIDA' WHERE code_type = '11' AND code = '253234129';
UPDATE codes SET code_text = 'VIH/SIDA - Consultation pour la prévention du VIH/SIDA - AUTRE' WHERE code_type = '11' AND code = '253234999';
UPDATE codes SET code_text = 'VIH/SIDA - COUNSELLING PRE ET POST TEST' WHERE code_type = '11' AND code = '253235000';
UPDATE codes SET code_text = 'VIH/SIDA - Counseling - Pré Conseil et dépistage volontaires (CDV)' WHERE code_type = '11' AND code = '253235129';
UPDATE codes SET code_text = 'VIH/SIDA - Counseling - Après dépistage (Positif) - Clients seuls' WHERE code_type = '11' AND code = '253235229';
UPDATE codes SET code_text = 'VIH/SIDA - Counseling - Après dépistage (Négatif)' WHERE code_type = '11' AND code = '253235329';
UPDATE codes SET code_text = 'VIH/SIDA - Counseling - Après dépistage (Positif) - Partenaires sexuels' WHERE code_type = '11' AND code = '253235429';
UPDATE codes SET code_text = 'VIH/SIDA - Counseling - Après dépistage' WHERE code_type = '11' AND code = '253235529';
UPDATE codes SET code_text = 'VIH/SIDA - Counseling - AUTRE' WHERE code_type = '11' AND code = '253235999';
UPDATE codes SET code_text = 'IST/IAR - SERVICES' WHERE code_type = '11' AND code = '254240000';
UPDATE codes SET code_text = 'IST/IAR - Services - AUTRE' WHERE code_type = '11' AND code = '254240999';
UPDATE codes SET code_text = 'IST/IAR - COUNSELLING - POST TEST' WHERE code_type = '11' AND code = '254241000';
UPDATE codes SET code_text = 'IST/IAR - Consultation - Conseils préventifs' WHERE code_type = '11' AND code = '254241129';
UPDATE codes SET code_text = 'IST/IAR - Consultation - Après dépistage' WHERE code_type = '11' AND code = '254241229';
UPDATE codes SET code_text = 'IST/IAR - Counselling Post Test - AUTRE' WHERE code_type = '11' AND code = '254241999';
UPDATE codes SET code_text = 'IST/IAR - CONSULTATION' WHERE code_type = '11' AND code = '254242000';
UPDATE codes SET code_text = 'IST/IAR - Consultation - Suivi' WHERE code_type = '11' AND code = '254242120';
UPDATE codes SET code_text = 'IST/IAR - Consultation - AUTRE' WHERE code_type = '11' AND code = '254242999';
UPDATE codes SET code_text = 'IST/IAR - TESTS EN LABORATOIRE' WHERE code_type = '11' AND code = '254243000';
UPDATE codes SET code_text = 'IST/IAR - Test - Vaginite' WHERE code_type = '11' AND code = '254243121';
UPDATE codes SET code_text = 'IST/IAR - Test - Candidose' WHERE code_type = '11' AND code = '254243221';
UPDATE codes SET code_text = 'IST/IAR - Test - Chancre mou' WHERE code_type = '11' AND code = '254243321';
UPDATE codes SET code_text = 'IST/IAR - Test - Chlamydiose' WHERE code_type = '11' AND code = '254243421';
UPDATE codes SET code_text = 'IST/IAR - Test - Blennorragie' WHERE code_type = '11' AND code = '254243521';
UPDATE codes SET code_text = 'IST/IAR - Test - AUTRE' WHERE code_type = '11' AND code = '254243999';
UPDATE codes SET code_text = 'IST/IAR - TESTS EN LABORATOIRE (SUITE)' WHERE code_type = '11' AND code = '254244000';
UPDATE codes SET code_text = 'IST/IAR - Test - Herpes simplex (HSV)' WHERE code_type = '11' AND code = '254244121';
UPDATE codes SET code_text = 'IST/IAR - Test - Virus du papillome humain (VPH)' WHERE code_type = '11' AND code = '254244221';
UPDATE codes SET code_text = 'IST/IAR - Test - Syphilis' WHERE code_type = '11' AND code = '254244321';
UPDATE codes SET code_text = 'IST/IAR - Test - Trichomonase' WHERE code_type = '11' AND code = '254244421';
UPDATE codes SET code_text = 'IST/IAR - Test - L`hepatite A et B' WHERE code_type = '11' AND code = '254244521';
UPDATE codes SET code_text = 'IST/IAR - Test - AUTRE' WHERE code_type = '11' AND code = '254244999';
UPDATE codes SET code_text = 'IST/IAR TRAITEMENTS (y compris la prophylaxie)' WHERE code_type = '11' AND code = '254245000';
UPDATE codes SET code_text = 'IST/IAR- Traitement - Diagnostic des syndromes avec traitement clinique' WHERE code_type = '11' AND code = '254245122';
UPDATE codes SET code_text = 'IST/IAR- Traitement - Diagnostic étiologique avec traitement clinique' WHERE code_type = '11' AND code = '254245222';
UPDATE codes SET code_text = 'IST/IAR- Traitement - Vaccination contre l`hépatite A' WHERE code_type = '11' AND code = '254245322';
UPDATE codes SET code_text = 'IST/IAR- Traitement - Vaccination contre l`hépatite B' WHERE code_type = '11' AND code = '254245422';
UPDATE codes SET code_text = 'IST/IAR- Traitement - Vaccination contre le VPH' WHERE code_type = '11' AND code = '254245522';
UPDATE codes SET code_text = 'IST/IAR- Traitement - AUTRE' WHERE code_type = '11' AND code = '254245999';
UPDATE codes SET code_text = 'GYNECOLOGIE - SERVICES' WHERE code_type = '11' AND code = '255250000';
UPDATE codes SET code_text = 'Gynécologie - Services - AUTRE' WHERE code_type = '11' AND code = '255250999';
UPDATE codes SET code_text = 'GYNECOLOGIE - BIOPSIE' WHERE code_type = '11' AND code = '255251000';
UPDATE codes SET code_text = 'Gynécologie - Biopsie - Conisation' WHERE code_type = '11' AND code = '255251123';
UPDATE codes SET code_text = 'Gynécologie - Biopsie - Biopsie  l`aiguille' WHERE code_type = '11' AND code = '255251223';
UPDATE codes SET code_text = 'Gynécologie - Biopsie - Biopsie par aspiration' WHERE code_type = '11' AND code = '255251323';
UPDATE codes SET code_text = 'Gynécologie - Biopsie - Dilatation & curetage (D&C)' WHERE code_type = '11' AND code = '255251423';
UPDATE codes SET code_text = 'Gynécologie - Biopsie - AUTRE' WHERE code_type = '11' AND code = '255251999';
UPDATE codes SET code_text = 'GYNECOLOGIE - ENDOSCOPIE' WHERE code_type = '11' AND code = '255252000';
UPDATE codes SET code_text = 'Gynécologie - Endoscopie - Colposcopie' WHERE code_type = '11' AND code = '255252123';
UPDATE codes SET code_text = 'Gynécologie - Endoscopie - Coelioscopie' WHERE code_type = '11' AND code = '255252223';
UPDATE codes SET code_text = 'Gynécologie - Endoscopie - Hystéroscopie' WHERE code_type = '11' AND code = '255252323';
UPDATE codes SET code_text = 'Gynécologie - Endoscopie - Culdoscopie' WHERE code_type = '11' AND code = '255252423';
UPDATE codes SET code_text = 'Gynécologie - Endoscopie - Hystérectomie' WHERE code_type = '11' AND code = '255252523';
UPDATE codes SET code_text = 'Gynécologie - Endoscopie - Ovariectomie' WHERE code_type = '11' AND code = '255252623';
UPDATE codes SET code_text = 'Gynécologie - Endoscopie - Mastectomie' WHERE code_type = '11' AND code = '255252723';
UPDATE codes SET code_text = 'Gynécologie - Endoscopie - Tumorectomie (ou Lumpectomie)' WHERE code_type = '11' AND code = '255252823';
UPDATE codes SET code_text = 'Gynécologie - Endoscopie - AUTRE' WHERE code_type = '11' AND code = '255252999';
UPDATE codes SET code_text = 'GYNECOLOGIE - IMAGERIE DIAGNOSTIQUE' WHERE code_type = '11' AND code = '255253000';
UPDATE codes SET code_text = 'Gynécologie - Imagerie diagnostique - Radiographie - Hysterosalpingographie' WHERE code_type = '11' AND code = '255253121';
UPDATE codes SET code_text = 'Gynécologie - Imagerie diagnostique - Radiographie - Mammographie' WHERE code_type = '11' AND code = '255253221';
UPDATE codes SET code_text = 'Gynécologie - Imagerie diagnostique - Radiographie - Echographie' WHERE code_type = '11' AND code = '255253321';
UPDATE codes SET code_text = 'Gynécologie - Imagerie diagnostique - Radiographie - Tomographie' WHERE code_type = '11' AND code = '255253421';
UPDATE codes SET code_text = 'Gynécologie - Imagerie diagnostique - Radiographie - Radiographie - Ostéodensitométrie' WHERE code_type = '11' AND code = '255253521';
UPDATE codes SET code_text = 'Gynécologie - Imagerie diagnostique - AUTRE' WHERE code_type = '11' AND code = '255253999';
UPDATE codes SET code_text = 'GYNECOLOGIE - EXAMENS' WHERE code_type = '11' AND code = '255254000';
UPDATE codes SET code_text = 'Gynécologie - Examen - Examen pelvien manuel (y compris palpation)' WHERE code_type = '11' AND code = '255254121';
UPDATE codes SET code_text = 'Gynécologie - Examen - Examen manuel des seins' WHERE code_type = '11' AND code = '255254221';
UPDATE codes SET code_text = 'Gynécologie - Examen - Dépistage  du cancer cervical - Test de Papanicolaou' WHERE code_type = '11' AND code = '255254321';
UPDATE codes SET code_text = 'Gynécologie - Examen - Consultation sans examen pelvien' WHERE code_type = '11' AND code = '255254421';
UPDATE codes SET code_text = 'Gynécologie - Examen - Dépistage du cancer cervical - inspection visuelle  (IVA ou IVL)' WHERE code_type = '11' AND code = '255254521';
UPDATE codes SET code_text = 'Gynécologie - Examen - Dépistage  du cancer cervical -  Cytologie en milieu liquide  (prelevement)' WHERE code_type = '11' AND code = '255254621';
UPDATE codes SET code_text = 'Gynécologie - Examen - Dépistage  du cancer cervical -  Test d ADN du VPH  (prelevement)' WHERE code_type = '11' AND code = '255254721';
UPDATE codes SET code_text = 'Gynécologie - Examen - AUTRE' WHERE code_type = '11' AND code = '255254999';
UPDATE codes SET code_text = 'GYNECOLOGIE - EXAMENS CYTOLOGIQUES' WHERE code_type = '11' AND code = '255255000';
UPDATE codes SET code_text = 'Gynécologie - Test en laboratoire - Analyse cytologique (Test de Papanicolaou)' WHERE code_type = '11' AND code = '255255121';
UPDATE codes SET code_text = 'Gynécologie - Test en laboratoire - Dépistage   du cancer cervical - Cytologie en milieu liquide' WHERE code_type = '11' AND code = '255255221';
UPDATE codes SET code_text = 'Gynécologie - Test en laboratoire - Dépistage   du cancer cervical - Test d ADN du VPH' WHERE code_type = '11' AND code = '255255321';
UPDATE codes SET code_text = 'Gynécologie - Test en laboratoire - AUTRE' WHERE code_type = '11' AND code = '255255999';
UPDATE codes SET code_text = 'GYNECOLOGIE - THERAPIES' WHERE code_type = '11' AND code = '255256000';
UPDATE codes SET code_text = 'Gynécologie - Thérapies gynécologiques - Consultation ménopause - Thérapie hormonale de remplacement' WHERE code_type = '11' AND code = '255256122';
UPDATE codes SET code_text = 'Gynécologie -Thérapies gynécologiques - Régulation de la menstruation' WHERE code_type = '11' AND code = '255256222';
UPDATE codes SET code_text = 'Gynécologie - Thérapies - Mutilation Génitale Féminine - Traitement des complications' WHERE code_type = '11' AND code = '255256322';
UPDATE codes SET code_text = 'Gynécologie -Thérapies gynécologiques - AUTRE' WHERE code_type = '11' AND code = '255256999';
UPDATE codes SET code_text = 'GYNECOLOGIE - CHIRURGIE' WHERE code_type = '11' AND code = '255257000';
UPDATE codes SET code_text = 'Gynécologie - Chirurgie - Cryochirugie - Cervicale' WHERE code_type = '11' AND code = '255257123';
UPDATE codes SET code_text = 'Gynécologie - Chirurgie - Cautérisation (cervicale / vaginale)' WHERE code_type = '11' AND code = '255257223';
UPDATE codes SET code_text = 'Gynécologie - Chirurgie - Mutilation Génitale Féminine Chirugie de reconstruction' WHERE code_type = '11' AND code = '255257323';
UPDATE codes SET code_text = 'Gynécologie - Chirurgie - AUTRE' WHERE code_type = '11' AND code = '255257999';
UPDATE codes SET code_text = 'GYNECOLOGIE - COUNSELLING' WHERE code_type = '11' AND code = '255258000';
UPDATE codes SET code_text = 'Gynécologie - Counseling - Consultation ménopause, counselling' WHERE code_type = '11' AND code = '255258129';
UPDATE codes SET code_text = 'Gynécologie - Counseling - Test de Papanicolaou, Importance (conseils avant test)' WHERE code_type = '11' AND code = '255258229';
UPDATE codes SET code_text = 'Gynécologie - Counseling - Test de Papanicolaou, Résultats anormaux (Conseils après test et suivi)' WHERE code_type = '11' AND code = '255258329';
UPDATE codes SET code_text = 'Gynécologie - Counseling - Résultats examen mammaire, Mammographie / Biopsie' WHERE code_type = '11' AND code = '255258429';
UPDATE codes SET code_text = 'Gynécologie - Counseling - Mutilation génitale féminine' WHERE code_type = '11' AND code = '255258529';
UPDATE codes SET code_text = 'Gynécologie - Counseling - Test de Papanicolaou - Résultat normal - (Conseils après le test' WHERE code_type = '11' AND code = '255258629';
UPDATE codes SET code_text = 'Gynécologie - Counseling - AUTRE' WHERE code_type = '11' AND code = '255258999';
UPDATE codes SET code_text = 'SERVICES OBSTETRIQUES' WHERE code_type = '11' AND code = '256260000';
UPDATE codes SET code_text = 'Obstétrique - Services - AUTRE' WHERE code_type = '11' AND code = '256260999';
UPDATE codes SET code_text = 'OBSTETRIQUE - PROCEDURES DE DIAGNOSTIC PRENATAL' WHERE code_type = '11' AND code = '256261000';
UPDATE codes SET code_text = 'Obstétrique - Diagnostic prénatal - Foestoscopie' WHERE code_type = '11' AND code = '256261121';
UPDATE codes SET code_text = 'Obstétrique - Diagnostic prénatal - Echographie prénatale' WHERE code_type = '11' AND code = '256261221';
UPDATE codes SET code_text = 'Obstétrique - Diagnostic prénatal - Pelvimétrie' WHERE code_type = '11' AND code = '256261321';
UPDATE codes SET code_text = 'Obstétrique - Diagnostic prénatal - Test de la fonction placentaire' WHERE code_type = '11' AND code = '256261421';
UPDATE codes SET code_text = 'Obstétrique - Diagnostic prénatal - AUTRE' WHERE code_type = '11' AND code = '256261999';
UPDATE codes SET code_text = 'OBSTETRIQUE - SOINS PRENATALS' WHERE code_type = '11' AND code = '256262000';
UPDATE codes SET code_text = 'Obstétrique - Soins prénatals - Suivi utérin -' WHERE code_type = '11' AND code = '256262121';
UPDATE codes SET code_text = 'Obstétrique - Soins prénatals - Suivi du foetus' WHERE code_type = '11' AND code = '256262221';
UPDATE codes SET code_text = 'Obstétrique - Soins prénatals - Immunisation' WHERE code_type = '11' AND code = '256262422';
UPDATE codes SET code_text = 'Obstétrique - Soins prénatals - AUTRE' WHERE code_type = '11' AND code = '256262999';
UPDATE codes SET code_text = 'OBSTETRIQUE - COUNSELLING PRENATAL' WHERE code_type = '11' AND code = '256263000';
UPDATE codes SET code_text = 'Obstétrique - Counseling prénatal - Information sur les soins prénatals' WHERE code_type = '11' AND code = '256263129';
UPDATE codes SET code_text = 'Obstétrique - Counseling prénatal - Grossesse non planifiée' WHERE code_type = '11' AND code = '256263229';
UPDATE codes SET code_text = 'Obstétrique - Counselling prénatal - Prévention et dépistage du VIH' WHERE code_type = '11' AND code = '256263329';
UPDATE codes SET code_text = 'Obstétrique - Counseling prénatal - AUTRE' WHERE code_type = '11' AND code = '256263999';
UPDATE codes SET code_text = 'OBSTETRIQUE - TESTS DE GROSSESSE' WHERE code_type = '11' AND code = '256264000';
UPDATE codes SET code_text = 'Obstétrique - Tests de laboratoire - Tests de grossesse - Inhibition de l`agglutination - Test urina' WHERE code_type = '11' AND code = '256264121';
UPDATE codes SET code_text = 'Obstétrique - Tests de laboratoire - Tests de grossesse - Radioimmunoanalyse - Test sanguin' WHERE code_type = '11' AND code = '256264221';
UPDATE codes SET code_text = 'Obstétrique - Tests de laboratoire - Tests de grossesse' WHERE code_type = '11' AND code = '256264999';
UPDATE codes SET code_text = 'OBSTETRIQUE - TESTS DE LABORATOIRE PRENATAL' WHERE code_type = '11' AND code = '256265000';
UPDATE codes SET code_text = 'Obstétrique - Tests prénatals en laboratoire - Test urinaire' WHERE code_type = '11' AND code = '256265121';
UPDATE codes SET code_text = 'Obstétrique - Tests prénatals en laboratoire - Glycémie à jeun' WHERE code_type = '11' AND code = '256265221';
UPDATE codes SET code_text = 'Obstétrique - Tests prénatals en laboratoire - Hémoglobine' WHERE code_type = '11' AND code = '256265321';
UPDATE codes SET code_text = 'Obstétrique - Tests prénatals en laboratoire - Type sanguin' WHERE code_type = '11' AND code = '256265421';
UPDATE codes SET code_text = 'Obstétrique - Tests prénatals en laboratoire - VDRL' WHERE code_type = '11' AND code = '256265521';
UPDATE codes SET code_text = 'Obstétrique - Tests prénatals en laboratoire - VIH' WHERE code_type = '11' AND code = '256265621';
UPDATE codes SET code_text = 'Obstétrique - Tests prénatals en laboratoire - Amniosynthèse' WHERE code_type = '11' AND code = '256265721';
UPDATE codes SET code_text = 'Obstétrique - Tests prénatals en laboratoire - prélèvement des villosités choriales' WHERE code_type = '11' AND code = '256265821';
UPDATE codes SET code_text = 'Obstétrique - Tests prénatals de laboratoire' WHERE code_type = '11' AND code = '256265999';
UPDATE codes SET code_text = 'OBSTETRIQUE - CHIRURGIE DE L`ACCOUCHEMENT' WHERE code_type = '11' AND code = '256267000';
UPDATE codes SET code_text = 'Obstétrique - Chirurgie - Accouchement, Accouchement vaginal' WHERE code_type = '11' AND code = '256267123';
UPDATE codes SET code_text = 'Obstétrique - Chirurgie - Accouchement, Césarienne' WHERE code_type = '11' AND code = '256267223';
UPDATE codes SET code_text = 'Obstétrique - Chirurgie - Accouchement, soins obstétriques d`urgence' WHERE code_type = '11' AND code = '256267323';
UPDATE codes SET code_text = 'Obstétrique - Chirurgie - AUTRE' WHERE code_type = '11' AND code = '256267999';
UPDATE codes SET code_text = 'OBSTETRIQUE - CHIRURGIE - SOINS POSTNATALS' WHERE code_type = '11' AND code = '256268000';
UPDATE codes SET code_text = 'Obstétrique - Soins postnatals - Consultation, y compris suivi de l`involution utérine' WHERE code_type = '11' AND code = '256268120';
UPDATE codes SET code_text = 'Obstétrique - Soins postnatals - AUTRE' WHERE code_type = '11' AND code = '256268999';
UPDATE codes SET code_text = 'OBSTETRIQUE - COUNSELLING POSTNATAL' WHERE code_type = '11' AND code = '256269000';
UPDATE codes SET code_text = 'Obstétrique - Counseling postnatal - Méthode de PF' WHERE code_type = '11' AND code = '256269129';
UPDATE codes SET code_text = 'Obstétrique - Counseling postnatal - Conseils sur l`allaitement' WHERE code_type = '11' AND code = '256269229';
UPDATE codes SET code_text = 'Obstétrique - Counseling postnatal - Conseils sur le VIH' WHERE code_type = '11' AND code = '256269329';
UPDATE codes SET code_text = 'Obstétrique - Counseling postnatal - AUTRE' WHERE code_type = '11' AND code = '256269999';
UPDATE codes SET code_text = 'SERVICES D`UROLOGIE' WHERE code_type = '11' AND code = '257270000';
UPDATE codes SET code_text = 'Urologie - Services - AUTRE' WHERE code_type = '11' AND code = '257270999';
UPDATE codes SET code_text = 'UROLOGIE - ENDOSCOPIE' WHERE code_type = '11' AND code = '257271000';
UPDATE codes SET code_text = 'Urologie - Endoscopie - Urographie' WHERE code_type = '11' AND code = '257271123';
UPDATE codes SET code_text = 'Urologie - Endoscopie - Urétéroscopie' WHERE code_type = '11' AND code = '257271223';
UPDATE codes SET code_text = 'Urologie - Endoscopie - AUTRE' WHERE code_type = '11' AND code = '257271999';
UPDATE codes SET code_text = 'UROLOGIE - IMAGERIE DIAGNOSTIQUE' WHERE code_type = '11' AND code = '257272000';
UPDATE codes SET code_text = 'Urologie - Imagerie diagnostique - Urographie' WHERE code_type = '11' AND code = '257272121';
UPDATE codes SET code_text = 'Urologie - Imagerie diagnostique - AUTRE' WHERE code_type = '11' AND code = '257272999';
UPDATE codes SET code_text = 'UROLOGIE - DIAGNOSTIC  (AUTRES)' WHERE code_type = '11' AND code = '257273000';
UPDATE codes SET code_text = 'Urologie - Autres diagnostics - Examen' WHERE code_type = '11' AND code = '257273121';
UPDATE codes SET code_text = 'Urologie - Autres diagnostics -  Dépistage du cancer de la prostate' WHERE code_type = '11' AND code = '257273221';
UPDATE codes SET code_text = 'Urologie - Autres diagnostics - Péniscopie' WHERE code_type = '11' AND code = '257273321';
UPDATE codes SET code_text = 'Urologie - Autres diagnostics -  Autres services urologiques' WHERE code_type = '11' AND code = '257273421';
UPDATE codes SET code_text = 'Urologie - Autres diagnostics - AUTRE' WHERE code_type = '11' AND code = '257273999';
UPDATE codes SET code_text = 'UROLOGIE - CHIRURGIE' WHERE code_type = '11' AND code = '257274000';
UPDATE codes SET code_text = 'Urologie - Chirurgie masculine - Biopsie' WHERE code_type = '11' AND code = '257274123';
UPDATE codes SET code_text = 'Urologie - Chirurgie masculine - Circoncision' WHERE code_type = '11' AND code = '257274223';
UPDATE codes SET code_text = 'Urologie - Chirurgie masculine - Autres services chirurgiques' WHERE code_type = '11' AND code = '257274323';
UPDATE codes SET code_text = 'Urologie - Chirurgie masculine - AUTRE' WHERE code_type = '11' AND code = '257274999';
UPDATE codes SET code_text = 'INFERTILITE - SERVICES' WHERE code_type = '11' AND code = '258280000';
UPDATE codes SET code_text = 'Infertilité /  Hypofertilité - AUTRE' WHERE code_type = '11' AND code = '258280999';
UPDATE codes SET code_text = 'INFERTILITE - BIOPSIE' WHERE code_type = '11' AND code = '258281000';
UPDATE codes SET code_text = 'Infertilité - Biopsie - Biopsie de l`endomètre' WHERE code_type = '11' AND code = '258281123';
UPDATE codes SET code_text = 'Infertilité - Biopsie - Biopsie testiculaire' WHERE code_type = '11' AND code = '258281223';
UPDATE codes SET code_text = 'Infertilité - Biopsie - AUTRE' WHERE code_type = '11' AND code = '258281999';
UPDATE codes SET code_text = 'INFERTILITE - ENDOSCOPIE' WHERE code_type = '11' AND code = '258282000';
UPDATE codes SET code_text = 'Infertilité - Endoscopie - Coelioscopie' WHERE code_type = '11' AND code = '258282123';
UPDATE codes SET code_text = 'Infertilité - Endoscopie - Hystéroscopie' WHERE code_type = '11' AND code = '258282223';
UPDATE codes SET code_text = 'Infertilité - Endoscopie - AUTRE' WHERE code_type = '11' AND code = '258282999';
UPDATE codes SET code_text = 'INFERTILITE - IMAGERIE DIAGNOSTIQUE' WHERE code_type = '11' AND code = '258283000';
UPDATE codes SET code_text = 'Infertilité - Imagerie diagnostique - Hystérosalpingographie' WHERE code_type = '11' AND code = '258283121';
UPDATE codes SET code_text = 'Infertilité - Imagerie diagnostique - Echographie' WHERE code_type = '11' AND code = '258283221';
UPDATE codes SET code_text = 'Infertilité - Imagerie diagnostique - Hystérosalpingographie' WHERE code_type = '11' AND code = '258283321';
UPDATE codes SET code_text = 'Infertilité - Imagerie diagnostique - AUTRE' WHERE code_type = '11' AND code = '258283999';
UPDATE codes SET code_text = 'INFERTILITE - TEST EN LABORATOIRE' WHERE code_type = '11' AND code = '258284000';
UPDATE codes SET code_text = 'Infertilité - Test en laboratoire - Test post coïtal de Hühner' WHERE code_type = '11' AND code = '258284121';
UPDATE codes SET code_text = 'Infertilité - Test en laboratoire - Test de perméabilité des trompes de Fallope' WHERE code_type = '11' AND code = '258284221';
UPDATE codes SET code_text = 'Infertilité - Test en laboratoire - Test de provocation au citrate de clomifene (CCCT)' WHERE code_type = '11' AND code = '258284321';
UPDATE codes SET code_text = 'Infertilité - Test en laboratoire - Analyse du sperme' WHERE code_type = '11' AND code = '258284421';
UPDATE codes SET code_text = 'Infertilité - Test en laboratoire - Température basale' WHERE code_type = '11' AND code = '258284521';
UPDATE codes SET code_text = 'Infertilité - Test en laboratoire - Analyse mucosale' WHERE code_type = '11' AND code = '258284621';
UPDATE codes SET code_text = 'Infertilité - Test en laboratoire - Numérotation des spermatozoïdes' WHERE code_type = '11' AND code = '258284721';
UPDATE codes SET code_text = 'Infertilité - Test en laboratoire - Spermogramme' WHERE code_type = '11' AND code = '258284821';
UPDATE codes SET code_text = 'Infertilité - Test en laboratoire - Analyse hormonale' WHERE code_type = '11' AND code = '258284921';
UPDATE codes SET code_text = 'Infertilité - Tests de laboratoire - AUTRE' WHERE code_type = '11' AND code = '258284999';
UPDATE codes SET code_text = 'INFERTILITE - TRAITEMENTS' WHERE code_type = '11' AND code = '258286000';
UPDATE codes SET code_text = 'Infertilité - Traitement - Induction d`ovulation' WHERE code_type = '11' AND code = '258286122';
UPDATE codes SET code_text = 'Infertilité - Traitement - Transfert d`embryo' WHERE code_type = '11' AND code = '258286222';
UPDATE codes SET code_text = 'Infertilité - Traitement - Fécondation in vitro' WHERE code_type = '11' AND code = '258286322';
UPDATE codes SET code_text = 'Infertilité - Traitement - Transfert intratubaire de gamètes' WHERE code_type = '11' AND code = '258286422';
UPDATE codes SET code_text = 'Infertilité - Traitement - Insémination artificielle' WHERE code_type = '11' AND code = '258286522';
UPDATE codes SET code_text = 'Infertilité - Traitement - Don d`ovocytes' WHERE code_type = '11' AND code = '258286622';
UPDATE codes SET code_text = 'Infertilité - Traitement - Transfert intratubaire de zygotes' WHERE code_type = '11' AND code = '258286722';
UPDATE codes SET code_text = 'Infertilité - Traitement - AUTRE' WHERE code_type = '11' AND code = '258286999';
UPDATE codes SET code_text = 'INFERTILITE - CONSULTATIONJ' WHERE code_type = '11' AND code = '258288000';
UPDATE codes SET code_text = 'Infertilité /  Hypofertilité - Consultation' WHERE code_type = '11' AND code = '258288120';
UPDATE codes SET code_text = 'Infertilité /  Hypofertilité - Consultation - AUTRE' WHERE code_type = '11' AND code = '258288999';
UPDATE codes SET code_text = 'INFERTILITE - Counselling / conseils' WHERE code_type = '11' AND code = '258289000';
UPDATE codes SET code_text = 'Infertilité / Hypofertilité - Counselling' WHERE code_type = '11' AND code = '258289129';
UPDATE codes SET code_text = 'Infertilité /  Hypofertilité - Counselling - Autres services / Services génériques' WHERE code_type = '11' AND code = '258289999';
UPDATE codes SET code_text = 'AUTRES SERVICES DE COUNSELLING SPECIALISE' WHERE code_type = '11' AND code = '260290000';
UPDATE codes SET code_text = 'Autres services de counseling spécialisé - AUTRE' WHERE code_type = '11' AND code = '260290999';
UPDATE codes SET code_text = 'COUNSELING - VIOLENCE CONTRE LES FEMMES (VBG)' WHERE code_type = '11' AND code = '261291000';
UPDATE codes SET code_text = 'Counseling - VBG - Conseils Individuels' WHERE code_type = '11' AND code = '261291129';
UPDATE codes SET code_text = 'Counseling - VBG - Groupes de Soutien pour Survivantes' WHERE code_type = '11' AND code = '261291229';
UPDATE codes SET code_text = 'Counseling - VBG - Conseils Juridiques' WHERE code_type = '11' AND code = '261291329';
UPDATE codes SET code_text = 'Counseling - VBG - Abus Sexuel de la part du partenaire' WHERE code_type = '11' AND code = '261291429';
UPDATE codes SET code_text = 'Counseling - VBG - Abus physique de la part du partenaire' WHERE code_type = '11' AND code = '261291529';
UPDATE codes SET code_text = 'Counseling - VBG - Abus émotionnel/affectif de la part du partenaire' WHERE code_type = '11' AND code = '261291629';
UPDATE codes SET code_text = 'Counseling - VBG - Viol / Agression Sexuelle' WHERE code_type = '11' AND code = '261291729';
UPDATE codes SET code_text = 'Counseling - VBG - Dépistage Seulement' WHERE code_type = '11' AND code = '261291829';
UPDATE codes SET code_text = 'Counseling - VBG - AUTRE' WHERE code_type = '11' AND code = '261291999';
UPDATE codes SET code_text = 'COUNSELING - VIOLENCE DOMESTIQUE' WHERE code_type = '11' AND code = '262292000';
UPDATE codes SET code_text = 'Counseling - Violence domestique, maltraitance des enfants' WHERE code_type = '11' AND code = '262292129';
UPDATE codes SET code_text = 'Counseling - Violence domestique, maltraitance des enfants, dépistage seulement' WHERE code_type = '11' AND code = '262292229';
UPDATE codes SET code_text = 'Counseling - Violence domestique - AUTRE' WHERE code_type = '11' AND code = '262292999';
UPDATE codes SET code_text = 'COUNSELING - FAMILLE' WHERE code_type = '11' AND code = '262293000';
UPDATE codes SET code_text = 'Counseling - Famille - Relation Parent/Enfant' WHERE code_type = '11' AND code = '262293129';
UPDATE codes SET code_text = 'Counseling - Famille - Conflits Familiaux' WHERE code_type = '11' AND code = '262293229';
UPDATE codes SET code_text = 'Counseling - Famille - Délinquance' WHERE code_type = '11' AND code = '262293329';
UPDATE codes SET code_text = 'Counseling - Famille - AUTRE' WHERE code_type = '11' AND code = '262293999';
UPDATE codes SET code_text = 'COUNSELING - PRECONJUGAL ET CONJUGAL' WHERE code_type = '11' AND code = '262294000';
UPDATE codes SET code_text = 'Counseling - Préconjugal, y compris planification familiale préconjugal' WHERE code_type = '11' AND code = '262294129';
UPDATE codes SET code_text = 'Counseling - Conjugal - Relation, Négociation avec le/la partenaire' WHERE code_type = '11' AND code = '262294229';
UPDATE codes SET code_text = 'Counseling - Conjugal - Sexualité / Dysfonctionnement sexuel' WHERE code_type = '11' AND code = '262294329';
UPDATE codes SET code_text = 'Counseling - Conjugal - Conseils Conjugaux - AUTRE' WHERE code_type = '11' AND code = '262294999';
UPDATE codes SET code_text = 'COUNSELING - JEUNES (moins de 25 ans)' WHERE code_type = '11' AND code = '262295000';
UPDATE codes SET code_text = 'Counseling - Jeunes - Conseils sur les compétences essentielles' WHERE code_type = '11' AND code = '262295129';
UPDATE codes SET code_text = 'Counseling - Jeunes - Sexualité' WHERE code_type = '11' AND code = '262295229';
UPDATE codes SET code_text = 'Counseling - Jeunes - Conseils téléphoniques / Hotline' WHERE code_type = '11' AND code = '262295329';
UPDATE codes SET code_text = 'Counseling - Jeunes - Conseils en SSR' WHERE code_type = '11' AND code = '262295429';
UPDATE codes SET code_text = 'Counseling - Jeunes - AUTRE' WHERE code_type = '11' AND code = '262295999';
UPDATE codes SET code_text = 'COUNSELING - LES HOMMES' WHERE code_type = '11' AND code = '262296000';
UPDATE codes SET code_text = 'Counseling - Hommes - Conseils en SSR' WHERE code_type = '11' AND code = '262296129';
UPDATE codes SET code_text = 'Counseling - Hommes - Sexualité' WHERE code_type = '11' AND code = '262296229';
UPDATE codes SET code_text = 'Counseling - Hommes - VBG' WHERE code_type = '11' AND code = '262296329';
UPDATE codes SET code_text = 'Counseling - Homme - AUTRE' WHERE code_type = '11' AND code = '262296999';
UPDATE codes SET code_text = 'COUNSELING -AUTRE' WHERE code_type = '11' AND code = '263297000';
UPDATE codes SET code_text = 'Counseling - Autre - Questions liées à la sexualité (25 ans et plus)' WHERE code_type = '11' AND code = '263297129';
UPDATE codes SET code_text = 'Counseling - AUTRE' WHERE code_type = '11' AND code = '263297999';
UPDATE codes SET code_text = 'AUTRES SERVICES MEDICAUX DE SSR' WHERE code_type = '11' AND code = '269298000';
UPDATE codes SET code_text = 'Autres services médicaux de SSR - Consultation' WHERE code_type = '11' AND code = '269298120';
UPDATE codes SET code_text = 'Autres services médicaux de SSR - Test diagnostic' WHERE code_type = '11' AND code = '269298221';
UPDATE codes SET code_text = 'Autres services médicaux de SSR - Thérapie / Traitement' WHERE code_type = '11' AND code = '269298322';
UPDATE codes SET code_text = 'Autres services médicaux de SSR - Chirurgie' WHERE code_type = '11' AND code = '269298423';
UPDATE codes SET code_text = 'Autres services médicaux de SSR - - AUTRE' WHERE code_type = '11' AND code = '269298999';
UPDATE codes SET code_text = 'LES SERVICES SPECIALITES MEDICALES' WHERE code_type = '11' AND code = '370000000';
UPDATE codes SET code_text = 'SPECIALITES MEDICALES - SERVICES OREINTES SUR LES SYSTEMES' WHERE code_type = '11' AND code = '371300000';
UPDATE codes SET code_text = 'Spécialités médicales - Services orientés sur les systèmes' WHERE code_type = '11' AND code = '371300999';
UPDATE codes SET code_text = 'ANGIOLOGIE' WHERE code_type = '11' AND code = '371301000';
UPDATE codes SET code_text = 'Angiologie - Consultation' WHERE code_type = '11' AND code = '371301130';
UPDATE codes SET code_text = 'Angiologie - Test diagnostique' WHERE code_type = '11' AND code = '371301231';
UPDATE codes SET code_text = 'Angiologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371301332';
UPDATE codes SET code_text = 'Angiologie - Chirurgie' WHERE code_type = '11' AND code = '371301433';
UPDATE codes SET code_text = 'Angiologie - AUTRE' WHERE code_type = '11' AND code = '371301999';
UPDATE codes SET code_text = 'CARDIOLOGIE' WHERE code_type = '11' AND code = '371311000';
UPDATE codes SET code_text = 'Cardiologie - Consultation' WHERE code_type = '11' AND code = '371311130';
UPDATE codes SET code_text = 'Cardiologie - Test diagnostique' WHERE code_type = '11' AND code = '371311231';
UPDATE codes SET code_text = 'Cardiologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371311332';
UPDATE codes SET code_text = 'Cardiologie - Chirurgie' WHERE code_type = '11' AND code = '371311433';
UPDATE codes SET code_text = 'Cardiologie - AUTRE' WHERE code_type = '11' AND code = '371311999';
UPDATE codes SET code_text = 'DENTISTERIE' WHERE code_type = '11' AND code = '371321000';
UPDATE codes SET code_text = 'Dentisterie - Diagnostic' WHERE code_type = '11' AND code = '371321131';
UPDATE codes SET code_text = 'Dentisterie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371321232';
UPDATE codes SET code_text = 'Dentisterie - Orthodontie' WHERE code_type = '11' AND code = '371321332';
UPDATE codes SET code_text = 'Dentisterie - Parodontie' WHERE code_type = '11' AND code = '371321432';
UPDATE codes SET code_text = 'Dentisterie - Chirurgie' WHERE code_type = '11' AND code = '371321533';
UPDATE codes SET code_text = 'Dentisterie -AUTRE' WHERE code_type = '11' AND code = '371321999';
UPDATE codes SET code_text = 'DERMATOLOGY' WHERE code_type = '11' AND code = '371331000';
UPDATE codes SET code_text = 'Dermatologie - Consultation' WHERE code_type = '11' AND code = '371331130';
UPDATE codes SET code_text = 'Dermatologie - Test diagnostique' WHERE code_type = '11' AND code = '371331231';
UPDATE codes SET code_text = 'Dermatologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371331332';
UPDATE codes SET code_text = 'Dermatologie - Chirurgie' WHERE code_type = '11' AND code = '371331433';
UPDATE codes SET code_text = 'Dermatologie - AUTRE' WHERE code_type = '11' AND code = '371331999';
UPDATE codes SET code_text = 'ENDOCRINOLOGIE' WHERE code_type = '11' AND code = '371341000';
UPDATE codes SET code_text = 'Endocrinologie - Consultation' WHERE code_type = '11' AND code = '371341130';
UPDATE codes SET code_text = 'Endocrinologie - Test diagnostique' WHERE code_type = '11' AND code = '371341231';
UPDATE codes SET code_text = 'Endocrinologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371341332';
UPDATE codes SET code_text = 'Endocrinologie - Chirurgie' WHERE code_type = '11' AND code = '371341433';
UPDATE codes SET code_text = 'Endocrinologie - AUTRE' WHERE code_type = '11' AND code = '371341999';
UPDATE codes SET code_text = 'GASTROENTEROLOGIE' WHERE code_type = '11' AND code = '371351000';
UPDATE codes SET code_text = 'Gastroentérologie - Consultation' WHERE code_type = '11' AND code = '371351130';
UPDATE codes SET code_text = 'Gastroentérologie - Test diagnostique' WHERE code_type = '11' AND code = '371351231';
UPDATE codes SET code_text = 'Gastroentérologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371351332';
UPDATE codes SET code_text = 'Gastroentérologie - Chirurgie' WHERE code_type = '11' AND code = '371351433';
UPDATE codes SET code_text = 'Gastroentérologie - AUTRE' WHERE code_type = '11' AND code = '371351999';
UPDATE codes SET code_text = 'GENETIQUE' WHERE code_type = '11' AND code = '371361000';
UPDATE codes SET code_text = 'Génétique - Counseling' WHERE code_type = '11' AND code = '371361129';
UPDATE codes SET code_text = 'Génétique - Test diagnostique' WHERE code_type = '11' AND code = '371361230';
UPDATE codes SET code_text = 'Génétique - Thérapie / Traitement' WHERE code_type = '11' AND code = '371361331';
UPDATE codes SET code_text = 'Génétique - Chirurgie' WHERE code_type = '11' AND code = '371361432';
UPDATE codes SET code_text = 'Génétique - AUTRE' WHERE code_type = '11' AND code = '371361999';
UPDATE codes SET code_text = 'NEPHROLOGIE' WHERE code_type = '11' AND code = '371371000';
UPDATE codes SET code_text = 'Néphrologie - Consultation' WHERE code_type = '11' AND code = '371371130';
UPDATE codes SET code_text = 'Néphrologie - Test diagnostique' WHERE code_type = '11' AND code = '371371231';
UPDATE codes SET code_text = 'Néphrologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371371332';
UPDATE codes SET code_text = 'Néphrologie - Chirurgie' WHERE code_type = '11' AND code = '371371433';
UPDATE codes SET code_text = 'Néphrologie - AUTRE' WHERE code_type = '11' AND code = '371371999';
UPDATE codes SET code_text = 'PNEUMOLOGIE' WHERE code_type = '11' AND code = '371381000';
UPDATE codes SET code_text = 'Pneumologie - Consultation' WHERE code_type = '11' AND code = '371381130';
UPDATE codes SET code_text = 'Pneumologie  - Test diagnostique' WHERE code_type = '11' AND code = '371381231';
UPDATE codes SET code_text = 'Pneumologie  - Thérapie / Traitement' WHERE code_type = '11' AND code = '371381332';
UPDATE codes SET code_text = 'Pneumologie - Chirurgie' WHERE code_type = '11' AND code = '371381433';
UPDATE codes SET code_text = 'Pneumologie - AUTRE' WHERE code_type = '11' AND code = '371381999';
UPDATE codes SET code_text = 'NEUROLOGIE' WHERE code_type = '11' AND code = '371391000';
UPDATE codes SET code_text = 'Neurologie - Consultation' WHERE code_type = '11' AND code = '371391130';
UPDATE codes SET code_text = 'Neurologie - Test diagnostique' WHERE code_type = '11' AND code = '371391231';
UPDATE codes SET code_text = 'Neurologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371391332';
UPDATE codes SET code_text = 'Neurologie - Chirurgie' WHERE code_type = '11' AND code = '371391433';
UPDATE codes SET code_text = 'Neurologie - AUTRE' WHERE code_type = '11' AND code = '371391999';
UPDATE codes SET code_text = 'OPHTALMOLOGIE' WHERE code_type = '11' AND code = '371401000';
UPDATE codes SET code_text = 'Ophtalmologie - Consultation' WHERE code_type = '11' AND code = '371401130';
UPDATE codes SET code_text = 'Ophtalmologie - Test diagnostique' WHERE code_type = '11' AND code = '371401231';
UPDATE codes SET code_text = 'Ophtalmologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371401332';
UPDATE codes SET code_text = 'Ophtalmologie - Chirurgie' WHERE code_type = '11' AND code = '371401433';
UPDATE codes SET code_text = 'Ophtalmologie - AUTRE' WHERE code_type = '11' AND code = '371401999';
UPDATE codes SET code_text = 'ORTHOPEDIE' WHERE code_type = '11' AND code = '371411000';
UPDATE codes SET code_text = 'Orthopédie - Consultation' WHERE code_type = '11' AND code = '371411130';
UPDATE codes SET code_text = 'Orthopédie - Test diagnostique' WHERE code_type = '11' AND code = '371411231';
UPDATE codes SET code_text = 'Orthopédie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371411332';
UPDATE codes SET code_text = 'Orthopédie - Chirurgie' WHERE code_type = '11' AND code = '371411433';
UPDATE codes SET code_text = 'Orthopédie -AUTRE' WHERE code_type = '11' AND code = '371411999';
UPDATE codes SET code_text = 'OTORHINOLARYNGOLOGIE' WHERE code_type = '11' AND code = '371421000';
UPDATE codes SET code_text = 'Otorhinolaryngologie - Consultation' WHERE code_type = '11' AND code = '371421130';
UPDATE codes SET code_text = 'Otorhinolaryngologie - Test diagnostique' WHERE code_type = '11' AND code = '371421231';
UPDATE codes SET code_text = 'Otorhinolaryngologie  - Thérapie / Traitement' WHERE code_type = '11' AND code = '371421332';
UPDATE codes SET code_text = 'Otorhinolaryngologie  - Chirurgie' WHERE code_type = '11' AND code = '371421433';
UPDATE codes SET code_text = 'Otorhinolaryngologie - AUTRE' WHERE code_type = '11' AND code = '371421999';
UPDATE codes SET code_text = 'PODOLOGIE' WHERE code_type = '11' AND code = '371431000';
UPDATE codes SET code_text = 'Podologie - Consultation' WHERE code_type = '11' AND code = '371431130';
UPDATE codes SET code_text = 'Podologie - Test diagnostique' WHERE code_type = '11' AND code = '371431231';
UPDATE codes SET code_text = 'Podologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371431332';
UPDATE codes SET code_text = 'Podologie - Chirurgie' WHERE code_type = '11' AND code = '371431433';
UPDATE codes SET code_text = 'Podologie - AUTRE' WHERE code_type = '11' AND code = '371431999';
UPDATE codes SET code_text = 'RHUMATOLOGIE' WHERE code_type = '11' AND code = '371441000';
UPDATE codes SET code_text = 'Rhumatologie - Consultation' WHERE code_type = '11' AND code = '371441130';
UPDATE codes SET code_text = 'Rhumatologie - Test diagnostique' WHERE code_type = '11' AND code = '371441231';
UPDATE codes SET code_text = 'Rhumatologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '371441332';
UPDATE codes SET code_text = 'Rhumatologie - Chirurgie' WHERE code_type = '11' AND code = '371441433';
UPDATE codes SET code_text = 'Rhumatologie - AUTRE' WHERE code_type = '11' AND code = '371441999';
UPDATE codes SET code_text = 'SPECIALITES MEDICALES - SERVICES ORIENTES SUR LES MALADIES' WHERE code_type = '11' AND code = '372500000';
UPDATE codes SET code_text = 'Spécialités médicales - Services orientés sur les maladies' WHERE code_type = '11' AND code = '372500999';
UPDATE codes SET code_text = 'OPTOMETRIE' WHERE code_type = '11' AND code = '372501000';
UPDATE codes SET code_text = 'Optométrie - Consultation' WHERE code_type = '11' AND code = '372501130';
UPDATE codes SET code_text = 'Optométrie - Examen diagnostique' WHERE code_type = '11' AND code = '372501231';
UPDATE codes SET code_text = 'Optométrie - AUTRE' WHERE code_type = '11' AND code = '372501999';
UPDATE codes SET code_text = 'PSYCHIATRIE' WHERE code_type = '11' AND code = '372511000';
UPDATE codes SET code_text = 'Psychiatrie - Consultation Diagnostique' WHERE code_type = '11' AND code = '372511131';
UPDATE codes SET code_text = 'Psychiatrie - Thérapie / Traitement' WHERE code_type = '11' AND code = '372511232';
UPDATE codes SET code_text = 'Psychiatrie - AUTRE' WHERE code_type = '11' AND code = '372511999';
UPDATE codes SET code_text = 'PSYCHOLOGIE' WHERE code_type = '11' AND code = '372521000';
UPDATE codes SET code_text = 'Psychologie - Consultation Diagnostique' WHERE code_type = '11' AND code = '372521131';
UPDATE codes SET code_text = 'Psychologie  - Thérapie / Traitement' WHERE code_type = '11' AND code = '372521232';
UPDATE codes SET code_text = 'Psychologie - AUTRE' WHERE code_type = '11' AND code = '372521999';
UPDATE codes SET code_text = 'RADIOLOGIE' WHERE code_type = '11' AND code = '372531000';
UPDATE codes SET code_text = 'Radiologie - Imagerie Diagnostique' WHERE code_type = '11' AND code = '372531131';
UPDATE codes SET code_text = 'Radiologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '372531232';
UPDATE codes SET code_text = 'Radiologie - AUTRE' WHERE code_type = '11' AND code = '372531999';
UPDATE codes SET code_text = 'ONCOLOGIE' WHERE code_type = '11' AND code = '372541000';
UPDATE codes SET code_text = 'Oncologie - Test Diagnostique' WHERE code_type = '11' AND code = '372541131';
UPDATE codes SET code_text = 'Oncologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '372541232';
UPDATE codes SET code_text = 'Oncologie - Chirurgie' WHERE code_type = '11' AND code = '372541333';
UPDATE codes SET code_text = 'Oncologie - AUTRE' WHERE code_type = '11' AND code = '372541999';
UPDATE codes SET code_text = 'ALLERGIE' WHERE code_type = '11' AND code = '372551000';
UPDATE codes SET code_text = 'Allergies - Consultation' WHERE code_type = '11' AND code = '372551130';
UPDATE codes SET code_text = 'Allergies - Test diagnostique' WHERE code_type = '11' AND code = '372551231';
UPDATE codes SET code_text = 'Allergies - Thérapie / Traitement' WHERE code_type = '11' AND code = '372551332';
UPDATE codes SET code_text = 'Allergies - AUTRE' WHERE code_type = '11' AND code = '372551999';
UPDATE codes SET code_text = 'IMMUNOLGIE' WHERE code_type = '11' AND code = '372561000';
UPDATE codes SET code_text = 'Immunologie - Consultation' WHERE code_type = '11' AND code = '372561130';
UPDATE codes SET code_text = 'Immunologie - Test diagnostique' WHERE code_type = '11' AND code = '372561231';
UPDATE codes SET code_text = 'Immunologie - AUTRE' WHERE code_type = '11' AND code = '372561999';
UPDATE codes SET code_text = 'SPECIALITES MEDICALES - SERVICES ORIENTES SUR LES COMMUNAUTES' WHERE code_type = '11' AND code = '373600000';
UPDATE codes SET code_text = 'Spécialités médicales - Services orientés sur les communautés' WHERE code_type = '11' AND code = '373600999';
UPDATE codes SET code_text = 'SANTE FAMILIALE' WHERE code_type = '11' AND code = '373601000';
UPDATE codes SET code_text = 'Santé Familiale - Dépistage de l`hypertension' WHERE code_type = '11' AND code = '373601131';
UPDATE codes SET code_text = 'Santé Familiale - Examen physique' WHERE code_type = '11' AND code = '373601231';
UPDATE codes SET code_text = 'Santé Familiale - Poids & signes vitaux' WHERE code_type = '11' AND code = '373601331';
UPDATE codes SET code_text = 'Santé Familiale - Dépistage du diabète' WHERE code_type = '11' AND code = '373601431';
UPDATE codes SET code_text = 'Santé Familiale - Analyse d`urine' WHERE code_type = '11' AND code = '373601531';
UPDATE codes SET code_text = 'Santé Familiale - Dépistage du cholestérol' WHERE code_type = '11' AND code = '373601631';
UPDATE codes SET code_text = 'Santé Familiale - Conseils sur la nutrition' WHERE code_type = '11' AND code = '373601729';
UPDATE codes SET code_text = 'Santé Familiale - Conseils sur les régimes/ le contrôle du poids' WHERE code_type = '11' AND code = '373601829';
UPDATE codes SET code_text = 'Santé Familial - AUTRE' WHERE code_type = '11' AND code = '373601999';
UPDATE codes SET code_text = 'GERIATRIE' WHERE code_type = '11' AND code = '373621000';
UPDATE codes SET code_text = 'Gériatrie - Consultation' WHERE code_type = '11' AND code = '373621130';
UPDATE codes SET code_text = 'Gériatrie - Test diagnostique' WHERE code_type = '11' AND code = '373621231';
UPDATE codes SET code_text = 'Gériatrie - Thérapie / Traitement' WHERE code_type = '11' AND code = '373621332';
UPDATE codes SET code_text = 'Gériatrie - AUTRE' WHERE code_type = '11' AND code = '373621999';
UPDATE codes SET code_text = 'PEDIATRIE' WHERE code_type = '11' AND code = '373641000';
UPDATE codes SET code_text = 'Pédiatrie - Consultation' WHERE code_type = '11' AND code = '373641130';
UPDATE codes SET code_text = 'Pédiatrie - Diagnostic - Dépistage Néonatal (à la naissance)' WHERE code_type = '11' AND code = '373641231';
UPDATE codes SET code_text = 'Pédiatrie - diagnostic - Soins au bébé en bonne santé / Santé infantile' WHERE code_type = '11' AND code = '373641331';
UPDATE codes SET code_text = 'Pédiatrie - Thérapie / Traitement - Nutrition' WHERE code_type = '11' AND code = '373641432';
UPDATE codes SET code_text = 'Pédiatrie - Thérapie / Traitement - Immunisation' WHERE code_type = '11' AND code = '373641532';
UPDATE codes SET code_text = 'Pédiatrie - Thérapie / Traitement - Réhydratation orale' WHERE code_type = '11' AND code = '373641632';
UPDATE codes SET code_text = 'Pédiatrie - Thérapie / Traitement - Soins intensifs néonatals' WHERE code_type = '11' AND code = '373641732';
UPDATE codes SET code_text = 'Pédiatrie - Chirurgie - Circoncision' WHERE code_type = '11' AND code = '373641833';
UPDATE codes SET code_text = 'Pédiatrie - AUTRE' WHERE code_type = '11' AND code = '373641999';
UPDATE codes SET code_text = 'MEDECINE PHYSIQUE ET DE READAPTATION' WHERE code_type = '11' AND code = '373661000';
UPDATE codes SET code_text = 'Médecine physique et de réadaptation - Consultation' WHERE code_type = '11' AND code = '373661130';
UPDATE codes SET code_text = 'Médecine physique et de réadaptation - Test diagnostique' WHERE code_type = '11' AND code = '373661231';
UPDATE codes SET code_text = 'Médecine physique et de réadaptation - Thérapie / Traitement' WHERE code_type = '11' AND code = '373661332';
UPDATE codes SET code_text = 'Médecine physique et de réadaptation - Chirurgie' WHERE code_type = '11' AND code = '373661433';
UPDATE codes SET code_text = 'Médecine physique et de réadaptation - AUTRE' WHERE code_type = '11' AND code = '373661999';
UPDATE codes SET code_text = 'MEDECINE PREVENTIVE' WHERE code_type = '11' AND code = '373671000';
UPDATE codes SET code_text = 'Médecine préventive - Consultation' WHERE code_type = '11' AND code = '373671130';
UPDATE codes SET code_text = 'Médecine préventive -Test diagnostique' WHERE code_type = '11' AND code = '373671231';
UPDATE codes SET code_text = 'Médecine préventive - AUTRE' WHERE code_type = '11' AND code = '373671999';
UPDATE codes SET code_text = 'MEDECINE D`URGENCE' WHERE code_type = '11' AND code = '373681000';
UPDATE codes SET code_text = 'Médecine d`urgence - Evaluation' WHERE code_type = '11' AND code = '373681131';
UPDATE codes SET code_text = 'Médecine d`urgence - Traitement initial' WHERE code_type = '11' AND code = '373681232';
UPDATE codes SET code_text = 'Médecine d`urgence - Chirurgie d`urgence' WHERE code_type = '11' AND code = '373681333';
UPDATE codes SET code_text = 'Médecine d`urgence - AUTRE' WHERE code_type = '11' AND code = '373681999';
UPDATE codes SET code_text = 'HOSPITALISATION' WHERE code_type = '11' AND code = '373691000';
UPDATE codes SET code_text = 'Hospitalisation - Ambulatoire (1 journée)' WHERE code_type = '11' AND code = '373691140';
UPDATE codes SET code_text = 'Hospitalisation - Prolongée (>1 journée)' WHERE code_type = '11' AND code = '373691241';
UPDATE codes SET code_text = 'Hospitalisation - AUTRE' WHERE code_type = '11' AND code = '373691999';
UPDATE codes SET code_text = 'SPECIALITES MEDICALES - DIAGNOSTICS ET PROCEDURES THERAPEUTIQUES' WHERE code_type = '11' AND code = '374700000';
UPDATE codes SET code_text = 'Spécialités médicales - Diagnostic / Procédures thérapeutiques - AUTRE' WHERE code_type = '11' AND code = '374700999';
UPDATE codes SET code_text = 'HEMATOLOGY' WHERE code_type = '11' AND code = '374701000';
UPDATE codes SET code_text = 'Hématologie - Consultation' WHERE code_type = '11' AND code = '374701130';
UPDATE codes SET code_text = 'Hématologie - Test diagnostique' WHERE code_type = '11' AND code = '374701231';
UPDATE codes SET code_text = 'Hématologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '374701332';
UPDATE codes SET code_text = 'Hématologie - AUTRE' WHERE code_type = '11' AND code = '374701999';
UPDATE codes SET code_text = 'TOXICOLOGIE' WHERE code_type = '11' AND code = '374721000';
UPDATE codes SET code_text = 'Toxicologie - Consultation' WHERE code_type = '11' AND code = '374721130';
UPDATE codes SET code_text = 'Toxicologie - Test Diagnostique' WHERE code_type = '11' AND code = '374721231';
UPDATE codes SET code_text = 'Toxicologie - Thérapie / Traitement' WHERE code_type = '11' AND code = '374721332';
UPDATE codes SET code_text = 'Toxicologie - AUTRE' WHERE code_type = '11' AND code = '374721999';
UPDATE codes SET code_text = 'PATHOLOGIE CHIMIQUE, TESTS DE LABORATOIRE' WHERE code_type = '11' AND code = '374741000';
UPDATE codes SET code_text = 'Pathologie chimique - Consultation' WHERE code_type = '11' AND code = '374741130';
UPDATE codes SET code_text = 'Pathologie chimique - Test diagnostique' WHERE code_type = '11' AND code = '374741231';
UPDATE codes SET code_text = 'Pathologie chimique - AUTRE' WHERE code_type = '11' AND code = '374751999';
UPDATE codes SET code_text = 'PATHOLOGIE, TESTS DE LABORATOIRE' WHERE code_type = '11' AND code = '374761000';
UPDATE codes SET code_text = 'Pathologie  - Consultation' WHERE code_type = '11' AND code = '374761130';
UPDATE codes SET code_text = 'Pathologie - Test Diagnostique' WHERE code_type = '11' AND code = '374761231';
UPDATE codes SET code_text = 'Pathologie - AUTRE' WHERE code_type = '11' AND code = '374761999';
UPDATE codes SET code_text = 'MICROBIOLOGIE' WHERE code_type = '11' AND code = '374781000';
UPDATE codes SET code_text = 'Microbiologie - Consultation' WHERE code_type = '11' AND code = '374781130';
UPDATE codes SET code_text = 'Microbiologie - Test diagnostique' WHERE code_type = '11' AND code = '374781231';
UPDATE codes SET code_text = 'Microbiologie - AUTRE' WHERE code_type = '11' AND code = '374781999';
UPDATE codes SET code_text = 'SPECIALITES MEDICALES - AUTRES SERVICES' WHERE code_type = '11' AND code = '375800000';
UPDATE codes SET code_text = 'Spécialités médicales - AUTRE' WHERE code_type = '11' AND code = '375800999';
UPDATE codes SET code_text = 'CHIROPRACTIQUE' WHERE code_type = '11' AND code = '375801000';
UPDATE codes SET code_text = 'Chiropratique - Consultation' WHERE code_type = '11' AND code = '375801130';
UPDATE codes SET code_text = 'Chiropratique - Test diagnostique' WHERE code_type = '11' AND code = '375801232';
UPDATE codes SET code_text = 'Chiropratique - AUTRE' WHERE code_type = '11' AND code = '375801999';
UPDATE codes SET code_text = 'OSTEOPATHIE' WHERE code_type = '11' AND code = '375811000';
UPDATE codes SET code_text = 'Ostéopathie - Consultation' WHERE code_type = '11' AND code = '375811130';
UPDATE codes SET code_text = 'Ostéopathie - Thérapie / Traitement' WHERE code_type = '11' AND code = '375811232';
UPDATE codes SET code_text = 'Ostéopathie -  Test diagnostique' WHERE code_type = '11' AND code = '375811331';
UPDATE codes SET code_text = 'Ostéopathie - AUTRE' WHERE code_type = '11' AND code = '375811999';
UPDATE codes SET code_text = 'CHIRURGIE ESTHETIQUE' WHERE code_type = '11' AND code = '375821000';
UPDATE codes SET code_text = 'Chirurgie esthétique - Consultation' WHERE code_type = '11' AND code = '375821130';
UPDATE codes SET code_text = 'Chirurgie esthétique- Thérapie / Traitement' WHERE code_type = '11' AND code = '375821232';
UPDATE codes SET code_text = 'Chirurgie esthétique - Chirurgie' WHERE code_type = '11' AND code = '375821333';
UPDATE codes SET code_text = 'Chirurgie esthétique - AUTRE' WHERE code_type = '11' AND code = '375821999';
UPDATE codes SET code_text = 'AUTRES SERVICES MEDICAUX AUTRES QUE LA SSR' WHERE code_type = '11' AND code = '375831000';
UPDATE codes SET code_text = 'Tous les services médicaux autres que la SSR - Consultation' WHERE code_type = '11' AND code = '375831130';
UPDATE codes SET code_text = 'Tous les services médicaux autres que la SSR - Test diagnostic' WHERE code_type = '11' AND code = '375831231';
UPDATE codes SET code_text = 'Tous les services médicaux autres que la SSR - Thérapie / Traitement' WHERE code_type = '11' AND code = '375831332';
UPDATE codes SET code_text = 'Tous les services médicaux autres que la SSR - Chirurgie' WHERE code_type = '11' AND code = '375831433';
UPDATE codes SET code_text = 'Tous les services médicaux autres que la SSR - Counseling' WHERE code_type = '11' AND code = '375831539';
UPDATE codes SET code_text = 'Tous les services médicaux autres que la SSR - AUTRE' WHERE code_type = '11' AND code = '375831999';
UPDATE codes SET code_text = 'AUTRES SERVICES AUTRES QUE LA SSR' WHERE code_type = '11' AND code = '380910000';
UPDATE codes SET code_text = 'TOUS LES AUTRES SERVICES AUTRES QUE LA SSR - AUTRE' WHERE code_type = '11' AND code = '380910999';
UPDATE codes SET code_text = 'VENTE ET LOCATION' WHERE code_type = '11' AND code = '380911000';
UPDATE codes SET code_text = 'Vente et Location - AUTRE' WHERE code_type = '11' AND code = '380911999';
UPDATE codes SET code_text = 'VENTES DE MEDICAMENTS, BIENS ET EQUIPEMENTS' WHERE code_type = '11' AND code = '381912000';
UPDATE codes SET code_text = 'Ventes de Médicaments' WHERE code_type = '11' AND code = '381912150';
UPDATE codes SET code_text = 'Vente de Biens Médicaux' WHERE code_type = '11' AND code = '381912250';
UPDATE codes SET code_text = 'Vente d`Equipements Médicaux' WHERE code_type = '11' AND code = '381912350';
UPDATE codes SET code_text = 'Vente - AUTRE' WHERE code_type = '11' AND code = '381913999';
UPDATE codes SET code_text = 'LOCATION D`EQUIPEMENTS MEDICAUX /D` INFRASTRUCTURES' WHERE code_type = '11' AND code = '382914000';
UPDATE codes SET code_text = 'Location d`infrastructures médicales' WHERE code_type = '11' AND code = '382914450';
UPDATE codes SET code_text = 'Location d`infrastructures médicales' WHERE code_type = '11' AND code = '382914450';
UPDATE codes SET code_text = 'Location d`équipements médicaux / d`infrastructures - AUTRE' WHERE code_type = '11' AND code = '382915999';
UPDATE codes SET code_text = 'LES PRODUITS ET SERVICES NON MEDICAUX' WHERE code_type = '11' AND code = '490000000';
UPDATE codes SET code_text = 'AUTRES PRODUITS ET SERVICES NON MEDICAUX' WHERE code_type = '11' AND code = '491990000';
UPDATE codes SET code_text = 'Tous les produits et services non médicaux - Vente de matériels d`IEC' WHERE code_type = '11' AND code = '491990190';
UPDATE codes SET code_text = 'Autres produits non-médicaux  & Services - Distribution gratuite de matériels  d`IEC' WHERE code_type = '11' AND code = '491990290';
UPDATE codes SET code_text = 'Tous les produits et services non médicaux -  AUTRES' WHERE code_type = '11' AND code = '491990999';
UPDATE codes SET code_text = 'AUTRES SERVICES NON MEDICALE DE VENTE' WHERE code_type = '11' AND code = '492992000';
UPDATE codes SET code_text = 'Tous les produits et services non médicaux - Ventes de services d`IEC' WHERE code_type = '11' AND code = '492992090';
UPDATE codes SET code_text = 'Tous les produits et services non médicaux - AUTRE' WHERE code_type = '11' AND code = '492992999';

