== 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_388165180`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#11200, Nom_Usage#11201, Nom_Naissance#11202, Prenom#11203, Sexe#11204, Date_Naissance#11205, N_Identification_National#11206, N_Securite_Social#11207], false
(4) Project
Arguments: [N_Patient_Etablissement#11200 AS N_Patient_Etablissement#11224, Nom_Usage#11201 AS Nom_Usage#11225, Nom_Naissance#11202 AS Nom_Naissance#11226, Prenom#11203 AS Prenom#11227, Sexe#11204 AS Sexe#11228, Date_Naissance#11205 AS Date_Naissance#11229, N_Identification_National#11206 AS N_Identification_National#11230, N_Securite_Social#11207 AS N_Securite_Social#11231]
(5) Project
Arguments: [N_Patient_Etablissement#11224, Nom_Usage#11225, Nom_Naissance#11226, Prenom#11227, Sexe#11228, Date_Naissance#11229, N_Identification_National#11230, N_Securite_Social#11231]
(6) Project
Arguments: [Date_Naissance#11229 AS DATE_NAISSANCE_388125#11249, Nom_Naissance#11226 AS NOM_NAISSANCE_388122#11250, Nom_Usage#11225 AS NOM_USAGE_388121#11251, N_Identification_National#11230 AS N_IDENTIFICATIO_388126#11252, N_Patient_Etablissement#11224 AS N_PATIENT_ETABL_388120#11253, N_Securite_Social#11231 AS N_SECURITE_SOCI_388127#11254, Prenom#11227 AS PRENOM_388123#11255, Sexe#11228 AS SEXE_388124#11256]
(7) LogicalRelation
Arguments: parquet, [IPP#11265, Nom_Usage#11266, Nom_Naissance#11267, Prenom#11268, Sexe-Pat#11269, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273], false
(8) Project
Arguments: [IPP#11265 AS IPP#11283, Nom_Usage#11266, Nom_Naissance#11267, Prenom#11268, Sexe-Pat#11269, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(9) Project
Arguments: [IPP#11283, Nom_Usage#11266 AS Nom_Usage#11294, Nom_Naissance#11267, Prenom#11268, Sexe-Pat#11269, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(10) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11267 AS Nom_Naissance#11304, Prenom#11268, Sexe-Pat#11269, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(11) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11268 AS Prenom#11314, Sexe-Pat#11269, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(12) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11314, Sexe-Pat#11269 AS Sexe-Pat#11324, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(13) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11314, Sexe-Pat#11324, Date_Naissance#11270 AS Date_Naissance#11334, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(14) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11314, Sexe-Pat#11324, Date_Naissance#11334, N_Identification_National#11271 AS N_Identification_National#11344, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(15) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11314, Sexe-Pat#11324, Date_Naissance#11334, N_Identification_National#11344, N_Secu#11272 AS N_Secu#11354, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(16) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11314, Sexe-Pat#11324, Date_Naissance#11334, N_Identification_National#11344, N_Secu#11354, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11364]
(17) Project
Arguments: [IPP#11283 AS IPP#11374, Nom_Usage#11294 AS Nom_Usage#11375, Nom_Naissance#11304 AS Nom_Naissance#11376, Prenom#11314 AS Prenom#11377, Sexe-Pat#11324 AS Sexe-Pat#11378, Date_Naissance#11334 AS Date_Naissance#11379, N_Identification_National#11344 AS N_Identification_National#11380, N_Secu#11354 AS N_Secu#11381, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11364 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11382]
(18) Project
Arguments: [IPP#11374, Nom_Usage#11375, Nom_Naissance#11376, Prenom#11377, Sexe-Pat#11378, Date_Naissance#11379, N_Identification_National#11380, N_Secu#11381, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11382]
(19) Project
Arguments: [Date_Naissance#11379 AS DATE_NAISSANCE_388125#11401, Nom_Naissance#11376 AS NOM_NAISSANCE_388122#11402, Nom_Usage#11375 AS NOM_USAGE_388121#11403, N_Identification_National#11380 AS N_IDENTIFICATIO_388126#11404, IPP#11374 AS N_PATIENT_ETABL_388120#11405, N_Secu#11381 AS N_SECURITE_SOCI_388127#11406, Prenom#11377 AS PRENOM_388123#11407, cast(str_replace_extend(Sexe-Pat#11378, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#11409]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#11249, NOM_NAISSANCE_388122#11250, NOM_USAGE_388121#11251, N_IDENTIFICATIO_388126#11252, N_PATIENT_ETABL_388120#11253, N_SECURITE_SOCI_388127#11254, PRENOM_388123#11255, SEXE_388124#11256, str_encrypt(N_PATIENT_ETABL_388120#11253) AS ID_PATIENT_388128#11426, str_encrypt(N_PATIENT_ETABL_388120#11253) AS ID_PATIENT_BIS_388129#11427]
(22) View
Arguments: `LES_PATIENTS_388119180`, true
(23) SubqueryAlias
Arguments: LES_PATIENTS_388119180
(24) Project
Arguments: [DATE_NAISSANCE_388125#11249 AS LES_PATIENTS_388119_DATE_NAISSANCE_388125#11696, NOM_NAISSANCE_388122#11250 AS LES_PATIENTS_388119_NOM_NAISSANCE_388122#11697, NOM_USAGE_388121#11251 AS LES_PATIENTS_388119_NOM_USAGE_388121#11698, N_IDENTIFICATIO_388126#11252 AS LES_PATIENTS_388119_N_IDENTIFICATIO_388126#11699, N_PATIENT_ETABL_388120#11253 AS LES_PATIENTS_388119_N_PATIENT_ETABL_388120#11700, N_SECURITE_SOCI_388127#11254 AS LES_PATIENTS_388119_N_SECURITE_SOCI_388127#11701, PRENOM_388123#11255 AS LES_PATIENTS_388119_PRENOM_388123#11702, SEXE_388124#11256 AS LES_PATIENTS_388119_SEXE_388124#11703, ID_PATIENT_388128#11426 AS LES_PATIENTS_388119_ID_PATIENT_388128#11704, ID_PATIENT_BIS_388129#11427 AS LES_PATIENTS_388119_ID_PATIENT_BIS_388129#11705]
(25) Project
Arguments: [cast(LES_PATIENTS_388119_SEXE_388124#11703 as string) AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11719, cast(LES_PATIENTS_388119_DATE_NAISSANCE_388125#11696 as string) AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11720, cast(LES_PATIENTS_388119_ID_PATIENT_388128#11704 as string) AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11721]
(26) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11719 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11725, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11720 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11726, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11721 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11727]
(27) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#11575, N_Sejour#11576, Date_Debut_Sejour#11577, Date_Fin_Sejour#11578, Code_Unite_Medicale#11579, Libelle_Unite_Medicale#11580, Medecin_Responsable#11581], false
(28) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#11613, N_Sejour#11614, Date_Debut_Sejour#11615, Date_Fin_Sejour#11616, Code_Unite_Medicale#11617, Libelle_Unite_Medicale#11618, Medecin_Responsable#11619], false
(29) Project
Arguments: [N_Patient_Etablissement#11613, N_Sejour#11614, Date_Debut_Sejour#11615, Date_Fin_Sejour#11616, Code_Unite_Medicale#11617, Libelle_Unite_Medicale#11618, Medecin_Responsable#11619]
(30) Union
Arguments: false, false
(31) Project
Arguments: [N_Patient_Etablissement#11575 AS N_Patient_Etablissement#11642, N_Sejour#11576 AS N_Sejour#11643, Date_Debut_Sejour#11577 AS Date_Debut_Sejour#11644, Date_Fin_Sejour#11578 AS Date_Fin_Sejour#11645, Code_Unite_Medicale#11579 AS Code_Unite_Medicale#11646, Libelle_Unite_Medicale#11580 AS Libelle_Unite_Medicale#11647, Medecin_Responsable#11581 AS Medecin_Responsable#11648]
(32) Project
Arguments: [N_Patient_Etablissement#11642, N_Sejour#11643, Date_Debut_Sejour#11644, Date_Fin_Sejour#11645, Code_Unite_Medicale#11646, Libelle_Unite_Medicale#11647, Medecin_Responsable#11648]
(33) Project
Arguments: [Code_Unite_Medicale#11646 AS CODE_UNITE_MEDI_388065#11663, cast(Date_Debut_Sejour#11644 as timestamp) AS DATE_DEBUT_SEJO_388063#11664, cast(Date_Fin_Sejour#11645 as timestamp) AS DATE_FIN_SEJOUR_388064#11665, Libelle_Unite_Medicale#11647 AS LIBELLE_UNITE_M_388066#11666, Medecin_Responsable#11648 AS MEDECIN_RESPONS_388067#11667, N_Patient_Etablissement#11642 AS N_PATIENT_ETABL_388061#11668, N_Sejour#11643 AS N_SEJOUR_388062#11669]
(34) Project
Arguments: [CODE_UNITE_MEDI_388065#11663, DATE_DEBUT_SEJO_388063#11664, DATE_FIN_SEJOUR_388064#11665, LIBELLE_UNITE_M_388066#11666, MEDECIN_RESPONS_388067#11667, N_PATIENT_ETABL_388061#11668, N_SEJOUR_388062#11669, str_encrypt(N_PATIENT_ETABL_388061#11668) AS ID_PATIENT_388068#11677]
(35) View
Arguments: `LES_SEJOURS_388060180`, true
(36) SubqueryAlias
Arguments: LES_SEJOURS_388060180
(37) Project
Arguments: [CODE_UNITE_MEDI_388065#11663 AS LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#11739, DATE_DEBUT_SEJO_388063#11664 AS LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#11740, DATE_FIN_SEJOUR_388064#11665 AS LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#11741, LIBELLE_UNITE_M_388066#11666 AS LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#11742, MEDECIN_RESPONS_388067#11667 AS LES_SEJOURS_388060_MEDECIN_RESPONS_388067#11743, N_PATIENT_ETABL_388061#11668 AS LES_SEJOURS_388060_N_PATIENT_ETABL_388061#11744, N_SEJOUR_388062#11669 AS LES_SEJOURS_388060_N_SEJOUR_388062#11745, ID_PATIENT_388068#11677 AS LES_SEJOURS_388060_ID_PATIENT_388068#11746]
(38) Join
Arguments: LeftOuter, (COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11727 = LES_SEJOURS_388060_ID_PATIENT_388068#11746)
(39) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11725, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11726, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11727, LES_SEJOURS_388060_N_SEJOUR_388062#11745 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11777, LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#11740 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11778, LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#11741 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11779, LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#11739 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#11780, LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#11742 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11781, LES_SEJOURS_388060_MEDECIN_RESPONS_388067#11743 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11782]
(40) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11725 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11792, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11726 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11793, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11727 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11794, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11778 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11795, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11779 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11796, COL_0B71585C_6332_4738_A790_07EC5BC1F173#11780 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#11797, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11781 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11798, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11782 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11799, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11777 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11800]
(41) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11792 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11810, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11793 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11811, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11794 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11812, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11795 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11813, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11796 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11814, COL_0B71585C_6332_4738_A790_07EC5BC1F173#11797 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#11815, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11798 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11816, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11799 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11817, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11800 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11818]
(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#11438, N_Patient_Etablissement#11439, N_Sejour#11440, N_Mutation#11441, Date_Prelevement#11442, Code_Analyse#11443, Libelle_Analyse#11444, Valeur#11445, Unite#11446, Valeur_Ref_Min#11447, Valeur_Ref_Max#11448, Statut#11449], false
(43) Project
Arguments: [N_Examen#11438 AS COLL0#11462, N_Patient_Etablissement#11439 AS COLL1#11463, N_Sejour#11440 AS COLL2#11464, N_Mutation#11441 AS COLL3#11465, Date_Prelevement#11442 AS COLL4#11466, Code_Analyse#11443 AS COLL5#11467, Libelle_Analyse#11444 AS COLL6#11468, Valeur#11445 AS COLL7#11469, Unite#11446 AS COLL8#11470, Valeur_Ref_Min#11447 AS COLL9#11471, Valeur_Ref_Max#11448 AS COLL10#11472, Statut#11449 AS COLL11#11473]
(44) Project
Arguments: [COLL0#11462 AS COLL0#11486, COLL1#11463 AS COLL1#11487, COLL2#11464 AS COLL2#11488, COLL3#11465 AS COLL3#11489, COLL4#11466 AS COLL4#11490, COLL5#11467 AS COLL5#11491, COLL6#11468 AS COLL6#11492, COLL7#11469 AS COLL7#11493, COLL8#11470 AS COLL8#11494, COLL9#11471 AS COLL9#11495, COLL10#11472 AS COLL10#11496, COLL11#11473 AS COLL11#11497]
(45) Project
Arguments: [COLL0#11486, COLL1#11487, COLL2#11488, COLL3#11489, COLL4#11490, COLL5#11491, COLL6#11492, COLL7#11493, COLL8#11494, COLL9#11495, COLL10#11496, COLL11#11497]
(46) Project
Arguments: [COLL5#11491 AS CODE_ANALYSE_388136#11522, COLL4#11490 AS DATE_PRELEVEMEN_388135#11523, COLL6#11492 AS LIBELLE_ANALYSE_388137#11524, COLL0#11486 AS N_EXAMEN_388131#11525, COLL3#11489 AS N_MUTATION_388134#11526, COLL1#11487 AS N_PATIENT_ETABL_388132#11527, COLL2#11488 AS N_SEJOUR_388133#11528, COLL11#11497 AS STATUT_388142#11529, COLL8#11494 AS UNITE_388139#11530, COLL7#11493 AS VALEUR_388138#11531, COLL10#11496 AS VALEUR_REF_MAX_388141#11532, COLL9#11495 AS VALEUR_REF_MIN_388140#11533]
(47) Project
Arguments: [CODE_ANALYSE_388136#11522, DATE_PRELEVEMEN_388135#11523, LIBELLE_ANALYSE_388137#11524, N_EXAMEN_388131#11525, N_MUTATION_388134#11526, N_PATIENT_ETABL_388132#11527, N_SEJOUR_388133#11528, STATUT_388142#11529, UNITE_388139#11530, VALEUR_388138#11531, VALEUR_REF_MAX_388141#11532, VALEUR_REF_MIN_388140#11533]
(48) View
Arguments: `BIOLOGIE_PATIEN_388130180`, true
(49) SubqueryAlias
Arguments: BIOLOGIE_PATIEN_388130180
(50) Project
Arguments: [CODE_ANALYSE_388136#11522 AS BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#11840, DATE_PRELEVEMEN_388135#11523 AS BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#11841, LIBELLE_ANALYSE_388137#11524 AS BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#11842, N_EXAMEN_388131#11525 AS BIOLOGIE_PATIEN_388130_N_EXAMEN_388131#11843, N_MUTATION_388134#11526 AS BIOLOGIE_PATIEN_388130_N_MUTATION_388134#11844, N_PATIENT_ETABL_388132#11527 AS BIOLOGIE_PATIEN_388130_N_PATIENT_ETABL_388132#11845, N_SEJOUR_388133#11528 AS BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#11846, STATUT_388142#11529 AS BIOLOGIE_PATIEN_388130_STATUT_388142#11847, UNITE_388139#11530 AS BIOLOGIE_PATIEN_388130_UNITE_388139#11848, VALEUR_388138#11531 AS BIOLOGIE_PATIEN_388130_VALEUR_388138#11849, VALEUR_REF_MAX_388141#11532 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#11850, VALEUR_REF_MIN_388140#11533 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#11851]
(51) Join
Arguments: Inner, (COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11818 = BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#11846)
(52) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11810, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11811, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11812, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11813, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11814, COL_0B71585C_6332_4738_A790_07EC5BC1F173#11815, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11816, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11817, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11818, BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#11841 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#11906, BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#11840 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#11907, BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#11842 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#11908, BIOLOGIE_PATIEN_388130_VALEUR_388138#11849 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#11909, BIOLOGIE_PATIEN_388130_UNITE_388139#11848 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#11910, BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#11851 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#11911, BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#11850 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#11912, BIOLOGIE_PATIEN_388130_STATUT_388142#11847 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#11913]
(53) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11810, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11811, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11812, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11813, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11814, COL_0B71585C_6332_4738_A790_07EC5BC1F173#11815, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11816, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11817, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11818, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#11906, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#11907, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#11908, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#11909, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#11910, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#11911, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#11912, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#11913, date_diff(cast(MINUTE as string), COL_46FA8E68_4A9B_4128_997C_B17F45599E34#11906, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11813) AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#11931L]
(54) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11810, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11811, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11812, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11813, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11814, COL_0B71585C_6332_4738_A790_07EC5BC1F173#11815, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11816, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11817, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11818, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#11906, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#11907, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#11908, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#11909, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#11910, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#11911, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#11912, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#11913, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#11931L, date_diff(cast(MINUTE as string), COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11814, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#11906) AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#11950L]
(55) Filter
Arguments: (CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11817, cast(SIMON as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11817, cast(SIMON as string)) END OR CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11817, cast(DUPONT as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11817, cast(DUPONT as string)) END)
(56) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11810 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11970, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11811 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11971, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11812 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11972, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11813 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11973, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11814 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11974, COL_0B71585C_6332_4738_A790_07EC5BC1F173#11815 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#11975, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11816 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11976, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11817 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11977, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11818 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11978, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#11906 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#11979, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#11907 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#11980, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#11908 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#11981, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#11909 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#11982, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#11910 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#11983, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#11911 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#11984, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#11912 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#11985, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#11913 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#11986, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#11931L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#11987L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#11950L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#11988L]
(57) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#11970 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#12008, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#11971 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#12009, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#11972 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#12010, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#11973 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#12011, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#11974 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#12012, COL_0B71585C_6332_4738_A790_07EC5BC1F173#11975 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#12013, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#11976 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#12014, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#11977 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#12015, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#11978 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#12016, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#11979 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#12017, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#11980 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#12018, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#11981 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#12019, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#11982 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#12020, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#11983 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#12021, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#11984 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#12022, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#11985 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#12023, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#11986 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#12024, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#11987L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#12025L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#11988L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#12026L]
(58) Aggregate
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#12008, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#12009, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#12010, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#12011, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#12012, COL_0B71585C_6332_4738_A790_07EC5BC1F173#12013, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#12014, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#12015, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#12016, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#12017, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#12018, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#12019, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#12020, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#12021, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#12022, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#12023, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#12024, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#12025L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#12026L], [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#12008 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#12046, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#12009 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#12047, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#12010 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#12048, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#12011 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#12049, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#12012 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#12050, COL_0B71585C_6332_4738_A790_07EC5BC1F173#12013 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#12051, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#12014 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#12052, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#12015 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#12053, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#12016 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#12054, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#12017 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#12055, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#12018 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#12056, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#12019 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#12057, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#12020 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#12058, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#12021 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#12059, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#12022 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#12060, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#12023 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#12061, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#12024 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#12062, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#12025L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#12063L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#12026L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#12064L, 1 AS NULL_1#12084]
(59) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#12046, COL_53BB3EE9_8890_4C91_B227_683FABF95657#12047, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#12048, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#12049, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#12050, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#12051, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#12052, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#12053, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#12054, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#12055, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#12056, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#12057, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#12058, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#12059, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#12060, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#12061, COL_155D490C_35A1_496B_88D3_425E93ED3101#12062, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#12063L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#12064L]
(60) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#12046 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#12124, COL_53BB3EE9_8890_4C91_B227_683FABF95657#12047 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#12125, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#12048 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#12126, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#12049 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#12127, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#12050 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#12128, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#12051 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#12129, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#12052 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#12130, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#12053 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#12131, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#12054 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#12132, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#12055 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#12133, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#12056 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#12134, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#12057 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#12135, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#12058 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#12136, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#12059 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#12137, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#12060 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#12138, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#12061 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#12139, COL_155D490C_35A1_496B_88D3_425E93ED3101#12062 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#12140, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#12063L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#12141L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#12064L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#12142L]