== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (60)
+- Project (59)
+- Aggregate (58)
+- Project (57)
+- Project (56)
+- Filter (55)
+- Project (54)
+- Project (53)
+- Project (52)
+- Join (51)
:- Project (41)
: +- Project (40)
: +- Project (39)
: +- Join (38)
: :- Project (26)
: : +- Project (25)
: : +- Project (24)
: : +- SubqueryAlias (23)
: : +- View (22)
: : +- Project (21)
: : +- Union (20)
: : :- Project (6)
: : : +- Project (5)
: : : +- Project (4)
: : : +- LogicalRelation (3)
: : +- Project (19)
: : +- Project (18)
: : +- Project (17)
: : +- Project (16)
: : +- Project (15)
: : +- Project (14)
: : +- Project (13)
: : +- Project (12)
: : +- Project (11)
: : +- Project (10)
: : +- Project (9)
: : +- Project (8)
: : +- LogicalRelation (7)
: +- Project (37)
: +- SubqueryAlias (36)
: +- View (35)
: +- Project (34)
: +- Project (33)
: +- Project (32)
: +- Project (31)
: +- Union (30)
: :- LogicalRelation (27)
: +- Project (29)
: +- LogicalRelation (28)
+- Project (50)
+- SubqueryAlias (49)
+- View (48)
+- Project (47)
+- Project (46)
+- Project (45)
+- Project (44)
+- Project (43)
+- LogicalRelation (42)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `BIOLOGIE_PATIEN_388165180`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#31466, Nom_Usage#31467, Nom_Naissance#31468, Prenom#31469, Sexe#31470, Date_Naissance#31471, N_Identification_National#31472, N_Securite_Social#31473], false
(4) Project
Arguments: [N_Patient_Etablissement#31466 AS N_Patient_Etablissement#31490, Nom_Usage#31467 AS Nom_Usage#31491, Nom_Naissance#31468 AS Nom_Naissance#31492, Prenom#31469 AS Prenom#31493, Sexe#31470 AS Sexe#31494, Date_Naissance#31471 AS Date_Naissance#31495, N_Identification_National#31472 AS N_Identification_National#31496, N_Securite_Social#31473 AS N_Securite_Social#31497]
(5) Project
Arguments: [N_Patient_Etablissement#31490, Nom_Usage#31491, Nom_Naissance#31492, Prenom#31493, Sexe#31494, Date_Naissance#31495, N_Identification_National#31496, N_Securite_Social#31497]
(6) Project
Arguments: [Date_Naissance#31495 AS DATE_NAISSANCE_388125#31515, Nom_Naissance#31492 AS NOM_NAISSANCE_388122#31516, Nom_Usage#31491 AS NOM_USAGE_388121#31517, N_Identification_National#31496 AS N_IDENTIFICATIO_388126#31518, N_Patient_Etablissement#31490 AS N_PATIENT_ETABL_388120#31519, N_Securite_Social#31497 AS N_SECURITE_SOCI_388127#31520, Prenom#31493 AS PRENOM_388123#31521, Sexe#31494 AS SEXE_388124#31522]
(7) LogicalRelation
Arguments: parquet, [IPP#31531, Nom_Usage#31532, Nom_Naissance#31533, Prenom#31534, Sexe-Pat#31535, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539], false
(8) Project
Arguments: [IPP#31531 AS IPP#31549, Nom_Usage#31532, Nom_Naissance#31533, Prenom#31534, Sexe-Pat#31535, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(9) Project
Arguments: [IPP#31549, Nom_Usage#31532 AS Nom_Usage#31560, Nom_Naissance#31533, Prenom#31534, Sexe-Pat#31535, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(10) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31533 AS Nom_Naissance#31570, Prenom#31534, Sexe-Pat#31535, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(11) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31534 AS Prenom#31580, Sexe-Pat#31535, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(12) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31580, Sexe-Pat#31535 AS Sexe-Pat#31590, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(13) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31580, Sexe-Pat#31590, Date_Naissance#31536 AS Date_Naissance#31600, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(14) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31580, Sexe-Pat#31590, Date_Naissance#31600, N_Identification_National#31537 AS N_Identification_National#31610, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(15) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31580, Sexe-Pat#31590, Date_Naissance#31600, N_Identification_National#31610, N_Secu#31538 AS N_Secu#31620, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(16) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31580, Sexe-Pat#31590, Date_Naissance#31600, N_Identification_National#31610, N_Secu#31620, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31630]
(17) Project
Arguments: [IPP#31549 AS IPP#31640, Nom_Usage#31560 AS Nom_Usage#31641, Nom_Naissance#31570 AS Nom_Naissance#31642, Prenom#31580 AS Prenom#31643, Sexe-Pat#31590 AS Sexe-Pat#31644, Date_Naissance#31600 AS Date_Naissance#31645, N_Identification_National#31610 AS N_Identification_National#31646, N_Secu#31620 AS N_Secu#31647, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31630 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31648]
(18) Project
Arguments: [IPP#31640, Nom_Usage#31641, Nom_Naissance#31642, Prenom#31643, Sexe-Pat#31644, Date_Naissance#31645, N_Identification_National#31646, N_Secu#31647, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31648]
(19) Project
Arguments: [Date_Naissance#31645 AS DATE_NAISSANCE_388125#31667, Nom_Naissance#31642 AS NOM_NAISSANCE_388122#31668, Nom_Usage#31641 AS NOM_USAGE_388121#31669, N_Identification_National#31646 AS N_IDENTIFICATIO_388126#31670, IPP#31640 AS N_PATIENT_ETABL_388120#31671, N_Secu#31647 AS N_SECURITE_SOCI_388127#31672, Prenom#31643 AS PRENOM_388123#31673, cast(str_replace_extend(Sexe-Pat#31644, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#31675]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#31515, NOM_NAISSANCE_388122#31516, NOM_USAGE_388121#31517, N_IDENTIFICATIO_388126#31518, N_PATIENT_ETABL_388120#31519, N_SECURITE_SOCI_388127#31520, PRENOM_388123#31521, SEXE_388124#31522, str_encrypt(N_PATIENT_ETABL_388120#31519) AS ID_PATIENT_388128#31692, str_encrypt(N_PATIENT_ETABL_388120#31519) AS ID_PATIENT_BIS_388129#31693]
(22) View
Arguments: `LES_PATIENTS_388119180`, true
(23) SubqueryAlias
Arguments: LES_PATIENTS_388119180
(24) Project
Arguments: [DATE_NAISSANCE_388125#31515 AS LES_PATIENTS_388119_DATE_NAISSANCE_388125#31962, NOM_NAISSANCE_388122#31516 AS LES_PATIENTS_388119_NOM_NAISSANCE_388122#31963, NOM_USAGE_388121#31517 AS LES_PATIENTS_388119_NOM_USAGE_388121#31964, N_IDENTIFICATIO_388126#31518 AS LES_PATIENTS_388119_N_IDENTIFICATIO_388126#31965, N_PATIENT_ETABL_388120#31519 AS LES_PATIENTS_388119_N_PATIENT_ETABL_388120#31966, N_SECURITE_SOCI_388127#31520 AS LES_PATIENTS_388119_N_SECURITE_SOCI_388127#31967, PRENOM_388123#31521 AS LES_PATIENTS_388119_PRENOM_388123#31968, SEXE_388124#31522 AS LES_PATIENTS_388119_SEXE_388124#31969, ID_PATIENT_388128#31692 AS LES_PATIENTS_388119_ID_PATIENT_388128#31970, ID_PATIENT_BIS_388129#31693 AS LES_PATIENTS_388119_ID_PATIENT_BIS_388129#31971]
(25) Project
Arguments: [cast(LES_PATIENTS_388119_SEXE_388124#31969 as string) AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#31985, cast(LES_PATIENTS_388119_DATE_NAISSANCE_388125#31962 as string) AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#31986, cast(LES_PATIENTS_388119_ID_PATIENT_388128#31970 as string) AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#31987]
(26) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#31985 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#31991, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#31986 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#31992, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#31987 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#31993]
(27) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#31841, N_Sejour#31842, Date_Debut_Sejour#31843, Date_Fin_Sejour#31844, Code_Unite_Medicale#31845, Libelle_Unite_Medicale#31846, Medecin_Responsable#31847], false
(28) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#31879, N_Sejour#31880, Date_Debut_Sejour#31881, Date_Fin_Sejour#31882, Code_Unite_Medicale#31883, Libelle_Unite_Medicale#31884, Medecin_Responsable#31885], false
(29) Project
Arguments: [N_Patient_Etablissement#31879, N_Sejour#31880, Date_Debut_Sejour#31881, Date_Fin_Sejour#31882, Code_Unite_Medicale#31883, Libelle_Unite_Medicale#31884, Medecin_Responsable#31885]
(30) Union
Arguments: false, false
(31) Project
Arguments: [N_Patient_Etablissement#31841 AS N_Patient_Etablissement#31908, N_Sejour#31842 AS N_Sejour#31909, Date_Debut_Sejour#31843 AS Date_Debut_Sejour#31910, Date_Fin_Sejour#31844 AS Date_Fin_Sejour#31911, Code_Unite_Medicale#31845 AS Code_Unite_Medicale#31912, Libelle_Unite_Medicale#31846 AS Libelle_Unite_Medicale#31913, Medecin_Responsable#31847 AS Medecin_Responsable#31914]
(32) Project
Arguments: [N_Patient_Etablissement#31908, N_Sejour#31909, Date_Debut_Sejour#31910, Date_Fin_Sejour#31911, Code_Unite_Medicale#31912, Libelle_Unite_Medicale#31913, Medecin_Responsable#31914]
(33) Project
Arguments: [Code_Unite_Medicale#31912 AS CODE_UNITE_MEDI_388065#31929, cast(Date_Debut_Sejour#31910 as timestamp) AS DATE_DEBUT_SEJO_388063#31930, cast(Date_Fin_Sejour#31911 as timestamp) AS DATE_FIN_SEJOUR_388064#31931, Libelle_Unite_Medicale#31913 AS LIBELLE_UNITE_M_388066#31932, Medecin_Responsable#31914 AS MEDECIN_RESPONS_388067#31933, N_Patient_Etablissement#31908 AS N_PATIENT_ETABL_388061#31934, N_Sejour#31909 AS N_SEJOUR_388062#31935]
(34) Project
Arguments: [CODE_UNITE_MEDI_388065#31929, DATE_DEBUT_SEJO_388063#31930, DATE_FIN_SEJOUR_388064#31931, LIBELLE_UNITE_M_388066#31932, MEDECIN_RESPONS_388067#31933, N_PATIENT_ETABL_388061#31934, N_SEJOUR_388062#31935, str_encrypt(N_PATIENT_ETABL_388061#31934) AS ID_PATIENT_388068#31943]
(35) View
Arguments: `LES_SEJOURS_388060180`, true
(36) SubqueryAlias
Arguments: LES_SEJOURS_388060180
(37) Project
Arguments: [CODE_UNITE_MEDI_388065#31929 AS LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#32005, DATE_DEBUT_SEJO_388063#31930 AS LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#32006, DATE_FIN_SEJOUR_388064#31931 AS LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#32007, LIBELLE_UNITE_M_388066#31932 AS LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#32008, MEDECIN_RESPONS_388067#31933 AS LES_SEJOURS_388060_MEDECIN_RESPONS_388067#32009, N_PATIENT_ETABL_388061#31934 AS LES_SEJOURS_388060_N_PATIENT_ETABL_388061#32010, N_SEJOUR_388062#31935 AS LES_SEJOURS_388060_N_SEJOUR_388062#32011, ID_PATIENT_388068#31943 AS LES_SEJOURS_388060_ID_PATIENT_388068#32012]
(38) Join
Arguments: LeftOuter, (COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#31993 = LES_SEJOURS_388060_ID_PATIENT_388068#32012)
(39) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#31991, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#31992, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#31993, LES_SEJOURS_388060_N_SEJOUR_388062#32011 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32043, LES_SEJOURS_388060_DATE_DEBUT_SEJO_388063#32006 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32044, LES_SEJOURS_388060_DATE_FIN_SEJOUR_388064#32007 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32045, LES_SEJOURS_388060_CODE_UNITE_MEDI_388065#32005 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#32046, LES_SEJOURS_388060_LIBELLE_UNITE_M_388066#32008 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32047, LES_SEJOURS_388060_MEDECIN_RESPONS_388067#32009 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32048]
(40) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#31991 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32058, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#31992 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32059, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#31993 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32060, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32044 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32061, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32045 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32062, COL_0B71585C_6332_4738_A790_07EC5BC1F173#32046 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#32063, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32047 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32064, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32048 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32065, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32043 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32066]
(41) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32058 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32076, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32059 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32077, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32060 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32078, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32061 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32079, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32062 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32080, COL_0B71585C_6332_4738_A790_07EC5BC1F173#32063 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#32081, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32064 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32082, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32065 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32083, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32066 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32084]
(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#31704, N_Patient_Etablissement#31705, N_Sejour#31706, N_Mutation#31707, Date_Prelevement#31708, Code_Analyse#31709, Libelle_Analyse#31710, Valeur#31711, Unite#31712, Valeur_Ref_Min#31713, Valeur_Ref_Max#31714, Statut#31715], false
(43) Project
Arguments: [N_Examen#31704 AS COLL0#31728, N_Patient_Etablissement#31705 AS COLL1#31729, N_Sejour#31706 AS COLL2#31730, N_Mutation#31707 AS COLL3#31731, Date_Prelevement#31708 AS COLL4#31732, Code_Analyse#31709 AS COLL5#31733, Libelle_Analyse#31710 AS COLL6#31734, Valeur#31711 AS COLL7#31735, Unite#31712 AS COLL8#31736, Valeur_Ref_Min#31713 AS COLL9#31737, Valeur_Ref_Max#31714 AS COLL10#31738, Statut#31715 AS COLL11#31739]
(44) Project
Arguments: [COLL0#31728 AS COLL0#31752, COLL1#31729 AS COLL1#31753, COLL2#31730 AS COLL2#31754, COLL3#31731 AS COLL3#31755, COLL4#31732 AS COLL4#31756, COLL5#31733 AS COLL5#31757, COLL6#31734 AS COLL6#31758, COLL7#31735 AS COLL7#31759, COLL8#31736 AS COLL8#31760, COLL9#31737 AS COLL9#31761, COLL10#31738 AS COLL10#31762, COLL11#31739 AS COLL11#31763]
(45) Project
Arguments: [COLL0#31752, COLL1#31753, COLL2#31754, COLL3#31755, COLL4#31756, COLL5#31757, COLL6#31758, COLL7#31759, COLL8#31760, COLL9#31761, COLL10#31762, COLL11#31763]
(46) Project
Arguments: [COLL5#31757 AS CODE_ANALYSE_388136#31788, COLL4#31756 AS DATE_PRELEVEMEN_388135#31789, COLL6#31758 AS LIBELLE_ANALYSE_388137#31790, COLL0#31752 AS N_EXAMEN_388131#31791, COLL3#31755 AS N_MUTATION_388134#31792, COLL1#31753 AS N_PATIENT_ETABL_388132#31793, COLL2#31754 AS N_SEJOUR_388133#31794, COLL11#31763 AS STATUT_388142#31795, COLL8#31760 AS UNITE_388139#31796, COLL7#31759 AS VALEUR_388138#31797, COLL10#31762 AS VALEUR_REF_MAX_388141#31798, COLL9#31761 AS VALEUR_REF_MIN_388140#31799]
(47) Project
Arguments: [CODE_ANALYSE_388136#31788, DATE_PRELEVEMEN_388135#31789, LIBELLE_ANALYSE_388137#31790, N_EXAMEN_388131#31791, N_MUTATION_388134#31792, N_PATIENT_ETABL_388132#31793, N_SEJOUR_388133#31794, STATUT_388142#31795, UNITE_388139#31796, VALEUR_388138#31797, VALEUR_REF_MAX_388141#31798, VALEUR_REF_MIN_388140#31799]
(48) View
Arguments: `BIOLOGIE_PATIEN_388130180`, true
(49) SubqueryAlias
Arguments: BIOLOGIE_PATIEN_388130180
(50) Project
Arguments: [CODE_ANALYSE_388136#31788 AS BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#32106, DATE_PRELEVEMEN_388135#31789 AS BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#32107, LIBELLE_ANALYSE_388137#31790 AS BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#32108, N_EXAMEN_388131#31791 AS BIOLOGIE_PATIEN_388130_N_EXAMEN_388131#32109, N_MUTATION_388134#31792 AS BIOLOGIE_PATIEN_388130_N_MUTATION_388134#32110, N_PATIENT_ETABL_388132#31793 AS BIOLOGIE_PATIEN_388130_N_PATIENT_ETABL_388132#32111, N_SEJOUR_388133#31794 AS BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#32112, STATUT_388142#31795 AS BIOLOGIE_PATIEN_388130_STATUT_388142#32113, UNITE_388139#31796 AS BIOLOGIE_PATIEN_388130_UNITE_388139#32114, VALEUR_388138#31797 AS BIOLOGIE_PATIEN_388130_VALEUR_388138#32115, VALEUR_REF_MAX_388141#31798 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#32116, VALEUR_REF_MIN_388140#31799 AS BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#32117]
(51) Join
Arguments: Inner, (COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32084 = BIOLOGIE_PATIEN_388130_N_SEJOUR_388133#32112)
(52) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32076, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32077, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32078, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32079, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32080, COL_0B71585C_6332_4738_A790_07EC5BC1F173#32081, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32082, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32083, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32084, BIOLOGIE_PATIEN_388130_DATE_PRELEVEMEN_388135#32107 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32172, BIOLOGIE_PATIEN_388130_CODE_ANALYSE_388136#32106 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#32173, BIOLOGIE_PATIEN_388130_LIBELLE_ANALYSE_388137#32108 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#32174, BIOLOGIE_PATIEN_388130_VALEUR_388138#32115 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#32175, BIOLOGIE_PATIEN_388130_UNITE_388139#32114 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#32176, BIOLOGIE_PATIEN_388130_VALEUR_REF_MIN_388140#32117 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#32177, BIOLOGIE_PATIEN_388130_VALEUR_REF_MAX_388141#32116 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#32178, BIOLOGIE_PATIEN_388130_STATUT_388142#32113 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#32179]
(53) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32076, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32077, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32078, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32079, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32080, COL_0B71585C_6332_4738_A790_07EC5BC1F173#32081, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32082, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32083, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32084, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32172, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#32173, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#32174, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#32175, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#32176, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#32177, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#32178, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#32179, date_diff(cast(MINUTE as string), COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32172, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32079) AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#32197L]
(54) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32076, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32077, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32078, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32079, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32080, COL_0B71585C_6332_4738_A790_07EC5BC1F173#32081, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32082, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32083, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32084, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32172, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#32173, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#32174, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#32175, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#32176, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#32177, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#32178, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#32179, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#32197L, date_diff(cast(MINUTE as string), COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32080, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32172) AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#32216L]
(55) Filter
Arguments: (CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32083, cast(SIMON as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32083, cast(SIMON as string)) END OR CASE WHEN isnull(Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32083, cast(DUPONT as string))) THEN false ELSE Contains(COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32083, cast(DUPONT as string)) END)
(56) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32076 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32236, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32077 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32237, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32078 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32238, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32079 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32239, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32080 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32240, COL_0B71585C_6332_4738_A790_07EC5BC1F173#32081 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#32241, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32082 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32242, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32083 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32243, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32084 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32244, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32172 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32245, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#32173 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#32246, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#32174 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#32247, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#32175 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#32248, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#32176 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#32249, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#32177 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#32250, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#32178 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#32251, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#32179 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#32252, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#32197L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#32253L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#32216L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#32254L]
(57) Project
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32236 AS COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32274, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32237 AS COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32275, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32238 AS COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32276, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32239 AS COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32277, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32240 AS COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32278, COL_0B71585C_6332_4738_A790_07EC5BC1F173#32241 AS COL_0B71585C_6332_4738_A790_07EC5BC1F173#32279, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32242 AS COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32280, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32243 AS COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32281, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32244 AS COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32282, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32245 AS COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32283, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#32246 AS COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#32284, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#32247 AS COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#32285, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#32248 AS COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#32286, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#32249 AS COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#32287, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#32250 AS COL_4A919C45_D9DB_491B_84CE_AED7550C7537#32288, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#32251 AS COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#32289, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#32252 AS COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#32290, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#32253L AS COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#32291L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#32254L AS COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#32292L]
(58) Aggregate
Arguments: [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32274, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32275, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32276, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32277, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32278, COL_0B71585C_6332_4738_A790_07EC5BC1F173#32279, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32280, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32281, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32282, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32283, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#32284, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#32285, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#32286, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#32287, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#32288, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#32289, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#32290, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#32291L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#32292L], [COL_E104352C_6BD2_4BEA_90F9_09D5B947DBA5#32274 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#32312, COL_6EF5E8B6_4E12_42F7_97F8_7F18B521AC11#32275 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#32313, COL_FCC795C2_63F2_4F84_850F_F0D07312BEC7#32276 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#32314, COL_55C08FDA_E0C0_4BCD_8C57_EAE939A70055#32277 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#32315, COL_6A3A284D_B48F_4E20_BAC8_23BCC100595D#32278 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#32316, COL_0B71585C_6332_4738_A790_07EC5BC1F173#32279 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#32317, COL_652FEB04_858F_4CC1_99BC_51E9B2952E4B#32280 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#32318, COL_DF9E72B0_21E6_4540_ACFD_1137AA53ABF7#32281 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#32319, COL_955D5497_99FD_42BC_B435_98B1FFF6F635#32282 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#32320, COL_46FA8E68_4A9B_4128_997C_B17F45599E34#32283 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#32321, COL_82614C13_4E42_45E4_9B77_8F2237ECC5A1#32284 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#32322, COL_968D5DCB_8AB8_48EC_AE65_6356F491F3D4#32285 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#32323, COL_DF2A39F3_C24A_4986_A06C_44B4950BFEB7#32286 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#32324, COL_03BF3785_AC30_4C94_B04F_123D7D0C368B#32287 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#32325, COL_4A919C45_D9DB_491B_84CE_AED7550C7537#32288 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#32326, COL_A60ADF7C_1D3C_4D68_8E57_9AE0BF57AA41#32289 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#32327, COL_3AA00C54_A0A0_4DEA_87EE_D0C0119927D3#32290 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#32328, COL_D7EC1076_13A7_4A6E_9CA8_56523330C9EA#32291L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#32329L, COL_E8CF3FC3_7210_440A_A467_0E68F5BF2081#32292L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#32330L, 1 AS NULL_1#32350]
(59) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#32312, COL_53BB3EE9_8890_4C91_B227_683FABF95657#32313, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#32314, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#32315, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#32316, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#32317, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#32318, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#32319, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#32320, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#32321, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#32322, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#32323, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#32324, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#32325, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#32326, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#32327, COL_155D490C_35A1_496B_88D3_425E93ED3101#32328, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#32329L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#32330L]
(60) Project
Arguments: [COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#32312 AS COL_E0B6D7B9_C750_40B0_AB0B_3D3A8C3F1488#32390, COL_53BB3EE9_8890_4C91_B227_683FABF95657#32313 AS COL_53BB3EE9_8890_4C91_B227_683FABF95657#32391, COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#32314 AS COL_C563D90C_3D52_4CCB_9163_EE3D301432C6#32392, COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#32315 AS COL_692127C5_DD1E_48F4_8B5E_513D16FF4DC8#32393, COL_F5750F25_A92C_408A_97C4_117D2536A0AB#32316 AS COL_F5750F25_A92C_408A_97C4_117D2536A0AB#32394, COL_5167F6A1_86C8_4CD5_9072_424229C297D1#32317 AS COL_5167F6A1_86C8_4CD5_9072_424229C297D1#32395, COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#32318 AS COL_4913FDB0_56E4_4512_9A93_C02DCF748E1D#32396, COL_C3C35BE1_E087_4848_B69F_E384965FECE7#32319 AS COL_C3C35BE1_E087_4848_B69F_E384965FECE7#32397, COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#32320 AS COL_0D8109AB_CF2C_4EF1_AAAD_A63DB0D7CC10#32398, COL_A9E45155_EFA6_4F78_8F04_8B6602830423#32321 AS COL_A9E45155_EFA6_4F78_8F04_8B6602830423#32399, COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#32322 AS COL_313C3B01_EF5B_445A_B2DE_D4853B2BA5E8#32400, COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#32323 AS COL_17AE2EBD_7D82_4B97_BB55_70F3D95FE00C#32401, COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#32324 AS COL_05523D85_F4A6_4558_9B2C_CFE9C288DEE9#32402, COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#32325 AS COL_38B75BC2_5576_44D1_8E8E_61A7F414E63C#32403, COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#32326 AS COL_314B7367_6F22_4AC7_BCD6_006D4E59D916#32404, COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#32327 AS COL_6D66E0F2_B298_4ED8_AD89_97D895B07903#32405, COL_155D490C_35A1_496B_88D3_425E93ED3101#32328 AS COL_155D490C_35A1_496B_88D3_425E93ED3101#32406, COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#32329L AS COL_34E2611E_F282_43FE_8BAF_7CD4DD265CE1#32407L, COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#32330L AS COL_CD655C2B_3F63_452B_84D2_FA4C7D40A046#32408L]