{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SQL Results","SQL Statement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SQL Results","index":0,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["","NOM","PRENOM","MATRICULE","CODE_DE_FONCTION","FONCTION","DATE_FORMATION","CODE_ACTIVITE","FORMATION"]
[1,"Boulanger","Jonathan","SQ10003","032","Agt Liais. Autoch 02","2011-02-25","231-0092","Sensibilisation aux réalités autochtones"]
[2,"Desbiens","Dany","SQ10563","433","Agt Liai. Ct Autoch","2016-06-10","238-0447","Colloque des directeurs de police autochtones"]
[3,"Desbiens","Dany","SQ10563","433","Agt Liai. Ct Autoch","2013-11-20","231-0092","Sensibilisation aux réalités autochtones"]
[4,"Desbiens","Dany","SQ10563","433","Agt Liai. Ct Autoch","2017-06-08","238-0447","Colloque des directeurs de police autochtones"]
[5,"Desbiens","Dany","SQ10563","433","Agt Liai. Ct Autoch","2015-09-23","231-0092","Sensibilisation aux réalités autochtones"]
[6,"Larouche","Frédéric","SQ10571","032","Agt Liais. Autoch 02","2017-06-08","238-0447","Colloque des directeurs de police autochtones"]
[7,"Larouche","Frédéric","SQ10571","032","Agt Liais. Autoch 02","2011-11-09","231-0092","Sensibilisation aux réalités autochtones"]
[8,"Larouche","Frédéric","SQ10571","032","Agt Liais. Autoch 02","2009-10-16","231-0092","Sensibilisation aux réalités autochtones"]
[9,"Larouche","Frédéric","SQ10571","032","Agt Liais. Autoch 02","2013-11-20","231-0092","Sensibilisation aux réalités autochtones"]
[10,"Larouche","Frédéric","SQ10571","032","Agt Liais. Autoch 02","2016-06-10","238-0447","Colloque des directeurs de police autochtones"]
[11,"Gervais","Richard","SQ10623","433","Agt Liai. Ct Autoch","2016-02-10","231-0092","Sensibilisation aux réalités autochtones"]
[12,"Gervais","Richard","SQ10623","433","Agt Liai. Ct Autoch","2005-03-31","231-0092","Sensibilisation aux réalités autochtones"]
[13,"Côté","François","SQ10624","032","Agt Liais. Autoch 02","2016-02-17","231-0092","Sensibilisation aux réalités autochtones"]
[14,"Côté","François","SQ10624","032","Agt Liais. Autoch 02","2011-02-25","231-0092","Sensibilisation aux réalités autochtones"]
[15,"Côté","François","SQ10624","032","Agt Liais. Autoch 02","2010-08-25","238-0005","US ' COUTUMES AUTOCHTONES"]
[16,"Frenette","Daniel","SQ11094","032","Agt Liais. Autoch 02","2008-11-21","231-0092","Sensibilisation aux réalités autochtones"]
[17,"Bouvier","Julie","SQ11433","032","Agt Liais. Autoch 02","2017-06-08","238-0447","Colloque des directeurs de police autochtones"]
[18,"Bouvier","Julie","SQ11433","032","Agt Liais. Autoch 02","2017-04-04","231-0092","Sensibilisation aux réalités autochtones"]
[19,"Boulanger","Geoffroy","SQ11589","032","Agt Liais. Autoch 02","2007-10-12","231-0092","Sensibilisation aux réalités autochtones"]
[20,"Boulanger","Geoffroy","SQ11589","032","Agt Liais. Autoch 02","2009-10-16","231-0092","Sensibilisation aux réalités autochtones"]
[21,"Boulanger","Geoffroy","SQ11589","032","Agt Liais. Autoch 02","2011-11-09","231-0092","Sensibilisation aux réalités autochtones"]
[22,"Bélisle","Guillaume","SQ11866","032","Agt Liais. Autoch 02","2013-02-21","231-0092","Sensibilisation aux réalités autochtones"]
[23,"Bélisle","Guillaume","SQ11866","032","Agt Liais. Autoch 02","2016-10-13","231-0092","Sensibilisation aux réalités autochtones"]
[24,"Bélisle","Guillaume","SQ11866","032","Agt Liais. Autoch 02","2013-03-14","231-0092","Sensibilisation aux réalités autochtones"]
[25,"Bélisle","Guillaume","SQ11866","032","Agt Liais. Autoch 02","2007-09-14","231-0092","Sensibilisation aux réalités autochtones"]
[26,"Bélisle","Guillaume","SQ11866","032","Agt Liais. Autoch 02","2017-06-08","238-0447","Colloque des directeurs de police autochtones"]
[27,"Bélisle","Guillaume","SQ11866","032","Agt Liais. Autoch 02","2016-06-10","238-0447","Colloque des directeurs de police autochtones"]
[28,"Larouche","Dany","SQ12064","032","Agt Liais. Autoch 02","2008-11-21","231-0092","Sensibilisation aux réalités autochtones"]
[29,"Courteau","Chantal","SQ12400","032","Agt Liais. Autoch 02","2017-06-08","238-0447","Colloque des directeurs de police autochtones"]
[30,"Courteau","Chantal","SQ12400","032","Agt Liais. Autoch 02","2017-10-18","231-0092","Sensibilisation aux réalités autochtones"]
[31,"Maltais","Guillaume","SQ12589","433","Agt Liai. Ct Autoch","2016-06-10","238-0447","Colloque des directeurs de police autochtones"]
[32,"Maltais","Guillaume","SQ12589","433","Agt Liai. Ct Autoch","2017-06-08","238-0447","Colloque des directeurs de police autochtones"]
[33,"Maltais","Guillaume","SQ12589","433","Agt Liai. Ct Autoch","2011-01-26","231-0092","Sensibilisation aux réalités autochtones"]
[34,"Maltais","Guillaume","SQ12589","433","Agt Liai. Ct Autoch","2016-01-28","231-0092","Sensibilisation aux réalités autochtones"]
[35,"Maltais","Guillaume","SQ12589","433","Agt Liai. Ct Autoch","2017-05-17","231-0092","Sensibilisation aux réalités autochtones"]
[36,"McBride","Matthew","SQ12873","032","Agt Liais. Autoch 02","2008-11-21","231-0092","Sensibilisation aux réalités autochtones"]
[37,"McBride","Matthew","SQ12873","032","Agt Liais. Autoch 02","2013-06-05","238-0447","Colloque des directeurs de police autochtones"]
[38,"Beaudry","Daniel","SQ6669","032","Agt Liais. Autoch 02"]
[39,"Turnbull","Ian","SQ6760","032","Agt Liais. Autoch 02","2004-03-31","231-0092","Sensibilisation aux réalités autochtones"]
[40,"Bremer","Louis","SQ7049","032","Agt Liais. Autoch 02","1984-04-01","000-7088","SENSIBILISATION MOEURS AUTOCHTONES"]
[41,"Bremer","Louis","SQ7049","032","Agt Liais. Autoch 02","2004-04-01","231-0092","Sensibilisation aux réalités autochtones"]
[42,"Babin","Gilles","SQ7120","032","Agt Liais. Autoch 02","2009-10-16","231-0092","Sensibilisation aux réalités autochtones"]
[43,"Babin","Gilles","SQ7120","032","Agt Liais. Autoch 02","2011-11-09","231-0092","Sensibilisation aux réalités autochtones"]
[44,"Babin","Gilles","SQ7120","032","Agt Liais. Autoch 02","1994-04-01","231-0092","Sensibilisation aux réalités autochtones"]
[45,"Delisle","Réjean","SQ7282","032","Agt Liais. Autoch 02","1999-03-31","231-0092","Sensibilisation aux réalités autochtones"]
[46,"Cadieux","Daniel","SQ7407","032","Agt Liais. Autoch 02","2009-11-05","231-0092","Sensibilisation aux réalités autochtones"]
[47,"Cadieux","Daniel","SQ7407","032","Agt Liais. Autoch 02","2011-03-03","231-0092","Sensibilisation aux réalités autochtones"]
[48,"Savage","Daniel","SQ7418","032","Agt Liais. Autoch 02","2002-04-01","231-0092","Sensibilisation aux réalités autochtones"]
[49,"Savage","Daniel","SQ7418","032","Agt Liais. Autoch 02","1985-04-01","000-7088","SENSIBILISATION MOEURS AUTOCHTONES"]
[50,"Bibeau","Raymond","SQ7658","032","Agt Liais. Autoch 02"]
[51,"Hébert","Alain","SQ7757","433","Agt Liai. Ct Autoch","2011-03-24","231-0092","Sensibilisation aux réalités autochtones"]
[52,"Hébert","Alain","SQ7757","433","Agt Liai. Ct Autoch","2009-09-30","231-0092","Sensibilisation aux réalités autochtones"]
[53,"Hébert","Alain","SQ7757","433","Agt Liai. Ct Autoch","2013-10-24","231-0092","Sensibilisation aux réalités autochtones"]
[54,"Hébert","Alain","SQ7757","433","Agt Liai. Ct Autoch","2013-11-28","231-0092","Sensibilisation aux réalités autochtones"]
[55,"Hébert","Alain","SQ7757","433","Agt Liai. Ct Autoch","2017-06-08","238-0447","Colloque des directeurs de police autochtones"]
[56,"Hétu","Louis-François","SQ8394","032","Agt Liais. Autoch 02"]
[57,"Lacombe","Claude","SQ8551","433","Agt Liai. Ct Autoch","2016-06-10","238-0447","Colloque des directeurs de police autochtones"]
[58,"Lacombe","Claude","SQ8551","433","Agt Liai. Ct Autoch","2015-09-10","231-0092","Sensibilisation aux réalités autochtones"]
[59,"Lacombe","Claude","SQ8551","433","Agt Liai. Ct Autoch","2015-12-01","234-1976","Piwaseha – la culture et les réalités autochtones"]
[60,"Lacombe","Claude","SQ8551","433","Agt Liai. Ct Autoch","2013-10-24","231-0092","Sensibilisation aux réalités autochtones"]
[61,"Lacombe","Claude","SQ8551","433","Agt Liai. Ct Autoch","2017-06-08","238-0447","Colloque des directeurs de police autochtones"]
[62,"Lacombe","Claude","SQ8551","433","Agt Liai. Ct Autoch","2013-10-31","231-0092","Sensibilisation aux réalités autochtones"]
[63,"Lacombe","Claude","SQ8551","433","Agt Liai. Ct Autoch","2015-12-09","231-0092","Sensibilisation aux réalités autochtones"]
[64,"Lacombe","Claude","SQ8551","433","Agt Liai. Ct Autoch","2013-06-05","238-0447","Colloque des directeurs de police autochtones"]
[65,"Vicaire","Jean","SQ8563","032","Agt Liais. Autoch 02","2015-09-10","231-0092","Sensibilisation aux réalités autochtones"]
[66,"Vicaire","Jean","SQ8563","032","Agt Liais. Autoch 02","1992-04-01","231-0092","Sensibilisation aux réalités autochtones"]
[67,"Vicaire","Jean","SQ8563","032","Agt Liais. Autoch 02","2013-06-05","238-0447","Colloque des directeurs de police autochtones"]
[68,"Vicaire","Jean","SQ8563","032","Agt Liais. Autoch 02","2015-12-09","231-0092","Sensibilisation aux réalités autochtones"]
[69,"Vicaire","Jean","SQ8563","032","Agt Liais. Autoch 02","2000-06-09","231-0092","Sensibilisation aux réalités autochtones"]
[70,"Roussel","Germain","SQ8643","032","Agt Liais. Autoch 02","1995-03-14","231-0092","Sensibilisation aux réalités autochtones"]
[71,"Boutin","Carole","SQ8644","032","Agt Liais. Autoch 02","2005-05-31","231-0092","Sensibilisation aux réalités autochtones"]
[72,"Landry","Jean","SQ8663","032","Agt Liais. Autoch 02","2015-12-01","234-1976","Piwaseha – la culture et les réalités autochtones"]
[73,"Landry","Jean","SQ8663","032","Agt Liais. Autoch 02","2015-12-09","231-0092","Sensibilisation aux réalités autochtones"]
[74,"Landry","Jean","SQ8663","032","Agt Liais. Autoch 02","2013-10-31","231-0092","Sensibilisation aux réalités autochtones"]
[75,"Simoneau","Sylvie","SQ8930","032","Agt Liais. Autoch 02","2015-09-10","231-0092","Sensibilisation aux réalités autochtones"]
[76,"Simoneau","Sylvie","SQ8930","032","Agt Liais. Autoch 02","2005-05-31","231-0092","Sensibilisation aux réalités autochtones"]
[77,"Simoneau","Sylvie","SQ8930","032","Agt Liais. Autoch 02","2016-06-10","238-0447","Colloque des directeurs de police autochtones"]
[78,"Leblanc","Karina","SQ9001","032","Agt Liais. Autoch 02","2015-09-23","231-0092","Sensibilisation aux réalités autochtones"]
[79,"Leduc","Paul","SQ9008","032","Agt Liais. Autoch 02"]
[80,"Couture","René","SQ9079","032","Agt Liais. Autoch 02","2013-11-20","231-0092","Sensibilisation aux réalités autochtones"]
[81,"Rouillard","Ghislain","SQ9113","032","Agt Liais. Autoch 02","1995-03-14","231-0092","Sensibilisation aux réalités autochtones"]
[82,"Medeiros","Carlos","SQ9128","032","Agt Liais. Autoch 02","2013-10-24","231-0092","Sensibilisation aux réalités autochtones"]
[83,"Medeiros","Carlos","SQ9128","032","Agt Liais. Autoch 02","2008-05-02","231-0092","Sensibilisation aux réalités autochtones"]
[84,"Michaud","Jean-Marc","SQ9315","433","Agt Liai. Ct Autoch","2013-02-21","231-0092","Sensibilisation aux réalités autochtones"]
[85,"Michaud","Éric","SQ9415","032","Agt Liais. Autoch 02","2008-09-26","231-0092","Sensibilisation aux réalités autochtones"]
[86,"Michaud","Éric","SQ9415","032","Agt Liais. Autoch 02","2011-03-03","231-0092","Sensibilisation aux réalités autochtones"]
[87,"Michaud","Éric","SQ9415","032","Agt Liais. Autoch 02","2008-05-23","231-0092","Sensibilisation aux réalités autochtones"]
[88,"Labrie","Érick","SQ9496","032","Agt Liais. Autoch 02","2005-06-10","231-0092","Sensibilisation aux réalités autochtones"]
[89,"Labrie","Érick","SQ9496","032","Agt Liais. Autoch 02","2004-03-31","231-0092","Sensibilisation aux réalités autochtones"]
[90,"Talbot","Marc","SQ9645","032","Agt Liais. Autoch 02","2007-09-14","231-0092","Sensibilisation aux réalités autochtones"]
[91,"Talbot","Marc","SQ9645","032","Agt Liais. Autoch 02","2012-03-22","231-0092","Sensibilisation aux réalités autochtones"]
[92,"Jean","Israël","SQ9707","032","Agt Liais. Autoch 02","2014-10-07","231-0092","Sensibilisation aux réalités autochtones"]
[93,"Jean","Israël","SQ9707","032","Agt Liais. Autoch 02","2016-06-10","238-0447","Colloque des directeurs de police autochtones"]
[94,"Jean","Israël","SQ9707","032","Agt Liais. Autoch 02","2013-11-20","231-0092","Sensibilisation aux réalités autochtones"]
[95,"Jean","Israël","SQ9707","032","Agt Liais. Autoch 02","2008-09-26","231-0092","Sensibilisation aux réalités autochtones"]
[96,"Jean","Israël","SQ9707","032","Agt Liais. Autoch 02","2017-06-08","238-0447","Colloque des directeurs de police autochtones"]
[97,"Bergeron","David","SQ9953","433","Agt Liai. Ct Autoch","2004-04-01","231-0092","Sensibilisation aux réalités autochtones"]
[98,"Bergeron","David","SQ9953","433","Agt Liai. Ct Autoch","2016-02-10","231-0092","Sensibilisation aux réalités autochtones"]
[99,"Bergeron","David","SQ9953","433","Agt Liai. Ct Autoch","2017-03-16","234-1976","Piwaseha – la culture et les réalités autochtones"]

{"sheet":"SQL Statement","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SELECT DISTINCT EMP.Nom                  NOM,\n                EMP.Prenom               PRENOM,\n                EMP.SQ_Matricule         MATRICULE,\n                MVT.Fnctn_Code           CODE_DE_FONCTION,\n                FNC.Description          FONCTION,\n                TAB_TMP.DT_FORM          DATE_FORMATION,\n                TAB_TMP.ACT_COD          CODE_ACTIVITE,\n                TAB_TMP.DESC_FORM        FORMATION\n         FROM   RHU_Employes             EMP,\n                RHU_Mouvements           MVT,\n                TCM_Fonctions            FNC,\n        (SELECT REM.SQ_Matricule          EMPLY_MAT,\n                FMT.Dt_Frmtn_Qualif       DT_FORM,\n                DOM.Code_Act              ACT_COD,\n                DOM.Description           DESC_FORM\n           FROM RHU_Employes              REM,\n                RHU_Frmtn_Milieu_Trvls    FMT,\n                RHU_Domaine_Frmtns        DOM\n          WHERE REM.No_Employe        =   FMT.Emply_No_Employe\n            AND FMT.Dmnfr_Cle_Domaine =   DOM.Cle_Domaine\n            AND DOM.Code_Act         IN ('000-7088',  '231-0024', '231-0092', '234-1976', '236-0013', '236-0032', '237-0426', '238-0005', '238-0331', '238-0447', '238-0474', '532-0044', 'ITX-0010')\n    ) TAB_TMP\n        WHERE   EMP.No_Employe        =  MVT.Emply_No_Employe AND EMP.SQ_Matricule= TAB_TMP.EMPLY_MAT(+)\n          AND   MVT.Fnctn_Code        =  FNC.Code\n          AND   MVT.Clsfc_Corps_Code  = '910'\n         -- AND   MVT.Tpmvm_Code       <> '66'\n          AND   MVT.Fnctn_Code       IN ('433','032')\n          AND ((MVT.Dt_Fin >= '2001-01-01' AND MVT.Dt_Debut < SYSDATE )  OR  ( MVT.Dt_Debut < SYSDATE AND MVT.Dt_Fin IS NULL))\n    AND (EMP.dt_depart_sq >  '2001-01-01' or EMP.dt_depart_sq is null)\n     ORDER BY   EMP.SQ_Matricule"]