== 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_388165177`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#26362, Nom_Usage#26363, Nom_Naissance#26364, Prenom#26365, Sexe#26366, Date_Naissance#26367, N_Identification_National#26368, N_Securite_Social#26369], false
(4) Project
Arguments: [N_Patient_Etablissement#26362 AS N_Patient_Etablissement#26386, Nom_Usage#26363 AS Nom_Usage#26387, Nom_Naissance#26364 AS Nom_Naissance#26388, Prenom#26365 AS Prenom#26389, Sexe#26366 AS Sexe#26390, Date_Naissance#26367 AS Date_Naissance#26391, N_Identification_National#26368 AS N_Identification_National#26392, N_Securite_Social#26369 AS N_Securite_Social#26393]
(5) Project
Arguments: [N_Patient_Etablissement#26386, Nom_Usage#26387, Nom_Naissance#26388, Prenom#26389, Sexe#26390, Date_Naissance#26391, N_Identification_National#26392, N_Securite_Social#26393]
(6) Project
Arguments: [Date_Naissance#26391 AS DATE_NAISSANCE_388125#26411, Nom_Naissance#26388 AS NOM_NAISSANCE_388122#26412, Nom_Usage#26387 AS NOM_USAGE_388121#26413, N_Identification_National#26392 AS N_IDENTIFICATIO_388126#26414, N_Patient_Etablissement#26386 AS N_PATIENT_ETABL_388120#26415, N_Securite_Social#26393 AS N_SECURITE_SOCI_388127#26416, Prenom#26389 AS PRENOM_388123#26417, Sexe#26390 AS SEXE_388124#26418]
(7) LogicalRelation
Arguments: parquet, [IPP#26427, Nom_Usage#26428, Nom_Naissance#26429, Prenom#26430, Sexe-Pat#26431, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435], false
(8) Project
Arguments: [IPP#26427 AS IPP#26445, Nom_Usage#26428, Nom_Naissance#26429, Prenom#26430, Sexe-Pat#26431, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(9) Project
Arguments: [IPP#26445, Nom_Usage#26428 AS Nom_Usage#26456, Nom_Naissance#26429, Prenom#26430, Sexe-Pat#26431, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(10) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26429 AS Nom_Naissance#26466, Prenom#26430, Sexe-Pat#26431, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(11) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26430 AS Prenom#26476, Sexe-Pat#26431, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(12) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26476, Sexe-Pat#26431 AS Sexe-Pat#26486, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(13) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26476, Sexe-Pat#26486, Date_Naissance#26432 AS Date_Naissance#26496, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(14) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26476, Sexe-Pat#26486, Date_Naissance#26496, N_Identification_National#26433 AS N_Identification_National#26506, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(15) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26476, Sexe-Pat#26486, Date_Naissance#26496, N_Identification_National#26506, N_Secu#26434 AS N_Secu#26516, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(16) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26476, Sexe-Pat#26486, Date_Naissance#26496, N_Identification_National#26506, N_Secu#26516, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26526]
(17) Project
Arguments: [IPP#26445 AS IPP#26536, Nom_Usage#26456 AS Nom_Usage#26537, Nom_Naissance#26466 AS Nom_Naissance#26538, Prenom#26476 AS Prenom#26539, Sexe-Pat#26486 AS Sexe-Pat#26540, Date_Naissance#26496 AS Date_Naissance#26541, N_Identification_National#26506 AS N_Identification_National#26542, N_Secu#26516 AS N_Secu#26543, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26526 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26544]
(18) Project
Arguments: [IPP#26536, Nom_Usage#26537, Nom_Naissance#26538, Prenom#26539, Sexe-Pat#26540, Date_Naissance#26541, N_Identification_National#26542, N_Secu#26543, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26544]
(19) Project
Arguments: [Date_Naissance#26541 AS DATE_NAISSANCE_388125#26563, Nom_Naissance#26538 AS NOM_NAISSANCE_388122#26564, Nom_Usage#26537 AS NOM_USAGE_388121#26565, N_Identification_National#26542 AS N_IDENTIFICATIO_388126#26566, IPP#26536 AS N_PATIENT_ETABL_388120#26567, N_Secu#26543 AS N_SECURITE_SOCI_388127#26568, Prenom#26539 AS PRENOM_388123#26569, cast(str_replace_extend(Sexe-Pat#26540, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#26571]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#26411, NOM_NAISSANCE_388122#26412, NOM_USAGE_388121#26413, N_IDENTIFICATIO_388126#26414, N_PATIENT_ETABL_388120#26415, N_SECURITE_SOCI_388127#26416, PRENOM_388123#26417, SEXE_388124#26418, str_encrypt(N_PATIENT_ETABL_388120#26415) AS ID_PATIENT_388128#26588, str_encrypt(N_PATIENT_ETABL_388120#26415) AS ID_PATIENT_BIS_388129#26589]
(22) View
Arguments: `LES_PATIENTS_388119177`, true
(23) SubqueryAlias
Arguments: LES_PATIENTS_388119177
(24) Project
Arguments: [DATE_NAISSANCE_388125#26411 AS LES_PATIENTS_388119_DATE_NAISSANCE_388125#26858, NOM_NAISSANCE_388122#26412 AS LES_PATIENTS_388119_NOM_NAISSANCE_388122#26859, NOM_USAGE_388121#26413 AS LES_PATIENTS_388119_NOM_USAGE_388121#26860, N_IDENTIFICATIO_388126#26414 AS LES_PATIENTS_388119_N_IDENTIFICATIO_388126#26861, N_PATIENT_ETABL_388120#26415 AS LES_PATIENTS_388119_N_PATIENT_ETABL_388120#26862, N_SECURITE_SOCI_388127#26416 AS LES_PATIENTS_388119_N_SECURITE_SOCI_388127#26863, PRENOM_388123#26417 AS LES_PATIENTS_388119_PRENOM_388123#26864, SEXE_388124#26418 AS LES_PATIENTS_388119_SEXE_388124#26865, ID_PATIENT_388128#26588 AS LES_PATIENTS_388119_ID_PATIENT_388128#26866, ID_PATIENT_BIS_388129#26589 AS LES_PATIENTS_388119_ID_PATIENT_BIS_388129#26867]
(25) Project
Arguments: [cast(LES_PATIENTS_388119_SEXE_388124#26865 as string) AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26881, cast(LES_PATIENTS_388119_DATE_NAISSANCE_388125#26858 as string) AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26882, cast(LES_PATIENTS_388119_ID_PATIENT_388128#26866 as string) AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26883]
(26) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26881 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26887, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26882 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26888, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26883 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26889]
(27) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#26737, N_Sejour#26738, Date_Debut_Sejour#26739, Date_Fin_Sejour#26740, Code_Unite_Medicale#26741, Libelle_Unite_Medicale#26742, Medecin_Responsable#26743], false
(28) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#26775, N_Sejour#26776, Date_Debut_Sejour#26777, Date_Fin_Sejour#26778, Code_Unite_Medicale#26779, Libelle_Unite_Medicale#26780, Medecin_Responsable#26781], false
(29) Project
Arguments: [N_Patient_Etablissement#26775, N_Sejour#26776, Date_Debut_Sejour#26777, Date_Fin_Sejour#26778, Code_Unite_Medicale#26779, Libelle_Unite_Medicale#26780, Medecin_Responsable#26781]
(30) Union
Arguments: false, false
(31) Project
Arguments: [N_Patient_Etablissement#26737 AS N_Patient_Etablissement#26804, N_Sejour#26738 AS N_Sejour#26805, Date_Debut_Sejour#26739 AS Date_Debut_Sejour#26806, Date_Fin_Sejour#26740 AS Date_Fin_Sejour#26807, Code_Unite_Medicale#26741 AS Code_Unite_Medicale#26808, Libelle_Unite_Medicale#26742 AS Libelle_Unite_Medicale#26809, Medecin_Responsable#26743 AS Medecin_Responsable#26810]
(32) Project
Arguments: [N_Patient_Etablissement#26804, N_Sejour#26805, Date_Debut_Sejour#26806, Date_Fin_Sejour#26807, Code_Unite_Medicale#26808, Libelle_Unite_Medicale#26809, Medecin_Responsable#26810]
(33) Project
Arguments: [Code_Unite_Medicale#26808 AS CODE_UNITE_MEDI_388065#26825, cast(Date_Debut_Sejour#26806 as timestamp) AS DATE_DEBUT_SEJO_388063#26826, cast(Date_Fin_Sejour#26807 as timestamp) AS DATE_FIN_SEJOUR_388064#26827, Libelle_Unite_Medicale#26809 AS LIBELLE_UNITE_M_388066#26828, Medecin_Responsable#26810 AS MEDECIN_RESPONS_388067#26829, N_Patient_Etablissement#26804 AS N_PATIENT_ETABL_388061#26830, N_Sejour#26805 AS N_SEJOUR_388062#26831]
(34) Project
Arguments: [CODE_UNITE_MEDI_388065#26825, DATE_DEBUT_SEJO_388063#26826, DATE_FIN_SEJOUR_388064#26827, LIBELLE_UNITE_M_388066#26828, MEDECIN_RESPONS_388067#26829, N_PATIENT_ETABL_388061#26830, N_SEJOUR_388062#26831, str_encrypt(N_PATIENT_ETABL_388061#26830) AS ID_PATIENT_388068#26839]
(35) View
Arguments: `LES_SEJOURS_388060177`, true
(36) SubqueryAlias
Arguments: LES_SEJOURS_388060177
(37) Project
Arguments: [CODE_UNITE_MEDI_388065#26825 AS LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#26901, DATE_DEBUT_SEJO_388063#26826 AS LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#26902, DATE_FIN_SEJOUR_388064#26827 AS LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#26903, LIBELLE_UNITE_M_388066#26828 AS LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#26904, MEDECIN_RESPONS_388067#26829 AS LES_SEJOURS_388060_MEDECIN_RESPONS_388067#26905, N_PATIENT_ETABL_388061#26830 AS LES_SEJOURS_388060_N_PATIENT_ETABL_388061#26906, N_SEJOUR_388062#26831 AS LES_SEJOURS_388060_N_SEJOUR_388062#26907, ID_PATIENT_388068#26839 AS LES_SEJOURS_388060_ID_PATIENT_388068#26908]
(38) Join
Arguments: LeftOuter, (COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26889 = LES_SEJOURS_388060_ID_PATIENT_388068#26908)
(39) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26887, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26888, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26889, LES_SEJOURS_388060_N_SEJOUR_388062#26907 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#26939, LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#26902 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#26940, LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#26903 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#26941, LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#26901 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#26942, LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#26904 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#26943, LES_SEJOURS_388060_MEDECIN_RESPONS_388067#26905 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26944]
(40) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26887 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26954, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26888 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26955, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26889 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26956, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#26940 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#26957, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#26941 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#26958, COL_0B71585C_6332_4738_A790_07EC5BC1F173#26942 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#26959, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#26943 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#26960, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26944 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26961, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#26939 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#26962]
(41) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26954 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26972, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26955 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26973, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26956 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26974, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#26957 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#26975, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#26958 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#26976, COL_0B71585C_6332_4738_A790_07EC5BC1F173#26959 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#26977, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#26960 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#26978, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26961 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26979, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#26962 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#26980]
(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#26600, N_Patient_Etablissement#26601, N_Sejour#26602, N_Mutation#26603, Date_Prelevement#26604, Code_Analyse#26605, Libelle_Analyse#26606, Valeur#26607, Unite#26608, Valeur_Ref_Min#26609, Valeur_Ref_Max#26610, Statut#26611], false
(43) Project
Arguments: [N_Examen#26600 AS COLL0#26624, N_Patient_Etablissement#26601 AS COLL1#26625, N_Sejour#26602 AS COLL2#26626, N_Mutation#26603 AS COLL3#26627, Date_Prelevement#26604 AS COLL4#26628, Code_Analyse#26605 AS COLL5#26629, Libelle_Analyse#26606 AS COLL6#26630, Valeur#26607 AS COLL7#26631, Unite#26608 AS COLL8#26632, Valeur_Ref_Min#26609 AS COLL9#26633, Valeur_Ref_Max#26610 AS COLL10#26634, Statut#26611 AS COLL11#26635]
(44) Project
Arguments: [COLL0#26624 AS COLL0#26648, COLL1#26625 AS COLL1#26649, COLL2#26626 AS COLL2#26650, COLL3#26627 AS COLL3#26651, COLL4#26628 AS COLL4#26652, COLL5#26629 AS COLL5#26653, COLL6#26630 AS COLL6#26654, COLL7#26631 AS COLL7#26655, COLL8#26632 AS COLL8#26656, COLL9#26633 AS COLL9#26657, COLL10#26634 AS COLL10#26658, COLL11#26635 AS COLL11#26659]
(45) Project
Arguments: [COLL0#26648, COLL1#26649, COLL2#26650, COLL3#26651, COLL4#26652, COLL5#26653, COLL6#26654, COLL7#26655, COLL8#26656, COLL9#26657, COLL10#26658, COLL11#26659]
(46) Project
Arguments: [COLL5#26653 AS CODE_ANALYSE_388136#26684, COLL4#26652 AS DATE_PRELEVEMEN_388135#26685, COLL6#26654 AS LIBELLE_ANALYSE_388137#26686, COLL0#26648 AS N_EXAMEN_388131#26687, COLL3#26651 AS N_MUTATION_388134#26688, COLL1#26649 AS N_PATIENT_ETABL_388132#26689, COLL2#26650 AS N_SEJOUR_388133#26690, COLL11#26659 AS STATUT_388142#26691, COLL8#26656 AS UNITE_388139#26692, COLL7#26655 AS VALEUR_388138#26693, COLL10#26658 AS VALEUR_REF_MAX_388141#26694, COLL9#26657 AS VALEUR_REF_MIN_388140#26695]
(47) Project
Arguments: [CODE_ANALYSE_388136#26684, DATE_PRELEVEMEN_388135#26685, LIBELLE_ANALYSE_388137#26686, N_EXAMEN_388131#26687, N_MUTATION_388134#26688, N_PATIENT_ETABL_388132#26689, N_SEJOUR_388133#26690, STATUT_388142#26691, UNITE_388139#26692, VALEUR_388138#26693, VALEUR_REF_MAX_388141#26694, VALEUR_REF_MIN_388140#26695]
(48) View
Arguments: `BIOLOGIE_PATIEN_388130177`, true
(49) SubqueryAlias
Arguments: BIOLOGIE_PATIEN_388130177
(50) Project
Arguments: [CODE_ANALYSE_388136#26684 AS BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#27002, DATE_PRELEVEMEN_388135#26685 AS BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#27003, LIBELLE_ANALYSE_388137#26686 AS BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#27004, N_EXAMEN_388131#26687 AS BIOLOGIE_PATIEN_388130_N_EXAMEN_388131#27005, N_MUTATION_388134#26688 AS BIOLOGIE_PATIEN_388130_N_MUTATION_388134#27006, N_PATIENT_ETABL_388132#26689 AS BIOLOGIE_PATIEN_388130_N_PATIENT_ETABL_388132#27007, N_SEJOUR_388133#26690 AS BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#27008, STATUT_388142#26691 AS BIOLOGIE_PATIEN_388130_STATUT_388142#27009, UNITE_388139#26692 AS BIOLOGIE_PATIEN_388130_UNITE_388139#27010, VALEUR_388138#26693 AS BIOLOGIE_PATIEN_388130_VALEUR_388138#27011, VALEUR_REF_MAX_388141#26694 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#27012, VALEUR_REF_MIN_388140#26695 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#27013]
(51) Join
Arguments: Inner, (COL_955D5497_99FD_42BC_B435_98B1FFF6F635#26980 = BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#27008)
(52) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26972, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26973, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26974, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#26975, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#26976, COL_0B71585C_6332_4738_A790_07EC5BC1F173#26977, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#26978, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26979, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#26980, BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#27003 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27068, BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#27002 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#27069, BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#27004 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#27070, BIOLOGIE_PATIEN_388130_VALEUR_388138#27011 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#27071, BIOLOGIE_PATIEN_388130_UNITE_388139#27010 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#27072, BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#27013 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#27073, BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#27012 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#27074, BIOLOGIE_PATIEN_388130_STATUT_388142#27009 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#27075]
(53) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26972, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26973, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26974, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#26975, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#26976, COL_0B71585C_6332_4738_A790_07EC5BC1F173#26977, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#26978, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26979, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#26980, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27068, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#27069, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#27070, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#27071, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#27072, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#27073, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#27074, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#27075, date_diff(cast(MINUTE as string), COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27068, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#26975) AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#27093L]
(54) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26972, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26973, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26974, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#26975, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#26976, COL_0B71585C_6332_4738_A790_07EC5BC1F173#26977, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#26978, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26979, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#26980, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27068, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#27069, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#27070, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#27071, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#27072, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#27073, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#27074, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#27075, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#27093L, date_diff(cast(MINUTE as string), COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#26976, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27068) AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#27112L]
(55) Filter
Arguments: (CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26979, cast(SIMON as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26979, cast(SIMON as string)) END OR CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26979, cast(DUPONT as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26979, cast(DUPONT as string)) END)
(56) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#26972 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#27132, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#26973 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#27133, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#26974 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#27134, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#26975 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#27135, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#26976 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#27136, COL_0B71585C_6332_4738_A790_07EC5BC1F173#26977 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#27137, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#26978 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#27138, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#26979 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#27139, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#26980 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#27140, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27068 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27141, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#27069 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#27142, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#27070 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#27143, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#27071 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#27144, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#27072 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#27145, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#27073 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#27146, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#27074 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#27147, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#27075 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#27148, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#27093L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#27149L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#27112L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#27150L]
(57) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#27132 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#27170, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#27133 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#27171, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#27134 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#27172, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#27135 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#27173, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#27136 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#27174, COL_0B71585C_6332_4738_A790_07EC5BC1F173#27137 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#27175, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#27138 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#27176, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#27139 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#27177, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#27140 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#27178, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27141 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27179, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#27142 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#27180, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#27143 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#27181, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#27144 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#27182, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#27145 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#27183, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#27146 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#27184, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#27147 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#27185, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#27148 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#27186, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#27149L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#27187L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#27150L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#27188L]
(58) Aggregate
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#27170, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#27171, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#27172, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#27173, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#27174, COL_0B71585C_6332_4738_A790_07EC5BC1F173#27175, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#27176, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#27177, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#27178, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27179, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#27180, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#27181, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#27182, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#27183, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#27184, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#27185, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#27186, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#27187L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#27188L], [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#27170 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#27208, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#27171 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#27209, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#27172 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#27210, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#27173 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#27211, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#27174 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#27212, COL_0B71585C_6332_4738_A790_07EC5BC1F173#27175 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#27213, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#27176 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#27214, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#27177 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#27215, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#27178 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#27216, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#27179 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#27217, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#27180 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#27218, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#27181 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#27219, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#27182 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#27220, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#27183 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#27221, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#27184 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#27222, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#27185 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#27223, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#27186 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#27224, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#27187L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#27225L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#27188L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#27226L, 1 AS NULL_1#27246]
(59) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#27208, COL_53BB3EE9_8890_4C91_B227_683FABF95657#27209, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#27210, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#27211, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#27212, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#27213, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#27214, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#27215, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#27216, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#27217, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#27218, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#27219, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#27220, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#27221, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#27222, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#27223, COL_155D490C_35A1_496B_88D3_425E93ED3101#27224, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#27225L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#27226L]
(60) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#27208 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#27286, COL_53BB3EE9_8890_4C91_B227_683FABF95657#27209 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#27287, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#27210 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#27288, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#27211 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#27289, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#27212 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#27290, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#27213 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#27291, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#27214 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#27292, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#27215 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#27293, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#27216 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#27294, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#27217 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#27295, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#27218 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#27296, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#27219 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#27297, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#27220 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#27298, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#27221 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#27299, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#27222 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#27300, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#27223 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#27301, COL_155D490C_35A1_496B_88D3_425E93ED3101#27224 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#27302, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#27225L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#27303L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#27226L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#27304L]