== 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_388165176`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#20040, Nom_Usage#20041, Nom_Naissance#20042, Prenom#20043, Sexe#20044, Date_Naissance#20045, N_Identification_National#20046, N_Securite_Social#20047], false
(4) Project
Arguments: [N_Patient_Etablissement#20040 AS N_Patient_Etablissement#20064, Nom_Usage#20041 AS Nom_Usage#20065, Nom_Naissance#20042 AS Nom_Naissance#20066, Prenom#20043 AS Prenom#20067, Sexe#20044 AS Sexe#20068, Date_Naissance#20045 AS Date_Naissance#20069, N_Identification_National#20046 AS N_Identification_National#20070, N_Securite_Social#20047 AS N_Securite_Social#20071]
(5) Project
Arguments: [N_Patient_Etablissement#20064, Nom_Usage#20065, Nom_Naissance#20066, Prenom#20067, Sexe#20068, Date_Naissance#20069, N_Identification_National#20070, N_Securite_Social#20071]
(6) Project
Arguments: [Date_Naissance#20069 AS DATE_NAISSANCE_388125#20089, Nom_Naissance#20066 AS NOM_NAISSANCE_388122#20090, Nom_Usage#20065 AS NOM_USAGE_388121#20091, N_Identification_National#20070 AS N_IDENTIFICATIO_388126#20092, N_Patient_Etablissement#20064 AS N_PATIENT_ETABL_388120#20093, N_Securite_Social#20071 AS N_SECURITE_SOCI_388127#20094, Prenom#20067 AS PRENOM_388123#20095, Sexe#20068 AS SEXE_388124#20096]
(7) LogicalRelation
Arguments: parquet, [IPP#20105, Nom_Usage#20106, Nom_Naissance#20107, Prenom#20108, Sexe-Pat#20109, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113], false
(8) Project
Arguments: [IPP#20105 AS IPP#20123, Nom_Usage#20106, Nom_Naissance#20107, Prenom#20108, Sexe-Pat#20109, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(9) Project
Arguments: [IPP#20123, Nom_Usage#20106 AS Nom_Usage#20134, Nom_Naissance#20107, Prenom#20108, Sexe-Pat#20109, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(10) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20107 AS Nom_Naissance#20144, Prenom#20108, Sexe-Pat#20109, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(11) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20108 AS Prenom#20154, Sexe-Pat#20109, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(12) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20154, Sexe-Pat#20109 AS Sexe-Pat#20164, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(13) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20154, Sexe-Pat#20164, Date_Naissance#20110 AS Date_Naissance#20174, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(14) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20154, Sexe-Pat#20164, Date_Naissance#20174, N_Identification_National#20111 AS N_Identification_National#20184, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(15) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20154, Sexe-Pat#20164, Date_Naissance#20174, N_Identification_National#20184, N_Secu#20112 AS N_Secu#20194, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(16) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20154, Sexe-Pat#20164, Date_Naissance#20174, N_Identification_National#20184, N_Secu#20194, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20204]
(17) Project
Arguments: [IPP#20123 AS IPP#20214, Nom_Usage#20134 AS Nom_Usage#20215, Nom_Naissance#20144 AS Nom_Naissance#20216, Prenom#20154 AS Prenom#20217, Sexe-Pat#20164 AS Sexe-Pat#20218, Date_Naissance#20174 AS Date_Naissance#20219, N_Identification_National#20184 AS N_Identification_National#20220, N_Secu#20194 AS N_Secu#20221, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20204 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20222]
(18) Project
Arguments: [IPP#20214, Nom_Usage#20215, Nom_Naissance#20216, Prenom#20217, Sexe-Pat#20218, Date_Naissance#20219, N_Identification_National#20220, N_Secu#20221, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20222]
(19) Project
Arguments: [Date_Naissance#20219 AS DATE_NAISSANCE_388125#20241, Nom_Naissance#20216 AS NOM_NAISSANCE_388122#20242, Nom_Usage#20215 AS NOM_USAGE_388121#20243, N_Identification_National#20220 AS N_IDENTIFICATIO_388126#20244, IPP#20214 AS N_PATIENT_ETABL_388120#20245, N_Secu#20221 AS N_SECURITE_SOCI_388127#20246, Prenom#20217 AS PRENOM_388123#20247, cast(str_replace_extend(Sexe-Pat#20218, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#20249]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#20089, NOM_NAISSANCE_388122#20090, NOM_USAGE_388121#20091, N_IDENTIFICATIO_388126#20092, N_PATIENT_ETABL_388120#20093, N_SECURITE_SOCI_388127#20094, PRENOM_388123#20095, SEXE_388124#20096, str_encrypt(N_PATIENT_ETABL_388120#20093) AS ID_PATIENT_388128#20266, str_encrypt(N_PATIENT_ETABL_388120#20093) AS ID_PATIENT_BIS_388129#20267]
(22) View
Arguments: `LES_PATIENTS_388119176`, true
(23) SubqueryAlias
Arguments: LES_PATIENTS_388119176
(24) Project
Arguments: [DATE_NAISSANCE_388125#20089 AS LES_PATIENTS_388119_DATE_NAISSANCE_388125#20536, NOM_NAISSANCE_388122#20090 AS LES_PATIENTS_388119_NOM_NAISSANCE_388122#20537, NOM_USAGE_388121#20091 AS LES_PATIENTS_388119_NOM_USAGE_388121#20538, N_IDENTIFICATIO_388126#20092 AS LES_PATIENTS_388119_N_IDENTIFICATIO_388126#20539, N_PATIENT_ETABL_388120#20093 AS LES_PATIENTS_388119_N_PATIENT_ETABL_388120#20540, N_SECURITE_SOCI_388127#20094 AS LES_PATIENTS_388119_N_SECURITE_SOCI_388127#20541, PRENOM_388123#20095 AS LES_PATIENTS_388119_PRENOM_388123#20542, SEXE_388124#20096 AS LES_PATIENTS_388119_SEXE_388124#20543, ID_PATIENT_388128#20266 AS LES_PATIENTS_388119_ID_PATIENT_388128#20544, ID_PATIENT_BIS_388129#20267 AS LES_PATIENTS_388119_ID_PATIENT_BIS_388129#20545]
(25) Project
Arguments: [cast(LES_PATIENTS_388119_SEXE_388124#20543 as string) AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20559, cast(LES_PATIENTS_388119_DATE_NAISSANCE_388125#20536 as string) AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20560, cast(LES_PATIENTS_388119_ID_PATIENT_388128#20544 as string) AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20561]
(26) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20559 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20565, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20560 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20566, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20561 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20567]
(27) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#20415, N_Sejour#20416, Date_Debut_Sejour#20417, Date_Fin_Sejour#20418, Code_Unite_Medicale#20419, Libelle_Unite_Medicale#20420, Medecin_Responsable#20421], false
(28) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#20453, N_Sejour#20454, Date_Debut_Sejour#20455, Date_Fin_Sejour#20456, Code_Unite_Medicale#20457, Libelle_Unite_Medicale#20458, Medecin_Responsable#20459], false
(29) Project
Arguments: [N_Patient_Etablissement#20453, N_Sejour#20454, Date_Debut_Sejour#20455, Date_Fin_Sejour#20456, Code_Unite_Medicale#20457, Libelle_Unite_Medicale#20458, Medecin_Responsable#20459]
(30) Union
Arguments: false, false
(31) Project
Arguments: [N_Patient_Etablissement#20415 AS N_Patient_Etablissement#20482, N_Sejour#20416 AS N_Sejour#20483, Date_Debut_Sejour#20417 AS Date_Debut_Sejour#20484, Date_Fin_Sejour#20418 AS Date_Fin_Sejour#20485, Code_Unite_Medicale#20419 AS Code_Unite_Medicale#20486, Libelle_Unite_Medicale#20420 AS Libelle_Unite_Medicale#20487, Medecin_Responsable#20421 AS Medecin_Responsable#20488]
(32) Project
Arguments: [N_Patient_Etablissement#20482, N_Sejour#20483, Date_Debut_Sejour#20484, Date_Fin_Sejour#20485, Code_Unite_Medicale#20486, Libelle_Unite_Medicale#20487, Medecin_Responsable#20488]
(33) Project
Arguments: [Code_Unite_Medicale#20486 AS CODE_UNITE_MEDI_388065#20503, cast(Date_Debut_Sejour#20484 as timestamp) AS DATE_DEBUT_SEJO_388063#20504, cast(Date_Fin_Sejour#20485 as timestamp) AS DATE_FIN_SEJOUR_388064#20505, Libelle_Unite_Medicale#20487 AS LIBELLE_UNITE_M_388066#20506, Medecin_Responsable#20488 AS MEDECIN_RESPONS_388067#20507, N_Patient_Etablissement#20482 AS N_PATIENT_ETABL_388061#20508, N_Sejour#20483 AS N_SEJOUR_388062#20509]
(34) Project
Arguments: [CODE_UNITE_MEDI_388065#20503, DATE_DEBUT_SEJO_388063#20504, DATE_FIN_SEJOUR_388064#20505, LIBELLE_UNITE_M_388066#20506, MEDECIN_RESPONS_388067#20507, N_PATIENT_ETABL_388061#20508, N_SEJOUR_388062#20509, str_encrypt(N_PATIENT_ETABL_388061#20508) AS ID_PATIENT_388068#20517]
(35) View
Arguments: `LES_SEJOURS_388060176`, true
(36) SubqueryAlias
Arguments: LES_SEJOURS_388060176
(37) Project
Arguments: [CODE_UNITE_MEDI_388065#20503 AS LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#20579, DATE_DEBUT_SEJO_388063#20504 AS LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#20580, DATE_FIN_SEJOUR_388064#20505 AS LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#20581, LIBELLE_UNITE_M_388066#20506 AS LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#20582, MEDECIN_RESPONS_388067#20507 AS LES_SEJOURS_388060_MEDECIN_RESPONS_388067#20583, N_PATIENT_ETABL_388061#20508 AS LES_SEJOURS_388060_N_PATIENT_ETABL_388061#20584, N_SEJOUR_388062#20509 AS LES_SEJOURS_388060_N_SEJOUR_388062#20585, ID_PATIENT_388068#20517 AS LES_SEJOURS_388060_ID_PATIENT_388068#20586]
(38) Join
Arguments: LeftOuter, (COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20567 = LES_SEJOURS_388060_ID_PATIENT_388068#20586)
(39) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20565, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20566, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20567, LES_SEJOURS_388060_N_SEJOUR_388062#20585 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20617, LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#20580 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20618, LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#20581 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20619, LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#20579 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#20620, LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#20582 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20621, LES_SEJOURS_388060_MEDECIN_RESPONS_388067#20583 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20622]
(40) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20565 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20632, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20566 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20633, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20567 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20634, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20618 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20635, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20619 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20636, COL_0B71585C_6332_4738_A790_07EC5BC1F173#20620 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#20637, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20621 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20638, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20622 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20639, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20617 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20640]
(41) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20632 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20650, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20633 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20651, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20634 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20652, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20635 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20653, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20636 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20654, COL_0B71585C_6332_4738_A790_07EC5BC1F173#20637 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#20655, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20638 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20656, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20639 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20657, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20640 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20658]
(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#20278, N_Patient_Etablissement#20279, N_Sejour#20280, N_Mutation#20281, Date_Prelevement#20282, Code_Analyse#20283, Libelle_Analyse#20284, Valeur#20285, Unite#20286, Valeur_Ref_Min#20287, Valeur_Ref_Max#20288, Statut#20289], false
(43) Project
Arguments: [N_Examen#20278 AS COLL0#20302, N_Patient_Etablissement#20279 AS COLL1#20303, N_Sejour#20280 AS COLL2#20304, N_Mutation#20281 AS COLL3#20305, Date_Prelevement#20282 AS COLL4#20306, Code_Analyse#20283 AS COLL5#20307, Libelle_Analyse#20284 AS COLL6#20308, Valeur#20285 AS COLL7#20309, Unite#20286 AS COLL8#20310, Valeur_Ref_Min#20287 AS COLL9#20311, Valeur_Ref_Max#20288 AS COLL10#20312, Statut#20289 AS COLL11#20313]
(44) Project
Arguments: [COLL0#20302 AS COLL0#20326, COLL1#20303 AS COLL1#20327, COLL2#20304 AS COLL2#20328, COLL3#20305 AS COLL3#20329, COLL4#20306 AS COLL4#20330, COLL5#20307 AS COLL5#20331, COLL6#20308 AS COLL6#20332, COLL7#20309 AS COLL7#20333, COLL8#20310 AS COLL8#20334, COLL9#20311 AS COLL9#20335, COLL10#20312 AS COLL10#20336, COLL11#20313 AS COLL11#20337]
(45) Project
Arguments: [COLL0#20326, COLL1#20327, COLL2#20328, COLL3#20329, COLL4#20330, COLL5#20331, COLL6#20332, COLL7#20333, COLL8#20334, COLL9#20335, COLL10#20336, COLL11#20337]
(46) Project
Arguments: [COLL5#20331 AS CODE_ANALYSE_388136#20362, COLL4#20330 AS DATE_PRELEVEMEN_388135#20363, COLL6#20332 AS LIBELLE_ANALYSE_388137#20364, COLL0#20326 AS N_EXAMEN_388131#20365, COLL3#20329 AS N_MUTATION_388134#20366, COLL1#20327 AS N_PATIENT_ETABL_388132#20367, COLL2#20328 AS N_SEJOUR_388133#20368, COLL11#20337 AS STATUT_388142#20369, COLL8#20334 AS UNITE_388139#20370, COLL7#20333 AS VALEUR_388138#20371, COLL10#20336 AS VALEUR_REF_MAX_388141#20372, COLL9#20335 AS VALEUR_REF_MIN_388140#20373]
(47) Project
Arguments: [CODE_ANALYSE_388136#20362, DATE_PRELEVEMEN_388135#20363, LIBELLE_ANALYSE_388137#20364, N_EXAMEN_388131#20365, N_MUTATION_388134#20366, N_PATIENT_ETABL_388132#20367, N_SEJOUR_388133#20368, STATUT_388142#20369, UNITE_388139#20370, VALEUR_388138#20371, VALEUR_REF_MAX_388141#20372, VALEUR_REF_MIN_388140#20373]
(48) View
Arguments: `BIOLOGIE_PATIEN_388130176`, true
(49) SubqueryAlias
Arguments: BIOLOGIE_PATIEN_388130176
(50) Project
Arguments: [CODE_ANALYSE_388136#20362 AS BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#20680, DATE_PRELEVEMEN_388135#20363 AS BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#20681, LIBELLE_ANALYSE_388137#20364 AS BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#20682, N_EXAMEN_388131#20365 AS BIOLOGIE_PATIEN_388130_N_EXAMEN_388131#20683, N_MUTATION_388134#20366 AS BIOLOGIE_PATIEN_388130_N_MUTATION_388134#20684, N_PATIENT_ETABL_388132#20367 AS BIOLOGIE_PATIEN_388130_N_PATIENT_ETABL_388132#20685, N_SEJOUR_388133#20368 AS BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#20686, STATUT_388142#20369 AS BIOLOGIE_PATIEN_388130_STATUT_388142#20687, UNITE_388139#20370 AS BIOLOGIE_PATIEN_388130_UNITE_388139#20688, VALEUR_388138#20371 AS BIOLOGIE_PATIEN_388130_VALEUR_388138#20689, VALEUR_REF_MAX_388141#20372 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#20690, VALEUR_REF_MIN_388140#20373 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#20691]
(51) Join
Arguments: Inner, (COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20658 = BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#20686)
(52) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20650, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20651, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20652, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20653, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20654, COL_0B71585C_6332_4738_A790_07EC5BC1F173#20655, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20656, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20657, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20658, BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#20681 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20746, BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#20680 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#20747, BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#20682 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#20748, BIOLOGIE_PATIEN_388130_VALEUR_388138#20689 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#20749, BIOLOGIE_PATIEN_388130_UNITE_388139#20688 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#20750, BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#20691 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#20751, BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#20690 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#20752, BIOLOGIE_PATIEN_388130_STATUT_388142#20687 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#20753]
(53) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20650, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20651, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20652, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20653, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20654, COL_0B71585C_6332_4738_A790_07EC5BC1F173#20655, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20656, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20657, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20658, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20746, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#20747, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#20748, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#20749, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#20750, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#20751, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#20752, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#20753, date_diff(cast(MINUTE as string), COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20746, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20653) AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#20771L]
(54) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20650, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20651, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20652, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20653, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20654, COL_0B71585C_6332_4738_A790_07EC5BC1F173#20655, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20656, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20657, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20658, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20746, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#20747, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#20748, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#20749, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#20750, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#20751, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#20752, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#20753, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#20771L, date_diff(cast(MINUTE as string), COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20654, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20746) AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#20790L]
(55) Filter
Arguments: (CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20657, cast(SIMON as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20657, cast(SIMON as string)) END OR CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20657, cast(DUPONT as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20657, cast(DUPONT as string)) END)
(56) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20650 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20810, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20651 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20811, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20652 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20812, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20653 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20813, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20654 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20814, COL_0B71585C_6332_4738_A790_07EC5BC1F173#20655 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#20815, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20656 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20816, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20657 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20817, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20658 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20818, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20746 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20819, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#20747 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#20820, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#20748 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#20821, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#20749 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#20822, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#20750 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#20823, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#20751 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#20824, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#20752 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#20825, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#20753 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#20826, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#20771L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#20827L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#20790L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#20828L]
(57) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20810 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20848, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20811 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20849, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20812 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20850, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20813 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20851, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20814 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20852, COL_0B71585C_6332_4738_A790_07EC5BC1F173#20815 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#20853, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20816 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20854, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20817 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20855, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20818 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20856, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20819 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20857, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#20820 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#20858, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#20821 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#20859, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#20822 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#20860, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#20823 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#20861, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#20824 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#20862, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#20825 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#20863, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#20826 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#20864, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#20827L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#20865L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#20828L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#20866L]
(58) Aggregate
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20848, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20849, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20850, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20851, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20852, COL_0B71585C_6332_4738_A790_07EC5BC1F173#20853, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20854, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20855, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20856, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20857, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#20858, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#20859, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#20860, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#20861, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#20862, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#20863, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#20864, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#20865L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#20866L], [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#20848 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#20886, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#20849 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#20887, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#20850 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#20888, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#20851 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#20889, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#20852 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#20890, COL_0B71585C_6332_4738_A790_07EC5BC1F173#20853 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#20891, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#20854 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#20892, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#20855 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#20893, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#20856 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#20894, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#20857 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#20895, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#20858 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#20896, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#20859 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#20897, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#20860 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#20898, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#20861 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#20899, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#20862 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#20900, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#20863 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#20901, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#20864 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#20902, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#20865L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#20903L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#20866L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#20904L, 1 AS NULL_1#20924]
(59) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#20886, COL_53BB3EE9_8890_4C91_B227_683FABF95657#20887, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#20888, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#20889, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#20890, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#20891, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#20892, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#20893, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#20894, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#20895, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#20896, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#20897, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#20898, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#20899, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#20900, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#20901, COL_155D490C_35A1_496B_88D3_425E93ED3101#20902, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#20903L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#20904L]
(60) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#20886 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#20964, COL_53BB3EE9_8890_4C91_B227_683FABF95657#20887 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#20965, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#20888 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#20966, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#20889 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#20967, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#20890 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#20968, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#20891 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#20969, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#20892 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#20970, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#20893 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#20971, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#20894 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#20972, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#20895 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#20973, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#20896 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#20974, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#20897 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#20975, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#20898 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#20976, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#20899 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#20977, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#20900 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#20978, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#20901 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#20979, COL_155D490C_35A1_496B_88D3_425E93ED3101#20902 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#20980, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#20903L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#20981L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#20904L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#20982L]