== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (60)
+- Project (59)
+- Aggregate (58)
+- Project (57)
+- Project (56)
+- Filter (55)
+- Project (54)
+- Project (53)
+- Project (52)
+- Join (51)
:- Project (41)
: +- Project (40)
: +- Project (39)
: +- Join (38)
: :- Project (26)
: : +- Project (25)
: : +- Project (24)
: : +- SubqueryAlias (23)
: : +- View (22)
: : +- Project (21)
: : +- Union (20)
: : :- Project (6)
: : : +- Project (5)
: : : +- Project (4)
: : : +- LogicalRelation (3)
: : +- Project (19)
: : +- Project (18)
: : +- Project (17)
: : +- Project (16)
: : +- Project (15)
: : +- Project (14)
: : +- Project (13)
: : +- Project (12)
: : +- Project (11)
: : +- Project (10)
: : +- Project (9)
: : +- Project (8)
: : +- LogicalRelation (7)
: +- Project (37)
: +- SubqueryAlias (36)
: +- View (35)
: +- Project (34)
: +- Project (33)
: +- Project (32)
: +- Project (31)
: +- Union (30)
: :- LogicalRelation (27)
: +- Project (29)
: +- LogicalRelation (28)
+- Project (50)
+- SubqueryAlias (49)
+- View (48)
+- Project (47)
+- Project (46)
+- Project (45)
+- Project (44)
+- Project (43)
+- LogicalRelation (42)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `BIOLOGIE_PATIEN_388165178`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#17604, Nom_Usage#17605, Nom_Naissance#17606, Prenom#17607, Sexe#17608, Date_Naissance#17609, N_Identification_National#17610, N_Securite_Social#17611], false
(4) Project
Arguments: [N_Patient_Etablissement#17604 AS N_Patient_Etablissement#17628, Nom_Usage#17605 AS Nom_Usage#17629, Nom_Naissance#17606 AS Nom_Naissance#17630, Prenom#17607 AS Prenom#17631, Sexe#17608 AS Sexe#17632, Date_Naissance#17609 AS Date_Naissance#17633, N_Identification_National#17610 AS N_Identification_National#17634, N_Securite_Social#17611 AS N_Securite_Social#17635]
(5) Project
Arguments: [N_Patient_Etablissement#17628, Nom_Usage#17629, Nom_Naissance#17630, Prenom#17631, Sexe#17632, Date_Naissance#17633, N_Identification_National#17634, N_Securite_Social#17635]
(6) Project
Arguments: [Date_Naissance#17633 AS DATE_NAISSANCE_388125#17653, Nom_Naissance#17630 AS NOM_NAISSANCE_388122#17654, Nom_Usage#17629 AS NOM_USAGE_388121#17655, N_Identification_National#17634 AS N_IDENTIFICATIO_388126#17656, N_Patient_Etablissement#17628 AS N_PATIENT_ETABL_388120#17657, N_Securite_Social#17635 AS N_SECURITE_SOCI_388127#17658, Prenom#17631 AS PRENOM_388123#17659, Sexe#17632 AS SEXE_388124#17660]
(7) LogicalRelation
Arguments: parquet, [IPP#17669, Nom_Usage#17670, Nom_Naissance#17671, Prenom#17672, Sexe-Pat#17673, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677], false
(8) Project
Arguments: [IPP#17669 AS IPP#17687, Nom_Usage#17670, Nom_Naissance#17671, Prenom#17672, Sexe-Pat#17673, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(9) Project
Arguments: [IPP#17687, Nom_Usage#17670 AS Nom_Usage#17698, Nom_Naissance#17671, Prenom#17672, Sexe-Pat#17673, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(10) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17671 AS Nom_Naissance#17708, Prenom#17672, Sexe-Pat#17673, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(11) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17672 AS Prenom#17718, Sexe-Pat#17673, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(12) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17718, Sexe-Pat#17673 AS Sexe-Pat#17728, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(13) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17718, Sexe-Pat#17728, Date_Naissance#17674 AS Date_Naissance#17738, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(14) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17718, Sexe-Pat#17728, Date_Naissance#17738, N_Identification_National#17675 AS N_Identification_National#17748, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(15) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17718, Sexe-Pat#17728, Date_Naissance#17738, N_Identification_National#17748, N_Secu#17676 AS N_Secu#17758, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(16) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17718, Sexe-Pat#17728, Date_Naissance#17738, N_Identification_National#17748, N_Secu#17758, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17768]
(17) Project
Arguments: [IPP#17687 AS IPP#17778, Nom_Usage#17698 AS Nom_Usage#17779, Nom_Naissance#17708 AS Nom_Naissance#17780, Prenom#17718 AS Prenom#17781, Sexe-Pat#17728 AS Sexe-Pat#17782, Date_Naissance#17738 AS Date_Naissance#17783, N_Identification_National#17748 AS N_Identification_National#17784, N_Secu#17758 AS N_Secu#17785, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17768 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17786]
(18) Project
Arguments: [IPP#17778, Nom_Usage#17779, Nom_Naissance#17780, Prenom#17781, Sexe-Pat#17782, Date_Naissance#17783, N_Identification_National#17784, N_Secu#17785, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17786]
(19) Project
Arguments: [Date_Naissance#17783 AS DATE_NAISSANCE_388125#17805, Nom_Naissance#17780 AS NOM_NAISSANCE_388122#17806, Nom_Usage#17779 AS NOM_USAGE_388121#17807, N_Identification_National#17784 AS N_IDENTIFICATIO_388126#17808, IPP#17778 AS N_PATIENT_ETABL_388120#17809, N_Secu#17785 AS N_SECURITE_SOCI_388127#17810, Prenom#17781 AS PRENOM_388123#17811, cast(str_replace_extend(Sexe-Pat#17782, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#17813]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#17653, NOM_NAISSANCE_388122#17654, NOM_USAGE_388121#17655, N_IDENTIFICATIO_388126#17656, N_PATIENT_ETABL_388120#17657, N_SECURITE_SOCI_388127#17658, PRENOM_388123#17659, SEXE_388124#17660, str_encrypt(N_PATIENT_ETABL_388120#17657) AS ID_PATIENT_388128#17830, str_encrypt(N_PATIENT_ETABL_388120#17657) AS ID_PATIENT_BIS_388129#17831]
(22) View
Arguments: `LES_PATIENTS_388119178`, true
(23) SubqueryAlias
Arguments: LES_PATIENTS_388119178
(24) Project
Arguments: [DATE_NAISSANCE_388125#17653 AS LES_PATIENTS_388119_DATE_NAISSANCE_388125#18100, NOM_NAISSANCE_388122#17654 AS LES_PATIENTS_388119_NOM_NAISSANCE_388122#18101, NOM_USAGE_388121#17655 AS LES_PATIENTS_388119_NOM_USAGE_388121#18102, N_IDENTIFICATIO_388126#17656 AS LES_PATIENTS_388119_N_IDENTIFICATIO_388126#18103, N_PATIENT_ETABL_388120#17657 AS LES_PATIENTS_388119_N_PATIENT_ETABL_388120#18104, N_SECURITE_SOCI_388127#17658 AS LES_PATIENTS_388119_N_SECURITE_SOCI_388127#18105, PRENOM_388123#17659 AS LES_PATIENTS_388119_PRENOM_388123#18106, SEXE_388124#17660 AS LES_PATIENTS_388119_SEXE_388124#18107, ID_PATIENT_388128#17830 AS LES_PATIENTS_388119_ID_PATIENT_388128#18108, ID_PATIENT_BIS_388129#17831 AS LES_PATIENTS_388119_ID_PATIENT_BIS_388129#18109]
(25) Project
Arguments: [cast(LES_PATIENTS_388119_SEXE_388124#18107 as string) AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18123, cast(LES_PATIENTS_388119_DATE_NAISSANCE_388125#18100 as string) AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18124, cast(LES_PATIENTS_388119_ID_PATIENT_388128#18108 as string) AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18125]
(26) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18123 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18129, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18124 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18130, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18125 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18131]
(27) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#17979, N_Sejour#17980, Date_Debut_Sejour#17981, Date_Fin_Sejour#17982, Code_Unite_Medicale#17983, Libelle_Unite_Medicale#17984, Medecin_Responsable#17985], false
(28) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#18017, N_Sejour#18018, Date_Debut_Sejour#18019, Date_Fin_Sejour#18020, Code_Unite_Medicale#18021, Libelle_Unite_Medicale#18022, Medecin_Responsable#18023], false
(29) Project
Arguments: [N_Patient_Etablissement#18017, N_Sejour#18018, Date_Debut_Sejour#18019, Date_Fin_Sejour#18020, Code_Unite_Medicale#18021, Libelle_Unite_Medicale#18022, Medecin_Responsable#18023]
(30) Union
Arguments: false, false
(31) Project
Arguments: [N_Patient_Etablissement#17979 AS N_Patient_Etablissement#18046, N_Sejour#17980 AS N_Sejour#18047, Date_Debut_Sejour#17981 AS Date_Debut_Sejour#18048, Date_Fin_Sejour#17982 AS Date_Fin_Sejour#18049, Code_Unite_Medicale#17983 AS Code_Unite_Medicale#18050, Libelle_Unite_Medicale#17984 AS Libelle_Unite_Medicale#18051, Medecin_Responsable#17985 AS Medecin_Responsable#18052]
(32) Project
Arguments: [N_Patient_Etablissement#18046, N_Sejour#18047, Date_Debut_Sejour#18048, Date_Fin_Sejour#18049, Code_Unite_Medicale#18050, Libelle_Unite_Medicale#18051, Medecin_Responsable#18052]
(33) Project
Arguments: [Code_Unite_Medicale#18050 AS CODE_UNITE_MEDI_388065#18067, cast(Date_Debut_Sejour#18048 as timestamp) AS DATE_DEBUT_SEJO_388063#18068, cast(Date_Fin_Sejour#18049 as timestamp) AS DATE_FIN_SEJOUR_388064#18069, Libelle_Unite_Medicale#18051 AS LIBELLE_UNITE_M_388066#18070, Medecin_Responsable#18052 AS MEDECIN_RESPONS_388067#18071, N_Patient_Etablissement#18046 AS N_PATIENT_ETABL_388061#18072, N_Sejour#18047 AS N_SEJOUR_388062#18073]
(34) Project
Arguments: [CODE_UNITE_MEDI_388065#18067, DATE_DEBUT_SEJO_388063#18068, DATE_FIN_SEJOUR_388064#18069, LIBELLE_UNITE_M_388066#18070, MEDECIN_RESPONS_388067#18071, N_PATIENT_ETABL_388061#18072, N_SEJOUR_388062#18073, str_encrypt(N_PATIENT_ETABL_388061#18072) AS ID_PATIENT_388068#18081]
(35) View
Arguments: `LES_SEJOURS_388060178`, true
(36) SubqueryAlias
Arguments: LES_SEJOURS_388060178
(37) Project
Arguments: [CODE_UNITE_MEDI_388065#18067 AS LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#18143, DATE_DEBUT_SEJO_388063#18068 AS LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#18144, DATE_FIN_SEJOUR_388064#18069 AS LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#18145, LIBELLE_UNITE_M_388066#18070 AS LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#18146, MEDECIN_RESPONS_388067#18071 AS LES_SEJOURS_388060_MEDECIN_RESPONS_388067#18147, N_PATIENT_ETABL_388061#18072 AS LES_SEJOURS_388060_N_PATIENT_ETABL_388061#18148, N_SEJOUR_388062#18073 AS LES_SEJOURS_388060_N_SEJOUR_388062#18149, ID_PATIENT_388068#18081 AS LES_SEJOURS_388060_ID_PATIENT_388068#18150]
(38) Join
Arguments: LeftOuter, (COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18131 = LES_SEJOURS_388060_ID_PATIENT_388068#18150)
(39) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18129, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18130, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18131, LES_SEJOURS_388060_N_SEJOUR_388062#18149 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18181, LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#18144 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18182, LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#18145 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18183, LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#18143 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#18184, LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#18146 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18185, LES_SEJOURS_388060_MEDECIN_RESPONS_388067#18147 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18186]
(40) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18129 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18196, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18130 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18197, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18131 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18198, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18182 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18199, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18183 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18200, COL_0B71585C_6332_4738_A790_07EC5BC1F173#18184 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#18201, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18185 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18202, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18186 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18203, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18181 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18204]
(41) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18196 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18214, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18197 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18215, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18198 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18216, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18199 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18217, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18200 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18218, COL_0B71585C_6332_4738_A790_07EC5BC1F173#18201 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#18219, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18202 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18220, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18203 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18221, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18204 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18222]
(42) LogicalRelation
Arguments: JDBCRelation((SELECT "N_Examen", "N_Patient_Etablissement", "N_Sejour", "N_Mutation", "Date_Prelevement", "Code_Analyse", "Libelle_Analyse", "Valeur", "Unite", "Valeur_Ref_Min", "Valeur_Ref_Max", "Statut" FROM "formation"."biologie_patient") as x) [numPartitions=1], [N_Examen#17842, N_Patient_Etablissement#17843, N_Sejour#17844, N_Mutation#17845, Date_Prelevement#17846, Code_Analyse#17847, Libelle_Analyse#17848, Valeur#17849, Unite#17850, Valeur_Ref_Min#17851, Valeur_Ref_Max#17852, Statut#17853], false
(43) Project
Arguments: [N_Examen#17842 AS COLL0#17866, N_Patient_Etablissement#17843 AS COLL1#17867, N_Sejour#17844 AS COLL2#17868, N_Mutation#17845 AS COLL3#17869, Date_Prelevement#17846 AS COLL4#17870, Code_Analyse#17847 AS COLL5#17871, Libelle_Analyse#17848 AS COLL6#17872, Valeur#17849 AS COLL7#17873, Unite#17850 AS COLL8#17874, Valeur_Ref_Min#17851 AS COLL9#17875, Valeur_Ref_Max#17852 AS COLL10#17876, Statut#17853 AS COLL11#17877]
(44) Project
Arguments: [COLL0#17866 AS COLL0#17890, COLL1#17867 AS COLL1#17891, COLL2#17868 AS COLL2#17892, COLL3#17869 AS COLL3#17893, COLL4#17870 AS COLL4#17894, COLL5#17871 AS COLL5#17895, COLL6#17872 AS COLL6#17896, COLL7#17873 AS COLL7#17897, COLL8#17874 AS COLL8#17898, COLL9#17875 AS COLL9#17899, COLL10#17876 AS COLL10#17900, COLL11#17877 AS COLL11#17901]
(45) Project
Arguments: [COLL0#17890, COLL1#17891, COLL2#17892, COLL3#17893, COLL4#17894, COLL5#17895, COLL6#17896, COLL7#17897, COLL8#17898, COLL9#17899, COLL10#17900, COLL11#17901]
(46) Project
Arguments: [COLL5#17895 AS CODE_ANALYSE_388136#17926, COLL4#17894 AS DATE_PRELEVEMEN_388135#17927, COLL6#17896 AS LIBELLE_ANALYSE_388137#17928, COLL0#17890 AS N_EXAMEN_388131#17929, COLL3#17893 AS N_MUTATION_388134#17930, COLL1#17891 AS N_PATIENT_ETABL_388132#17931, COLL2#17892 AS N_SEJOUR_388133#17932, COLL11#17901 AS STATUT_388142#17933, COLL8#17898 AS UNITE_388139#17934, COLL7#17897 AS VALEUR_388138#17935, COLL10#17900 AS VALEUR_REF_MAX_388141#17936, COLL9#17899 AS VALEUR_REF_MIN_388140#17937]
(47) Project
Arguments: [CODE_ANALYSE_388136#17926, DATE_PRELEVEMEN_388135#17927, LIBELLE_ANALYSE_388137#17928, N_EXAMEN_388131#17929, N_MUTATION_388134#17930, N_PATIENT_ETABL_388132#17931, N_SEJOUR_388133#17932, STATUT_388142#17933, UNITE_388139#17934, VALEUR_388138#17935, VALEUR_REF_MAX_388141#17936, VALEUR_REF_MIN_388140#17937]
(48) View
Arguments: `BIOLOGIE_PATIEN_388130178`, true
(49) SubqueryAlias
Arguments: BIOLOGIE_PATIEN_388130178
(50) Project
Arguments: [CODE_ANALYSE_388136#17926 AS BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#18244, DATE_PRELEVEMEN_388135#17927 AS BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#18245, LIBELLE_ANALYSE_388137#17928 AS BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#18246, N_EXAMEN_388131#17929 AS BIOLOGIE_PATIEN_388130_N_EXAMEN_388131#18247, N_MUTATION_388134#17930 AS BIOLOGIE_PATIEN_388130_N_MUTATION_388134#18248, N_PATIENT_ETABL_388132#17931 AS BIOLOGIE_PATIEN_388130_N_PATIENT_ETABL_388132#18249, N_SEJOUR_388133#17932 AS BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#18250, STATUT_388142#17933 AS BIOLOGIE_PATIEN_388130_STATUT_388142#18251, UNITE_388139#17934 AS BIOLOGIE_PATIEN_388130_UNITE_388139#18252, VALEUR_388138#17935 AS BIOLOGIE_PATIEN_388130_VALEUR_388138#18253, VALEUR_REF_MAX_388141#17936 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#18254, VALEUR_REF_MIN_388140#17937 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#18255]
(51) Join
Arguments: Inner, (COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18222 = BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#18250)
(52) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18214, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18215, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18216, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18217, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18218, COL_0B71585C_6332_4738_A790_07EC5BC1F173#18219, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18220, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18221, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18222, BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#18245 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18310, BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#18244 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#18311, BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#18246 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#18312, BIOLOGIE_PATIEN_388130_VALEUR_388138#18253 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#18313, BIOLOGIE_PATIEN_388130_UNITE_388139#18252 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#18314, BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#18255 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#18315, BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#18254 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#18316, BIOLOGIE_PATIEN_388130_STATUT_388142#18251 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#18317]
(53) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18214, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18215, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18216, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18217, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18218, COL_0B71585C_6332_4738_A790_07EC5BC1F173#18219, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18220, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18221, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18222, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18310, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#18311, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#18312, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#18313, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#18314, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#18315, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#18316, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#18317, date_diff(cast(MINUTE as string), COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18310, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18217) AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#18335L]
(54) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18214, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18215, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18216, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18217, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18218, COL_0B71585C_6332_4738_A790_07EC5BC1F173#18219, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18220, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18221, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18222, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18310, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#18311, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#18312, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#18313, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#18314, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#18315, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#18316, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#18317, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#18335L, date_diff(cast(MINUTE as string), COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18218, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18310) AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#18354L]
(55) Filter
Arguments: (CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18221, cast(SIMON as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18221, cast(SIMON as string)) END OR CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18221, cast(DUPONT as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18221, cast(DUPONT as string)) END)
(56) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18214 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18374, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18215 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18375, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18216 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18376, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18217 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18377, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18218 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18378, COL_0B71585C_6332_4738_A790_07EC5BC1F173#18219 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#18379, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18220 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18380, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18221 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18381, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18222 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18382, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18310 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18383, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#18311 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#18384, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#18312 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#18385, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#18313 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#18386, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#18314 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#18387, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#18315 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#18388, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#18316 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#18389, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#18317 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#18390, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#18335L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#18391L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#18354L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#18392L]
(57) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18374 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18412, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18375 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18413, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18376 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18414, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18377 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18415, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18378 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18416, COL_0B71585C_6332_4738_A790_07EC5BC1F173#18379 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#18417, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18380 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18418, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18381 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18419, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18382 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18420, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18383 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18421, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#18384 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#18422, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#18385 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#18423, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#18386 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#18424, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#18387 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#18425, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#18388 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#18426, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#18389 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#18427, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#18390 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#18428, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#18391L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#18429L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#18392L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#18430L]
(58) Aggregate
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18412, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18413, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18414, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18415, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18416, COL_0B71585C_6332_4738_A790_07EC5BC1F173#18417, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18418, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18419, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18420, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18421, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#18422, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#18423, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#18424, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#18425, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#18426, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#18427, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#18428, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#18429L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#18430L], [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#18412 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#18450, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#18413 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#18451, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#18414 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#18452, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#18415 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#18453, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#18416 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#18454, COL_0B71585C_6332_4738_A790_07EC5BC1F173#18417 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#18455, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#18418 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#18456, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#18419 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#18457, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#18420 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#18458, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#18421 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#18459, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#18422 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#18460, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#18423 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#18461, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#18424 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#18462, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#18425 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#18463, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#18426 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#18464, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#18427 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#18465, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#18428 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#18466, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#18429L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#18467L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#18430L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#18468L, 1 AS NULL_1#18488]
(59) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#18450, COL_53BB3EE9_8890_4C91_B227_683FABF95657#18451, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#18452, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#18453, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#18454, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#18455, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#18456, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#18457, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#18458, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#18459, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#18460, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#18461, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#18462, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#18463, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#18464, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#18465, COL_155D490C_35A1_496B_88D3_425E93ED3101#18466, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#18467L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#18468L]
(60) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#18450 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#18528, COL_53BB3EE9_8890_4C91_B227_683FABF95657#18451 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#18529, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#18452 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#18530, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#18453 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#18531, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#18454 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#18532, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#18455 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#18533, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#18456 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#18534, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#18457 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#18535, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#18458 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#18536, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#18459 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#18537, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#18460 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#18538, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#18461 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#18539, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#18462 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#18540, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#18463 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#18541, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#18464 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#18542, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#18465 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#18543, COL_155D490C_35A1_496B_88D3_425E93ED3101#18466 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#18544, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#18467L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#18545L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#18468L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#18546L]