TRUNCATE TABLE thesaurus; INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (1, '01 - MONDE AGRICOLE', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (2, '02 - COMMUNICATION-CULTURE-EDUCATION', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (3, '03 - MONDE ECONOMIQUE', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (4, '04 - ENVIRONNEMENT', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (5, '05 - INTERNATIONAL ET UNION EUROPEENNE', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (6, '06 - SANTE', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (7, '07 - SOCIAL', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (8, '08 - SOCIETE', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (9, '09 - VIE ADMINISTRATIVE ET POLITIQUE', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (10, '10 - VIE PROFESSIONNELLE', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (11, '11 - LISTES ANNEXES', '', '', '', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (12, 'Abandon d''enfant', '', '', 'Situation familiale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (13, 'Abattement', '', '', 'Fiscalité', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (14, 'Abattoir', '', '', 'Industrie agroalimentaire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (15, 'Abeille', '', '', 'Insecte', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (16, 'Abrogation', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (17, 'Absentéisme', '', '', 'Comportement au travail', NULL, 'Absence'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (18, 'Abus sexuel', '', '', 'Problème social', NULL, 'Violence sexuelle'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (19, 'Accès aux documents administratifs', '', '', 'Relation administration-usager', NULL, 'Communication des documents administratifs'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (20, 'Accès aux origines', 'La loi 2001-93 du 11 janvier 2001 relative à l''accès aux origines des personnes adoptées et pupilles de l''État vise à limiter les cas dans lesquels un enfant peut être privé des informations concernant son identité et ses origines et tend également à favoriser les retrouvailles entre l''enfant et ses parents biologiques en créant le Conseil national pour l''accès aux origines personnelles (CNAOP).', '', 'Situation familiale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (21, 'Accès aux soins', '', '', 'Planification sanitaire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (22, 'Accession à la propriété', '', 'Plan local d''urbanisme (PLU)', 'Propriété', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (23, 'Accident', '', '', 'Situation de crise', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (24, 'Accident chimique', '', '', 'Accident technologique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (25, 'Accident d''avion', '', 'Accident', 'Sécurité aérienne', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (26, 'Accident domestique', '', '', 'Santé individuelle', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (27, 'Accident du travail', '', '', 'Sécurité au travail', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (28, 'Accident nucléaire', '', '', 'Accident technologique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (29, 'Accident scolaire', '', '', 'Education', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (30, 'Accident technologique', '', '', 'Risque majeur', NULL, 'Accident industriel'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (31, 'Accident vasculaire cérébral (AVC)', '', '', 'Maladie cérébro-vasculaire', NULL, 'AVC'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (32, 'Accompagnement scolaire', '', 'Réserve citoyenne', 'Scolarité', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (33, 'Accord', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (34, 'Accord cadre', 'L''accord cadre est un accord général conclu entre différentes parties (partenaires sociaux, Etat) Il fixe de grands principes destinés à être précisés ultérieurement. Cette notion s''emploie dans différents domaines notamment dans le cadre de la négociation collective, mais également dans le cadre des marchés publics.', '', 'Texte juridique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (35, 'Accord collectif de travail', '', '', 'Négociation collective', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (36, 'Accord de branche', '', '', 'Négociation collective', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (37, 'Accord de groupe', '', '', 'Négociation collective', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (38, 'Accord de pêche', '', '', 'Politique de la pêche', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (39, 'Accord de Schengen', '', '', 'Droit de l''Union européenne', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (40, 'Accord d''entreprise', '', '', 'Négociation collective', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (41, 'Accord préélectoral', '', '', 'Election', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (42, 'Accord salarial', '', '', 'Négociation collective', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (43, 'Accord UE - Turquie sur les migrants', '', '', 'Droit de l''Union européenne', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (44, 'Accords de Paris', '', '', 'Changement climatique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (45, 'Accouchement', '', '', 'Obstétrique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (46, 'Accouchement sous X', '', '', 'Situation familiale', NULL, 'Accouchement anonyme'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (47, 'Accueil', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (48, 'Accueil de jour médicalisé', 'Constitue une déclinaison de l''accueil de jour qui consiste à accueillir pour une ou plusieurs journées par semaine, voire une demi-journée des personnes âgées vivant à leur domicile, dans des locaux dédiés à cet accueil. Ce type d''accueil s''adresse essentiellement à des personnes atteintes de maladie d''Alzheimer ou de troubles apparentés. Ils peuvent être autonomes ou rattachés à une structure telle qu''un EHPAD. Il s''agit d''un ESMS tel défini à l''article L311-1.I.6e du code de l''action sociale et des familles.', '', 'Hôpital', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (49, 'Accueillant familial', 'Titulaire d''un agrément, l''accueillant familial accueille à son domicile moyennant rémunération des personnes âgées ou des personnes handicapées. Son statut est fixé par la loi du 17 janvier 2001 de modernisation sociale et complétée par l''article 57 de la loi du 5 mars 2007 instituant le droit au logement opposable.', '', 'Métier de la dépendance', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (50, 'Acharnement thérapeutique', '', '', 'Fin de vie', NULL, 'Acharnement médical'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (51, 'Achat public', '', '', 'Marché public', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (52, 'Acquisition de la nationalité', '', '', 'Nationalité', NULL, 'Naturalisation'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (53, 'Acte administratif', '', '', 'Droit public', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (54, 'Acte médical', '', '', 'Corps humain et pratique médicale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (55, 'Acte unique européen', '', '', 'Union européenne', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (56, 'Action culturelle', '', '', 'Politique culturelle', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (57, 'Action logement', 'Participation des employeurs à l''effort de construction (PEEC)', '', 'Politique du logement', NULL, '1 % logement'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (58, 'Action parlementaire', '', '', 'Parlement', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (59, 'Actionnariat', '', '', 'Financement de l''économie', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (60, 'Actionnariat salarial', '', '', 'Financement de l''économie', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (61, 'Activité agricole', '', '', 'Agriculture', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (62, 'Activité syndicale', '', '', 'Syndicalisme', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (63, 'Activités d''adultes relais', '', '', 'Type de contrat', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (64, 'Acupuncture', '', '', 'Médecine non conventionnelle', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (65, 'Addictologie', '', '', 'Spécialité médicale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (66, 'Adhésion', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (67, 'Adhésion à l''Union européenne', '', '', 'Elargissement de l''Union européenne', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (68, 'Administration centrale', '', '', 'Organisation administrative', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (69, 'Administration publique', '', '', '09 - VIE ADMINISTRATIVE ET POLITIQUE', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (70, 'Admission', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (71, 'ADN', '', '', 'Chromosome', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (72, 'Adoption', '', '', 'Situation familiale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (73, 'Aéronef', '', '', 'Transport aérien', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (74, 'Aéroport', '', '', 'Infrastructure aéronautique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (75, 'Affaires intérieures', '', '', '09 - VIE ADMINISTRATIVE ET POLITIQUE', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (76, 'Affection de longue durée', '', '', 'Remboursement', NULL, 'Maladie de longue durée/ALD'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (77, 'Affiliation', '', '', 'Organisation de la sécurité sociale', NULL, 'Assujettissement'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (78, 'Afghanistan', '', '', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (79, 'Afrique', '', '', 'Zone géographique et géopolitique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (80, 'Afrique du Nord', '', '', 'Zone géographique et géopolitique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (81, 'Afrique du sud', '', '', 'Pays étranger', NULL, 'République d''Afrique du Sud/République sud-africaine'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (82, 'Afrique noire', '', '', 'Zone géographique et géopolitique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (83, 'Afrique sub-saharienne', '', '', 'Zone géographique et géopolitique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (84, 'Age de la retraite', '', '', 'Retraite', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (85, 'Agence nationale de rénovation urbaine (ANRU)', '', '', 'Politique de la ville', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (86, 'Agence nationale de traitement automatisé des infractions (ANTAI)', '', '', 'Permis de conduire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (87, 'Agence Nationale pour l''Amélioration de l''Habitat (ANAH)', '', '', 'Amélioration de l''habitat', NULL, 'Agence nationale pour l''amélioration de l''habitat'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (88, 'Agence Régionale de Santé (ARS)', 'Les Agences régionales de santé (ARS) visent à décloisonner, à rassembler le pilotage des politiques de santé au niveau régional et à contrôler les dépenses de santé. La création de ces agences, prévue dans la loi Hôpital, patients, santé et territoire (HPST) n° 2009-879 du 11 juillet 2009, est effective depuis avril 2010.', '', 'Politique de la santé', NULL, 'ARS'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (89, 'Agent artistique', '', '', 'Métier du spectacle', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (90, 'Agent cancérigène', '', '', 'Sécurité sanitaire', NULL, 'Agent carcinogène/Cancérogénicité'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (91, 'Agent contractuel', '', '', 'Agent public', NULL, 'Contractuel'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (92, 'Agent de joueurs', '', '', 'Métier du sport', NULL, 'Agent sportif'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (93, 'Agent de santé communautaire', '', '', 'Profession paramédicale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (94, 'Agent non titulaire', '', '', 'Agent public', NULL, 'Non titulaire'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (95, 'Agent public', '', '', 'Statut général', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (96, 'Agent toxique', '', '', 'Polluant', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (97, 'Agglomération', '', '', 'Milieu urbain', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (98, 'Agression', '', '', 'Violence', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (99, 'Agriculteur', '', '', 'Métier de l''agriculture', NULL, 'Exploitant agricole'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (100, 'Agriculture', '', '', '01 - MONDE AGRICOLE', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (101, 'Agriculture biologique', '', '', 'Agriculture', NULL, 'Agrobiologie'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (102, 'Aide', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (103, 'Aide à la création d''entreprise', 'Mesure d''aide à la création d''entreprise au bénéfice des demandeurs d''emploi, des bénéficiaires de minima sociaux, des jeunes de moins de 16 ans, des créateurs d''entreprise en ZUS.', '', 'Aide aux entreprises', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (104, 'Aide à la formation', '', '', 'Financement de la formation', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (105, 'Aide à l''emploi', '', '', 'Emploi', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (106, 'Aide alimentaire', '', '', 'Aide sociale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (107, 'Aide au logement', '', '', 'Politique du logement', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (108, 'Aide au logement temporaire (ALT)', 'Créée dans le cadre de la loi contre les exclusions de juillet 1998', '', 'Dispositif d''accueil', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (109, 'Aide au retour', '', '', 'Retour au pays d''origine', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (110, 'Aide aux chômeurs créateurs et repreneurs d''entreprise (ACCRE)', '', '', 'Aide aux entreprises', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (111, 'Aide aux entreprises', '', '', 'Entreprise', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (112, 'Aide communautaire', '', '', 'Politique commune', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (113, 'Aide humanitaire', '', '', 'Aide sociale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (114, 'Aide juridictionnelle', '', '', 'Procédure', NULL, 'Aide judiciaire'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (115, 'Aide médicale de l''Etat', 'Dispositif spécifique conçu pour prendre en charge les frais de soins des personnes de nationalité étrangère, résidant en France sans titre de séjour régulier, depuis la disparition de l''aide médicale départementale à la suite de la création de la CMU.', '', 'Aide humanitaire', NULL, 'AME'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (116, 'Aide personnalisée au logement (APL)', 'L''aide personnalisée au logement (APL) est attribuée sous conditions de ressources, aux personnes qui occupent un logement conventionné avec l''État, quelles que soient les caractéristiques familiales des occupants.', '', 'Aide au logement', NULL, 'APL'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (117, 'Aide sociale', '', '', '07 - SOCIAL', NULL, 'Assistance'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (118, 'Aide sociale à l''enfance (ASE)', '', '', 'Protection de l''enfance', NULL, 'Aide sociale à l''enfance'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (119, 'Aide-soignant', '', '', 'Profession paramédicale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (120, 'Ain', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (121, 'Air France', '', '', 'Compagnie aérienne', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (122, 'Aire d''accueil des gens du voyage', '', '', 'Equipement collectif', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (123, 'Aisne', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (124, 'Aix-en-Provence', '', '', 'Bouches du Rhône', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (125, 'Aix-Marseille-Provence', '', '', 'Métropole', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (126, 'Albanie', '', '', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (127, 'Alcool', '', 'Vin', 'Boisson', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (128, 'Alcoolisme', '', '', 'Pratique addictive', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (129, 'Alcoologie', '', '', 'Spécialité médicale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (130, 'Aléa thérapeutique', '', '', 'Déontologie médicale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (131, 'Alerte épidémiologique', '', '', 'Epidémie', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (132, 'Algérie', '', 'Maghreb', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (133, 'Algue verte', '', '', 'Pollution de la mer', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (134, 'Aliment de substitution', '', '', 'Hygiène alimentaire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (135, 'Aliment du bétail', '', 'Production végétale', 'Alimentation animale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (136, 'Aliment transformé', '', '', 'Produit alimentaire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (137, 'Alimentation animale', '', '', 'Bien-être animal', NULL, 'Alimentation des animaux/Alimentation du bétail'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (138, 'Allaitement', '', '', 'Maternité', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (139, 'Allemagne', '', 'RDA', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (140, 'Allergie', '', '', 'Pathologie', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (141, 'Allergologie', '', '', 'Spécialité médicale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (142, 'Allier', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (143, 'Allocation adulte handicapé (AAH)', '', '', 'Prestation handicapé', NULL, 'Allocation aux adultes handicapés'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (144, 'Allocation de logement familiale (ALF)', 'L''allocation de logement familiale (ALF) est attribuée spécifiquement aux ménages ou personnes isolées ayant des personnes à charge.', '', 'Aide au logement', NULL, 'ALF'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (145, 'Allocation de logement sociale (ALS)', 'L''allocation de logement sociale (ALS) est attribuée à certaines catégories de personnes, autre que les familles, caractérisées par le niveau modeste de leurs ressources.', '', 'Aide au logement', NULL, 'ALS'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (146, 'Allocation de rentrée scolaire', '', '', 'Prestation familiale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (147, 'Allocation de solidarité spécifique', '', '', 'Prestations chômage', NULL, 'ASS'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (148, 'Allocation de soutien familial (ASF)', '', '', 'Prestation familiale', NULL, 'Allocation de soutien familial'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (149, 'Allocation d''éducation de l''enfant handicapé (AEEH)', 'Remplace l''Allocation d''éducation spéciale depuis le 1er janvier 2006', '', 'Prestation handicapé', NULL, 'AEEH'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (150, 'Allocation d''orphelin', '', '', 'Prestation familiale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (328, 'Banque centrale européenne (BCE)', '', '', 'Organe communautaire', NULL, 'Banque centrale européenne'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (329, 'Banque mondiale', '', '', 'Finances internationales', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (604, 'Commerce de détail', '', '', 'Commerce', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (151, 'Allocation journalière de présence parentale', 'L''allocation journalière de présence parentale (AJPP) est attribuée à toute personne qui interrompt ponctuellement son contrat de travail ou bénéficie d''un congé de présence parentale pour assumer la charge d''un enfant âgé de moins de 10 ans atteint d''une maladie, d''un handicap ou victime d''un accident d''une particulière gravité.', '', 'Prestation familiale', NULL, 'AJPP'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (152, 'Allocation parent isolé (API)', '', '', 'Prestation familiale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (153, 'Allocation parentale d''éducation (APE)', '', '', 'Prestation familiale', NULL, 'Allocation parentale d''éducation'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (154, 'Allocation personnalisée d''autonomie (APA)', 'Fait suite à la PSD, à compter du 1er janvier 2001', '', 'Prestation vieillesse', NULL, 'Allocation personnalisée d''autonomie'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (155, 'Allocation Retour à l''Emploi (ARE)', '', '', 'Prestations chômage', NULL, 'ARE'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (156, 'Alpes de Haute Provence', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (157, 'Alpes Maritimes', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (158, 'Alphabétisation', '', 'Analphabétisme', 'Enseignement', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (159, 'Alternance', '', '', 'Stage', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (160, 'Ambassade', '', '', 'Représentation diplomatique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (161, 'Ambulances', '', '', 'Transport sanitaire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (162, 'Ambulancier', '', '', 'Profession paramédicale', NULL, 'brancardier'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (163, 'Amélioration de l''habitat', '', '', 'Logement', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (164, 'Aménagement du temps de travail', '', '', 'Durée du travail', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (165, 'Aménagement du territoire', '', '', 'Organisation territoriale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (166, 'Aménagement foncier', '', '', 'Aménagement du territoire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (167, 'Aménagement rural', '', '', 'Milieu rural', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (168, 'Aménagement urbain', '', '', 'Urbanisme', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (169, 'Amérique', '', '', 'Zone géographique et géopolitique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (170, 'Amérique du Nord', '', '', 'Zone géographique et géopolitique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (171, 'Amérique latine', '', '', 'Zone géographique et géopolitique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (172, 'Amiante', '', '', 'Polluant', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (173, 'Anarchisme', '', '', 'Idéologie politique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (174, 'Anatomie', '', '', 'Corps humain et pratique médicale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (175, 'Ancien combattant et victime de guerre', '', '', 'Armée', NULL, 'Ancien combattant'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (176, 'Ancien ministre', '', '', 'Ministre', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (177, 'Ancien Premier ministre', '', '', 'Premier ministre', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (178, 'Ancien Président de la République', '', '', 'Président de la République', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (179, 'Andorre', '', '', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (180, 'Anesthésie', '', '', 'Spécialité médicale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (181, 'Angleterre', '', '', 'Royaume-Uni', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (182, 'Angola', '', '', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (183, 'Animal de laboratoire', '', '', 'Bien-être animal', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (184, 'Animal domestique', '', '', 'Faune', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (185, 'Animal sauvage', '', '', 'Faune', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (186, 'Animateur social', '', '', 'Travailleur social', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (187, 'Animateur sportif', '', '', 'Métier du sport', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (188, 'Annecy', '', '', 'Haute Savoie', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (189, 'Annuaire', '', '', 'Publication', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (190, 'Annuaire international', '', '', 'Annuaire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (191, 'Annulation', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (192, 'Annulation d''élection', '', '', 'Droit électoral', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (193, 'Anorexie', '', '', 'Trouble du comportement alimentaire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (194, 'Anthropologie', '', '', 'Sciences humaines', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (195, 'Antibiotique', '', '', 'Médicament', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (196, 'Antigua-et-Barbuda', '', '', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (197, 'Antilles', '', '', 'Zone géographique et géopolitique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (198, 'Antimusulman', '', '', 'Racisme', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (199, 'Antisémitisme', '', '', 'Lutte contre les discriminations', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (200, 'Apatride', '', '', 'Droit d''asile', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (201, 'Apiculture', '', 'Abeille', 'Elevage', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (202, 'Appareillage', '', '', 'Corps humain et pratique médicale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (203, 'Appartement thérapeutique', '', '', 'Hôpital', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (204, 'Appel à projet', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (205, 'Appel d''offres', '', '', 'Marché public', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (206, 'Apprenti', '', '', 'Apprentissage', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (207, 'Apprentissage', '', '', 'Stage', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (208, 'Aptitude au travail', '', '', 'Conditions de travail', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (209, 'Aquaculture', '', '', 'Pêche', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (210, 'Aqueduc', '', '', 'Ouvrage d''art', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (211, 'Aquitaine-Limousin-Poitou-Charentes', '', '', 'France par région', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (212, 'Arabie saoudite', '', 'Moyen Orient', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (213, 'Arbitre', '', '', 'Métier du sport', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (214, 'Arboriculture', '', '', 'Production végétale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (215, 'Architecte', '', '', 'Métier du bâtiment et de la construction', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (216, 'Architecture', '', '', 'Logement et hébergement', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (217, 'Archives', '', '', 'Communication', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (218, 'Ardèche', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (219, 'Ardennes', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (220, 'Argentine', '', '', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (221, 'Ariège', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (222, 'Armateur', '', '', 'Transport maritime', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (223, 'Arme chimique', '', '', 'Armement', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (224, 'Arme nucléaire', '', '', 'Armement', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (225, 'Armée', '', '', 'Défense', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (226, 'Armée de l''air', '', '', 'Forces armées', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (227, 'Armée de terre', '', '', 'Forces armées', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (228, 'Armement', '', '', 'Défense', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (229, 'Arménie', '', '', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (230, 'Arrêté', '', '', 'Norme juridique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (231, 'Art', '', '', 'Culture', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (232, 'Artisan', '', '', 'Artisanat', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (233, 'Artisanat', '', '', 'Secteur économique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (234, 'Arts graphiques', '', '', 'Art', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (235, 'Arts martiaux mixtes (MMA)', '', '', 'Discipline sportive', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (236, 'Arts plastiques', '', '', 'Art', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (237, 'Asie', '', '', 'Zone géographique et géopolitique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (238, 'Asie du Sud-est', '', '', 'Zone géographique et géopolitique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (239, 'Assainissement collectif', '', '', 'Assainissement de l''eau', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (240, 'Assainissement de l''eau', '', '', 'Gestion de l''eau', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (241, 'Assainissement industriel', '', '', 'Assainissement de l''eau', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (242, 'Assainissement non collectif', '', '', 'Assainissement de l''eau', NULL, 'Assainissement autonome/Assainissement individuel'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (243, 'Assemblée nationale', '', '', 'Parlement', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (244, 'Assiduité', '', '', 'Action parlementaire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (245, 'Assistant de service social', '', '', 'Travailleur social', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (330, 'Banque publique d''investissement (BPI)', '', '', 'Aide aux entreprises', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (331, 'Barème', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (246, 'Assistant de vie aux familles', 'Créé par l''arrêté du 11 juillet 2003 relatif au titre professionnel d''assistant de vie, l''assistant de vie aux familles apporte une aide professionnalisée à domicile auprès de familles, de personnes dites fragilisées ou sensibles comme les jeunes enfants, les personnes âgées ou handicapées.', '', 'Travailleur social', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (247, 'Assistant familial', '', '', 'Travailleur social', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (248, 'Assistante maternelle', '', '', 'Profession sanitaire et sociale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (249, 'Association', '', '', 'Aide sociale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (250, 'Association caritative', '', '', 'Association', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (251, 'Association de 1901', '', '', 'Association', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (252, 'Association de défense de l''environnement', '', '', 'Protection de l''environnement', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (253, 'Association de malades', '', '', 'Association d''usagers', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (254, 'Association d''usagers', '', '', 'Association', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (255, 'Association générale des institutions de retraite des cadres (AGIRC)', 'Régime de retraite complémentaire des salariés cadres, qui complète le régime ARRCO', '', 'Institutions de retraites complémentaires', NULL, 'Association générale des institutions de retraite des cadres'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (256, 'Association pour le régime de retraite complémentaire des salariés (ARRCO)', 'Régime de retraite complémentaire de tous les salariés du secteur privé', '', 'Institutions de retraites complémentaires', NULL, 'Association pour le régime de retraite complémentaire des salariés'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (257, 'Assujettissement', '', '', 'Fiscalité', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (258, 'Assurance', '', '', 'Financement de l''économie', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (259, 'Assurance chômage', '', 'Pôle emploi', 'Chômage', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (260, 'Assurance décès', '', '', 'Assurance sociale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (261, 'Assurance invalidité', '', '', 'Assurance sociale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (262, 'Assurance maladie', '', '', 'Sécurité sociale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (263, 'Assurance sociale', '', '', 'Sécurité sociale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (264, 'Assurance vie', '', '', 'Assurance', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (265, 'Assuré social', '', '', 'Assurance maladie', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (266, 'Asthme', '', '', 'Maladie de l''appareil respiratoire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (267, 'Astreinte', '', '', 'Durée du travail', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (268, 'Athlétisme', '', '', 'Discipline sportive', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (269, 'Atlanta', '', '', 'Etats-Unis', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (270, 'Atlas', '', '', 'Publication', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (271, 'Attentat', '', '', 'Terrorisme', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (272, 'Attractivité du territoire', 'Capacité d''un territoire, pour une période donnée, à attirer toutes sortes d''activités économiques et facteurs de production mobiles', '', 'Politique d''aménagement du territoire', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (273, 'Attributions des fonds de péréquation et de solidarité', '', '', 'Fiscalité locale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (274, 'Aube', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (275, 'Aude', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (276, 'Audience', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (277, 'Audiovisuel', '', '', 'Information', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (278, 'Australie', '', '', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (279, 'Autisme', '', '', 'Personne handicapée', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (280, 'Autobiographie', '', '', 'Publication', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (281, 'Autobus', '', '', 'Transport en commun en site propre', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (282, 'Autocar', '', '', 'Transport routier de personnes', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (283, 'Auto-entrepreneur', '', '', 'Auto-entreprise', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (284, 'Auto-entreprise', 'Nouveau régime instauré par la loi 2008-776 du 4 août 2008 qui s''adresse en particulier aux personnes qui ne veulent pas nécessairement créer une société commerciale pour exercer leur nouvelle activité et souhaitent pouvoir débuter ou arrêter facilement leur activité indépendante.', '', 'Statut de l''entreprise', NULL, 'Auto-entrepreneur'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (285, 'Autogestion', '', '', 'Mode de gestion', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (286, 'Automédication', '', '', 'Comportement de santé', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (287, 'Autonomie', '', '', 'Vieillesse', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (288, 'Autopsie', '', '', 'Décès', NULL, 'Autopsie médico-scientifique'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (289, 'Autorisation', '', '', 'Mots-outils', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (290, 'Autorisation de Mise sur le Marché (AMM)', '', '', 'Contrôle des médicaments', NULL, 'Autorisation de mise sur le marché'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (291, 'Autorisation Temporaire d''Utilisation (ATU)', '', '', 'Contrôle des médicaments', NULL, 'Autorisation temporaire d''utilisation'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (292, 'Autorité administrative indépendante (AAI)', '', '', 'Institution publique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (293, 'Autorité parentale', '', '', 'Droit de la famille', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (294, 'Autoroute', '', '', 'Infrastructure de transport routier', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (295, 'Autoroute de la mer', '', '', 'Transport maritime', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (296, 'Autres contributions directes', '', '', 'Fiscalité locale', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (297, 'Autres décorations', '', '', 'Décoration', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (298, 'Autriche', '', '', 'Pays étranger', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (299, 'Auvergne-Rhône-Alpes', '', '', 'France par région', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (300, 'Auxiliaire de vie scolaire', '', '', 'Métier de l''éducation', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (301, 'Auxiliaire de vie sociale', 'Les auxiliaires de vie deviennent des auxiliaires de vie sociale, diplômés (décret 2001-410)', '', 'Travailleur social', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (302, 'Avalanche', '', '', 'Catastrophe naturelle', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (303, 'Avenant', '', '', 'Contrat', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (304, 'Avertisseur de radar', '', '', 'Radar', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (305, 'Aveyron', '', '', 'France par département', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (306, 'Aviculture', '', 'Viande de volaille', 'Elevage', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (307, 'Avion', '', '', 'Aéronef', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (308, 'Aviron', '', '', 'Sport nautique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (309, 'Avis', '', '', 'Norme juridique', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (310, 'Avocat', '', '', 'Métier du droit', NULL, ''); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (311, 'Avortement', '', '', 'Obstétrique', NULL, 'IVG'); INSERT INTO thesaurus (thesaurus_id, thesaurus_name, thesaurus_description, thesaurus_name_associate, thesaurus_parent_id, creation_date, used_for) VALUES (312, 'Azerbaïdjan', '', '', 'Pays étranger', NULL, ''); select setval('thesaurus_id_seq', (select max(thesaurus_id)+1 from thesaurus), false);