[ https://issues.jboss.org/browse/TEIID-4259?page=com.atlassian.jira.plugin... ] Bram Gadeyne commented on TEIID-4259: ------------------------------------- Hi Steven, Upgrading to a newer version in on my schedule for next week or the week after that. I'll make sure to test it then. Here is the query plan: ============================================================================ USER COMMAND: SELECT w.Patientid AS Patientid, formattimestamp(w.ValueTime, 'yyyy-MM-dd HH:mm') AS t2, w.ValueTime AS Tijdstip, MAX(w.Bed) AS Bed, MAX(w.Naam) AS Naam, CASE WHEN convert(MAX(w.opname), date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(MAX(w.opname), date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN COUNT(w.MondZorgAantal) IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN COUNT(w.EvaluatieMond) > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS FROM (SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT obs1.PatientID, obs1.ValueTime, COUNT(*) AS c, pi.PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi.PatientID = obs1.PatientID AND pi.PatientStatusID = 1 AND convert(pi.AdmTime, date) <> convert(now(), date) AND pi.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT obs1.PatientID, obs1.ValueTime, COUNT(*) AS c, pi.PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi.PatientID = obs1.PatientID AND pi.PatientStatusID = 1 AND convert(pi.AdmTime, date) < convert(now(), date) AND pi.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 15005534) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v) AS w GROUP BY w.Patientid, w.ValueTime ORDER BY Bed LIMIT 100 ---------------------------------------------------------------------------- OPTIMIZE: SELECT w.Patientid AS Patientid, formattimestamp(w.ValueTime, 'yyyy-MM-dd HH:mm') AS t2, w.ValueTime AS Tijdstip, MAX(w.Bed) AS Bed, MAX(w.Naam) AS Naam, CASE WHEN convert(MAX(w.opname), date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(MAX(w.opname), date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN COUNT(w.MondZorgAantal) IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN COUNT(w.EvaluatieMond) > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS FROM (SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT obs1.PatientID, obs1.ValueTime, COUNT(*) AS c, pi.PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi.PatientID = obs1.PatientID AND pi.PatientStatusID = 1 AND convert(pi.AdmTime, date) <> convert(now(), date) AND pi.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT obs1.PatientID, obs1.ValueTime, COUNT(*) AS c, pi.PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi.PatientID = obs1.PatientID AND pi.PatientStatusID = 1 AND convert(pi.AdmTime, date) < convert(now(), date) AND pi.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 15005534) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v) AS w GROUP BY w.Patientid, w.ValueTime ORDER BY Bed LIMIT 100 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT w.Patientid AS Patientid, formattimestamp(w.ValueTime, 'yyyy-MM-dd HH:mm') AS t2, w.ValueTime AS Tijdstip, MAX(w.Bed) AS Bed, MAX(w.Naam) AS Naam, CASE WHEN convert(MAX(w.opname), date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(MAX(w.opname), date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN COUNT(w.MondZorgAantal) IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN COUNT(w.EvaluatieMond) > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS FROM (SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT obs1.PatientID, obs1.ValueTime, COUNT(*) AS c, pi.PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi.PatientID = obs1.PatientID AND pi.PatientStatusID = 1 AND convert(pi.AdmTime, date) <> convert(now(), date) AND pi.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT obs1.PatientID, obs1.ValueTime, COUNT(*) AS c, pi.PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi.PatientID = obs1.PatientID AND pi.PatientStatusID = 1 AND convert(pi.AdmTime, date) < convert(now(), date) AND pi.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 15005534) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v) AS w GROUP BY w.Patientid, w.ValueTime ORDER BY Bed LIMIT 100 CANONICAL PLAN: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100}) Sort(groups=[anon_grp2], props={SORT_ORDER=ORDER BY Bed}) Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS]}) Group(groups=[w, anon_grp2], props={GROUP_COLS=[w.Patientid, w.ValueTime], SYMBOL_MAP={anon_grp2.gcol0=w.Patientid, anon_grp2.gcol1=w.ValueTime, anon_grp2.agg0=MAX(w.Bed), anon_grp2.agg1=MAX(w.Naam), anon_grp2.agg2=MAX(w.opname), anon_grp2.agg3=COUNT(w.MondZorgAantal), anon_grp2.agg4=COUNT(w.EvaluatieMond)}}) Source(groups=[w], props={NESTED_COMMAND=SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi.PatientID = obs1.PatientID AND pi.PatientStatusID = 1 AND convert(pi.AdmTime, date) <> convert(now(), date) AND pi.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi.PatientID = obs1.PatientID AND pi.PatientStatusID = 1 AND convert(pi.AdmTime, date) < convert(now(), date) AND pi.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 15005534) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v, SYMBOL_MAP={w.Patientid=pi.PatientID, w.ValueTime=null, w.Bed=pi.BedAbbr, w.Naam=concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)), w.opname=pi.AdmTime, w.MondZorgAantal=null, w.EvaluatieMond=null, w.PatientStatusID=pi.PatientStatusID}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) Project(groups=[izisprod.prod_PV_PatientInfo AS pi], props={PROJECT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID]}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=convert(pi.AdmTime, date) <> convert(now(), date)}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=pi.PatGroupAbbr LIKE 'PICU%'}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=pi.PatientStatusID = 1}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v], props={PROJECT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID]}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi.PatientID = obs1.PatientID AND pi.PatientStatusID = 1 AND convert(pi.AdmTime, date) <> convert(now(), date) AND pi.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v.PatientID=anon_grp0.gcol0, v.ValueTime=anon_grp0.gcol1, v.c=anon_grp0.agg0, v.PatientStatusID=anon_grp0.gcol2}}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID]}) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi, anon_grp0], props={GROUP_COLS=[obs1.PatientID, obs1.ValueTime, pi.PatientStatusID], SYMBOL_MAP={anon_grp0.gcol0=obs1.PatientID, anon_grp0.gcol1=obs1.ValueTime, anon_grp0.gcol2=pi.PatientStatusID, anon_grp0.agg0=COUNT(*)}}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=obs1.VariableID = 30010003}) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi.PatientID = obs1.PatientID, pi.PatientStatusID = 1, convert(pi.AdmTime, date) <> convert(now(), date), pi.PatGroupAbbr LIKE 'PICU%']}) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v], props={PROJECT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v.c AS EvaluatieMond, v.PatientStatusID]}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi.PatientID = obs1.PatientID AND pi.PatientStatusID = 1 AND convert(pi.AdmTime, date) < convert(now(), date) AND pi.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 15005534) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v.PatientID=anon_grp1.gcol0, v.ValueTime=anon_grp1.gcol1, v.c=anon_grp1.agg0, v.PatientStatusID=anon_grp1.gcol2}}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID]}) Group(groups=[izisprod.prod_PV_ObservationVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi, anon_grp1], props={GROUP_COLS=[obs1.PatientID, obs1.ValueTime, pi.PatientStatusID], SYMBOL_MAP={anon_grp1.gcol0=obs1.PatientID, anon_grp1.gcol1=obs1.ValueTime, anon_grp1.gcol2=pi.PatientStatusID, anon_grp1.agg0=COUNT(*)}}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1], props={SELECT_CRITERIA=convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1], props={SELECT_CRITERIA=obs1.VariableID = 15005534}) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi.PatientID = obs1.PatientID, pi.PatientStatusID = 1, convert(pi.AdmTime, date) < convert(now(), date), pi.PatGroupAbbr LIKE 'PICU%']}) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) ============================================================================ EXECUTING PlaceAccess AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100}) Sort(groups=[anon_grp2], props={SORT_ORDER=ORDER BY Bed}) Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS]}) Group(groups=[w, anon_grp2], props={GROUP_COLS=[w.Patientid, w.ValueTime], SYMBOL_MAP={anon_grp2.gcol0=w.Patientid, anon_grp2.gcol1=w.ValueTime, anon_grp2.agg0=MAX(w.Bed), anon_grp2.agg1=MAX(w.Naam), anon_grp2.agg2=MAX(w.opname), anon_grp2.agg3=COUNT(w.MondZorgAantal), anon_grp2.agg4=COUNT(w.EvaluatieMond)}}) Source(groups=[w], props={NESTED_COMMAND=SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v__1.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v, SYMBOL_MAP={w.Patientid=pi.PatientID, w.ValueTime=null, w.Bed=pi.BedAbbr, w.Naam=concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)), w.opname=pi.AdmTime, w.MondZorgAantal=null, w.EvaluatieMond=null, w.PatientStatusID=pi.PatientStatusID}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) Project(groups=[izisprod.prod_PV_PatientInfo AS pi], props={PROJECT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID]}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=convert(pi.AdmTime, date) <> convert(now(), date)}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=pi.PatGroupAbbr LIKE 'PICU%'}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=pi.PatientStatusID = 1}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v], props={PROJECT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID]}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v.PatientID=anon_grp0.gcol0, v.ValueTime=anon_grp0.gcol1, v.c=anon_grp0.agg0, v.PatientStatusID=anon_grp0.gcol2}}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID]}) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1], props={GROUP_COLS=[obs1.PatientID, obs1.ValueTime, pi__1.PatientStatusID], SYMBOL_MAP={anon_grp0.gcol0=obs1.PatientID, anon_grp0.gcol1=obs1.ValueTime, anon_grp0.gcol2=pi__1.PatientStatusID, anon_grp0.agg0=COUNT(*)}}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=obs1.VariableID = 30010003}) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__1.PatientID = obs1.PatientID, pi__1.PatientStatusID = 1, convert(pi__1.AdmTime, date) <> convert(now(), date), pi__1.PatGroupAbbr LIKE 'PICU%']}) Access(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1], props={PROJECT_COLS=[v__1.PatientID AS Patientid, v__1.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v__1.PatientStatusID]}) Source(groups=[v AS v__1], props={NESTED_COMMAND=SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v__1.PatientID=anon_grp1.gcol0, v__1.ValueTime=anon_grp1.gcol1, v__1.c=anon_grp1.agg0, v__1.PatientStatusID=anon_grp1.gcol2}}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID]}) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={GROUP_COLS=[obs1__1.PatientID, obs1__1.ValueTime, pi__2.PatientStatusID], SYMBOL_MAP={anon_grp1.gcol0=obs1__1.PatientID, anon_grp1.gcol1=obs1__1.ValueTime, anon_grp1.gcol2=pi__2.PatientStatusID, anon_grp1.agg0=COUNT(*)}}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SELECT_CRITERIA=convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SELECT_CRITERIA=obs1__1.VariableID = 15005534}) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__2.PatientID = obs1__1.PatientID, pi__2.PatientStatusID = 1, convert(pi__2.AdmTime, date) < convert(now(), date), pi__2.PatGroupAbbr LIKE 'PICU%']}) Access(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING AssignOutputElements AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS]}) Sort(groups=[anon_grp2], props={SORT_ORDER=ORDER BY Bed, OUTPUT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS], UNRELATED_SORT=false}) Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS], OUTPUT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS]}) Group(groups=[w, anon_grp2], props={GROUP_COLS=[w.Patientid, w.ValueTime], SYMBOL_MAP={anon_grp2.gcol0=w.Patientid, anon_grp2.gcol1=w.ValueTime, anon_grp2.agg0=MAX(w.Bed), anon_grp2.agg1=MAX(w.Naam), anon_grp2.agg2=MAX(w.opname), anon_grp2.agg3=COUNT(w.MondZorgAantal), anon_grp2.agg4=COUNT(w.EvaluatieMond)}, OUTPUT_COLS=[anon_grp2.gcol0, anon_grp2.gcol1, anon_grp2.agg0, anon_grp2.agg1, anon_grp2.agg2, anon_grp2.agg3, anon_grp2.agg4]}) Source(groups=[w], props={NESTED_COMMAND=SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v__1.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v, SYMBOL_MAP={w.Patientid=pi.PatientID, w.ValueTime=null, w.Bed=pi.BedAbbr, w.Naam=concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)), w.opname=pi.AdmTime, w.MondZorgAantal=null, w.EvaluatieMond=null, w.PatientStatusID=pi.PatientStatusID}, OUTPUT_COLS=[w.Patientid, w.ValueTime, w.Bed, w.Naam, w.opname, w.MondZorgAantal, w.EvaluatieMond, w.PatientStatusID]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID]}) Project(groups=[izisprod.prod_PV_PatientInfo AS pi], props={PROJECT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID], OUTPUT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID]}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=convert(pi.AdmTime, date) <> convert(now(), date), OUTPUT_COLS=[pi.PatientID, pi.BedAbbr, pi.PatientLastName, pi.PatientFirstName, pi.AdmTime, pi.PatientStatusID]}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=pi.PatGroupAbbr LIKE 'PICU%', OUTPUT_COLS=[pi.AdmTime, pi.PatientID, pi.BedAbbr, pi.PatientLastName, pi.PatientFirstName, pi.PatientStatusID]}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=pi.PatientStatusID = 1, OUTPUT_COLS=[pi.PatGroupAbbr, pi.AdmTime, pi.PatientID, pi.BedAbbr, pi.PatientLastName, pi.PatientFirstName, pi.PatientStatusID]}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pi.PatientStatusID, pi.PatGroupAbbr, pi.AdmTime, pi.PatientID, pi.BedAbbr, pi.PatientLastName, pi.PatientFirstName]}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi], props={OUTPUT_COLS=[pi.PatientStatusID, pi.PatGroupAbbr, pi.AdmTime, pi.PatientID, pi.BedAbbr, pi.PatientLastName, pi.PatientFirstName]}) Project(groups=[v], props={PROJECT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID], OUTPUT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID]}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v.PatientID=anon_grp0.gcol0, v.ValueTime=anon_grp0.gcol1, v.c=anon_grp0.agg0, v.PatientStatusID=anon_grp0.gcol2}, OUTPUT_COLS=[v.PatientID, v.ValueTime, v.c, v.PatientStatusID]}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID], OUTPUT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID]}) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1], props={GROUP_COLS=[obs1.PatientID, obs1.ValueTime, pi__1.PatientStatusID], SYMBOL_MAP={anon_grp0.gcol0=obs1.PatientID, anon_grp0.gcol1=obs1.ValueTime, anon_grp0.gcol2=pi__1.PatientStatusID, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.gcol2]}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date), OUTPUT_COLS=[obs1.PatientID, obs1.ValueTime, pi__1.PatientStatusID]}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=obs1.VariableID = 30010003, OUTPUT_COLS=[obs1.ValueTime, obs1.PatientID, pi__1.PatientStatusID]}) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__1.PatientID = obs1.PatientID, pi__1.PatientStatusID = 1, convert(pi__1.AdmTime, date) <> convert(now(), date), pi__1.PatGroupAbbr LIKE 'PICU%'], OUTPUT_COLS=[obs1.VariableID, obs1.ValueTime, obs1.PatientID, pi__1.PatientStatusID]}) Access(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[obs1.PatientID, obs1.VariableID, obs1.ValueTime]}) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={OUTPUT_COLS=[obs1.PatientID, obs1.VariableID, obs1.ValueTime]}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pi__1.PatientID, pi__1.PatientStatusID, pi__1.AdmTime, pi__1.PatGroupAbbr]}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={OUTPUT_COLS=[pi__1.PatientID, pi__1.PatientStatusID, pi__1.AdmTime, pi__1.PatGroupAbbr]}) Project(groups=[v AS v__1], props={PROJECT_COLS=[v__1.PatientID AS Patientid, v__1.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v__1.PatientStatusID], OUTPUT_COLS=[v__1.PatientID AS Patientid, v__1.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v__1.PatientStatusID]}) Source(groups=[v AS v__1], props={NESTED_COMMAND=SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v__1.PatientID=anon_grp1.gcol0, v__1.ValueTime=anon_grp1.gcol1, v__1.c=anon_grp1.agg0, v__1.PatientStatusID=anon_grp1.gcol2}, OUTPUT_COLS=[v__1.PatientID, v__1.ValueTime, v__1.c, v__1.PatientStatusID]}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID], OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID]}) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={GROUP_COLS=[obs1__1.PatientID, obs1__1.ValueTime, pi__2.PatientStatusID], SYMBOL_MAP={anon_grp1.gcol0=obs1__1.PatientID, anon_grp1.gcol1=obs1__1.ValueTime, anon_grp1.gcol2=pi__2.PatientStatusID, anon_grp1.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.gcol2]}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SELECT_CRITERIA=convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date), OUTPUT_COLS=[obs1__1.PatientID, obs1__1.ValueTime, pi__2.PatientStatusID]}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SELECT_CRITERIA=obs1__1.VariableID = 15005534, OUTPUT_COLS=[obs1__1.ValueTime, obs1__1.PatientID, pi__2.PatientStatusID]}) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__2.PatientID = obs1__1.PatientID, pi__2.PatientStatusID = 1, convert(pi__2.AdmTime, date) < convert(now(), date), pi__2.PatGroupAbbr LIKE 'PICU%'], OUTPUT_COLS=[obs1__1.VariableID, obs1__1.ValueTime, obs1__1.PatientID, pi__2.PatientStatusID]}) Access(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[obs1__1.PatientID, obs1__1.VariableID, obs1__1.ValueTime]}) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={OUTPUT_COLS=[obs1__1.PatientID, obs1__1.VariableID, obs1__1.ValueTime]}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pi__2.PatientID, pi__2.PatientStatusID, pi__2.AdmTime, pi__2.PatGroupAbbr]}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={OUTPUT_COLS=[pi__2.PatientID, pi__2.PatientStatusID, pi__2.AdmTime, pi__2.PatGroupAbbr]}) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi], props={PROJECT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID], OUTPUT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID]}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pi.PatientStatusID, pi.PatGroupAbbr, pi.AdmTime, pi.PatientID, pi.BedAbbr, pi.PatientLastName, pi.PatientFirstName]}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=(pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)), OUTPUT_COLS=[pi.PatientID, pi.BedAbbr, pi.PatientLastName, pi.PatientFirstName, pi.AdmTime, pi.PatientStatusID]}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi], props={OUTPUT_COLS=[pi.PatientStatusID, pi.PatGroupAbbr, pi.AdmTime, pi.PatientID, pi.BedAbbr, pi.PatientLastName, pi.PatientFirstName]}) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1], props={GROUP_COLS=[obs1.PatientID, obs1.ValueTime, pi__1.PatientStatusID], SYMBOL_MAP={anon_grp0.gcol0=obs1.PatientID, anon_grp0.gcol1=obs1.ValueTime, anon_grp0.gcol2=pi__1.PatientStatusID, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, anon_grp0.gcol2]}) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__1.PatientID = obs1.PatientID, pi__1.PatientStatusID = 1, convert(pi__1.AdmTime, date) <> convert(now(), date), pi__1.PatGroupAbbr LIKE 'PICU%'], OUTPUT_COLS=[obs1.VariableID, obs1.ValueTime, obs1.PatientID, pi__1.PatientStatusID]}) Access(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[obs1.PatientID, obs1.VariableID, obs1.ValueTime]}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=(obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=[obs1.PatientID, obs1.ValueTime, pi__1.PatientStatusID]}) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={OUTPUT_COLS=[obs1.PatientID, obs1.VariableID, obs1.ValueTime]}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={GROUP_COLS=[obs1__1.PatientID, obs1__1.ValueTime, pi__2.PatientStatusID], SYMBOL_MAP={anon_grp1.gcol0=obs1__1.PatientID, anon_grp1.gcol1=obs1__1.ValueTime, anon_grp1.gcol2=pi__2.PatientStatusID, anon_grp1.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0, anon_grp1.gcol2]}) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__2.PatientID = obs1__1.PatientID, pi__2.PatientStatusID = 1, convert(pi__2.AdmTime, date) < convert(now(), date), pi__2.PatGroupAbbr LIKE 'PICU%'], OUTPUT_COLS=[obs1__1.VariableID, obs1__1.ValueTime, obs1__1.PatientID, pi__2.PatientStatusID]}) Access(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[obs1__1.PatientID, obs1__1.VariableID, obs1__1.ValueTime]}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SELECT_CRITERIA=(obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=[obs1__1.PatientID, obs1__1.ValueTime, pi__2.PatientStatusID]}) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={OUTPUT_COLS=[obs1__1.PatientID, obs1__1.VariableID, obs1__1.ValueTime]}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING MergeVirtual AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2], props={SORT_ORDER=ORDER BY Bed, OUTPUT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS], UNRELATED_SORT=false}) Project(groups=[anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w], props={NESTED_COMMAND=SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v__1.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v, SYMBOL_MAP={w.Patientid=pi.PatientID, w.ValueTime=null, w.Bed=pi.BedAbbr, w.Naam=concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)), w.opname=pi.AdmTime, w.MondZorgAantal=null, w.EvaluatieMond=null, w.PatientStatusID=pi.PatientStatusID}, OUTPUT_COLS=[w.Patientid, w.ValueTime, w.Bed, w.Naam, w.opname, w.MondZorgAantal, w.EvaluatieMond, w.PatientStatusID]}) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v], props={PROJECT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID], OUTPUT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID]}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v.PatientID=anon_grp0.gcol0, v.ValueTime=anon_grp0.gcol1, v.c=anon_grp0.agg0, v.PatientStatusID=anon_grp0.gcol2}, OUTPUT_COLS=[v.PatientID, v.ValueTime, v.c, v.PatientStatusID]}) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Access(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1], props={PROJECT_COLS=[v__1.PatientID AS Patientid, v__1.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v__1.PatientStatusID], OUTPUT_COLS=[v__1.PatientID AS Patientid, v__1.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v__1.PatientStatusID]}) Source(groups=[v AS v__1], props={NESTED_COMMAND=SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v__1.PatientID=anon_grp1.gcol0, v__1.ValueTime=anon_grp1.gcol1, v__1.c=anon_grp1.agg0, v__1.PatientStatusID=anon_grp1.gcol2}, OUTPUT_COLS=[v__1.PatientID, v__1.ValueTime, v__1.c, v__1.PatientStatusID]}) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Access(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING DecomposeJoin AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__1.PatientID = obs1.PatientID, pi__1.PatientStatusID = 1, convert(pi__1.AdmTime, date) <> convert(now(), date), pi__1.PatGroupAbbr LIKE 'PICU%'], OUTPUT_COLS=[obs1.VariableID, obs1.ValueTime, obs1.PatientID, pi__1.PatientStatusID]}) Access(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__2.PatientID = obs1__1.PatientID, pi__2.PatientStatusID = 1, convert(pi__2.AdmTime, date) < convert(now(), date), pi__2.PatGroupAbbr LIKE 'PICU%'], OUTPUT_COLS=[obs1__1.VariableID, obs1__1.ValueTime, obs1__1.PatientID, pi__2.PatientStatusID]}) Access(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING MergeVirtual AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2], props={SORT_ORDER=ORDER BY Bed, OUTPUT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS], UNRELATED_SORT=false}) Project(groups=[anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w], props={NESTED_COMMAND=SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v__1.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v, SYMBOL_MAP={w.Patientid=pi.PatientID, w.ValueTime=null, w.Bed=pi.BedAbbr, w.Naam=concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)), w.opname=pi.AdmTime, w.MondZorgAantal=null, w.EvaluatieMond=null, w.PatientStatusID=pi.PatientStatusID}, OUTPUT_COLS=[w.Patientid, w.ValueTime, w.Bed, w.Naam, w.opname, w.MondZorgAantal, w.EvaluatieMond, w.PatientStatusID]}) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v], props={PROJECT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID], OUTPUT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID]}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v.PatientID=anon_grp0.gcol0, v.ValueTime=anon_grp0.gcol1, v.c=anon_grp0.agg0, v.PatientStatusID=anon_grp0.gcol2}, OUTPUT_COLS=[v.PatientID, v.ValueTime, v.c, v.PatientStatusID]}) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Access(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1], props={PROJECT_COLS=[v__1.PatientID AS Patientid, v__1.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v__1.PatientStatusID], OUTPUT_COLS=[v__1.PatientID AS Patientid, v__1.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v__1.PatientStatusID]}) Source(groups=[v AS v__1], props={NESTED_COMMAND=SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v__1.PatientID=anon_grp1.gcol0, v__1.ValueTime=anon_grp1.gcol1, v__1.c=anon_grp1.agg0, v__1.PatientStatusID=anon_grp1.gcol2}, OUTPUT_COLS=[v__1.PatientID, v__1.ValueTime, v__1.c, v__1.PatientStatusID]}) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Access(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__1.PatientID = obs1.PatientID], OUTPUT_COLS=[obs1.VariableID, obs1.ValueTime, obs1.PatientID, pi__1.PatientStatusID]}) Access(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SELECT_CRITERIA=pi__1.PatGroupAbbr LIKE 'PICU%'}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SELECT_CRITERIA=convert(pi__1.AdmTime, date) <> convert(now(), date)}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SELECT_CRITERIA=pi__1.PatientStatusID = 1}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pi__1.PatientID, pi__1.PatientStatusID, pi__1.AdmTime, pi__1.PatGroupAbbr]}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__2.PatientID = obs1__1.PatientID], OUTPUT_COLS=[obs1__1.VariableID, obs1__1.ValueTime, obs1__1.PatientID, pi__2.PatientStatusID]}) Access(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SELECT_CRITERIA=pi__2.PatGroupAbbr LIKE 'PICU%'}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SELECT_CRITERIA=convert(pi__2.AdmTime, date) < convert(now(), date)}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SELECT_CRITERIA=pi__2.PatientStatusID = 1}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pi__2.PatientID, pi__2.PatientStatusID, pi__2.AdmTime, pi__2.PatGroupAbbr]}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__1.PatientID = obs1.PatientID], OUTPUT_COLS=[obs1.VariableID, obs1.ValueTime, obs1.PatientID, pi__1.PatientStatusID]}) Access(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pi__1.PatientID, pi__1.PatientStatusID, pi__1.AdmTime, pi__1.PatGroupAbbr]}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SELECT_CRITERIA=(pi__1.PatientStatusID = 1) AND (convert(pi__1.AdmTime, date) <> convert(now(), date)) AND (pi__1.PatGroupAbbr LIKE 'PICU%')}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={OUTPUT_COLS=[pi__1.PatientID, pi__1.PatientStatusID, pi__1.AdmTime, pi__1.PatGroupAbbr]}) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__2.PatientID = obs1__1.PatientID], OUTPUT_COLS=[obs1__1.VariableID, obs1__1.ValueTime, obs1__1.PatientID, pi__2.PatientStatusID]}) Access(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pi__2.PatientID, pi__2.PatientStatusID, pi__2.AdmTime, pi__2.PatGroupAbbr]}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SELECT_CRITERIA=(pi__2.PatientStatusID = 1) AND (convert(pi__2.AdmTime, date) < convert(now(), date)) AND (pi__2.PatGroupAbbr LIKE 'PICU%')}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={OUTPUT_COLS=[pi__2.PatientID, pi__2.PatientStatusID, pi__2.AdmTime, pi__2.PatGroupAbbr]}) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null}) Sort(groups=[anon_grp2], props={SORT_ORDER=ORDER BY Bed, OUTPUT_COLS=null, UNRELATED_SORT=false}) Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS], OUTPUT_COLS=null}) Group(groups=[w, anon_grp2], props={GROUP_COLS=[w.Patientid, w.ValueTime], SYMBOL_MAP={anon_grp2.gcol0=w.Patientid, anon_grp2.gcol1=w.ValueTime, anon_grp2.agg0=MAX(w.Bed), anon_grp2.agg1=MAX(w.Naam), anon_grp2.agg2=MAX(w.opname), anon_grp2.agg3=COUNT(w.MondZorgAantal), anon_grp2.agg4=COUNT(w.EvaluatieMond)}, OUTPUT_COLS=null}) Source(groups=[w], props={NESTED_COMMAND=SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v__1.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v, SYMBOL_MAP={w.Patientid=pi.PatientID, w.ValueTime=null, w.Bed=pi.BedAbbr, w.Naam=concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)), w.opname=pi.AdmTime, w.MondZorgAantal=null, w.EvaluatieMond=null, w.PatientStatusID=pi.PatientStatusID}, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=null}) Project(groups=[izisprod.prod_PV_PatientInfo AS pi], props={PROJECT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID], OUTPUT_COLS=null}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=(pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi], props={OUTPUT_COLS=null}) Project(groups=[v], props={PROJECT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID], OUTPUT_COLS=null}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v.PatientID=anon_grp0.gcol0, v.ValueTime=anon_grp0.gcol1, v.c=anon_grp0.agg0, v.PatientStatusID=anon_grp0.gcol2}, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID], OUTPUT_COLS=null}) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1], props={GROUP_COLS=[obs1.PatientID, obs1.ValueTime, pi__1.PatientStatusID], SYMBOL_MAP={anon_grp0.gcol0=obs1.PatientID, anon_grp0.gcol1=obs1.ValueTime, anon_grp0.gcol2=pi__1.PatientStatusID, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__1.PatientID = obs1.PatientID], OUTPUT_COLS=null}) Access(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=(obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SELECT_CRITERIA=(pi__1.PatientStatusID = 1) AND (convert(pi__1.AdmTime, date) <> convert(now(), date)) AND (pi__1.PatGroupAbbr LIKE 'PICU%'), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={OUTPUT_COLS=null}) Project(groups=[v AS v__1], props={PROJECT_COLS=[v__1.PatientID AS Patientid, v__1.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v__1.PatientStatusID], OUTPUT_COLS=null}) Source(groups=[v AS v__1], props={NESTED_COMMAND=SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v__1.PatientID=anon_grp1.gcol0, v__1.ValueTime=anon_grp1.gcol1, v__1.c=anon_grp1.agg0, v__1.PatientStatusID=anon_grp1.gcol2}, OUTPUT_COLS=null}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID], OUTPUT_COLS=null}) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={GROUP_COLS=[obs1__1.PatientID, obs1__1.ValueTime, pi__2.PatientStatusID], SYMBOL_MAP={anon_grp1.gcol0=obs1__1.PatientID, anon_grp1.gcol1=obs1__1.ValueTime, anon_grp1.gcol2=pi__2.PatientStatusID, anon_grp1.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__2.PatientID = obs1__1.PatientID], OUTPUT_COLS=null}) Access(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SELECT_CRITERIA=(obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SELECT_CRITERIA=(pi__2.PatientStatusID = 1) AND (convert(pi__2.AdmTime, date) < convert(now(), date)) AND (pi__2.PatGroupAbbr LIKE 'PICU%'), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanUnions AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Access(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Access(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Access(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING RaiseAccess LOW [Relational Planner] formattimestamp function not supported by source izisprod - formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') was not pushed AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS], OUTPUT_COLS=null}) Access(groups=[w, anon_grp2], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Group(groups=[w, anon_grp2], props={GROUP_COLS=[w.Patientid, w.ValueTime], SYMBOL_MAP={anon_grp2.gcol0=w.Patientid, anon_grp2.gcol1=w.ValueTime, anon_grp2.agg0=MAX(w.Bed), anon_grp2.agg1=MAX(w.Naam), anon_grp2.agg2=MAX(w.opname), anon_grp2.agg3=COUNT(w.MondZorgAantal), anon_grp2.agg4=COUNT(w.EvaluatieMond)}, OUTPUT_COLS=null}) Source(groups=[w], props={NESTED_COMMAND=SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v__1.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v, SYMBOL_MAP={w.Patientid=pi.PatientID, w.ValueTime=null, w.Bed=pi.BedAbbr, w.Naam=concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)), w.opname=pi.AdmTime, w.MondZorgAantal=null, w.EvaluatieMond=null, w.PatientStatusID=pi.PatientStatusID}, OUTPUT_COLS=null, INLINE_VIEW=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=null}) Project(groups=[izisprod.prod_PV_PatientInfo AS pi], props={PROJECT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID], OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=(pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v], props={PROJECT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID], OUTPUT_COLS=null}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v.PatientID=anon_grp0.gcol0, v.ValueTime=anon_grp0.gcol1, v.c=anon_grp0.agg0, v.PatientStatusID=anon_grp0.gcol2}, OUTPUT_COLS=null, INLINE_VIEW=true}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID], OUTPUT_COLS=null}) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1], props={GROUP_COLS=[obs1.PatientID, obs1.ValueTime, pi__1.PatientStatusID], SYMBOL_MAP={anon_grp0.gcol0=obs1.PatientID, anon_grp0.gcol1=obs1.ValueTime, anon_grp0.gcol2=pi__1.PatientStatusID, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__1.PatientID = obs1.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=(obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SELECT_CRITERIA=(pi__1.PatientStatusID = 1) AND (convert(pi__1.AdmTime, date) <> convert(now(), date)) AND (pi__1.PatGroupAbbr LIKE 'PICU%'), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1], props={PROJECT_COLS=[v__1.PatientID AS Patientid, v__1.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v__1.PatientStatusID], OUTPUT_COLS=null}) Source(groups=[v AS v__1], props={NESTED_COMMAND=SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v__1.PatientID=anon_grp1.gcol0, v__1.ValueTime=anon_grp1.gcol1, v__1.c=anon_grp1.agg0, v__1.PatientStatusID=anon_grp1.gcol2}, OUTPUT_COLS=null, INLINE_VIEW=true}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID], OUTPUT_COLS=null}) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={GROUP_COLS=[obs1__1.PatientID, obs1__1.ValueTime, pi__2.PatientStatusID], SYMBOL_MAP={anon_grp1.gcol0=obs1__1.PatientID, anon_grp1.gcol1=obs1__1.ValueTime, anon_grp1.gcol2=pi__2.PatientStatusID, anon_grp1.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__2.PatientID = obs1__1.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SELECT_CRITERIA=(obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SELECT_CRITERIA=(pi__2.PatientStatusID = 1) AND (convert(pi__2.AdmTime, date) < convert(now(), date)) AND (pi__2.PatGroupAbbr LIKE 'PICU%'), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING CopyCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Access(groups=[w, anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=(pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__1.PatientID = obs1.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=(obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SELECT_CRITERIA=(pi__1.PatientStatusID = 1) AND (convert(pi__1.AdmTime, date) <> convert(now(), date)) AND (pi__1.PatGroupAbbr LIKE 'PICU%'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__2.PatientID = obs1__1.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SELECT_CRITERIA=(obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SELECT_CRITERIA=(pi__2.PatientStatusID = 1) AND (convert(pi__2.AdmTime, date) < convert(now(), date)) AND (pi__2.PatGroupAbbr LIKE 'PICU%'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null}) Sort(groups=[anon_grp2], props={SORT_ORDER=ORDER BY Bed, OUTPUT_COLS=null, UNRELATED_SORT=false}) Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS], OUTPUT_COLS=null}) Access(groups=[w, anon_grp2], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Group(groups=[w, anon_grp2], props={GROUP_COLS=[w.Patientid, w.ValueTime], SYMBOL_MAP={anon_grp2.gcol0=w.Patientid, anon_grp2.gcol1=w.ValueTime, anon_grp2.agg0=MAX(w.Bed), anon_grp2.agg1=MAX(w.Naam), anon_grp2.agg2=MAX(w.opname), anon_grp2.agg3=COUNT(w.MondZorgAantal), anon_grp2.agg4=COUNT(w.EvaluatieMond)}, OUTPUT_COLS=null}) Source(groups=[w], props={NESTED_COMMAND=SELECT pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID FROM izisprod.prod_PV_PatientInfo AS pi WHERE (pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)) UNION SELECT v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v UNION SELECT v__1.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v.PatientStatusID FROM (SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID) AS v, SYMBOL_MAP={w.Patientid=pi.PatientID, w.ValueTime=null, w.Bed=pi.BedAbbr, w.Naam=concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)), w.opname=pi.AdmTime, w.MondZorgAantal=null, w.EvaluatieMond=null, w.PatientStatusID=pi.PatientStatusID}, OUTPUT_COLS=null, INLINE_VIEW=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=null}) Project(groups=[izisprod.prod_PV_PatientInfo AS pi], props={PROJECT_COLS=[pi.PatientID AS Patientid, null AS ValueTime, pi.BedAbbr AS Bed, concat(pi.PatientLastName, concat(', ', pi.PatientFirstName)) AS Naam, pi.AdmTime AS opname, null AS MondZorgAantal, null AS EvaluatieMond, pi.PatientStatusID], OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=(pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi], props={OUTPUT_COLS=null}) Project(groups=[v], props={PROJECT_COLS=[v.PatientID AS Patientid, v.ValueTime, null AS Bed, null AS Naam, null AS opname, v.c AS MondZorgAantal, null AS EvaluatieMond, v.PatientStatusID], OUTPUT_COLS=null}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID FROM izisprod.prod_PV_DerivedVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__1.PatientID = obs1.PatientID AND pi__1.PatientStatusID = 1 AND convert(pi__1.AdmTime, date) <> convert(now(), date) AND pi__1.PatGroupAbbr LIKE 'PICU%' WHERE (obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v.PatientID=anon_grp0.gcol0, v.ValueTime=anon_grp0.gcol1, v.c=anon_grp0.agg0, v.PatientStatusID=anon_grp0.gcol2}, OUTPUT_COLS=null, INLINE_VIEW=true}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS PatientID, anon_grp0.gcol1 AS ValueTime, anon_grp0.agg0 AS c, anon_grp0.gcol2 AS PatientStatusID], OUTPUT_COLS=null}) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1], props={GROUP_COLS=[obs1.PatientID, obs1.ValueTime, pi__1.PatientStatusID], SYMBOL_MAP={anon_grp0.gcol0=obs1.PatientID, anon_grp0.gcol1=obs1.ValueTime, anon_grp0.gcol2=pi__1.PatientStatusID, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__1.PatientID = obs1.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=(obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SELECT_CRITERIA=(pi__1.PatientStatusID = 1) AND (convert(pi__1.AdmTime, date) <> convert(now(), date)) AND (pi__1.PatGroupAbbr LIKE 'PICU%'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={OUTPUT_COLS=null}) Project(groups=[v AS v__1], props={PROJECT_COLS=[v__1.PatientID AS Patientid, v__1.ValueTime, null AS Bed, null AS Naam, null AS opname, null AS MondZorgAantal, v__1.c AS EvaluatieMond, v__1.PatientStatusID], OUTPUT_COLS=null}) Source(groups=[v AS v__1], props={NESTED_COMMAND=SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID FROM izisprod.prod_PV_ObservationVariables AS obs1 INNER JOIN izisprod.prod_PV_PatientInfo AS pi ON pi__2.PatientID = obs1__1.PatientID AND pi__2.PatientStatusID = 1 AND convert(pi__2.AdmTime, date) < convert(now(), date) AND pi__2.PatGroupAbbr LIKE 'PICU%' WHERE (obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)) GROUP BY obs1.PatientID, obs1.ValueTime, pi.PatientStatusID, SYMBOL_MAP={v__1.PatientID=anon_grp1.gcol0, v__1.ValueTime=anon_grp1.gcol1, v__1.c=anon_grp1.agg0, v__1.PatientStatusID=anon_grp1.gcol2}, OUTPUT_COLS=null, INLINE_VIEW=true}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS ValueTime, anon_grp1.agg0 AS c, anon_grp1.gcol2 AS PatientStatusID], OUTPUT_COLS=null}) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={GROUP_COLS=[obs1__1.PatientID, obs1__1.ValueTime, pi__2.PatientStatusID], SYMBOL_MAP={anon_grp1.gcol0=obs1__1.PatientID, anon_grp1.gcol1=obs1__1.ValueTime, anon_grp1.gcol2=pi__2.PatientStatusID, anon_grp1.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pi__2.PatientID = obs1__1.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SELECT_CRITERIA=(obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={OUTPUT_COLS=null}) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SELECT_CRITERIA=(pi__2.PatientStatusID = 1) AND (convert(pi__2.AdmTime, date) < convert(now(), date)) AND (pi__2.PatGroupAbbr LIKE 'PICU%'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Access(groups=[w, anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Access(groups=[w, anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi], props={SELECT_CRITERIA=(pi.PatientStatusID = 1) AND (pi.PatGroupAbbr LIKE 'PICU%') AND (convert(pi.AdmTime, date) <> convert(now(), date)), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1], props={SELECT_CRITERIA=(obs1.VariableID = 30010003) AND (convert(obs1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1], props={SELECT_CRITERIA=(pi__1.PatientStatusID = 1) AND (convert(pi__1.AdmTime, date) <> convert(now(), date)) AND (pi__1.PatGroupAbbr LIKE 'PICU%'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1], props={SELECT_CRITERIA=(obs1__1.VariableID = 15005534) AND (convert(obs1__1.ValueTime, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date)), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2], props={SELECT_CRITERIA=(pi__2.PatientStatusID = 1) AND (convert(pi__2.AdmTime, date) < convert(now(), date)) AND (pi__2.PatGroupAbbr LIKE 'PICU%'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING RaiseAccess LOW [Relational Planner] formattimestamp function not supported by source izisprod - formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') was not pushed AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS Patientid, formattimestamp(anon_grp2.gcol1, 'yyyy-MM-dd HH:mm') AS t2, anon_grp2.gcol1 AS Tijdstip, anon_grp2.agg0 AS Bed, anon_grp2.agg1 AS Naam, CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END AS Opname, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END AS Comfort, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END AS NRS], OUTPUT_COLS=null}) Access(groups=[w, anon_grp2], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Access(groups=[w, anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING ChooseDependent AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Access(groups=[w, anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING PushAggregates AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Access(groups=[w, anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING ChooseDependent AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Access(groups=[w, anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING PushLimit AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null}) Sort(groups=[anon_grp2]) Project(groups=[anon_grp2]) Access(groups=[w, anon_grp2]) Group(groups=[w, anon_grp2]) Source(groups=[w]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[izisprod.prod_PV_PatientInfo AS pi]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi]) Project(groups=[v]) Source(groups=[v]) Project(groups=[anon_grp0]) Group(groups=[izisprod.prod_PV_DerivedVariables AS obs1, anon_grp0, izisprod.prod_PV_PatientInfo AS pi__1]) Join(groups=[izisprod.prod_PV_DerivedVariables AS obs1, izisprod.prod_PV_PatientInfo AS pi__1]) Select(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Source(groups=[izisprod.prod_PV_DerivedVariables AS obs1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__1]) Project(groups=[v AS v__1]) Source(groups=[v AS v__1]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Join(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1, izisprod.prod_PV_PatientInfo AS pi__2]) Select(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Source(groups=[izisprod.prod_PV_ObservationVariables AS obs1__1]) Select(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) Source(groups=[izisprod.prod_PV_PatientInfo AS pi__2]) ============================================================================ EXECUTING AssignOutputElements -- This message was sent by Atlassian JIRA (v6.4.11#64026)