== 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_388165175`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#28914, Nom_Usage#28915, Nom_Naissance#28916, Prenom#28917, Sexe#28918, Date_Naissance#28919, N_Identification_National#28920, N_Securite_Social#28921], false
(4) Project
Arguments: [N_Patient_Etablissement#28914 AS N_Patient_Etablissement#28938, Nom_Usage#28915 AS Nom_Usage#28939, Nom_Naissance#28916 AS Nom_Naissance#28940, Prenom#28917 AS Prenom#28941, Sexe#28918 AS Sexe#28942, Date_Naissance#28919 AS Date_Naissance#28943, N_Identification_National#28920 AS N_Identification_National#28944, N_Securite_Social#28921 AS N_Securite_Social#28945]
(5) Project
Arguments: [N_Patient_Etablissement#28938, Nom_Usage#28939, Nom_Naissance#28940, Prenom#28941, Sexe#28942, Date_Naissance#28943, N_Identification_National#28944, N_Securite_Social#28945]
(6) Project
Arguments: [Date_Naissance#28943 AS DATE_NAISSANCE_388125#28963, Nom_Naissance#28940 AS NOM_NAISSANCE_388122#28964, Nom_Usage#28939 AS NOM_USAGE_388121#28965, N_Identification_National#28944 AS N_IDENTIFICATIO_388126#28966, N_Patient_Etablissement#28938 AS N_PATIENT_ETABL_388120#28967, N_Securite_Social#28945 AS N_SECURITE_SOCI_388127#28968, Prenom#28941 AS PRENOM_388123#28969, Sexe#28942 AS SEXE_388124#28970]
(7) LogicalRelation
Arguments: parquet, [IPP#28979, Nom_Usage#28980, Nom_Naissance#28981, Prenom#28982, Sexe-Pat#28983, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987], false
(8) Project
Arguments: [IPP#28979 AS IPP#28997, Nom_Usage#28980, Nom_Naissance#28981, Prenom#28982, Sexe-Pat#28983, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(9) Project
Arguments: [IPP#28997, Nom_Usage#28980 AS Nom_Usage#29008, Nom_Naissance#28981, Prenom#28982, Sexe-Pat#28983, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(10) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#28981 AS Nom_Naissance#29018, Prenom#28982, Sexe-Pat#28983, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(11) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#28982 AS Prenom#29028, Sexe-Pat#28983, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(12) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#29028, Sexe-Pat#28983 AS Sexe-Pat#29038, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(13) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#29028, Sexe-Pat#29038, Date_Naissance#28984 AS Date_Naissance#29048, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(14) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#29028, Sexe-Pat#29038, Date_Naissance#29048, N_Identification_National#28985 AS N_Identification_National#29058, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(15) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#29028, Sexe-Pat#29038, Date_Naissance#29048, N_Identification_National#29058, N_Secu#28986 AS N_Secu#29068, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(16) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#29028, Sexe-Pat#29038, Date_Naissance#29048, N_Identification_National#29058, N_Secu#29068, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#29078]
(17) Project
Arguments: [IPP#28997 AS IPP#29088, Nom_Usage#29008 AS Nom_Usage#29089, Nom_Naissance#29018 AS Nom_Naissance#29090, Prenom#29028 AS Prenom#29091, Sexe-Pat#29038 AS Sexe-Pat#29092, Date_Naissance#29048 AS Date_Naissance#29093, N_Identification_National#29058 AS N_Identification_National#29094, N_Secu#29068 AS N_Secu#29095, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#29078 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#29096]
(18) Project
Arguments: [IPP#29088, Nom_Usage#29089, Nom_Naissance#29090, Prenom#29091, Sexe-Pat#29092, Date_Naissance#29093, N_Identification_National#29094, N_Secu#29095, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#29096]
(19) Project
Arguments: [Date_Naissance#29093 AS DATE_NAISSANCE_388125#29115, Nom_Naissance#29090 AS NOM_NAISSANCE_388122#29116, Nom_Usage#29089 AS NOM_USAGE_388121#29117, N_Identification_National#29094 AS N_IDENTIFICATIO_388126#29118, IPP#29088 AS N_PATIENT_ETABL_388120#29119, N_Secu#29095 AS N_SECURITE_SOCI_388127#29120, Prenom#29091 AS PRENOM_388123#29121, cast(str_replace_extend(Sexe-Pat#29092, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#29123]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#28963, NOM_NAISSANCE_388122#28964, NOM_USAGE_388121#28965, N_IDENTIFICATIO_388126#28966, N_PATIENT_ETABL_388120#28967, N_SECURITE_SOCI_388127#28968, PRENOM_388123#28969, SEXE_388124#28970, str_encrypt(N_PATIENT_ETABL_388120#28967) AS ID_PATIENT_388128#29140, str_encrypt(N_PATIENT_ETABL_388120#28967) AS ID_PATIENT_BIS_388129#29141]
(22) View
Arguments: `LES_PATIENTS_388119175`, true
(23) SubqueryAlias
Arguments: LES_PATIENTS_388119175
(24) Project
Arguments: [DATE_NAISSANCE_388125#28963 AS LES_PATIENTS_388119_DATE_NAISSANCE_388125#29410, NOM_NAISSANCE_388122#28964 AS LES_PATIENTS_388119_NOM_NAISSANCE_388122#29411, NOM_USAGE_388121#28965 AS LES_PATIENTS_388119_NOM_USAGE_388121#29412, N_IDENTIFICATIO_388126#28966 AS LES_PATIENTS_388119_N_IDENTIFICATIO_388126#29413, N_PATIENT_ETABL_388120#28967 AS LES_PATIENTS_388119_N_PATIENT_ETABL_388120#29414, N_SECURITE_SOCI_388127#28968 AS LES_PATIENTS_388119_N_SECURITE_SOCI_388127#29415, PRENOM_388123#28969 AS LES_PATIENTS_388119_PRENOM_388123#29416, SEXE_388124#28970 AS LES_PATIENTS_388119_SEXE_388124#29417, ID_PATIENT_388128#29140 AS LES_PATIENTS_388119_ID_PATIENT_388128#29418, ID_PATIENT_BIS_388129#29141 AS LES_PATIENTS_388119_ID_PATIENT_BIS_388129#29419]
(25) Project
Arguments: [cast(LES_PATIENTS_388119_SEXE_388124#29417 as string) AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29433, cast(LES_PATIENTS_388119_DATE_NAISSANCE_388125#29410 as string) AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29434, cast(LES_PATIENTS_388119_ID_PATIENT_388128#29418 as string) AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29435]
(26) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29433 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29439, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29434 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29440, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29435 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29441]
(27) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#29289, N_Sejour#29290, Date_Debut_Sejour#29291, Date_Fin_Sejour#29292, Code_Unite_Medicale#29293, Libelle_Unite_Medicale#29294, Medecin_Responsable#29295], false
(28) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#29327, N_Sejour#29328, Date_Debut_Sejour#29329, Date_Fin_Sejour#29330, Code_Unite_Medicale#29331, Libelle_Unite_Medicale#29332, Medecin_Responsable#29333], false
(29) Project
Arguments: [N_Patient_Etablissement#29327, N_Sejour#29328, Date_Debut_Sejour#29329, Date_Fin_Sejour#29330, Code_Unite_Medicale#29331, Libelle_Unite_Medicale#29332, Medecin_Responsable#29333]
(30) Union
Arguments: false, false
(31) Project
Arguments: [N_Patient_Etablissement#29289 AS N_Patient_Etablissement#29356, N_Sejour#29290 AS N_Sejour#29357, Date_Debut_Sejour#29291 AS Date_Debut_Sejour#29358, Date_Fin_Sejour#29292 AS Date_Fin_Sejour#29359, Code_Unite_Medicale#29293 AS Code_Unite_Medicale#29360, Libelle_Unite_Medicale#29294 AS Libelle_Unite_Medicale#29361, Medecin_Responsable#29295 AS Medecin_Responsable#29362]
(32) Project
Arguments: [N_Patient_Etablissement#29356, N_Sejour#29357, Date_Debut_Sejour#29358, Date_Fin_Sejour#29359, Code_Unite_Medicale#29360, Libelle_Unite_Medicale#29361, Medecin_Responsable#29362]
(33) Project
Arguments: [Code_Unite_Medicale#29360 AS CODE_UNITE_MEDI_388065#29377, cast(Date_Debut_Sejour#29358 as timestamp) AS DATE_DEBUT_SEJO_388063#29378, cast(Date_Fin_Sejour#29359 as timestamp) AS DATE_FIN_SEJOUR_388064#29379, Libelle_Unite_Medicale#29361 AS LIBELLE_UNITE_M_388066#29380, Medecin_Responsable#29362 AS MEDECIN_RESPONS_388067#29381, N_Patient_Etablissement#29356 AS N_PATIENT_ETABL_388061#29382, N_Sejour#29357 AS N_SEJOUR_388062#29383]
(34) Project
Arguments: [CODE_UNITE_MEDI_388065#29377, DATE_DEBUT_SEJO_388063#29378, DATE_FIN_SEJOUR_388064#29379, LIBELLE_UNITE_M_388066#29380, MEDECIN_RESPONS_388067#29381, N_PATIENT_ETABL_388061#29382, N_SEJOUR_388062#29383, str_encrypt(N_PATIENT_ETABL_388061#29382) AS ID_PATIENT_388068#29391]
(35) View
Arguments: `LES_SEJOURS_388060175`, true
(36) SubqueryAlias
Arguments: LES_SEJOURS_388060175
(37) Project
Arguments: [CODE_UNITE_MEDI_388065#29377 AS LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#29453, DATE_DEBUT_SEJO_388063#29378 AS LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#29454, DATE_FIN_SEJOUR_388064#29379 AS LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#29455, LIBELLE_UNITE_M_388066#29380 AS LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#29456, MEDECIN_RESPONS_388067#29381 AS LES_SEJOURS_388060_MEDECIN_RESPONS_388067#29457, N_PATIENT_ETABL_388061#29382 AS LES_SEJOURS_388060_N_PATIENT_ETABL_388061#29458, N_SEJOUR_388062#29383 AS LES_SEJOURS_388060_N_SEJOUR_388062#29459, ID_PATIENT_388068#29391 AS LES_SEJOURS_388060_ID_PATIENT_388068#29460]
(38) Join
Arguments: LeftOuter, (COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29441 = LES_SEJOURS_388060_ID_PATIENT_388068#29460)
(39) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29439, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29440, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29441, LES_SEJOURS_388060_N_SEJOUR_388062#29459 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29491, LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#29454 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29492, LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#29455 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29493, LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#29453 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#29494, LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#29456 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29495, LES_SEJOURS_388060_MEDECIN_RESPONS_388067#29457 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29496]
(40) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29439 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29506, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29440 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29507, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29441 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29508, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29492 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29509, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29493 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29510, COL_0B71585C_6332_4738_A790_07EC5BC1F173#29494 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#29511, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29495 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29512, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29496 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29513, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29491 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29514]
(41) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29506 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29524, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29507 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29525, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29508 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29526, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29509 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29527, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29510 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29528, COL_0B71585C_6332_4738_A790_07EC5BC1F173#29511 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#29529, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29512 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29530, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29513 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29531, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29514 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29532]
(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#29152, N_Patient_Etablissement#29153, N_Sejour#29154, N_Mutation#29155, Date_Prelevement#29156, Code_Analyse#29157, Libelle_Analyse#29158, Valeur#29159, Unite#29160, Valeur_Ref_Min#29161, Valeur_Ref_Max#29162, Statut#29163], false
(43) Project
Arguments: [N_Examen#29152 AS COLL0#29176, N_Patient_Etablissement#29153 AS COLL1#29177, N_Sejour#29154 AS COLL2#29178, N_Mutation#29155 AS COLL3#29179, Date_Prelevement#29156 AS COLL4#29180, Code_Analyse#29157 AS COLL5#29181, Libelle_Analyse#29158 AS COLL6#29182, Valeur#29159 AS COLL7#29183, Unite#29160 AS COLL8#29184, Valeur_Ref_Min#29161 AS COLL9#29185, Valeur_Ref_Max#29162 AS COLL10#29186, Statut#29163 AS COLL11#29187]
(44) Project
Arguments: [COLL0#29176 AS COLL0#29200, COLL1#29177 AS COLL1#29201, COLL2#29178 AS COLL2#29202, COLL3#29179 AS COLL3#29203, COLL4#29180 AS COLL4#29204, COLL5#29181 AS COLL5#29205, COLL6#29182 AS COLL6#29206, COLL7#29183 AS COLL7#29207, COLL8#29184 AS COLL8#29208, COLL9#29185 AS COLL9#29209, COLL10#29186 AS COLL10#29210, COLL11#29187 AS COLL11#29211]
(45) Project
Arguments: [COLL0#29200, COLL1#29201, COLL2#29202, COLL3#29203, COLL4#29204, COLL5#29205, COLL6#29206, COLL7#29207, COLL8#29208, COLL9#29209, COLL10#29210, COLL11#29211]
(46) Project
Arguments: [COLL5#29205 AS CODE_ANALYSE_388136#29236, COLL4#29204 AS DATE_PRELEVEMEN_388135#29237, COLL6#29206 AS LIBELLE_ANALYSE_388137#29238, COLL0#29200 AS N_EXAMEN_388131#29239, COLL3#29203 AS N_MUTATION_388134#29240, COLL1#29201 AS N_PATIENT_ETABL_388132#29241, COLL2#29202 AS N_SEJOUR_388133#29242, COLL11#29211 AS STATUT_388142#29243, COLL8#29208 AS UNITE_388139#29244, COLL7#29207 AS VALEUR_388138#29245, COLL10#29210 AS VALEUR_REF_MAX_388141#29246, COLL9#29209 AS VALEUR_REF_MIN_388140#29247]
(47) Project
Arguments: [CODE_ANALYSE_388136#29236, DATE_PRELEVEMEN_388135#29237, LIBELLE_ANALYSE_388137#29238, N_EXAMEN_388131#29239, N_MUTATION_388134#29240, N_PATIENT_ETABL_388132#29241, N_SEJOUR_388133#29242, STATUT_388142#29243, UNITE_388139#29244, VALEUR_388138#29245, VALEUR_REF_MAX_388141#29246, VALEUR_REF_MIN_388140#29247]
(48) View
Arguments: `BIOLOGIE_PATIEN_388130175`, true
(49) SubqueryAlias
Arguments: BIOLOGIE_PATIEN_388130175
(50) Project
Arguments: [CODE_ANALYSE_388136#29236 AS BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#29554, DATE_PRELEVEMEN_388135#29237 AS BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#29555, LIBELLE_ANALYSE_388137#29238 AS BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#29556, N_EXAMEN_388131#29239 AS BIOLOGIE_PATIEN_388130_N_EXAMEN_388131#29557, N_MUTATION_388134#29240 AS BIOLOGIE_PATIEN_388130_N_MUTATION_388134#29558, N_PATIENT_ETABL_388132#29241 AS BIOLOGIE_PATIEN_388130_N_PATIENT_ETABL_388132#29559, N_SEJOUR_388133#29242 AS BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#29560, STATUT_388142#29243 AS BIOLOGIE_PATIEN_388130_STATUT_388142#29561, UNITE_388139#29244 AS BIOLOGIE_PATIEN_388130_UNITE_388139#29562, VALEUR_388138#29245 AS BIOLOGIE_PATIEN_388130_VALEUR_388138#29563, VALEUR_REF_MAX_388141#29246 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#29564, VALEUR_REF_MIN_388140#29247 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#29565]
(51) Join
Arguments: Inner, (COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29532 = BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#29560)
(52) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29524, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29525, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29526, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29527, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29528, COL_0B71585C_6332_4738_A790_07EC5BC1F173#29529, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29530, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29531, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29532, BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#29555 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29620, BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#29554 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#29621, BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#29556 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#29622, BIOLOGIE_PATIEN_388130_VALEUR_388138#29563 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#29623, BIOLOGIE_PATIEN_388130_UNITE_388139#29562 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#29624, BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#29565 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#29625, BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#29564 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#29626, BIOLOGIE_PATIEN_388130_STATUT_388142#29561 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#29627]
(53) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29524, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29525, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29526, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29527, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29528, COL_0B71585C_6332_4738_A790_07EC5BC1F173#29529, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29530, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29531, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29532, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29620, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#29621, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#29622, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#29623, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#29624, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#29625, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#29626, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#29627, date_diff(cast(MINUTE as string), COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29620, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29527) AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#29645L]
(54) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29524, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29525, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29526, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29527, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29528, COL_0B71585C_6332_4738_A790_07EC5BC1F173#29529, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29530, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29531, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29532, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29620, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#29621, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#29622, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#29623, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#29624, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#29625, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#29626, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#29627, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#29645L, date_diff(cast(MINUTE as string), COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29528, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29620) AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#29664L]
(55) Filter
Arguments: (CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29531, cast(SIMON as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29531, cast(SIMON as string)) END OR CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29531, cast(DUPONT as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29531, cast(DUPONT as string)) END)
(56) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29524 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29684, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29525 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29685, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29526 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29686, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29527 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29687, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29528 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29688, COL_0B71585C_6332_4738_A790_07EC5BC1F173#29529 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#29689, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29530 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29690, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29531 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29691, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29532 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29692, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29620 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29693, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#29621 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#29694, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#29622 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#29695, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#29623 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#29696, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#29624 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#29697, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#29625 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#29698, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#29626 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#29699, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#29627 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#29700, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#29645L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#29701L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#29664L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#29702L]
(57) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29684 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29722, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29685 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29723, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29686 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29724, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29687 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29725, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29688 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29726, COL_0B71585C_6332_4738_A790_07EC5BC1F173#29689 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#29727, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29690 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29728, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29691 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29729, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29692 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29730, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29693 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29731, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#29694 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#29732, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#29695 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#29733, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#29696 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#29734, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#29697 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#29735, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#29698 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#29736, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#29699 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#29737, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#29700 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#29738, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#29701L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#29739L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#29702L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#29740L]
(58) Aggregate
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29722, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29723, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29724, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29725, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29726, COL_0B71585C_6332_4738_A790_07EC5BC1F173#29727, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29728, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29729, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29730, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29731, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#29732, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#29733, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#29734, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#29735, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#29736, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#29737, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#29738, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#29739L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#29740L], [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#29722 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#29760, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#29723 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#29761, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#29724 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#29762, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#29725 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#29763, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#29726 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#29764, COL_0B71585C_6332_4738_A790_07EC5BC1F173#29727 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#29765, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#29728 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#29766, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#29729 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#29767, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#29730 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#29768, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#29731 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#29769, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#29732 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#29770, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#29733 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#29771, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#29734 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#29772, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#29735 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#29773, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#29736 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#29774, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#29737 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#29775, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#29738 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#29776, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#29739L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#29777L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#29740L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#29778L, 1 AS NULL_1#29798]
(59) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#29760, COL_53BB3EE9_8890_4C91_B227_683FABF95657#29761, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#29762, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#29763, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#29764, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#29765, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#29766, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#29767, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#29768, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#29769, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#29770, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#29771, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#29772, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#29773, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#29774, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#29775, COL_155D490C_35A1_496B_88D3_425E93ED3101#29776, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#29777L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#29778L]
(60) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#29760 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#29838, COL_53BB3EE9_8890_4C91_B227_683FABF95657#29761 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#29839, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#29762 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#29840, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#29763 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#29841, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#29764 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#29842, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#29765 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#29843, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#29766 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#29844, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#29767 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#29845, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#29768 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#29846, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#29769 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#29847, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#29770 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#29848, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#29771 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#29849, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#29772 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#29850, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#29773 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#29851, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#29774 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#29852, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#29775 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#29853, COL_155D490C_35A1_496B_88D3_425E93ED3101#29776 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#29854, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#29777L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#29855L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#29778L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#29856L]