== 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_388165174`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#9950, Nom_Usage#9951, Nom_Naissance#9952, Prenom#9953, Sexe#9954, Date_Naissance#9955, N_Identification_National#9956, N_Securite_Social#9957], false
(4) Project
Arguments: [N_Patient_Etablissement#9950 AS N_Patient_Etablissement#9974, Nom_Usage#9951 AS Nom_Usage#9975, Nom_Naissance#9952 AS Nom_Naissance#9976, Prenom#9953 AS Prenom#9977, Sexe#9954 AS Sexe#9978, Date_Naissance#9955 AS Date_Naissance#9979, N_Identification_National#9956 AS N_Identification_National#9980, N_Securite_Social#9957 AS N_Securite_Social#9981]
(5) Project
Arguments: [N_Patient_Etablissement#9974, Nom_Usage#9975, Nom_Naissance#9976, Prenom#9977, Sexe#9978, Date_Naissance#9979, N_Identification_National#9980, N_Securite_Social#9981]
(6) Project
Arguments: [Date_Naissance#9979 AS DATE_NAISSANCE_388125#9999, Nom_Naissance#9976 AS NOM_NAISSANCE_388122#10000, Nom_Usage#9975 AS NOM_USAGE_388121#10001, N_Identification_National#9980 AS N_IDENTIFICATIO_388126#10002, N_Patient_Etablissement#9974 AS N_PATIENT_ETABL_388120#10003, N_Securite_Social#9981 AS N_SECURITE_SOCI_388127#10004, Prenom#9977 AS PRENOM_388123#10005, Sexe#9978 AS SEXE_388124#10006]
(7) LogicalRelation
Arguments: parquet, [IPP#10015, Nom_Usage#10016, Nom_Naissance#10017, Prenom#10018, Sexe-Pat#10019, Date_Naissance#10020, N_Identification_National#10021, N_Secu#10022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10023], false
(8) Project
Arguments: [IPP#10015 AS IPP#10033, Nom_Usage#10016, Nom_Naissance#10017, Prenom#10018, Sexe-Pat#10019, Date_Naissance#10020, N_Identification_National#10021, N_Secu#10022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10023]
(9) Project
Arguments: [IPP#10033, Nom_Usage#10016 AS Nom_Usage#10044, Nom_Naissance#10017, Prenom#10018, Sexe-Pat#10019, Date_Naissance#10020, N_Identification_National#10021, N_Secu#10022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10023]
(10) Project
Arguments: [IPP#10033, Nom_Usage#10044, Nom_Naissance#10017 AS Nom_Naissance#10054, Prenom#10018, Sexe-Pat#10019, Date_Naissance#10020, N_Identification_National#10021, N_Secu#10022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10023]
(11) Project
Arguments: [IPP#10033, Nom_Usage#10044, Nom_Naissance#10054, Prenom#10018 AS Prenom#10064, Sexe-Pat#10019, Date_Naissance#10020, N_Identification_National#10021, N_Secu#10022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10023]
(12) Project
Arguments: [IPP#10033, Nom_Usage#10044, Nom_Naissance#10054, Prenom#10064, Sexe-Pat#10019 AS Sexe-Pat#10074, Date_Naissance#10020, N_Identification_National#10021, N_Secu#10022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10023]
(13) Project
Arguments: [IPP#10033, Nom_Usage#10044, Nom_Naissance#10054, Prenom#10064, Sexe-Pat#10074, Date_Naissance#10020 AS Date_Naissance#10084, N_Identification_National#10021, N_Secu#10022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10023]
(14) Project
Arguments: [IPP#10033, Nom_Usage#10044, Nom_Naissance#10054, Prenom#10064, Sexe-Pat#10074, Date_Naissance#10084, N_Identification_National#10021 AS N_Identification_National#10094, N_Secu#10022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10023]
(15) Project
Arguments: [IPP#10033, Nom_Usage#10044, Nom_Naissance#10054, Prenom#10064, Sexe-Pat#10074, Date_Naissance#10084, N_Identification_National#10094, N_Secu#10022 AS N_Secu#10104, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10023]
(16) Project
Arguments: [IPP#10033, Nom_Usage#10044, Nom_Naissance#10054, Prenom#10064, Sexe-Pat#10074, Date_Naissance#10084, N_Identification_National#10094, N_Secu#10104, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10023 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10114]
(17) Project
Arguments: [IPP#10033 AS IPP#10124, Nom_Usage#10044 AS Nom_Usage#10125, Nom_Naissance#10054 AS Nom_Naissance#10126, Prenom#10064 AS Prenom#10127, Sexe-Pat#10074 AS Sexe-Pat#10128, Date_Naissance#10084 AS Date_Naissance#10129, N_Identification_National#10094 AS N_Identification_National#10130, N_Secu#10104 AS N_Secu#10131, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10114 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10132]
(18) Project
Arguments: [IPP#10124, Nom_Usage#10125, Nom_Naissance#10126, Prenom#10127, Sexe-Pat#10128, Date_Naissance#10129, N_Identification_National#10130, N_Secu#10131, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#10132]
(19) Project
Arguments: [Date_Naissance#10129 AS DATE_NAISSANCE_388125#10151, Nom_Naissance#10126 AS NOM_NAISSANCE_388122#10152, Nom_Usage#10125 AS NOM_USAGE_388121#10153, N_Identification_National#10130 AS N_IDENTIFICATIO_388126#10154, IPP#10124 AS N_PATIENT_ETABL_388120#10155, N_Secu#10131 AS N_SECURITE_SOCI_388127#10156, Prenom#10127 AS PRENOM_388123#10157, cast(str_replace_extend(Sexe-Pat#10128, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#10159]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#9999, NOM_NAISSANCE_388122#10000, NOM_USAGE_388121#10001, N_IDENTIFICATIO_388126#10002, N_PATIENT_ETABL_388120#10003, N_SECURITE_SOCI_388127#10004, PRENOM_388123#10005, SEXE_388124#10006, str_encrypt(N_PATIENT_ETABL_388120#10003) AS ID_PATIENT_388128#10176, str_encrypt(N_PATIENT_ETABL_388120#10003) AS ID_PATIENT_BIS_388129#10177]
(22) View
Arguments: `LES_PATIENTS_388119174`, true
(23) SubqueryAlias
Arguments: LES_PATIENTS_388119174
(24) Project
Arguments: [DATE_NAISSANCE_388125#9999 AS LES_PATIENTS_388119_DATE_NAISSANCE_388125#10446, NOM_NAISSANCE_388122#10000 AS LES_PATIENTS_388119_NOM_NAISSANCE_388122#10447, NOM_USAGE_388121#10001 AS LES_PATIENTS_388119_NOM_USAGE_388121#10448, N_IDENTIFICATIO_388126#10002 AS LES_PATIENTS_388119_N_IDENTIFICATIO_388126#10449, N_PATIENT_ETABL_388120#10003 AS LES_PATIENTS_388119_N_PATIENT_ETABL_388120#10450, N_SECURITE_SOCI_388127#10004 AS LES_PATIENTS_388119_N_SECURITE_SOCI_388127#10451, PRENOM_388123#10005 AS LES_PATIENTS_388119_PRENOM_388123#10452, SEXE_388124#10006 AS LES_PATIENTS_388119_SEXE_388124#10453, ID_PATIENT_388128#10176 AS LES_PATIENTS_388119_ID_PATIENT_388128#10454, ID_PATIENT_BIS_388129#10177 AS LES_PATIENTS_388119_ID_PATIENT_BIS_388129#10455]
(25) Project
Arguments: [cast(LES_PATIENTS_388119_SEXE_388124#10453 as string) AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10469, cast(LES_PATIENTS_388119_DATE_NAISSANCE_388125#10446 as string) AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10470, cast(LES_PATIENTS_388119_ID_PATIENT_388128#10454 as string) AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10471]
(26) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10469 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10475, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10470 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10476, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10471 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10477]
(27) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#10325, N_Sejour#10326, Date_Debut_Sejour#10327, Date_Fin_Sejour#10328, Code_Unite_Medicale#10329, Libelle_Unite_Medicale#10330, Medecin_Responsable#10331], false
(28) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#10363, N_Sejour#10364, Date_Debut_Sejour#10365, Date_Fin_Sejour#10366, Code_Unite_Medicale#10367, Libelle_Unite_Medicale#10368, Medecin_Responsable#10369], false
(29) Project
Arguments: [N_Patient_Etablissement#10363, N_Sejour#10364, Date_Debut_Sejour#10365, Date_Fin_Sejour#10366, Code_Unite_Medicale#10367, Libelle_Unite_Medicale#10368, Medecin_Responsable#10369]
(30) Union
Arguments: false, false
(31) Project
Arguments: [N_Patient_Etablissement#10325 AS N_Patient_Etablissement#10392, N_Sejour#10326 AS N_Sejour#10393, Date_Debut_Sejour#10327 AS Date_Debut_Sejour#10394, Date_Fin_Sejour#10328 AS Date_Fin_Sejour#10395, Code_Unite_Medicale#10329 AS Code_Unite_Medicale#10396, Libelle_Unite_Medicale#10330 AS Libelle_Unite_Medicale#10397, Medecin_Responsable#10331 AS Medecin_Responsable#10398]
(32) Project
Arguments: [N_Patient_Etablissement#10392, N_Sejour#10393, Date_Debut_Sejour#10394, Date_Fin_Sejour#10395, Code_Unite_Medicale#10396, Libelle_Unite_Medicale#10397, Medecin_Responsable#10398]
(33) Project
Arguments: [Code_Unite_Medicale#10396 AS CODE_UNITE_MEDI_388065#10413, cast(Date_Debut_Sejour#10394 as timestamp) AS DATE_DEBUT_SEJO_388063#10414, cast(Date_Fin_Sejour#10395 as timestamp) AS DATE_FIN_SEJOUR_388064#10415, Libelle_Unite_Medicale#10397 AS LIBELLE_UNITE_M_388066#10416, Medecin_Responsable#10398 AS MEDECIN_RESPONS_388067#10417, N_Patient_Etablissement#10392 AS N_PATIENT_ETABL_388061#10418, N_Sejour#10393 AS N_SEJOUR_388062#10419]
(34) Project
Arguments: [CODE_UNITE_MEDI_388065#10413, DATE_DEBUT_SEJO_388063#10414, DATE_FIN_SEJOUR_388064#10415, LIBELLE_UNITE_M_388066#10416, MEDECIN_RESPONS_388067#10417, N_PATIENT_ETABL_388061#10418, N_SEJOUR_388062#10419, str_encrypt(N_PATIENT_ETABL_388061#10418) AS ID_PATIENT_388068#10427]
(35) View
Arguments: `LES_SEJOURS_388060174`, true
(36) SubqueryAlias
Arguments: LES_SEJOURS_388060174
(37) Project
Arguments: [CODE_UNITE_MEDI_388065#10413 AS LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#10489, DATE_DEBUT_SEJO_388063#10414 AS LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#10490, DATE_FIN_SEJOUR_388064#10415 AS LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#10491, LIBELLE_UNITE_M_388066#10416 AS LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#10492, MEDECIN_RESPONS_388067#10417 AS LES_SEJOURS_388060_MEDECIN_RESPONS_388067#10493, N_PATIENT_ETABL_388061#10418 AS LES_SEJOURS_388060_N_PATIENT_ETABL_388061#10494, N_SEJOUR_388062#10419 AS LES_SEJOURS_388060_N_SEJOUR_388062#10495, ID_PATIENT_388068#10427 AS LES_SEJOURS_388060_ID_PATIENT_388068#10496]
(38) Join
Arguments: LeftOuter, (COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10477 = LES_SEJOURS_388060_ID_PATIENT_388068#10496)
(39) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10475, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10476, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10477, LES_SEJOURS_388060_N_SEJOUR_388062#10495 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10527, LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#10490 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10528, LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#10491 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10529, LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#10489 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#10530, LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#10492 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10531, LES_SEJOURS_388060_MEDECIN_RESPONS_388067#10493 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10532]
(40) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10475 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10542, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10476 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10543, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10477 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10544, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10528 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10545, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10529 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10546, COL_0B71585C_6332_4738_A790_07EC5BC1F173#10530 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#10547, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10531 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10548, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10532 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10549, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10527 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10550]
(41) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10542 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10560, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10543 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10561, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10544 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10562, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10545 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10563, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10546 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10564, COL_0B71585C_6332_4738_A790_07EC5BC1F173#10547 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#10565, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10548 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10566, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10549 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10567, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10550 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10568]
(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#10188, N_Patient_Etablissement#10189, N_Sejour#10190, N_Mutation#10191, Date_Prelevement#10192, Code_Analyse#10193, Libelle_Analyse#10194, Valeur#10195, Unite#10196, Valeur_Ref_Min#10197, Valeur_Ref_Max#10198, Statut#10199], false
(43) Project
Arguments: [N_Examen#10188 AS COLL0#10212, N_Patient_Etablissement#10189 AS COLL1#10213, N_Sejour#10190 AS COLL2#10214, N_Mutation#10191 AS COLL3#10215, Date_Prelevement#10192 AS COLL4#10216, Code_Analyse#10193 AS COLL5#10217, Libelle_Analyse#10194 AS COLL6#10218, Valeur#10195 AS COLL7#10219, Unite#10196 AS COLL8#10220, Valeur_Ref_Min#10197 AS COLL9#10221, Valeur_Ref_Max#10198 AS COLL10#10222, Statut#10199 AS COLL11#10223]
(44) Project
Arguments: [COLL0#10212 AS COLL0#10236, COLL1#10213 AS COLL1#10237, COLL2#10214 AS COLL2#10238, COLL3#10215 AS COLL3#10239, COLL4#10216 AS COLL4#10240, COLL5#10217 AS COLL5#10241, COLL6#10218 AS COLL6#10242, COLL7#10219 AS COLL7#10243, COLL8#10220 AS COLL8#10244, COLL9#10221 AS COLL9#10245, COLL10#10222 AS COLL10#10246, COLL11#10223 AS COLL11#10247]
(45) Project
Arguments: [COLL0#10236, COLL1#10237, COLL2#10238, COLL3#10239, COLL4#10240, COLL5#10241, COLL6#10242, COLL7#10243, COLL8#10244, COLL9#10245, COLL10#10246, COLL11#10247]
(46) Project
Arguments: [COLL5#10241 AS CODE_ANALYSE_388136#10272, COLL4#10240 AS DATE_PRELEVEMEN_388135#10273, COLL6#10242 AS LIBELLE_ANALYSE_388137#10274, COLL0#10236 AS N_EXAMEN_388131#10275, COLL3#10239 AS N_MUTATION_388134#10276, COLL1#10237 AS N_PATIENT_ETABL_388132#10277, COLL2#10238 AS N_SEJOUR_388133#10278, COLL11#10247 AS STATUT_388142#10279, COLL8#10244 AS UNITE_388139#10280, COLL7#10243 AS VALEUR_388138#10281, COLL10#10246 AS VALEUR_REF_MAX_388141#10282, COLL9#10245 AS VALEUR_REF_MIN_388140#10283]
(47) Project
Arguments: [CODE_ANALYSE_388136#10272, DATE_PRELEVEMEN_388135#10273, LIBELLE_ANALYSE_388137#10274, N_EXAMEN_388131#10275, N_MUTATION_388134#10276, N_PATIENT_ETABL_388132#10277, N_SEJOUR_388133#10278, STATUT_388142#10279, UNITE_388139#10280, VALEUR_388138#10281, VALEUR_REF_MAX_388141#10282, VALEUR_REF_MIN_388140#10283]
(48) View
Arguments: `BIOLOGIE_PATIEN_388130174`, true
(49) SubqueryAlias
Arguments: BIOLOGIE_PATIEN_388130174
(50) Project
Arguments: [CODE_ANALYSE_388136#10272 AS BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#10590, DATE_PRELEVEMEN_388135#10273 AS BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#10591, LIBELLE_ANALYSE_388137#10274 AS BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#10592, N_EXAMEN_388131#10275 AS BIOLOGIE_PATIEN_388130_N_EXAMEN_388131#10593, N_MUTATION_388134#10276 AS BIOLOGIE_PATIEN_388130_N_MUTATION_388134#10594, N_PATIENT_ETABL_388132#10277 AS BIOLOGIE_PATIEN_388130_N_PATIENT_ETABL_388132#10595, N_SEJOUR_388133#10278 AS BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#10596, STATUT_388142#10279 AS BIOLOGIE_PATIEN_388130_STATUT_388142#10597, UNITE_388139#10280 AS BIOLOGIE_PATIEN_388130_UNITE_388139#10598, VALEUR_388138#10281 AS BIOLOGIE_PATIEN_388130_VALEUR_388138#10599, VALEUR_REF_MAX_388141#10282 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#10600, VALEUR_REF_MIN_388140#10283 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#10601]
(51) Join
Arguments: Inner, (COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10568 = BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#10596)
(52) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10560, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10561, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10562, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10563, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10564, COL_0B71585C_6332_4738_A790_07EC5BC1F173#10565, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10566, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10567, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10568, BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#10591 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10656, BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#10590 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#10657, BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#10592 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#10658, BIOLOGIE_PATIEN_388130_VALEUR_388138#10599 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#10659, BIOLOGIE_PATIEN_388130_UNITE_388139#10598 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#10660, BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#10601 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#10661, BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#10600 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#10662, BIOLOGIE_PATIEN_388130_STATUT_388142#10597 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#10663]
(53) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10560, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10561, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10562, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10563, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10564, COL_0B71585C_6332_4738_A790_07EC5BC1F173#10565, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10566, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10567, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10568, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10656, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#10657, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#10658, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#10659, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#10660, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#10661, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#10662, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#10663, date_diff(cast(MINUTE as string), COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10656, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10563) AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#10681L]
(54) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10560, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10561, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10562, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10563, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10564, COL_0B71585C_6332_4738_A790_07EC5BC1F173#10565, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10566, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10567, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10568, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10656, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#10657, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#10658, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#10659, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#10660, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#10661, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#10662, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#10663, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#10681L, date_diff(cast(MINUTE as string), COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10564, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10656) AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#10700L]
(55) Filter
Arguments: (CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10567, cast(SIMON as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10567, cast(SIMON as string)) END OR CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10567, cast(DUPONT as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10567, cast(DUPONT as string)) END)
(56) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10560 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10720, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10561 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10721, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10562 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10722, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10563 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10723, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10564 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10724, COL_0B71585C_6332_4738_A790_07EC5BC1F173#10565 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#10725, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10566 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10726, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10567 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10727, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10568 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10728, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10656 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10729, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#10657 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#10730, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#10658 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#10731, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#10659 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#10732, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#10660 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#10733, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#10661 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#10734, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#10662 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#10735, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#10663 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#10736, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#10681L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#10737L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#10700L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#10738L]
(57) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10720 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10758, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10721 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10759, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10722 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10760, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10723 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10761, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10724 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10762, COL_0B71585C_6332_4738_A790_07EC5BC1F173#10725 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#10763, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10726 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10764, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10727 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10765, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10728 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10766, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10729 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10767, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#10730 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#10768, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#10731 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#10769, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#10732 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#10770, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#10733 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#10771, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#10734 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#10772, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#10735 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#10773, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#10736 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#10774, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#10737L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#10775L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#10738L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#10776L]
(58) Aggregate
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10758, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10759, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10760, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10761, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10762, COL_0B71585C_6332_4738_A790_07EC5BC1F173#10763, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10764, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10765, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10766, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10767, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#10768, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#10769, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#10770, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#10771, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#10772, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#10773, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#10774, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#10775L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#10776L], [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#10758 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#10796, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#10759 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#10797, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#10760 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#10798, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#10761 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#10799, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#10762 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#10800, COL_0B71585C_6332_4738_A790_07EC5BC1F173#10763 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#10801, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#10764 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#10802, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#10765 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#10803, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#10766 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#10804, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#10767 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#10805, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#10768 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#10806, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#10769 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#10807, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#10770 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#10808, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#10771 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#10809, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#10772 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#10810, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#10773 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#10811, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#10774 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#10812, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#10775L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#10813L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#10776L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#10814L, 1 AS NULL_1#10834]
(59) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#10796, COL_53BB3EE9_8890_4C91_B227_683FABF95657#10797, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#10798, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#10799, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#10800, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#10801, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#10802, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#10803, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#10804, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#10805, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#10806, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#10807, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#10808, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#10809, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#10810, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#10811, COL_155D490C_35A1_496B_88D3_425E93ED3101#10812, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#10813L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#10814L]
(60) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#10796 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#10874, COL_53BB3EE9_8890_4C91_B227_683FABF95657#10797 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#10875, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#10798 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#10876, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#10799 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#10877, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#10800 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#10878, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#10801 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#10879, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#10802 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#10880, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#10803 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#10881, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#10804 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#10882, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#10805 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#10883, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#10806 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#10884, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#10807 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#10885, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#10808 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#10886, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#10809 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#10887, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#10810 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#10888, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#10811 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#10889, COL_155D490C_35A1_496B_88D3_425E93ED3101#10812 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#10890, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#10813L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#10891L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#10814L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#10892L]