== 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_388165179`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#6200, Nom_Usage#6201, Nom_Naissance#6202, Prenom#6203, Sexe#6204, Date_Naissance#6205, N_Identification_National#6206, N_Securite_Social#6207], false
(4) Project
Arguments: [N_Patient_Etablissement#6200 AS N_Patient_Etablissement#6224, Nom_Usage#6201 AS Nom_Usage#6225, Nom_Naissance#6202 AS Nom_Naissance#6226, Prenom#6203 AS Prenom#6227, Sexe#6204 AS Sexe#6228, Date_Naissance#6205 AS Date_Naissance#6229, N_Identification_National#6206 AS N_Identification_National#6230, N_Securite_Social#6207 AS N_Securite_Social#6231]
(5) Project
Arguments: [N_Patient_Etablissement#6224, Nom_Usage#6225, Nom_Naissance#6226, Prenom#6227, Sexe#6228, Date_Naissance#6229, N_Identification_National#6230, N_Securite_Social#6231]
(6) Project
Arguments: [Date_Naissance#6229 AS DATE_NAISSANCE_388125#6249, Nom_Naissance#6226 AS NOM_NAISSANCE_388122#6250, Nom_Usage#6225 AS NOM_USAGE_388121#6251, N_Identification_National#6230 AS N_IDENTIFICATIO_388126#6252, N_Patient_Etablissement#6224 AS N_PATIENT_ETABL_388120#6253, N_Securite_Social#6231 AS N_SECURITE_SOCI_388127#6254, Prenom#6227 AS PRENOM_388123#6255, Sexe#6228 AS SEXE_388124#6256]
(7) LogicalRelation
Arguments: parquet, [IPP#6265, Nom_Usage#6266, Nom_Naissance#6267, Prenom#6268, Sexe-Pat#6269, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273], false
(8) Project
Arguments: [IPP#6265 AS IPP#6283, Nom_Usage#6266, Nom_Naissance#6267, Prenom#6268, Sexe-Pat#6269, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(9) Project
Arguments: [IPP#6283, Nom_Usage#6266 AS Nom_Usage#6294, Nom_Naissance#6267, Prenom#6268, Sexe-Pat#6269, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(10) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6267 AS Nom_Naissance#6304, Prenom#6268, Sexe-Pat#6269, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(11) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6268 AS Prenom#6314, Sexe-Pat#6269, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(12) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6314, Sexe-Pat#6269 AS Sexe-Pat#6324, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(13) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6314, Sexe-Pat#6324, Date_Naissance#6270 AS Date_Naissance#6334, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(14) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6314, Sexe-Pat#6324, Date_Naissance#6334, N_Identification_National#6271 AS N_Identification_National#6344, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(15) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6314, Sexe-Pat#6324, Date_Naissance#6334, N_Identification_National#6344, N_Secu#6272 AS N_Secu#6354, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(16) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6314, Sexe-Pat#6324, Date_Naissance#6334, N_Identification_National#6344, N_Secu#6354, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6364]
(17) Project
Arguments: [IPP#6283 AS IPP#6374, Nom_Usage#6294 AS Nom_Usage#6375, Nom_Naissance#6304 AS Nom_Naissance#6376, Prenom#6314 AS Prenom#6377, Sexe-Pat#6324 AS Sexe-Pat#6378, Date_Naissance#6334 AS Date_Naissance#6379, N_Identification_National#6344 AS N_Identification_National#6380, N_Secu#6354 AS N_Secu#6381, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6364 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6382]
(18) Project
Arguments: [IPP#6374, Nom_Usage#6375, Nom_Naissance#6376, Prenom#6377, Sexe-Pat#6378, Date_Naissance#6379, N_Identification_National#6380, N_Secu#6381, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6382]
(19) Project
Arguments: [Date_Naissance#6379 AS DATE_NAISSANCE_388125#6401, Nom_Naissance#6376 AS NOM_NAISSANCE_388122#6402, Nom_Usage#6375 AS NOM_USAGE_388121#6403, N_Identification_National#6380 AS N_IDENTIFICATIO_388126#6404, IPP#6374 AS N_PATIENT_ETABL_388120#6405, N_Secu#6381 AS N_SECURITE_SOCI_388127#6406, Prenom#6377 AS PRENOM_388123#6407, cast(str_replace_extend(Sexe-Pat#6378, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#6409]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#6249, NOM_NAISSANCE_388122#6250, NOM_USAGE_388121#6251, N_IDENTIFICATIO_388126#6252, N_PATIENT_ETABL_388120#6253, N_SECURITE_SOCI_388127#6254, PRENOM_388123#6255, SEXE_388124#6256, str_encrypt(N_PATIENT_ETABL_388120#6253) AS ID_PATIENT_388128#6426, str_encrypt(N_PATIENT_ETABL_388120#6253) AS ID_PATIENT_BIS_388129#6427]
(22) View
Arguments: `LES_PATIENTS_388119179`, true
(23) SubqueryAlias
Arguments: LES_PATIENTS_388119179
(24) Project
Arguments: [DATE_NAISSANCE_388125#6249 AS LES_PATIENTS_388119_DATE_NAISSANCE_388125#6696, NOM_NAISSANCE_388122#6250 AS LES_PATIENTS_388119_NOM_NAISSANCE_388122#6697, NOM_USAGE_388121#6251 AS LES_PATIENTS_388119_NOM_USAGE_388121#6698, N_IDENTIFICATIO_388126#6252 AS LES_PATIENTS_388119_N_IDENTIFICATIO_388126#6699, N_PATIENT_ETABL_388120#6253 AS LES_PATIENTS_388119_N_PATIENT_ETABL_388120#6700, N_SECURITE_SOCI_388127#6254 AS LES_PATIENTS_388119_N_SECURITE_SOCI_388127#6701, PRENOM_388123#6255 AS LES_PATIENTS_388119_PRENOM_388123#6702, SEXE_388124#6256 AS LES_PATIENTS_388119_SEXE_388124#6703, ID_PATIENT_388128#6426 AS LES_PATIENTS_388119_ID_PATIENT_388128#6704, ID_PATIENT_BIS_388129#6427 AS LES_PATIENTS_388119_ID_PATIENT_BIS_388129#6705]
(25) Project
Arguments: [cast(LES_PATIENTS_388119_SEXE_388124#6703 as string) AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6719, cast(LES_PATIENTS_388119_DATE_NAISSANCE_388125#6696 as string) AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6720, cast(LES_PATIENTS_388119_ID_PATIENT_388128#6704 as string) AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6721]
(26) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6719 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6725, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6720 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6726, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6721 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6727]
(27) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#6575, N_Sejour#6576, Date_Debut_Sejour#6577, Date_Fin_Sejour#6578, Code_Unite_Medicale#6579, Libelle_Unite_Medicale#6580, Medecin_Responsable#6581], false
(28) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#6613, N_Sejour#6614, Date_Debut_Sejour#6615, Date_Fin_Sejour#6616, Code_Unite_Medicale#6617, Libelle_Unite_Medicale#6618, Medecin_Responsable#6619], false
(29) Project
Arguments: [N_Patient_Etablissement#6613, N_Sejour#6614, Date_Debut_Sejour#6615, Date_Fin_Sejour#6616, Code_Unite_Medicale#6617, Libelle_Unite_Medicale#6618, Medecin_Responsable#6619]
(30) Union
Arguments: false, false
(31) Project
Arguments: [N_Patient_Etablissement#6575 AS N_Patient_Etablissement#6642, N_Sejour#6576 AS N_Sejour#6643, Date_Debut_Sejour#6577 AS Date_Debut_Sejour#6644, Date_Fin_Sejour#6578 AS Date_Fin_Sejour#6645, Code_Unite_Medicale#6579 AS Code_Unite_Medicale#6646, Libelle_Unite_Medicale#6580 AS Libelle_Unite_Medicale#6647, Medecin_Responsable#6581 AS Medecin_Responsable#6648]
(32) Project
Arguments: [N_Patient_Etablissement#6642, N_Sejour#6643, Date_Debut_Sejour#6644, Date_Fin_Sejour#6645, Code_Unite_Medicale#6646, Libelle_Unite_Medicale#6647, Medecin_Responsable#6648]
(33) Project
Arguments: [Code_Unite_Medicale#6646 AS CODE_UNITE_MEDI_388065#6663, cast(Date_Debut_Sejour#6644 as timestamp) AS DATE_DEBUT_SEJO_388063#6664, cast(Date_Fin_Sejour#6645 as timestamp) AS DATE_FIN_SEJOUR_388064#6665, Libelle_Unite_Medicale#6647 AS LIBELLE_UNITE_M_388066#6666, Medecin_Responsable#6648 AS MEDECIN_RESPONS_388067#6667, N_Patient_Etablissement#6642 AS N_PATIENT_ETABL_388061#6668, N_Sejour#6643 AS N_SEJOUR_388062#6669]
(34) Project
Arguments: [CODE_UNITE_MEDI_388065#6663, DATE_DEBUT_SEJO_388063#6664, DATE_FIN_SEJOUR_388064#6665, LIBELLE_UNITE_M_388066#6666, MEDECIN_RESPONS_388067#6667, N_PATIENT_ETABL_388061#6668, N_SEJOUR_388062#6669, str_encrypt(N_PATIENT_ETABL_388061#6668) AS ID_PATIENT_388068#6677]
(35) View
Arguments: `LES_SEJOURS_388060179`, true
(36) SubqueryAlias
Arguments: LES_SEJOURS_388060179
(37) Project
Arguments: [CODE_UNITE_MEDI_388065#6663 AS LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#6739, DATE_DEBUT_SEJO_388063#6664 AS LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#6740, DATE_FIN_SEJOUR_388064#6665 AS LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#6741, LIBELLE_UNITE_M_388066#6666 AS LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#6742, MEDECIN_RESPONS_388067#6667 AS LES_SEJOURS_388060_MEDECIN_RESPONS_388067#6743, N_PATIENT_ETABL_388061#6668 AS LES_SEJOURS_388060_N_PATIENT_ETABL_388061#6744, N_SEJOUR_388062#6669 AS LES_SEJOURS_388060_N_SEJOUR_388062#6745, ID_PATIENT_388068#6677 AS LES_SEJOURS_388060_ID_PATIENT_388068#6746]
(38) Join
Arguments: LeftOuter, (COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6727 = LES_SEJOURS_388060_ID_PATIENT_388068#6746)
(39) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6725, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6726, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6727, LES_SEJOURS_388060_N_SEJOUR_388062#6745 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6777, LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#6740 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6778, LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#6741 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6779, LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#6739 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#6780, LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#6742 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6781, LES_SEJOURS_388060_MEDECIN_RESPONS_388067#6743 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6782]
(40) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6725 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6792, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6726 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6793, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6727 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6794, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6778 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6795, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6779 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6796, COL_0B71585C_6332_4738_A790_07EC5BC1F173#6780 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#6797, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6781 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6798, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6782 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6799, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6777 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6800]
(41) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6792 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6810, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6793 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6811, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6794 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6812, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6795 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6813, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6796 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6814, COL_0B71585C_6332_4738_A790_07EC5BC1F173#6797 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#6815, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6798 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6816, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6799 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6817, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6800 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6818]
(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#6438, N_Patient_Etablissement#6439, N_Sejour#6440, N_Mutation#6441, Date_Prelevement#6442, Code_Analyse#6443, Libelle_Analyse#6444, Valeur#6445, Unite#6446, Valeur_Ref_Min#6447, Valeur_Ref_Max#6448, Statut#6449], false
(43) Project
Arguments: [N_Examen#6438 AS COLL0#6462, N_Patient_Etablissement#6439 AS COLL1#6463, N_Sejour#6440 AS COLL2#6464, N_Mutation#6441 AS COLL3#6465, Date_Prelevement#6442 AS COLL4#6466, Code_Analyse#6443 AS COLL5#6467, Libelle_Analyse#6444 AS COLL6#6468, Valeur#6445 AS COLL7#6469, Unite#6446 AS COLL8#6470, Valeur_Ref_Min#6447 AS COLL9#6471, Valeur_Ref_Max#6448 AS COLL10#6472, Statut#6449 AS COLL11#6473]
(44) Project
Arguments: [COLL0#6462 AS COLL0#6486, COLL1#6463 AS COLL1#6487, COLL2#6464 AS COLL2#6488, COLL3#6465 AS COLL3#6489, COLL4#6466 AS COLL4#6490, COLL5#6467 AS COLL5#6491, COLL6#6468 AS COLL6#6492, COLL7#6469 AS COLL7#6493, COLL8#6470 AS COLL8#6494, COLL9#6471 AS COLL9#6495, COLL10#6472 AS COLL10#6496, COLL11#6473 AS COLL11#6497]
(45) Project
Arguments: [COLL0#6486, COLL1#6487, COLL2#6488, COLL3#6489, COLL4#6490, COLL5#6491, COLL6#6492, COLL7#6493, COLL8#6494, COLL9#6495, COLL10#6496, COLL11#6497]
(46) Project
Arguments: [COLL5#6491 AS CODE_ANALYSE_388136#6522, COLL4#6490 AS DATE_PRELEVEMEN_388135#6523, COLL6#6492 AS LIBELLE_ANALYSE_388137#6524, COLL0#6486 AS N_EXAMEN_388131#6525, COLL3#6489 AS N_MUTATION_388134#6526, COLL1#6487 AS N_PATIENT_ETABL_388132#6527, COLL2#6488 AS N_SEJOUR_388133#6528, COLL11#6497 AS STATUT_388142#6529, COLL8#6494 AS UNITE_388139#6530, COLL7#6493 AS VALEUR_388138#6531, COLL10#6496 AS VALEUR_REF_MAX_388141#6532, COLL9#6495 AS VALEUR_REF_MIN_388140#6533]
(47) Project
Arguments: [CODE_ANALYSE_388136#6522, DATE_PRELEVEMEN_388135#6523, LIBELLE_ANALYSE_388137#6524, N_EXAMEN_388131#6525, N_MUTATION_388134#6526, N_PATIENT_ETABL_388132#6527, N_SEJOUR_388133#6528, STATUT_388142#6529, UNITE_388139#6530, VALEUR_388138#6531, VALEUR_REF_MAX_388141#6532, VALEUR_REF_MIN_388140#6533]
(48) View
Arguments: `BIOLOGIE_PATIEN_388130179`, true
(49) SubqueryAlias
Arguments: BIOLOGIE_PATIEN_388130179
(50) Project
Arguments: [CODE_ANALYSE_388136#6522 AS BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#6840, DATE_PRELEVEMEN_388135#6523 AS BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#6841, LIBELLE_ANALYSE_388137#6524 AS BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#6842, N_EXAMEN_388131#6525 AS BIOLOGIE_PATIEN_388130_N_EXAMEN_388131#6843, N_MUTATION_388134#6526 AS BIOLOGIE_PATIEN_388130_N_MUTATION_388134#6844, N_PATIENT_ETABL_388132#6527 AS BIOLOGIE_PATIEN_388130_N_PATIENT_ETABL_388132#6845, N_SEJOUR_388133#6528 AS BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#6846, STATUT_388142#6529 AS BIOLOGIE_PATIEN_388130_STATUT_388142#6847, UNITE_388139#6530 AS BIOLOGIE_PATIEN_388130_UNITE_388139#6848, VALEUR_388138#6531 AS BIOLOGIE_PATIEN_388130_VALEUR_388138#6849, VALEUR_REF_MAX_388141#6532 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#6850, VALEUR_REF_MIN_388140#6533 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#6851]
(51) Join
Arguments: Inner, (COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6818 = BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#6846)
(52) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6810, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6811, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6812, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6813, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6814, COL_0B71585C_6332_4738_A790_07EC5BC1F173#6815, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6816, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6817, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6818, BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#6841 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#6906, BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#6840 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#6907, BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#6842 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#6908, BIOLOGIE_PATIEN_388130_VALEUR_388138#6849 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#6909, BIOLOGIE_PATIEN_388130_UNITE_388139#6848 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#6910, BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#6851 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#6911, BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#6850 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#6912, BIOLOGIE_PATIEN_388130_STATUT_388142#6847 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#6913]
(53) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6810, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6811, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6812, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6813, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6814, COL_0B71585C_6332_4738_A790_07EC5BC1F173#6815, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6816, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6817, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6818, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#6906, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#6907, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#6908, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#6909, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#6910, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#6911, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#6912, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#6913, date_diff(cast(MINUTE as string), COL_46FA8E68_4A9B_4128_997C_B17F45599E34#6906, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6813) AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#6931L]
(54) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6810, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6811, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6812, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6813, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6814, COL_0B71585C_6332_4738_A790_07EC5BC1F173#6815, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6816, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6817, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6818, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#6906, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#6907, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#6908, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#6909, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#6910, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#6911, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#6912, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#6913, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#6931L, date_diff(cast(MINUTE as string), COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6814, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#6906) AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#6950L]
(55) Filter
Arguments: (CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6817, cast(SIMON as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6817, cast(SIMON as string)) END OR CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6817, cast(DUPONT as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6817, cast(DUPONT as string)) END)
(56) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6810 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6970, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6811 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6971, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6812 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6972, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6813 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6973, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6814 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6974, COL_0B71585C_6332_4738_A790_07EC5BC1F173#6815 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#6975, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6816 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6976, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6817 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6977, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6818 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6978, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#6906 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#6979, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#6907 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#6980, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#6908 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#6981, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#6909 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#6982, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#6910 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#6983, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#6911 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#6984, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#6912 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#6985, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#6913 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#6986, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#6931L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#6987L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#6950L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#6988L]
(57) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#6970 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#7008, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#6971 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#7009, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#6972 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#7010, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#6973 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#7011, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#6974 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#7012, COL_0B71585C_6332_4738_A790_07EC5BC1F173#6975 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#7013, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#6976 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#7014, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#6977 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#7015, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#6978 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#7016, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#6979 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#7017, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#6980 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#7018, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#6981 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#7019, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#6982 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#7020, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#6983 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#7021, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#6984 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#7022, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#6985 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#7023, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#6986 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#7024, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#6987L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#7025L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#6988L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#7026L]
(58) Aggregate
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#7008, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#7009, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#7010, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#7011, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#7012, COL_0B71585C_6332_4738_A790_07EC5BC1F173#7013, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#7014, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#7015, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#7016, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#7017, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#7018, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#7019, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#7020, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#7021, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#7022, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#7023, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#7024, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#7025L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#7026L], [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#7008 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#7046, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#7009 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#7047, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#7010 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#7048, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#7011 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#7049, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#7012 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#7050, COL_0B71585C_6332_4738_A790_07EC5BC1F173#7013 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#7051, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#7014 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#7052, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#7015 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#7053, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#7016 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#7054, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#7017 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#7055, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#7018 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#7056, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#7019 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#7057, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#7020 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#7058, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#7021 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#7059, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#7022 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#7060, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#7023 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#7061, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#7024 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#7062, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#7025L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#7063L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#7026L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#7064L, 1 AS NULL_1#7084]
(59) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#7046, COL_53BB3EE9_8890_4C91_B227_683FABF95657#7047, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#7048, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#7049, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#7050, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#7051, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#7052, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#7053, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#7054, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#7055, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#7056, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#7057, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#7058, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#7059, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#7060, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#7061, COL_155D490C_35A1_496B_88D3_425E93ED3101#7062, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#7063L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#7064L]
(60) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#7046 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#7124, COL_53BB3EE9_8890_4C91_B227_683FABF95657#7047 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#7125, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#7048 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#7126, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#7049 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#7127, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#7050 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#7128, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#7051 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#7129, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#7052 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#7130, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#7053 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#7131, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#7054 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#7132, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#7055 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#7133, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#7056 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#7134, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#7057 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#7135, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#7058 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#7136, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#7059 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#7137, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#7060 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#7138, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#7061 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#7139, COL_155D490C_35A1_496B_88D3_425E93ED3101#7062 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#7140, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#7063L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#7141L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#7064L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#7142L]