== 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_388165181`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#23694, Nom_Usage#23695, Nom_Naissance#23696, Prenom#23697, Sexe#23698, Date_Naissance#23699, N_Identification_National#23700, N_Securite_Social#23701], false
(4) Project
Arguments: [N_Patient_Etablissement#23694 AS N_Patient_Etablissement#23718, Nom_Usage#23695 AS Nom_Usage#23719, Nom_Naissance#23696 AS Nom_Naissance#23720, Prenom#23697 AS Prenom#23721, Sexe#23698 AS Sexe#23722, Date_Naissance#23699 AS Date_Naissance#23723, N_Identification_National#23700 AS N_Identification_National#23724, N_Securite_Social#23701 AS N_Securite_Social#23725]
(5) Project
Arguments: [N_Patient_Etablissement#23718, Nom_Usage#23719, Nom_Naissance#23720, Prenom#23721, Sexe#23722, Date_Naissance#23723, N_Identification_National#23724, N_Securite_Social#23725]
(6) Project
Arguments: [Date_Naissance#23723 AS DATE_NAISSANCE_388125#23743, Nom_Naissance#23720 AS NOM_NAISSANCE_388122#23744, Nom_Usage#23719 AS NOM_USAGE_388121#23745, N_Identification_National#23724 AS N_IDENTIFICATIO_388126#23746, N_Patient_Etablissement#23718 AS N_PATIENT_ETABL_388120#23747, N_Securite_Social#23725 AS N_SECURITE_SOCI_388127#23748, Prenom#23721 AS PRENOM_388123#23749, Sexe#23722 AS SEXE_388124#23750]
(7) LogicalRelation
Arguments: parquet, [IPP#23759, Nom_Usage#23760, Nom_Naissance#23761, Prenom#23762, Sexe-Pat#23763, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767], false
(8) Project
Arguments: [IPP#23759 AS IPP#23777, Nom_Usage#23760, Nom_Naissance#23761, Prenom#23762, Sexe-Pat#23763, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(9) Project
Arguments: [IPP#23777, Nom_Usage#23760 AS Nom_Usage#23788, Nom_Naissance#23761, Prenom#23762, Sexe-Pat#23763, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(10) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23761 AS Nom_Naissance#23798, Prenom#23762, Sexe-Pat#23763, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(11) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23762 AS Prenom#23808, Sexe-Pat#23763, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(12) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23808, Sexe-Pat#23763 AS Sexe-Pat#23818, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(13) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23808, Sexe-Pat#23818, Date_Naissance#23764 AS Date_Naissance#23828, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(14) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23808, Sexe-Pat#23818, Date_Naissance#23828, N_Identification_National#23765 AS N_Identification_National#23838, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(15) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23808, Sexe-Pat#23818, Date_Naissance#23828, N_Identification_National#23838, N_Secu#23766 AS N_Secu#23848, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(16) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23808, Sexe-Pat#23818, Date_Naissance#23828, N_Identification_National#23838, N_Secu#23848, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23858]
(17) Project
Arguments: [IPP#23777 AS IPP#23868, Nom_Usage#23788 AS Nom_Usage#23869, Nom_Naissance#23798 AS Nom_Naissance#23870, Prenom#23808 AS Prenom#23871, Sexe-Pat#23818 AS Sexe-Pat#23872, Date_Naissance#23828 AS Date_Naissance#23873, N_Identification_National#23838 AS N_Identification_National#23874, N_Secu#23848 AS N_Secu#23875, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23858 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23876]
(18) Project
Arguments: [IPP#23868, Nom_Usage#23869, Nom_Naissance#23870, Prenom#23871, Sexe-Pat#23872, Date_Naissance#23873, N_Identification_National#23874, N_Secu#23875, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23876]
(19) Project
Arguments: [Date_Naissance#23873 AS DATE_NAISSANCE_388125#23895, Nom_Naissance#23870 AS NOM_NAISSANCE_388122#23896, Nom_Usage#23869 AS NOM_USAGE_388121#23897, N_Identification_National#23874 AS N_IDENTIFICATIO_388126#23898, IPP#23868 AS N_PATIENT_ETABL_388120#23899, N_Secu#23875 AS N_SECURITE_SOCI_388127#23900, Prenom#23871 AS PRENOM_388123#23901, cast(str_replace_extend(Sexe-Pat#23872, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#23903]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#23743, NOM_NAISSANCE_388122#23744, NOM_USAGE_388121#23745, N_IDENTIFICATIO_388126#23746, N_PATIENT_ETABL_388120#23747, N_SECURITE_SOCI_388127#23748, PRENOM_388123#23749, SEXE_388124#23750, str_encrypt(N_PATIENT_ETABL_388120#23747) AS ID_PATIENT_388128#23920, str_encrypt(N_PATIENT_ETABL_388120#23747) AS ID_PATIENT_BIS_388129#23921]
(22) View
Arguments: `LES_PATIENTS_388119181`, true
(23) SubqueryAlias
Arguments: LES_PATIENTS_388119181
(24) Project
Arguments: [DATE_NAISSANCE_388125#23743 AS LES_PATIENTS_388119_DATE_NAISSANCE_388125#24190, NOM_NAISSANCE_388122#23744 AS LES_PATIENTS_388119_NOM_NAISSANCE_388122#24191, NOM_USAGE_388121#23745 AS LES_PATIENTS_388119_NOM_USAGE_388121#24192, N_IDENTIFICATIO_388126#23746 AS LES_PATIENTS_388119_N_IDENTIFICATIO_388126#24193, N_PATIENT_ETABL_388120#23747 AS LES_PATIENTS_388119_N_PATIENT_ETABL_388120#24194, N_SECURITE_SOCI_388127#23748 AS LES_PATIENTS_388119_N_SECURITE_SOCI_388127#24195, PRENOM_388123#23749 AS LES_PATIENTS_388119_PRENOM_388123#24196, SEXE_388124#23750 AS LES_PATIENTS_388119_SEXE_388124#24197, ID_PATIENT_388128#23920 AS LES_PATIENTS_388119_ID_PATIENT_388128#24198, ID_PATIENT_BIS_388129#23921 AS LES_PATIENTS_388119_ID_PATIENT_BIS_388129#24199]
(25) Project
Arguments: [cast(LES_PATIENTS_388119_SEXE_388124#24197 as string) AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24213, cast(LES_PATIENTS_388119_DATE_NAISSANCE_388125#24190 as string) AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24214, cast(LES_PATIENTS_388119_ID_PATIENT_388128#24198 as string) AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24215]
(26) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24213 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24219, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24214 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24220, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24215 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24221]
(27) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#24069, N_Sejour#24070, Date_Debut_Sejour#24071, Date_Fin_Sejour#24072, Code_Unite_Medicale#24073, Libelle_Unite_Medicale#24074, Medecin_Responsable#24075], false
(28) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#24107, N_Sejour#24108, Date_Debut_Sejour#24109, Date_Fin_Sejour#24110, Code_Unite_Medicale#24111, Libelle_Unite_Medicale#24112, Medecin_Responsable#24113], false
(29) Project
Arguments: [N_Patient_Etablissement#24107, N_Sejour#24108, Date_Debut_Sejour#24109, Date_Fin_Sejour#24110, Code_Unite_Medicale#24111, Libelle_Unite_Medicale#24112, Medecin_Responsable#24113]
(30) Union
Arguments: false, false
(31) Project
Arguments: [N_Patient_Etablissement#24069 AS N_Patient_Etablissement#24136, N_Sejour#24070 AS N_Sejour#24137, Date_Debut_Sejour#24071 AS Date_Debut_Sejour#24138, Date_Fin_Sejour#24072 AS Date_Fin_Sejour#24139, Code_Unite_Medicale#24073 AS Code_Unite_Medicale#24140, Libelle_Unite_Medicale#24074 AS Libelle_Unite_Medicale#24141, Medecin_Responsable#24075 AS Medecin_Responsable#24142]
(32) Project
Arguments: [N_Patient_Etablissement#24136, N_Sejour#24137, Date_Debut_Sejour#24138, Date_Fin_Sejour#24139, Code_Unite_Medicale#24140, Libelle_Unite_Medicale#24141, Medecin_Responsable#24142]
(33) Project
Arguments: [Code_Unite_Medicale#24140 AS CODE_UNITE_MEDI_388065#24157, cast(Date_Debut_Sejour#24138 as timestamp) AS DATE_DEBUT_SEJO_388063#24158, cast(Date_Fin_Sejour#24139 as timestamp) AS DATE_FIN_SEJOUR_388064#24159, Libelle_Unite_Medicale#24141 AS LIBELLE_UNITE_M_388066#24160, Medecin_Responsable#24142 AS MEDECIN_RESPONS_388067#24161, N_Patient_Etablissement#24136 AS N_PATIENT_ETABL_388061#24162, N_Sejour#24137 AS N_SEJOUR_388062#24163]
(34) Project
Arguments: [CODE_UNITE_MEDI_388065#24157, DATE_DEBUT_SEJO_388063#24158, DATE_FIN_SEJOUR_388064#24159, LIBELLE_UNITE_M_388066#24160, MEDECIN_RESPONS_388067#24161, N_PATIENT_ETABL_388061#24162, N_SEJOUR_388062#24163, str_encrypt(N_PATIENT_ETABL_388061#24162) AS ID_PATIENT_388068#24171]
(35) View
Arguments: `LES_SEJOURS_388060181`, true
(36) SubqueryAlias
Arguments: LES_SEJOURS_388060181
(37) Project
Arguments: [CODE_UNITE_MEDI_388065#24157 AS LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#24233, DATE_DEBUT_SEJO_388063#24158 AS LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#24234, DATE_FIN_SEJOUR_388064#24159 AS LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#24235, LIBELLE_UNITE_M_388066#24160 AS LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#24236, MEDECIN_RESPONS_388067#24161 AS LES_SEJOURS_388060_MEDECIN_RESPONS_388067#24237, N_PATIENT_ETABL_388061#24162 AS LES_SEJOURS_388060_N_PATIENT_ETABL_388061#24238, N_SEJOUR_388062#24163 AS LES_SEJOURS_388060_N_SEJOUR_388062#24239, ID_PATIENT_388068#24171 AS LES_SEJOURS_388060_ID_PATIENT_388068#24240]
(38) Join
Arguments: LeftOuter, (COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24221 = LES_SEJOURS_388060_ID_PATIENT_388068#24240)
(39) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24219, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24220, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24221, LES_SEJOURS_388060_N_SEJOUR_388062#24239 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24271, LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#24234 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24272, LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#24235 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24273, LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#24233 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#24274, LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#24236 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24275, LES_SEJOURS_388060_MEDECIN_RESPONS_388067#24237 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24276]
(40) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24219 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24286, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24220 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24287, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24221 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24288, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24272 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24289, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24273 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24290, COL_0B71585C_6332_4738_A790_07EC5BC1F173#24274 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#24291, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24275 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24292, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24276 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24293, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24271 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24294]
(41) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24286 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24304, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24287 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24305, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24288 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24306, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24289 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24307, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24290 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24308, COL_0B71585C_6332_4738_A790_07EC5BC1F173#24291 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#24309, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24292 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24310, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24293 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24311, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24294 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24312]
(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#23932, N_Patient_Etablissement#23933, N_Sejour#23934, N_Mutation#23935, Date_Prelevement#23936, Code_Analyse#23937, Libelle_Analyse#23938, Valeur#23939, Unite#23940, Valeur_Ref_Min#23941, Valeur_Ref_Max#23942, Statut#23943], false
(43) Project
Arguments: [N_Examen#23932 AS COLL0#23956, N_Patient_Etablissement#23933 AS COLL1#23957, N_Sejour#23934 AS COLL2#23958, N_Mutation#23935 AS COLL3#23959, Date_Prelevement#23936 AS COLL4#23960, Code_Analyse#23937 AS COLL5#23961, Libelle_Analyse#23938 AS COLL6#23962, Valeur#23939 AS COLL7#23963, Unite#23940 AS COLL8#23964, Valeur_Ref_Min#23941 AS COLL9#23965, Valeur_Ref_Max#23942 AS COLL10#23966, Statut#23943 AS COLL11#23967]
(44) Project
Arguments: [COLL0#23956 AS COLL0#23980, COLL1#23957 AS COLL1#23981, COLL2#23958 AS COLL2#23982, COLL3#23959 AS COLL3#23983, COLL4#23960 AS COLL4#23984, COLL5#23961 AS COLL5#23985, COLL6#23962 AS COLL6#23986, COLL7#23963 AS COLL7#23987, COLL8#23964 AS COLL8#23988, COLL9#23965 AS COLL9#23989, COLL10#23966 AS COLL10#23990, COLL11#23967 AS COLL11#23991]
(45) Project
Arguments: [COLL0#23980, COLL1#23981, COLL2#23982, COLL3#23983, COLL4#23984, COLL5#23985, COLL6#23986, COLL7#23987, COLL8#23988, COLL9#23989, COLL10#23990, COLL11#23991]
(46) Project
Arguments: [COLL5#23985 AS CODE_ANALYSE_388136#24016, COLL4#23984 AS DATE_PRELEVEMEN_388135#24017, COLL6#23986 AS LIBELLE_ANALYSE_388137#24018, COLL0#23980 AS N_EXAMEN_388131#24019, COLL3#23983 AS N_MUTATION_388134#24020, COLL1#23981 AS N_PATIENT_ETABL_388132#24021, COLL2#23982 AS N_SEJOUR_388133#24022, COLL11#23991 AS STATUT_388142#24023, COLL8#23988 AS UNITE_388139#24024, COLL7#23987 AS VALEUR_388138#24025, COLL10#23990 AS VALEUR_REF_MAX_388141#24026, COLL9#23989 AS VALEUR_REF_MIN_388140#24027]
(47) Project
Arguments: [CODE_ANALYSE_388136#24016, DATE_PRELEVEMEN_388135#24017, LIBELLE_ANALYSE_388137#24018, N_EXAMEN_388131#24019, N_MUTATION_388134#24020, N_PATIENT_ETABL_388132#24021, N_SEJOUR_388133#24022, STATUT_388142#24023, UNITE_388139#24024, VALEUR_388138#24025, VALEUR_REF_MAX_388141#24026, VALEUR_REF_MIN_388140#24027]
(48) View
Arguments: `BIOLOGIE_PATIEN_388130181`, true
(49) SubqueryAlias
Arguments: BIOLOGIE_PATIEN_388130181
(50) Project
Arguments: [CODE_ANALYSE_388136#24016 AS BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#24334, DATE_PRELEVEMEN_388135#24017 AS BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#24335, LIBELLE_ANALYSE_388137#24018 AS BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#24336, N_EXAMEN_388131#24019 AS BIOLOGIE_PATIEN_388130_N_EXAMEN_388131#24337, N_MUTATION_388134#24020 AS BIOLOGIE_PATIEN_388130_N_MUTATION_388134#24338, N_PATIENT_ETABL_388132#24021 AS BIOLOGIE_PATIEN_388130_N_PATIENT_ETABL_388132#24339, N_SEJOUR_388133#24022 AS BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#24340, STATUT_388142#24023 AS BIOLOGIE_PATIEN_388130_STATUT_388142#24341, UNITE_388139#24024 AS BIOLOGIE_PATIEN_388130_UNITE_388139#24342, VALEUR_388138#24025 AS BIOLOGIE_PATIEN_388130_VALEUR_388138#24343, VALEUR_REF_MAX_388141#24026 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#24344, VALEUR_REF_MIN_388140#24027 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#24345]
(51) Join
Arguments: Inner, (COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24312 = BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#24340)
(52) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24304, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24305, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24306, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24307, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24308, COL_0B71585C_6332_4738_A790_07EC5BC1F173#24309, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24310, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24311, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24312, BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#24335 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24400, BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#24334 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#24401, BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#24336 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#24402, BIOLOGIE_PATIEN_388130_VALEUR_388138#24343 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#24403, BIOLOGIE_PATIEN_388130_UNITE_388139#24342 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#24404, BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#24345 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#24405, BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#24344 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#24406, BIOLOGIE_PATIEN_388130_STATUT_388142#24341 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#24407]
(53) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24304, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24305, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24306, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24307, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24308, COL_0B71585C_6332_4738_A790_07EC5BC1F173#24309, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24310, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24311, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24312, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24400, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#24401, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#24402, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#24403, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#24404, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#24405, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#24406, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#24407, date_diff(cast(MINUTE as string), COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24400, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24307) AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#24425L]
(54) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24304, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24305, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24306, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24307, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24308, COL_0B71585C_6332_4738_A790_07EC5BC1F173#24309, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24310, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24311, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24312, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24400, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#24401, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#24402, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#24403, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#24404, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#24405, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#24406, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#24407, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#24425L, date_diff(cast(MINUTE as string), COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24308, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24400) AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#24444L]
(55) Filter
Arguments: (CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24311, cast(SIMON as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24311, cast(SIMON as string)) END OR CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24311, cast(DUPONT as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24311, cast(DUPONT as string)) END)
(56) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24304 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24464, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24305 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24465, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24306 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24466, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24307 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24467, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24308 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24468, COL_0B71585C_6332_4738_A790_07EC5BC1F173#24309 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#24469, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24310 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24470, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24311 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24471, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24312 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24472, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24400 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24473, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#24401 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#24474, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#24402 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#24475, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#24403 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#24476, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#24404 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#24477, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#24405 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#24478, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#24406 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#24479, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#24407 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#24480, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#24425L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#24481L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#24444L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#24482L]
(57) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24464 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24502, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24465 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24503, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24466 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24504, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24467 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24505, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24468 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24506, COL_0B71585C_6332_4738_A790_07EC5BC1F173#24469 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#24507, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24470 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24508, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24471 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24509, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24472 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24510, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24473 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24511, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#24474 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#24512, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#24475 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#24513, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#24476 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#24514, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#24477 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#24515, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#24478 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#24516, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#24479 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#24517, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#24480 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#24518, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#24481L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#24519L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#24482L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#24520L]
(58) Aggregate
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24502, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24503, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24504, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24505, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24506, COL_0B71585C_6332_4738_A790_07EC5BC1F173#24507, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24508, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24509, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24510, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24511, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#24512, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#24513, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#24514, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#24515, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#24516, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#24517, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#24518, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#24519L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#24520L], [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#24502 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#24540, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#24503 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#24541, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#24504 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#24542, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#24505 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#24543, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#24506 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#24544, COL_0B71585C_6332_4738_A790_07EC5BC1F173#24507 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#24545, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#24508 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#24546, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#24509 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#24547, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#24510 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#24548, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#24511 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#24549, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#24512 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#24550, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#24513 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#24551, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#24514 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#24552, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#24515 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#24553, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#24516 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#24554, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#24517 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#24555, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#24518 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#24556, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#24519L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#24557L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#24520L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#24558L, 1 AS NULL_1#24578]
(59) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#24540, COL_53BB3EE9_8890_4C91_B227_683FABF95657#24541, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#24542, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#24543, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#24544, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#24545, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#24546, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#24547, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#24548, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#24549, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#24550, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#24551, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#24552, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#24553, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#24554, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#24555, COL_155D490C_35A1_496B_88D3_425E93ED3101#24556, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#24557L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#24558L]
(60) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#24540 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#24618, COL_53BB3EE9_8890_4C91_B227_683FABF95657#24541 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#24619, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#24542 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#24620, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#24543 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#24621, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#24544 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#24622, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#24545 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#24623, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#24546 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#24624, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#24547 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#24625, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#24548 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#24626, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#24549 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#24627, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#24550 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#24628, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#24551 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#24629, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#24552 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#24630, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#24553 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#24631, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#24554 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#24632, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#24555 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#24633, COL_155D490C_35A1_496B_88D3_425E93ED3101#24556 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#24634, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#24557L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#24635L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#24558L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#24636L]