INSERT INTO lettres_cadres VALUES (1,'adresse responsable',100,40,100,5,'A l\'attention de\r\n<civilitee_court_responsable> <nom_responsable> <prenom_responsable>\r\n<adresse_responsable>\r\n<cp_responsable> <commune_responsable>\r\n',0,'||');
INSERT INTO lettres_cadres VALUES (2,'adresse etablissement',0,0,0,0,'',0,'');
INSERT INTO lettres_cadres VALUES (3,'datation',0,0,0,0,'',0,'');
INSERT INTO lettres_cadres VALUES (4,'corp avertissement',10,70,0,5,'<u>Objet: </u> <g>Avertissement</g>\r\n\r\n\r\n<nom_civilitee_long>,\r\n\r\nJe me vois dans l\'obligation de donner un <b>AVERTISSEMENT</b>\r\n\r\nà <g><nom_eleve> <prenom_eleve></g> élève de la classe <g><classe_eleve></g>.\r\n\r\n\r\npour la raison suivante : <g><sujet_eleve></g>\r\n\r\n<remarque_eleve>\r\n\r\n\r\n\r\nComme le prévoit le règlement intérieur de l\'établissement, il pourra être sanctionné à partir de ce jour.\r\nSanction(s) possible(s) :\r\n\r\n\r\n\r\n\r\nJe vous remercie de me renvoyer cet exemplaire après l\'avoir daté et signé.\r\nVeuillez agréer <nom_civilitee_long> <nom_responsable> l\'assurance de ma considération distinguée.\r\n\r\n\r\n\r\nDate et signatures des parents :	',0,'||');
INSERT INTO lettres_cadres VALUES (5,'corp blame',10,70,0,5,'<u>Objet</u>: <g>Blâme</g>\r\n\r\n\r\n<nom_civilitee_long>\r\n\r\nJe me vois dans l\'obligation de donner un BLAME \r\n\r\nà <g><nom_eleve> <prenom_eleve></g> élève de la classe <g><classe_eleve></g>.\r\n\r\nDemandé par: <g><courrier_demande_par></g>\r\n\r\npour la raison suivante: <g><raison></g>\r\n\r\n<remarque>\r\n\r\nJe vous remercie de me renvoyer cet exemplaire après l\'avoir daté et signé.\r\nVeuillez agréer <g><nom_civilitee_long> <nom_responsable></g> l\'assurance de ma considération distinguée.\r\n\r\n<u>Date et signatures des parents:</u>\r\n\r\n\r\n\r\n\r\n\r\nNous demandons un entretien avec la personne ayant demandé la sanction OUI / NON.\r\n(La prise de rendez-vous est à votre initiative)\r\n',0,'||');
INSERT INTO lettres_cadres VALUES (6,'corp convocation parents',10,70,0,5,'<u>Objet</u>: <g>Convocation des parents</g>\r\n\r\n\r\n<nom_civilitee_long>,\r\n\r\nVous êtes prié de prendre contact avec le Conseiller Principal d\'Education dans les plus brefs délais, au sujet de <g><nom_eleve> <prenom_eleve></g> inscrit en classe de <g><classe_eleve></g>.\r\n\r\npour le motif suivant:\r\n\r\n<remarque>\r\n\r\n\r\n\r\nSans nouvelle de votre part avant le ........................................., je serai dans l\'obligation de procéder à la descolarisation de l\'élève, avec les conséquences qui en résulteront, jusqu\'à votre rencontre.\r\n\r\n\r\nVeuillez agréer <g><nom_civilitee_long> <nom_responsable></g> l\'assurance de ma considération distinguée.',0,'||');
INSERT INTO lettres_cadres VALUES (7,'corp exclusion',10,70,0,5,'<u>Objet: </u> <g>Sanction - Exclusion de l\'établissement</g>\r\n\r\n\r\n<nom_civilitee_long>,\r\n\r\nPar la présente, je tiens à vous signaler que <nom_eleve>\r\n\r\ninscrit en classe de  <classe_eleve>\r\n\r\n\r\ns\'étant rendu coupable des faits suivants : \r\n\r\n<remarque>\r\n\r\n\r\n\r\nEst exclu de l\'établissement,\r\nà compter du: <b><date_debut></b> à <b><heure_debut></b>,\r\njusqu\'au: <b><date_fin></b> à <b><heure_fin></b>.\r\n\r\n\r\nIl devra se présenter, au bureau de la Vie Scolaire \r\n\r\nle ....................................... à ....................................... ACCOMPAGNE DE SES PARENTS.\r\n\r\n\r\n\r\n\r\nVeuillez agréer &lt;TYPEPARENT&gt; &lt;NOMPARENT&gt; l\'assurance de ma considération distinguée.',0,'||');
INSERT INTO lettres_cadres VALUES (8,'corp demande justificatif absence',10,70,0,5,'<u>Objet: </u> <g>Demande de justificatif d\'absence</g>\n\n<civilitee_long_responsable>,\n\nJ\'ai le regret de vous informer que <b><nom_eleve> <prenom_eleve></b>, élève en classe de <b><classe_eleve></b> n\'a pas assisté au(x) cours:\n\n<liste>\n\nJe vous prie de bien vouloir me faire connaître le motif de son absence.\n\nPour permettre un contrôle efficace des présences, toute absence d\'un élève doit être justifiée par sa famille, le jour même soit par téléphone, soit par écrit, soit par fax.\n\nAvant de regagner les cours, l\'élève absent devra se présenter au bureau du Conseiller Principal d\'Education muni de son carnet de correspondance avec un justificatif signé des parents.\n\nVeuillez agréer <civilitee_long_responsable> <nom_responsable>, l\'assurance de ma considération distinguée.\n                                               \nCPE\n<civilitee_long_cpe> <nom_cpe> <prenom_cpe>\n\nPrière de renvoyer, par retour du courrier, le présent avis signé des parents :\n\nMotif de l\'absence : ________________________________________________________________________________\n\n____________________________________________________________________________________________________\n\n____________________________________________________________________________________________________\n\n____________________________________________________________________________________________________\n\nDate et signatures des parents :  \n',0,'||');
INSERT INTO lettres_cadres VALUES (10,'signature',100,180,0,5,'<b><courrier_signe_par_fonction></b>,\r\n<courrier_signe_par>\r\n',0,'||');
INSERT INTO lettres_tcs VALUES (1,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (2,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (3,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (4,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (5,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (6,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (7,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (8,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (9,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (10,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (11,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (12,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (13,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (14,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (15,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (16,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (17,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (18,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (19,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (20,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (21,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (22,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (23,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (24,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (25,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (26,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (27,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (28,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (29,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (30,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (31,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (32,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (33,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (34,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (35,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (36,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (37,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (38,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (39,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (40,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (41,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (42,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (43,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (44,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (45,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (46,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (47,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (48,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (49,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (50,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (51,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (52,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (53,3,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (56,3,1,100,40,100,5,0);
INSERT INTO lettres_tcs VALUES (57,3,4,10,70,190,15,0);
INSERT INTO lettres_tcs VALUES (58,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (59,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (60,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (61,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (62,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (63,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (64,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (65,1,1,100,40,100,5,0);
INSERT INTO lettres_tcs VALUES (66,1,5,10,70,190,15,0);
INSERT INTO lettres_tcs VALUES (68,2,1,100,40,100,5,0);
INSERT INTO lettres_tcs VALUES (69,2,6,10,70,190,10,0);
INSERT INTO lettres_tcs VALUES (70,4,1,100,40,100,5,0);
INSERT INTO lettres_tcs VALUES (71,4,7,10,70,190,15,0);
INSERT INTO lettres_tcs VALUES (72,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (73,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (74,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (75,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (76,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (77,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (78,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (79,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (80,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (81,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (82,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (83,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (84,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (85,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (86,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (87,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (88,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (89,6,1,100,40,100,5,0);
INSERT INTO lettres_tcs VALUES (90,6,8,10,70,190,20,0);
INSERT INTO lettres_tcs VALUES (91,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (92,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (93,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (94,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (95,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (96,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (97,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (98,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (99,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (100,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (101,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (102,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (103,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (104,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (105,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (106,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (107,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (108,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (109,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (110,7,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (111,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (112,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (113,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (114,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (115,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (116,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (117,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (118,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (119,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (120,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (121,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (122,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (123,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (124,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (125,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (126,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (127,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (128,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (129,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (130,1,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (131,2,10,100,180,190,5,0);
INSERT INTO lettres_tcs VALUES (132,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (133,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (134,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (135,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (136,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (137,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (138,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (139,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (140,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (141,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (142,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (143,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (144,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (145,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (146,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (147,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (148,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (149,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (150,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (151,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (152,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (153,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (154,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (155,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (156,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (157,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (158,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (159,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (160,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (161,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (162,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (163,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (164,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (165,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (166,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (167,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (168,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (169,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (170,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (171,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (172,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (173,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (174,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (175,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (176,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (177,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (178,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (179,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (180,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (181,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (182,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (183,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (184,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (185,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (186,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (187,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (188,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (189,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (190,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (191,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (192,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (193,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (194,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (195,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (196,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (197,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (198,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (199,6,0,0,0,0,0,0);
INSERT INTO lettres_tcs VALUES (200,6,0,0,0,0,0,0);
INSERT INTO lettres_types VALUES (1,'blame','sanction','');
INSERT INTO lettres_types VALUES (2,'convocation des parents','suivi','');
INSERT INTO lettres_types VALUES (3,'avertissement','sanction','');
INSERT INTO lettres_types VALUES (4,'exclusion','sanction','');
INSERT INTO lettres_types VALUES (5,'certificat de scolarité','suivi','');
INSERT INTO lettres_types VALUES (6,'demande de justificatif d\'absence','suivi','oui');
INSERT INTO lettres_types VALUES (7,'demande de justificatif de retard','suivi','');
INSERT INTO lettres_types VALUES (8,'rapport d\'incident','sanction','');
INSERT INTO lettres_types VALUES (9,'regime de sortie','suivi','');
INSERT INTO lettres_types VALUES (10,'retenue','sanction','');
