- Créé par Emilien Casano, dernière modification le 12 nov. 2020
Public concerné : INFORMATICIENS
Préambule
La version 1.3.1 (0101 - Historique des versions) nécessite une MODIFICATION de la base de données et donc le passage de script SQL.
Prérequis techniques
S'assurer d'avoir passer toutes les mises à jour Calcium préalable et d'être en version 1.3.0
Modification des modèles Docx
Les modèles suivants ont été modifiés (ajout de la signature + pied de page) :
- Modele_Certificat.docx
- Modele_Ordonnance.docx
Les modèles suivants ont été modifiés eux aussi, mais seulement un pied de page a été ajouté :
- Modele_Convocation.docx
- Modele_Infos_Etudiant.docx
- Modele_Recapitulatif_Dossier.docx
- Modele_Relance.docx
- Modele_Vaccination.docx
Vous pouvez les récupérer sur la page 255 - Gestion des modèles
Script SQL - mise en conformité de la base de données
Vous pouvez récupérer les requêtes depuis ce fichier : requetes_1.3.1.sql
et les nomenclatures pour la fiche Psychologie : Nomenclature_1.3.1_finalisée.txt
Ou directement depuis ici :
Cliquez ici pour développer ...
Les requêtes :
-- Fiche Psychologie
CREATE TABLE PsyEntretien (ID_ENTR int(11) NOT NULL AUTO_INCREMENT, ID_IDT BIGINT NOT NULL, ID_CSL int(11) NOT NULL, ID_ORIGINE int(11) NOT NULL, DATE_ENTR date NOT NULL, UTI_CRE int(11) NOT NULL, DAT_CRE datetime NOT NULL, UTI_MOD int(11), DAT_MOD datetime NULL, PRIMARY KEY (ID_ENTR), UNIQUE INDEX (ID_ENTR), INDEX (ID_IDT), INDEX (ID_CSL));
ALTER TABLE PsyEntretien
ADD CONSTRAINT `FK_psyentretien_identite` FOREIGN KEY (`ID_IDT`) REFERENCES `identite` (`ID_IDT`) ON UPDATE NO ACTION ON DELETE NO ACTION,
ADD CONSTRAINT `FK_psyentretien_consultation` FOREIGN KEY (`ID_CSL`) REFERENCES `consultation` (`ID_CSL`) ON UPDATE NO ACTION ON DELETE NO ACTION;
CREATE TABLE PsyNote (ID_NOTE int(11) NOT NULL AUTO_INCREMENT, ID_IDT BIGINT NOT NULL, NOTE longtext NOT NULL comment 'Note crypté', UTI_CRE int(11) NOT NULL, DAT_CRE datetime NOT NULL, DAT_MOD datetime NULL, PRIMARY KEY (ID_NOTE), UNIQUE INDEX (ID_NOTE), INDEX (ID_IDT));
ALTER TABLE PsyNote
ADD INDEX `UTI_CRE` (`UTI_CRE`),
ADD CONSTRAINT `FK_psynote_identite` FOREIGN KEY (`ID_IDT`) REFERENCES `identite` (`ID_IDT`) ON UPDATE NO ACTION ON DELETE NO ACTION,
ADD CONSTRAINT `FK_psynote_utilisateur` FOREIGN KEY (`UTI_CRE`) REFERENCES `utilisateur` (`ID_UTI`) ON UPDATE NO ACTION ON DELETE NO ACTION;
CREATE TABLE PsySuivi (ID_SUIVI int(11) NOT NULL AUTO_INCREMENT, ID_IDT BIGINT NOT NULL, SUIVI longtext NOT NULL comment 'Suivi crypté', UTI_CRE int(11) NOT NULL, DAT_CRE datetime NOT NULL, UTI_MOD int(11), DAT_MOD datetime NULL, PRIMARY KEY (ID_SUIVI), UNIQUE INDEX (ID_SUIVI), INDEX (ID_IDT));
ALTER TABLE PsySuivi
ADD INDEX `UTI_CRE` (`UTI_CRE`),
ADD CONSTRAINT `FK_psysuivi_identite` FOREIGN KEY (`ID_IDT`) REFERENCES `identite` (`ID_IDT`) ON UPDATE NO ACTION ON DELETE NO ACTION,
ADD CONSTRAINT `FK_psysuivi_utilisateur` FOREIGN KEY (`UTI_CRE`) REFERENCES `utilisateur` (`ID_UTI`) ON UPDATE NO ACTION ON DELETE NO ACTION,
ADD CONSTRAINT `FK_psysuivi_utilisateur_2` FOREIGN KEY (`UTI_MOD`) REFERENCES `utilisateur` (`ID_UTI`) ON UPDATE NO ACTION ON DELETE NO ACTION;
CREATE TABLE PersonneConfiance (ID_PER int(11) NOT NULL AUTO_INCREMENT, ID_IDT BIGINT NOT NULL, NOM varchar(45) NOT NULL, PRENOM varchar(45) NOT NULL, LIEN varchar(45) NOT NULL, ID_ADR int(11) NOT NULL, UTI_CRE int(11) NOT NULL, DAT_CRE datetime NOT NULL, PRIMARY KEY (ID_PER), UNIQUE INDEX (ID_PER), INDEX (ID_IDT));
ALTER TABLE PersonneConfiance
ADD CONSTRAINT `FK_personneconfiance_identite` FOREIGN KEY (`ID_IDT`) REFERENCES `identite` (`ID_IDT`) ON UPDATE NO ACTION ON DELETE NO ACTION,
ADD CONSTRAINT `FK_personneconfiance_adresse` FOREIGN KEY (`ID_ADR`) REFERENCES `adresse` (`ID_ADR`) ON UPDATE NO ACTION ON DELETE NO ACTION,
ADD CONSTRAINT `FK_personneconfiance_utilisateur` FOREIGN KEY (`UTI_CRE`) REFERENCES `utilisateur` (`ID_UTI`) ON UPDATE NO ACTION ON DELETE NO ACTION;
CREATE TABLE PsyEntretien_Item (ID_ENTR int(11) NOT NULL, ID_IN int(11) NOT NULL, PRIMARY KEY (ID_ENTR, ID_IN), INDEX (ID_ENTR), INDEX (ID_IN));
ALTER TABLE PsyEntretien_Item ADD INDEX FKPsyEntreti482217 (ID_ENTR), ADD CONSTRAINT FKPsyEntreti482217 FOREIGN KEY (ID_ENTR) REFERENCES PsyEntretien (ID_ENTR);
ALTER TABLE PsyEntretien_Item ADD INDEX FKPsyEntreti456887 (ID_IN), ADD CONSTRAINT FKPsyEntreti456887 FOREIGN KEY (ID_IN) REFERENCES ItemNomenclature (ID_IN);
-- Droit fiche psychologie
INSERT INTO droit (`COD_DRO`, `LIB_DRO`) VALUES ('DF_PSY', 'Fiche Psychologue');
INSERT INTO droit (`COD_DRO`, `LIB_DRO`) VALUES ('DF_PSY_PRV', 'Fiche Psychologue - Notes privées');
INSERT INTO droit (`COD_DRO`, `LIB_DRO`) VALUES ('DF_PSY_MTF', 'Fiche Psychologue - Motif(s) consultation');
-- Importation convocations dans le planning
ALTER TABLE `motifcreneau`
ADD COLUMN `ID_CTR` INT(5) NULL DEFAULT NULL AFTER `ID_UTI`,
ADD INDEX `IDX_CTR` (`ID_CTR`);
ALTER TABLE `motifcreneau`
ADD COLUMN `TYP_CONVOC` INT(2) NULL AFTER `TEM_SERVICE`;
ALTER TABLE `rdv`
ADD COLUMN `ID_CVT` INT NULL AFTER `ID_IDT`,
ADD INDEX `IDX_CVT` (`ID_CVT`);
-- Parametre mail convocation
ALTER TABLE `parametre_convoc`
ADD COLUMN `OBJET_MAIL_CANCEL` VARCHAR(50) NULL DEFAULT NULL AFTER `TEXT_MAIL`,
ADD COLUMN `TEXT_MAIL_CANCEL` LONGTEXT NULL DEFAULT NULL AFTER `OBJET_MAIL_CANCEL`,
ADD COLUMN `OBJET_MAIL_EDIT` VARCHAR(50) NULL DEFAULT NULL AFTER `TEXT_MAIL_CANCEL`,
ADD COLUMN `TEXT_MAIL_EDIT` LONGTEXT NULL DEFAULT NULL AFTER `OBJET_MAIL_EDIT`;
UPDATE parametre_convoc p SET p.NAME_MAIL = "Santé universitaire";
UPDATE parametre_convoc p SET p.OBJET_MAIL='Convocation';
UPDATE parametre_convoc p SET p.TEXT_MAIL='Bonjour <PATIENT>,\r\n\r\nVous êtes convoqué(e) le <DATE_CVT> à <HEURE_CVT> à l\'adresse suivante :\r\n<CENTRE_LIB>\r\n<CENTRE_ADR1>\r\n<CENTRE_ADR2>\r\n<CENTRE_ADR3>\r\n<CENTRE_CP> <CENTRE_VILLE>\r\nTél. <CENTRE_TEL>\r\n\r\nComptant sur votre présence, veuillez croire, Madame, Monsieur, l\'expression de nos salutations distinguées.';
UPDATE parametre_convoc p SET p.OBJET_MAIL_CANCEL='[ANNULE] Convocation';
UPDATE parametre_convoc p SET p.TEXT_MAIL_CANCEL='Bonjour <PATIENT>,\r\n\r\nVotre convocation du <DATE_CVT> à <HEURE_CVT> au <CENTRE_LIB> a été ANNULÉE.\r\n\r\nMerci de prendre contact auprès de nos services s\'il s\'agit d\'une erreur.\r\nVeuillez croire, Madame, Monsieur, l\'expression de nos salutations distinguées.';
UPDATE parametre_convoc p SET p.OBJET_MAIL_EDIT='[ANNULE ET REMPLACE] Convocation';
UPDATE parametre_convoc p SET p.TEXT_MAIL_EDIT='Bonjour <PATIENT>,\r\n\r\nVous êtes convoqué(e) le <DATE_CVT> à <HEURE_CVT> à l\'adresse suivante :\r\n<CENTRE_LIB>\r\n<CENTRE_ADR1>\r\n<CENTRE_ADR2>\r\n<CENTRE_ADR3>\r\n<CENTRE_CP> <CENTRE_VILLE>\r\nTél. <CENTRE_TEL>\r\n\r\nComptant sur votre présence, veuillez croire, Madame, Monsieur, l\'expression de nos salutations distinguées.';
-- Fix
UPDATE consultation c SET c.TEM_CSL = "sans"
WHERE c.TEM_CSL = "echec";
Les nomenclatures :
INSERT INTO `nomenclature` (`ID_NMC`, `COD_NMC`, `LIB_NMC`, `TEM_SERVICE`, `DAT_NMC`, `TYPE`, `DESCRIPTION`, `NIVEAU`) VALUES (NULL, 'PSY', 'Motifs psychologiques', 1, '2020-05-14 00:00:00', 'E', 'Catégorie des motifs de suivi psychologique', 2), (NULL, 'DCP', 'Origine consultation psychologique', 1, '2020-05-18 00:00:00', 'E', 'Liste des origines de consultation psychologique', 1); INSERT INTO `itemnomenclature` (`ID_IN`, `ID_NMC`, `COD_IN`, `LIB_IN`, `LIB_C_IN`, `ORD_IN`, `CPL_IN`, `TEM_SERVICE`, `TEM_IMPORT`, `PARENT_ID`, `DAT_CRE`, `UTI_CRE`) VALUES (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'APT', 'Adaptation à la vie étudiante', NULL, 100, NULL, 1, NULL, NULL, '2020-05-15 11:49:42', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SEX', 'Relations amoureuses et sexualité', NULL, 200, NULL, 1, NULL, NULL, '2020-05-14 11:39:45', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'PAR', 'Difficultés dans la parentalité', NULL, 300, NULL, 1, NULL, NULL, '2020-05-14 11:40:27', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'VIO', 'Violences sexuelles', NULL, 400, NULL, 1, NULL, NULL, '2020-05-14 11:42:24', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'REA', 'Troubles du contact avec la réalité', NULL, 500, NULL, 1, NULL, NULL, '2020-05-14 11:43:08', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'REL', 'Troubles relationnels', NULL, 600, NULL, 1, NULL, NULL, '2020-05-14 11:44:42', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'RCT', 'Troubles réactionnels', NULL, 700, NULL, 1, NULL, NULL, '2020-05-14 11:45:18', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ANX', 'Troubles anxieux-dépressifs', NULL, 800, NULL, 1, NULL, NULL, '2020-05-14 11:45:46', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'NEV', 'Troubles d’allure névrotique', NULL, 900, NULL, 1, NULL, NULL, '2020-05-14 11:46:22', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SAN', 'Problèmes de santé de l’étudiant', NULL, 1000, NULL, 1, NULL, NULL, '2020-05-14 11:46:42', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'RYT', 'Troubles du rythme', NULL, 1100, NULL, 1, NULL, NULL, '2020-05-14 11:47:06', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'DHA', 'Discrimination/Harcèlement', NULL, 1200, NULL, 1, NULL, NULL, '2020-05-14 11:47:43', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'RAA', 'Recours à l’agir auto-agressif', NULL, 1300, NULL, 1, NULL, NULL, '2020-05-14 11:48:49', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'RAH', 'Recours à l’agir hétéro-agressif', NULL, 1400, NULL, 1, NULL, NULL, '2020-05-14 11:49:23', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'FAM', 'Problématiques liées à la famille', NULL, 1500, NULL, 1, NULL, NULL, '2020-05-14 11:49:52', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ADD', 'Troubles addictifs', NULL, 1600, NULL, 1, NULL, NULL, '2020-05-14 11:50:21', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SOC', 'Difficultés d’adaptation sociales et culturelles', NULL, 1700, NULL, 1, NULL, NULL, '2020-05-14 11:50:46', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'VIE', 'Conditions de vie', NULL, 1800, NULL, 1, NULL, NULL, '2020-05-14 11:51:16', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'COL', 'Traumatismes collectifs', NULL, 1900, NULL, 1, NULL, NULL, '2020-05-14 11:51:53', NULL); INSERT INTO `itemnomenclature` (`ID_IN`, `ID_NMC`, `COD_IN`, `LIB_IN`, `LIB_C_IN`, `ORD_IN`, `CPL_IN`, `TEM_SERVICE`, `TEM_IMPORT`, `PARENT_ID`, `DAT_CRE`, `UTI_CRE`) VALUES (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ORI', 'Orientation', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:43:04', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'RES', 'Pression des résultats', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:44:12', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ENS', 'Relations avec les enseignants', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:44:33', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'INT', 'Intégration dans la promotion', NULL, 400, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:45:05', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'CCT', 'Concentration difficile', NULL, 500, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:46:10', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'GRP', 'Conflits dans le travail en groupe', NULL, 600, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:46:53', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'PRO', 'Stress face à l’entrée dans la vie professionnelle', NULL, 700, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:47:15', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'STA', 'Difficultés sur lieu de stage', NULL, 800, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:47:51', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'INS', 'Angoisse face à l’insertion professionnelle future', NULL, 900, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:48:16', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ABS', 'Absentéisme', NULL, 1000, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:48:38', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'DEC', 'Décrochage', NULL, 1100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='APT'), '2020-05-15 11:49:03', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'RUP', 'Rupture', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SEX'), '2020-05-15 11:52:14', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'CJG', 'Conflits conjugaux', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SEX'), '2020-05-15 11:56:16', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'CPL', 'Vie de couple', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SEX'), '2020-05-15 11:56:39', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'IVG', 'IVG', NULL, 400, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SEX'), '2020-05-15 11:58:21', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SEX', 'Orientation sexuelle', NULL, 500, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SEX'), '2020-05-15 11:58:51', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'CTC', 'Contraception', NULL, 600, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SEX'), '2020-05-15 11:59:21', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'TRB', 'Troubles sexuels', NULL, 700, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SEX'), '2020-05-15 12:00:49', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ENF', 'Conflit avec l’enfant', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='PAR'), '2020-05-18 10:44:39', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'INC', 'Sentiment d’incompétence', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='PAR'), '2020-05-18 10:45:03', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'DCD', 'Décès d’un enfant', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='PAR'), '2020-05-18 10:45:25', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'FCO', 'Fausse couche', NULL, 400, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='PAR'), '2020-05-18 10:45:47', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'EMP', 'Emprise', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='VIO'), '2020-05-18 10:46:28', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'VSX', 'Violence sexuelle', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='VIO'), '2020-05-18 10:48:49', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'INC', 'Inceste', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='VIO'), '2020-05-18 10:50:23', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'VIL', 'Viol', NULL, 400, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='VIO'), '2020-05-18 10:50:56', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'PVS', 'Perversion', NULL, 500, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='VIO'), '2020-05-18 10:51:21', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'DLR', 'Délire', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='REA'), '2020-05-18 10:58:44', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'HAL', 'Hallucinations', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='REA'), '2020-05-18 10:59:07', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'PSC', 'Persécution', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='REA'), '2020-05-18 10:59:32', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'DSC', 'Troubles dissociatifs', NULL, 400, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='REA'), '2020-05-18 11:00:04', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'PSY', 'Psychoses', NULL, 500, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='REA'), '2020-05-18 11:00:24', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'IHB', 'Inhibition majeure', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='REL'), '2020-05-18 11:02:13', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'AUT', 'Difficultés pour aller vers les autres', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='REL'), '2020-05-18 11:02:37', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'PHB', 'Phobies', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='REL'), '2020-05-18 11:03:01', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ISL', 'Isolement', NULL, 400, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='REL'), '2020-05-18 11:03:19', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'RLI', 'Repli sur soi', NULL, 500, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='REL'), '2020-05-18 11:03:45', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'DEU', 'Deuils', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RCT'), '2020-05-18 11:05:54', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SPR', 'Séparations', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RCT'), '2020-05-18 11:06:11', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'AGR', 'Agressions', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RCT'), '2020-05-18 11:06:33', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'PRO', 'Maladie d’un proche', NULL, 400, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RCT'), '2020-05-18 11:06:50', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ACC', 'Accidents', NULL, 500, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RCT'), '2020-05-18 11:07:04', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'EVE', 'Evènements récents', NULL, 600, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RCT'), '2020-05-18 11:07:26', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ANX', 'Anxiété', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='ANX'), '2020-05-18 11:08:17', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'DEP', 'Eléments dépressifs', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='ANX'), '2020-05-18 11:08:37', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ANG', 'Crises d’angoisse', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='ANX'), '2020-05-18 11:08:53', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'HUM', 'Variations de l’humeur', NULL, 400, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='ANX'), '2020-05-18 11:09:35', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'CVS', 'Conversions', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='NEV'), '2020-05-18 11:16:38', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'OBS', 'Obsessions', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='NEV'), '2020-05-18 11:17:07', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'HCP', 'Handicap', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SAN'), '2020-05-18 11:17:39', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SOM', 'Maladie somatique', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SAN'), '2020-05-18 11:17:55', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'DER', 'Troubles dermatologiques', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SAN'), '2020-05-18 11:18:13', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SOM', 'Sommeil', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RYT'), '2020-05-18 11:19:12', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ALI', 'Alimentation', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RYT'), '2020-05-18 11:19:28', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'FAT', 'Fatigue', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RYT'), '2020-05-18 11:19:43', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'DIS', 'Discrimination', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='DHA'), '2020-05-18 11:20:22', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'HAR', 'Harcèlement', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='DHA'), '2020-05-18 11:20:38', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SCA', 'Scarifications', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RAA'), '2020-05-18 11:21:03', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SUI', 'Tentative de suicide', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RAA'), '2020-05-18 11:21:26', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'AUT', 'Violence sur autrui', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='RAH'), '2020-05-18 11:22:01', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'FAM', 'Conflits familiaux', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='FAM'), '2020-05-18 11:37:21', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SEP', 'Séparation parentale', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='FAM'), '2020-05-18 11:37:45', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'VTI', 'Vécus traumatiques intrafamiliaux', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='FAM'), '2020-05-18 11:38:07', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'PMA', 'Parents malades', NULL, 400, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='FAM'), '2020-05-18 11:38:29', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'PPS', 'Parents psychiatrisés', NULL, 500, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='FAM'), '2020-05-18 11:38:52', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'SFA', 'Secrets familiaux', NULL, 600, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='FAM'), '2020-05-18 11:39:39', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ADD', 'Troubles addictifs', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='ADD'), '2020-05-18 11:40:07', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'AVU', 'Adaptation à la vie urbaine ', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SOC'), '2020-05-18 11:41:43', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'REP', 'Perte des repères liée à une origine étrangère', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='SOC'), '2020-05-18 11:42:07', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ECO', 'Précarité économique', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='VIE'), '2020-05-18 11:42:46', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'LOG', 'Problème de logement', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='VIE'), '2020-05-18 11:43:02', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'QUO', 'Difficultés dans la gestion du quotidien', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='VIE'), '2020-05-18 11:43:18', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'MAT', 'Contraintes matérielles', NULL, 400, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='VIE'), '2020-05-18 11:43:37', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'TRA', 'Transports compliqués', NULL, 500, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='VIE'), '2020-05-18 11:43:56', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'ATT', 'Attentat', NULL, 100, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='COL'), '2020-05-18 11:50:06', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'GEN', 'Rescapé génocide', NULL, 200, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='COL'), '2020-05-18 11:50:25', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY'), 'CLI', 'Catastrophe climatique', NULL, 300, NULL, 1, NULL, (SELECT I.ID_IN FROM `itemnomenclature` I WHERE I.ID_NMC=(SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'PSY') AND I.PARENT_ID IS NULL AND I.COD_IN='COL'), '2020-05-18 11:50:50', NULL); INSERT INTO `itemnomenclature` (`ID_IN`, `ID_NMC`, `COD_IN`, `LIB_IN`, `LIB_C_IN`, `ORD_IN`, `CPL_IN`, `TEM_SERVICE`, `TEM_IMPORT`, `PARENT_ID`, `DAT_CRE`, `UTI_CRE`) VALUES (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'DCP'), 'SPO', 'Demande spontanée de l’étudiant', NULL, 100, NULL, 1, NULL, NULL, '2020-05-18 12:11:39', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'DCP'), 'SUM', 'Adressé par un professionnel du SUMPPS', NULL, 200, NULL, 1, NULL, NULL, '2020-05-18 12:12:39', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'DCP'), 'EXT', 'Adressé par des services extérieurs', NULL, 300, NULL, 1, NULL, NULL, '2020-05-18 12:12:56', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'DCP'), 'UNI', 'Adressé par des professionnels de l’Université', NULL, 400, NULL, 1, NULL, NULL, '2020-05-18 12:18:00', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'DCP'), 'ETU', 'Orienté par un autre étudiant', NULL, 500, NULL, 1, NULL, NULL, '2020-05-18 12:18:26', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'DCP'), 'FAM', 'Orienté par sa famille', NULL, 600, NULL, 1, NULL, NULL, '2020-05-18 12:18:42', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'DCP'), 'PRO', 'Orientée par un proche', NULL, 700, NULL, 1, NULL, NULL, '2020-05-18 12:19:08', NULL), (NULL, (SELECT ID_NMC FROM `nomenclature` WHERE COD_NMC = 'DCP'), 'REU', 'Demande adressée suite à une réunion de rentrée', NULL, 800, NULL, 1, NULL, NULL, '2020-05-18 12:20:36', NULL);
Dans cette page
En savoir plus
- Aucune étiquette