== 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#21258, Nom_Usage#21259, Nom_Naissance#21260, Prenom#21261, Sexe#21262, Date_Naissance#21263, N_Identification_National#21264, N_Securite_Social#21265], false
(4) Project
Arguments: [N_Patient_Etablissement#21258 AS N_Patient_Etablissement#21282, Nom_Usage#21259 AS Nom_Usage#21283, Nom_Naissance#21260 AS Nom_Naissance#21284, Prenom#21261 AS Prenom#21285, Sexe#21262 AS Sexe#21286, Date_Naissance#21263 AS Date_Naissance#21287, N_Identification_National#21264 AS N_Identification_National#21288, N_Securite_Social#21265 AS N_Securite_Social#21289]
(5) Project
Arguments: [N_Patient_Etablissement#21282, Nom_Usage#21283, Nom_Naissance#21284, Prenom#21285, Sexe#21286, Date_Naissance#21287, N_Identification_National#21288, N_Securite_Social#21289]
(6) Project
Arguments: [Date_Naissance#21287 AS DATE_NAISSANCE_388125#21307, Nom_Naissance#21284 AS NOM_NAISSANCE_388122#21308, Nom_Usage#21283 AS NOM_USAGE_388121#21309, N_Identification_National#21288 AS N_IDENTIFICATIO_388126#21310, N_Patient_Etablissement#21282 AS N_PATIENT_ETABL_388120#21311, N_Securite_Social#21289 AS N_SECURITE_SOCI_388127#21312, Prenom#21285 AS PRENOM_388123#21313, Sexe#21286 AS SEXE_388124#21314]
(7) LogicalRelation
Arguments: parquet, [IPP#21323, Nom_Usage#21324, Nom_Naissance#21325, Prenom#21326, Sexe-Pat#21327, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331], false
(8) Project
Arguments: [IPP#21323 AS IPP#21341, Nom_Usage#21324, Nom_Naissance#21325, Prenom#21326, Sexe-Pat#21327, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(9) Project
Arguments: [IPP#21341, Nom_Usage#21324 AS Nom_Usage#21352, Nom_Naissance#21325, Prenom#21326, Sexe-Pat#21327, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(10) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21325 AS Nom_Naissance#21362, Prenom#21326, Sexe-Pat#21327, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(11) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21326 AS Prenom#21372, Sexe-Pat#21327, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(12) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21372, Sexe-Pat#21327 AS Sexe-Pat#21382, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(13) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21372, Sexe-Pat#21382, Date_Naissance#21328 AS Date_Naissance#21392, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(14) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21372, Sexe-Pat#21382, Date_Naissance#21392, N_Identification_National#21329 AS N_Identification_National#21402, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(15) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21372, Sexe-Pat#21382, Date_Naissance#21392, N_Identification_National#21402, N_Secu#21330 AS N_Secu#21412, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(16) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21372, Sexe-Pat#21382, Date_Naissance#21392, N_Identification_National#21402, N_Secu#21412, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21422]
(17) Project
Arguments: [IPP#21341 AS IPP#21432, Nom_Usage#21352 AS Nom_Usage#21433, Nom_Naissance#21362 AS Nom_Naissance#21434, Prenom#21372 AS Prenom#21435, Sexe-Pat#21382 AS Sexe-Pat#21436, Date_Naissance#21392 AS Date_Naissance#21437, N_Identification_National#21402 AS N_Identification_National#21438, N_Secu#21412 AS N_Secu#21439, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21422 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21440]
(18) Project
Arguments: [IPP#21432, Nom_Usage#21433, Nom_Naissance#21434, Prenom#21435, Sexe-Pat#21436, Date_Naissance#21437, N_Identification_National#21438, N_Secu#21439, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21440]
(19) Project
Arguments: [Date_Naissance#21437 AS DATE_NAISSANCE_388125#21459, Nom_Naissance#21434 AS NOM_NAISSANCE_388122#21460, Nom_Usage#21433 AS NOM_USAGE_388121#21461, N_Identification_National#21438 AS N_IDENTIFICATIO_388126#21462, IPP#21432 AS N_PATIENT_ETABL_388120#21463, N_Secu#21439 AS N_SECURITE_SOCI_388127#21464, Prenom#21435 AS PRENOM_388123#21465, cast(str_replace_extend(Sexe-Pat#21436, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#21467]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#21307, NOM_NAISSANCE_388122#21308, NOM_USAGE_388121#21309, N_IDENTIFICATIO_388126#21310, N_PATIENT_ETABL_388120#21311, N_SECURITE_SOCI_388127#21312, PRENOM_388123#21313, SEXE_388124#21314, str_encrypt(N_PATIENT_ETABL_388120#21311) AS ID_PATIENT_388128#21484, str_encrypt(N_PATIENT_ETABL_388120#21311) AS ID_PATIENT_BIS_388129#21485]
(22) View
Arguments: `LES_PATIENTS_388119179`, true
(23) SubqueryAlias
Arguments: LES_PATIENTS_388119179
(24) Project
Arguments: [DATE_NAISSANCE_388125#21307 AS LES_PATIENTS_388119_DATE_NAISSANCE_388125#21754, NOM_NAISSANCE_388122#21308 AS LES_PATIENTS_388119_NOM_NAISSANCE_388122#21755, NOM_USAGE_388121#21309 AS LES_PATIENTS_388119_NOM_USAGE_388121#21756, N_IDENTIFICATIO_388126#21310 AS LES_PATIENTS_388119_N_IDENTIFICATIO_388126#21757, N_PATIENT_ETABL_388120#21311 AS LES_PATIENTS_388119_N_PATIENT_ETABL_388120#21758, N_SECURITE_SOCI_388127#21312 AS LES_PATIENTS_388119_N_SECURITE_SOCI_388127#21759, PRENOM_388123#21313 AS LES_PATIENTS_388119_PRENOM_388123#21760, SEXE_388124#21314 AS LES_PATIENTS_388119_SEXE_388124#21761, ID_PATIENT_388128#21484 AS LES_PATIENTS_388119_ID_PATIENT_388128#21762, ID_PATIENT_BIS_388129#21485 AS LES_PATIENTS_388119_ID_PATIENT_BIS_388129#21763]
(25) Project
Arguments: [cast(LES_PATIENTS_388119_SEXE_388124#21761 as string) AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21777, cast(LES_PATIENTS_388119_DATE_NAISSANCE_388125#21754 as string) AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21778, cast(LES_PATIENTS_388119_ID_PATIENT_388128#21762 as string) AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21779]
(26) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21777 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21783, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21778 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21784, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21779 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21785]
(27) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#21633, N_Sejour#21634, Date_Debut_Sejour#21635, Date_Fin_Sejour#21636, Code_Unite_Medicale#21637, Libelle_Unite_Medicale#21638, Medecin_Responsable#21639], false
(28) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#21671, N_Sejour#21672, Date_Debut_Sejour#21673, Date_Fin_Sejour#21674, Code_Unite_Medicale#21675, Libelle_Unite_Medicale#21676, Medecin_Responsable#21677], false
(29) Project
Arguments: [N_Patient_Etablissement#21671, N_Sejour#21672, Date_Debut_Sejour#21673, Date_Fin_Sejour#21674, Code_Unite_Medicale#21675, Libelle_Unite_Medicale#21676, Medecin_Responsable#21677]
(30) Union
Arguments: false, false
(31) Project
Arguments: [N_Patient_Etablissement#21633 AS N_Patient_Etablissement#21700, N_Sejour#21634 AS N_Sejour#21701, Date_Debut_Sejour#21635 AS Date_Debut_Sejour#21702, Date_Fin_Sejour#21636 AS Date_Fin_Sejour#21703, Code_Unite_Medicale#21637 AS Code_Unite_Medicale#21704, Libelle_Unite_Medicale#21638 AS Libelle_Unite_Medicale#21705, Medecin_Responsable#21639 AS Medecin_Responsable#21706]
(32) Project
Arguments: [N_Patient_Etablissement#21700, N_Sejour#21701, Date_Debut_Sejour#21702, Date_Fin_Sejour#21703, Code_Unite_Medicale#21704, Libelle_Unite_Medicale#21705, Medecin_Responsable#21706]
(33) Project
Arguments: [Code_Unite_Medicale#21704 AS CODE_UNITE_MEDI_388065#21721, cast(Date_Debut_Sejour#21702 as timestamp) AS DATE_DEBUT_SEJO_388063#21722, cast(Date_Fin_Sejour#21703 as timestamp) AS DATE_FIN_SEJOUR_388064#21723, Libelle_Unite_Medicale#21705 AS LIBELLE_UNITE_M_388066#21724, Medecin_Responsable#21706 AS MEDECIN_RESPONS_388067#21725, N_Patient_Etablissement#21700 AS N_PATIENT_ETABL_388061#21726, N_Sejour#21701 AS N_SEJOUR_388062#21727]
(34) Project
Arguments: [CODE_UNITE_MEDI_388065#21721, DATE_DEBUT_SEJO_388063#21722, DATE_FIN_SEJOUR_388064#21723, LIBELLE_UNITE_M_388066#21724, MEDECIN_RESPONS_388067#21725, N_PATIENT_ETABL_388061#21726, N_SEJOUR_388062#21727, str_encrypt(N_PATIENT_ETABL_388061#21726) AS ID_PATIENT_388068#21735]
(35) View
Arguments: `LES_SEJOURS_388060179`, true
(36) SubqueryAlias
Arguments: LES_SEJOURS_388060179
(37) Project
Arguments: [CODE_UNITE_MEDI_388065#21721 AS LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#21797, DATE_DEBUT_SEJO_388063#21722 AS LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#21798, DATE_FIN_SEJOUR_388064#21723 AS LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#21799, LIBELLE_UNITE_M_388066#21724 AS LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#21800, MEDECIN_RESPONS_388067#21725 AS LES_SEJOURS_388060_MEDECIN_RESPONS_388067#21801, N_PATIENT_ETABL_388061#21726 AS LES_SEJOURS_388060_N_PATIENT_ETABL_388061#21802, N_SEJOUR_388062#21727 AS LES_SEJOURS_388060_N_SEJOUR_388062#21803, ID_PATIENT_388068#21735 AS LES_SEJOURS_388060_ID_PATIENT_388068#21804]
(38) Join
Arguments: LeftOuter, (COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21785 = LES_SEJOURS_388060_ID_PATIENT_388068#21804)
(39) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21783, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21784, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21785, LES_SEJOURS_388060_N_SEJOUR_388062#21803 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#21835, LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#21798 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#21836, LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#21799 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#21837, LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#21797 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#21838, LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#21800 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#21839, LES_SEJOURS_388060_MEDECIN_RESPONS_388067#21801 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21840]
(40) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21783 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21850, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21784 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21851, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21785 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21852, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#21836 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#21853, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#21837 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#21854, COL_0B71585C_6332_4738_A790_07EC5BC1F173#21838 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#21855, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#21839 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#21856, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21840 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21857, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#21835 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#21858]
(41) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21850 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21868, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21851 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21869, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21852 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21870, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#21853 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#21871, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#21854 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#21872, COL_0B71585C_6332_4738_A790_07EC5BC1F173#21855 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#21873, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#21856 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#21874, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21857 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21875, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#21858 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#21876]
(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#21496, N_Patient_Etablissement#21497, N_Sejour#21498, N_Mutation#21499, Date_Prelevement#21500, Code_Analyse#21501, Libelle_Analyse#21502, Valeur#21503, Unite#21504, Valeur_Ref_Min#21505, Valeur_Ref_Max#21506, Statut#21507], false
(43) Project
Arguments: [N_Examen#21496 AS COLL0#21520, N_Patient_Etablissement#21497 AS COLL1#21521, N_Sejour#21498 AS COLL2#21522, N_Mutation#21499 AS COLL3#21523, Date_Prelevement#21500 AS COLL4#21524, Code_Analyse#21501 AS COLL5#21525, Libelle_Analyse#21502 AS COLL6#21526, Valeur#21503 AS COLL7#21527, Unite#21504 AS COLL8#21528, Valeur_Ref_Min#21505 AS COLL9#21529, Valeur_Ref_Max#21506 AS COLL10#21530, Statut#21507 AS COLL11#21531]
(44) Project
Arguments: [COLL0#21520 AS COLL0#21544, COLL1#21521 AS COLL1#21545, COLL2#21522 AS COLL2#21546, COLL3#21523 AS COLL3#21547, COLL4#21524 AS COLL4#21548, COLL5#21525 AS COLL5#21549, COLL6#21526 AS COLL6#21550, COLL7#21527 AS COLL7#21551, COLL8#21528 AS COLL8#21552, COLL9#21529 AS COLL9#21553, COLL10#21530 AS COLL10#21554, COLL11#21531 AS COLL11#21555]
(45) Project
Arguments: [COLL0#21544, COLL1#21545, COLL2#21546, COLL3#21547, COLL4#21548, COLL5#21549, COLL6#21550, COLL7#21551, COLL8#21552, COLL9#21553, COLL10#21554, COLL11#21555]
(46) Project
Arguments: [COLL5#21549 AS CODE_ANALYSE_388136#21580, COLL4#21548 AS DATE_PRELEVEMEN_388135#21581, COLL6#21550 AS LIBELLE_ANALYSE_388137#21582, COLL0#21544 AS N_EXAMEN_388131#21583, COLL3#21547 AS N_MUTATION_388134#21584, COLL1#21545 AS N_PATIENT_ETABL_388132#21585, COLL2#21546 AS N_SEJOUR_388133#21586, COLL11#21555 AS STATUT_388142#21587, COLL8#21552 AS UNITE_388139#21588, COLL7#21551 AS VALEUR_388138#21589, COLL10#21554 AS VALEUR_REF_MAX_388141#21590, COLL9#21553 AS VALEUR_REF_MIN_388140#21591]
(47) Project
Arguments: [CODE_ANALYSE_388136#21580, DATE_PRELEVEMEN_388135#21581, LIBELLE_ANALYSE_388137#21582, N_EXAMEN_388131#21583, N_MUTATION_388134#21584, N_PATIENT_ETABL_388132#21585, N_SEJOUR_388133#21586, STATUT_388142#21587, UNITE_388139#21588, VALEUR_388138#21589, VALEUR_REF_MAX_388141#21590, VALEUR_REF_MIN_388140#21591]
(48) View
Arguments: `BIOLOGIE_PATIEN_388130179`, true
(49) SubqueryAlias
Arguments: BIOLOGIE_PATIEN_388130179
(50) Project
Arguments: [CODE_ANALYSE_388136#21580 AS BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#21898, DATE_PRELEVEMEN_388135#21581 AS BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#21899, LIBELLE_ANALYSE_388137#21582 AS BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#21900, N_EXAMEN_388131#21583 AS BIOLOGIE_PATIEN_388130_N_EXAMEN_388131#21901, N_MUTATION_388134#21584 AS BIOLOGIE_PATIEN_388130_N_MUTATION_388134#21902, N_PATIENT_ETABL_388132#21585 AS BIOLOGIE_PATIEN_388130_N_PATIENT_ETABL_388132#21903, N_SEJOUR_388133#21586 AS BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#21904, STATUT_388142#21587 AS BIOLOGIE_PATIEN_388130_STATUT_388142#21905, UNITE_388139#21588 AS BIOLOGIE_PATIEN_388130_UNITE_388139#21906, VALEUR_388138#21589 AS BIOLOGIE_PATIEN_388130_VALEUR_388138#21907, VALEUR_REF_MAX_388141#21590 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#21908, VALEUR_REF_MIN_388140#21591 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#21909]
(51) Join
Arguments: Inner, (COL_955D5497_99FD_42BC_B435_98B1FFF6F635#21876 = BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#21904)
(52) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21868, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21869, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21870, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#21871, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#21872, COL_0B71585C_6332_4738_A790_07EC5BC1F173#21873, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#21874, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21875, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#21876, BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#21899 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#21964, BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#21898 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#21965, BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#21900 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#21966, BIOLOGIE_PATIEN_388130_VALEUR_388138#21907 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#21967, BIOLOGIE_PATIEN_388130_UNITE_388139#21906 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#21968, BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#21909 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#21969, BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#21908 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#21970, BIOLOGIE_PATIEN_388130_STATUT_388142#21905 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#21971]
(53) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21868, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21869, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21870, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#21871, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#21872, COL_0B71585C_6332_4738_A790_07EC5BC1F173#21873, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#21874, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21875, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#21876, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#21964, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#21965, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#21966, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#21967, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#21968, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#21969, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#21970, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#21971, date_diff(cast(MINUTE as string), COL_46FA8E68_4A9B_4128_997C_B17F45599E34#21964, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#21871) AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#21989L]
(54) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21868, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21869, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21870, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#21871, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#21872, COL_0B71585C_6332_4738_A790_07EC5BC1F173#21873, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#21874, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21875, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#21876, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#21964, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#21965, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#21966, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#21967, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#21968, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#21969, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#21970, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#21971, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#21989L, date_diff(cast(MINUTE as string), COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#21872, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#21964) AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#22008L]
(55) Filter
Arguments: (CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21875, cast(SIMON as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21875, cast(SIMON as string)) END OR CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21875, cast(DUPONT as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21875, cast(DUPONT as string)) END)
(56) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#21868 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#22028, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#21869 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#22029, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#21870 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#22030, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#21871 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#22031, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#21872 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#22032, COL_0B71585C_6332_4738_A790_07EC5BC1F173#21873 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#22033, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#21874 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#22034, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#21875 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#22035, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#21876 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#22036, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#21964 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#22037, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#21965 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#22038, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#21966 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#22039, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#21967 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#22040, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#21968 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#22041, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#21969 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#22042, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#21970 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#22043, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#21971 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#22044, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#21989L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#22045L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#22008L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#22046L]
(57) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#22028 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#22066, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#22029 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#22067, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#22030 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#22068, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#22031 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#22069, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#22032 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#22070, COL_0B71585C_6332_4738_A790_07EC5BC1F173#22033 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#22071, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#22034 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#22072, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#22035 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#22073, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#22036 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#22074, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#22037 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#22075, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#22038 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#22076, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#22039 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#22077, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#22040 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#22078, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#22041 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#22079, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#22042 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#22080, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#22043 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#22081, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#22044 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#22082, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#22045L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#22083L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#22046L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#22084L]
(58) Aggregate
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#22066, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#22067, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#22068, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#22069, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#22070, COL_0B71585C_6332_4738_A790_07EC5BC1F173#22071, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#22072, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#22073, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#22074, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#22075, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#22076, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#22077, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#22078, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#22079, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#22080, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#22081, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#22082, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#22083L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#22084L], [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#22066 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#22104, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#22067 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#22105, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#22068 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#22106, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#22069 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#22107, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#22070 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#22108, COL_0B71585C_6332_4738_A790_07EC5BC1F173#22071 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#22109, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#22072 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#22110, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#22073 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#22111, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#22074 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#22112, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#22075 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#22113, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#22076 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#22114, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#22077 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#22115, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#22078 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#22116, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#22079 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#22117, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#22080 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#22118, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#22081 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#22119, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#22082 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#22120, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#22083L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#22121L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#22084L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#22122L, 1 AS NULL_1#22142]
(59) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#22104, COL_53BB3EE9_8890_4C91_B227_683FABF95657#22105, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#22106, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#22107, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#22108, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#22109, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#22110, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#22111, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#22112, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#22113, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#22114, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#22115, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#22116, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#22117, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#22118, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#22119, COL_155D490C_35A1_496B_88D3_425E93ED3101#22120, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#22121L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#22122L]
(60) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#22104 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#22182, COL_53BB3EE9_8890_4C91_B227_683FABF95657#22105 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#22183, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#22106 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#22184, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#22107 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#22185, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#22108 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#22186, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#22109 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#22187, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#22110 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#22188, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#22111 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#22189, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#22112 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#22190, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#22113 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#22191, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#22114 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#22192, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#22115 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#22193, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#22116 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#22194, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#22117 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#22195, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#22118 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#22196, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#22119 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#22197, COL_155D490C_35A1_496B_88D3_425E93ED3101#22120 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#22198, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#22121L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#22199L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#22122L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#22200L]