============================================================================ USER COMMAND: SELECT res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime FROM (((#tmp_results AS res INNER JOIN iziswh.wh_P_PharmaOrder AS po ON po.PatientID = res.admissionid AND po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart) AND po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart) AND po.Status <> 2) INNER JOIN iziswh.wh_P_Pharmas AS ph ON ph.OrderNumber = po.OrderNumber) INNER JOIN iziswh.wh_P_DailyOrderSchedule AS dos ON dos.OrderNumber = po.OrderNumber AND dos.PharmaID = ph.PharmaID) INNER JOIN izisprod.prod_S_PharmaRef AS pr ON pr.PharmaID = ph.PharmaID AND pr.GenericName = 'vancomycine hydrochloride' WHERE EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1) ORDER BY res.admissionid, res.periodgroup, po.OrderTime ---------------------------------------------------------------------------- OPTIMIZE: SELECT res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime FROM (((#tmp_results AS res INNER JOIN iziswh.wh_P_PharmaOrder AS po ON po.PatientID = res.admissionid AND po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart) AND po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart) AND po.Status <> 2) INNER JOIN iziswh.wh_P_Pharmas AS ph ON ph.OrderNumber = po.OrderNumber) INNER JOIN iziswh.wh_P_DailyOrderSchedule AS dos ON dos.OrderNumber = po.OrderNumber AND dos.PharmaID = ph.PharmaID) INNER JOIN izisprod.prod_S_PharmaRef AS pr ON pr.PharmaID = ph.PharmaID AND pr.GenericName = 'vancomycine hydrochloride' WHERE EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1) ORDER BY res.admissionid, res.periodgroup, po.OrderTime ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime FROM (((#tmp_results AS res INNER JOIN iziswh.wh_P_PharmaOrder AS po ON po.PatientID = res.admissionid AND po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart) AND po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart) AND po.Status <> 2) INNER JOIN iziswh.wh_P_Pharmas AS ph ON ph.OrderNumber = po.OrderNumber) INNER JOIN iziswh.wh_P_DailyOrderSchedule AS dos ON dos.OrderNumber = po.OrderNumber AND dos.PharmaID = ph.PharmaID) INNER JOIN izisprod.prod_S_PharmaRef AS pr ON pr.PharmaID = ph.PharmaID AND pr.GenericName = 'vancomycine hydrochloride' WHERE EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1) ORDER BY res.admissionid, res.periodgroup, po.OrderTime CANONICAL PLAN: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1)}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, pr.GenericName = 'vancomycine hydrochloride']}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart), po.Status <> 2]}) Source(groups=[#tmp_results AS res]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ---------------------------------------------------------------------------- OPTIMIZE: SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1 CANONICAL PLAN: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true}) Project(groups=[], props={PROJECT_COLS=[1]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=phr.PharmaID = ph.PharmaID}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=phr.OrderNumber = ph.OrderNumber}) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING PlaceAccess AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true}) Project(groups=[], props={PROJECT_COLS=[1]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=phr.PharmaID = ph.PharmaID}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=phr.OrderNumber = ph.OrderNumber}) Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Project(groups=[], props={PROJECT_COLS=[1]}) Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=(phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID)}) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=null}) Project(groups=[], props={PROJECT_COLS=[1], OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=(phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID), OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_PharmaRec AS phr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=null}) Project(groups=[], props={PROJECT_COLS=[1], OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=(phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID), OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING PushLimit AFTER: Access(groups=[iziswh.wh_P_PharmaRec AS phr]) TupleLimit(groups=[]) Project(groups=[]) Select(groups=[iziswh.wh_P_PharmaRec AS phr]) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING AssignOutputElements AFTER: Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[1]}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[1]}) Project(groups=[], props={PROJECT_COLS=[1], OUTPUT_COLS=[1]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=(phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID), OUTPUT_COLS=[]}) Source(groups=[iziswh.wh_P_PharmaRec AS phr], props={OUTPUT_COLS=[phr.OrderNumber, phr.PharmaID]}) ============================================================================ EXECUTING CalculateCost AFTER: Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[1], EST_CARDINALITY=1.0, EST_COL_STATS={1=[1.0, 1.0]}}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[1], EST_CARDINALITY=1.0, EST_COL_STATS={1=[1.0, 1.0]}}) Project(groups=[], props={PROJECT_COLS=[1], OUTPUT_COLS=[1], EST_CARDINALITY=3.9980574, EST_COL_STATS={1=[1.0, 1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=(phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID), OUTPUT_COLS=[], EST_CARDINALITY=3.9980574, EST_COL_STATS={}}) Source(groups=[iziswh.wh_P_PharmaRec AS phr], props={OUTPUT_COLS=[phr.OrderNumber, phr.PharmaID], EST_COL_STATS={phr.OrderNumber=[-1.0, -1.0], phr.PharmaID=[-1.0, -1.0]}, EST_CARDINALITY=5.5E7}) ============================================================================ EXECUTING MergeCriteria AFTER: Access(groups=[iziswh.wh_P_PharmaRec AS phr]) TupleLimit(groups=[]) Project(groups=[]) Select(groups=[iziswh.wh_P_PharmaRec AS phr]) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING PlanSorts AFTER: Access(groups=[iziswh.wh_P_PharmaRec AS phr]) TupleLimit(groups=[]) Project(groups=[]) Select(groups=[iziswh.wh_P_PharmaRec AS phr]) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING CollapseSource AFTER: Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[1], EST_CARDINALITY=1.0, EST_COL_STATS={1=[1.0, 1.0]}, ATOMIC_REQUEST=SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = AccessNode(0) output=[1] SELECT 1 AS c_0 FROM iziswh.wh_P_PharmaRec AS g_0 WHERE (g_0.OrderNumber = ph.OrderNumber) AND (g_0.PharmaID = ph.PharmaID) LIMIT 1 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(0) output=[1] SELECT 1 AS c_0 FROM iziswh.wh_P_PharmaRec AS g_0 WHERE (g_0.OrderNumber = ph.OrderNumber) AND (g_0.PharmaID = ph.PharmaID) LIMIT 1 ============================================================================ ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1)}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, pr.GenericName = 'vancomycine hydrochloride']}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart), po.Status <> 2]}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__}) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, pr.GenericName = 'vancomycine hydrochloride']}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1)}) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)]}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2}) Access(groups=[iziswh.wh_P_PharmaOrder AS po], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride'}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)]}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride'}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=null}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaOrder AS po], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], 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_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], 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_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING CopyCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING RaiseAccess AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], 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_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING CopyCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=null}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaOrder AS po], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], 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_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=null}) Select(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart), EST_SELECTIVITY=0.33333334}) Select(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), EST_SELECTIVITY=0.33333334}) Select(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID = res.admissionid, EST_SELECTIVITY=0.12577777}) Select(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={SELECT_CRITERIA=dos.PharmaID = pr.PharmaID, EST_SELECTIVITY=0.12577777}) Select(groups=[iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.PharmaID = ph.PharmaID, EST_SELECTIVITY=0.12577777}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, ph.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=null, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=15.999957, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=null, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=null, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=null, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=null, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=null}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)]}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID]}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) ============================================================================ EXECUTING RaiseAccess AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)]}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID]}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[po.PatientID], RIGHT_EXPRESSIONS=[res.admissionid], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)]}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], LEFT_EXPRESSIONS=[ph.PharmaID], RIGHT_EXPRESSIONS=[pr.PharmaID], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) ============================================================================ EXECUTING ChooseDependent AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id8393}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=null, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], LEFT_EXPRESSIONS=[pr.PharmaID], RIGHT_EXPRESSIONS=[ph.PharmaID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=28.78788, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8394}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=null, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=ph.PharmaID IN (), IS_DEPENDENT_SET=true}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, ph.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=null, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=15.999957, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=null, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=null, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id8393}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], LEFT_EXPRESSIONS=[pr.PharmaID], RIGHT_EXPRESSIONS=[ph.PharmaID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=28.78788, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8394}) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=ph.PharmaID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true}) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, ph.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=15.999957, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=null}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=null}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id8393, OUTPUT_COLS=null}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=null, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], LEFT_EXPRESSIONS=[pr.PharmaID], RIGHT_EXPRESSIONS=[ph.PharmaID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=28.78788, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8394, OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=null, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=ph.PharmaID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null}) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, ph.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=null, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=15.999957, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=null, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=null, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], UNRELATED_SORT=false}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id8393, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], LEFT_EXPRESSIONS=[pr.PharmaID], RIGHT_EXPRESSIONS=[ph.PharmaID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=28.78788, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8394, OUTPUT_COLS=[po.PatientID, po.StartTime, ph.PharmaID, ph.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=[pr.GenericName, pr.PharmaID, pr.PharmaName], EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=ph.PharmaID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[po.PatientID, ph.PharmaID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, ph.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=[po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=[po.Status, po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=15.999957, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=[dos.OrderNumber, ph.OrderNumber, ph.PharmaID, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=[dos.PharmaID, dos.OrderNumber, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.PatientID, dos.PlannedTime], EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING CalculateCost AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], UNRELATED_SORT=false, EST_CARDINALITY=47.86555, EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_CARDINALITY=47.86555, EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=47.86555, DEPENDENT_VALUE_SOURCE=$dsc/id8393, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], LEFT_EXPRESSIONS=[pr.PharmaID], RIGHT_EXPRESSIONS=[ph.PharmaID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=28.78788, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8394, OUTPUT_COLS=[po.PatientID, po.StartTime, ph.PharmaID, ph.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=[pr.GenericName, pr.PharmaID, pr.PharmaName], EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={ph.PharmaID=[-1.0, -1.0], po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_CARDINALITY=1.0, EST_COL_STATS={ph.PharmaID=[-1.0, -1.0], po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=ph.PharmaID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[po.PatientID, ph.PharmaID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_CARDINALITY=1.0, EST_COL_STATS={po.PatientID=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, ph.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=[po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=[po.Status, po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=15.999957, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=[dos.OrderNumber, ph.OrderNumber, ph.PharmaID, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=[dos.PharmaID, dos.OrderNumber, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.PatientID, dos.PlannedTime], EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=47.86555, DEPENDENT_VALUE_SOURCE=$dsc/id8393, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, SORT_LEFT=SORT, SORT_RIGHT=SORT}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], LEFT_EXPRESSIONS=[pr.PharmaID], RIGHT_EXPRESSIONS=[ph.PharmaID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=28.78788, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8394, OUTPUT_COLS=[po.PatientID, po.StartTime, ph.PharmaID, ph.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Sort(groups=[], props={SORT_ORDER=ORDER BY pr.PharmaID, OUTPUT_COLS=[pr.PharmaID, pr.PharmaName]}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=[pr.GenericName, pr.PharmaID, pr.PharmaName], EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={ph.PharmaID=[-1.0, -1.0], po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Sort(groups=[], props={SORT_ORDER=ORDER BY ph.PharmaID, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_CARDINALITY=1.0, EST_COL_STATS={ph.PharmaID=[-1.0, -1.0], po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=ph.PharmaID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[po.PatientID, ph.PharmaID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_CARDINALITY=1.0, EST_COL_STATS={po.PatientID=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, ph.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=1.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=[po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=[po.Status, po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=15.999957, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=[dos.OrderNumber, ph.OrderNumber, ph.PharmaID, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) LIMIT 1), OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=[dos.PharmaID, dos.OrderNumber, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.PatientID, dos.PlannedTime], EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING MergeCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res]) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Sort(groups=[]) Select(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos]) Sort(groups=[]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) ============================================================================ EXECUTING PlanSorts AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], UNRELATED_SORT=false, EST_CARDINALITY=47.86555, EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=47.86555, DEPENDENT_VALUE_SOURCE=$dsc/id8393, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, SORT_LEFT=SORT, SORT_RIGHT=SORT}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], LEFT_EXPRESSIONS=[pr.PharmaID], RIGHT_EXPRESSIONS=[ph.PharmaID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=28.78788, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8394, OUTPUT_COLS=[po.PatientID, po.StartTime, ph.PharmaID, ph.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Sort(groups=[]) Select(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos]) Sort(groups=[]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Join(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) ============================================================================ EXECUTING CollapseSource AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_CARDINALITY=47.86555, EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr, #tmp_results AS res]) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT res.admissionid, res.periodstart, res.periodgroup, res.periodend FROM #tmp_results AS res}) Join(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT pr.PharmaID, pr.PharmaName FROM izisprod.prod_S_PharmaRef AS pr WHERE pr.GenericName = 'vancomycine hydrochloride' ORDER BY pr.PharmaID}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={ph.PharmaID=[-1.0, -1.0], po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime FROM iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos WHERE (dos.PharmaID = ph.PharmaID) AND (dos.OrderNumber = po.OrderNumber) AND (ph.OrderNumber = po.OrderNumber) AND (po.Status <> 2) AND (EXISTS (SELECT 1 AS c_0 FROM iziswh.wh_P_PharmaRec AS g_0 WHERE (g_0.OrderNumber = ph.OrderNumber) AND (g_0.PharmaID = ph.PharmaID))) AND (ph.PharmaID IN ()) AND (po.PatientID IN ()) ORDER BY ph.PharmaID}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = SortNode(1) output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] [SORT] [res.admissionid, res.periodgroup, po.OrderTime] ProjectNode(2) output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] [res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] JoinNode(3) [Dependent] [ENHANCED SORT JOIN (SORT/SORT)] [INNER JOIN] criteria=[res.admissionid=po.PatientID, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)] output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] AccessNode(4) output=[res.admissionid, res.periodstart, res.periodgroup, res.periodend] SELECT #tmp_results.admissionid, #tmp_results.periodstart, #tmp_results.periodgroup, #tmp_results.periodend FROM #tmp_results JoinNode(5) [Dependent] [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [INNER JOIN] criteria=[pr.PharmaID=ph.PharmaID] output=[po.PatientID, po.StartTime, ph.PharmaID, ph.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] AccessNode(6) output=[pr.PharmaID, pr.PharmaName] SELECT g_0.PharmaID AS c_0, g_0.PharmaName AS c_1 FROM izisprod.prod_S_PharmaRef AS g_0 WHERE g_0.GenericName = 'vancomycine hydrochloride' ORDER BY c_0 DependentAccessNode(7) output=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] SELECT g_1.PharmaID AS c_0, g_0.PatientID AS c_1, g_0.StartTime AS c_2, g_1.OrderNumber AS c_3, g_0.OrderTime AS c_4, g_2.Concentration AS c_5, g_2.ConcentrationUnit AS c_6, g_2.Dose AS c_7, g_2.OrderNumber AS c_8, g_2.PatientID AS c_9, g_2.PharmaID AS c_10, g_2.PlannedTime AS c_11 FROM iziswh.wh_P_PharmaOrder AS g_0, iziswh.wh_P_Pharmas AS g_1, iziswh.wh_P_DailyOrderSchedule AS g_2 WHERE (g_2.PharmaID = g_1.PharmaID) AND (g_2.OrderNumber = g_0.OrderNumber) AND (g_1.OrderNumber = g_0.OrderNumber) AND (g_0.Status <> 2) AND (EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS g_3 WHERE (g_3.OrderNumber = g_1.OrderNumber) AND (g_3.PharmaID = g_1.PharmaID))) AND (g_1.PharmaID IN ()) AND (g_0.PatientID IN ()) ORDER BY c_0 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: SortNode(1) output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] [SORT] [res.admissionid, res.periodgroup, po.OrderTime] ProjectNode(2) output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] [res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] JoinNode(3) [Dependent] [ENHANCED SORT JOIN (SORT/SORT)] [INNER JOIN] criteria=[res.admissionid=po.PatientID, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)] output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] AccessNode(4) output=[res.admissionid, res.periodstart, res.periodgroup, res.periodend] SELECT #tmp_results.admissionid, #tmp_results.periodstart, #tmp_results.periodgroup, #tmp_results.periodend FROM #tmp_results JoinNode(5) [Dependent] [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [INNER JOIN] criteria=[pr.PharmaID=ph.PharmaID] output=[po.PatientID, po.StartTime, ph.PharmaID, ph.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] AccessNode(6) output=[pr.PharmaID, pr.PharmaName] SELECT g_0.PharmaID AS c_0, g_0.PharmaName AS c_1 FROM izisprod.prod_S_PharmaRef AS g_0 WHERE g_0.GenericName = 'vancomycine hydrochloride' ORDER BY c_0 DependentAccessNode(7) output=[ph.PharmaID, po.PatientID, po.StartTime, ph.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] SELECT g_1.PharmaID AS c_0, g_0.PatientID AS c_1, g_0.StartTime AS c_2, g_1.OrderNumber AS c_3, g_0.OrderTime AS c_4, g_2.Concentration AS c_5, g_2.ConcentrationUnit AS c_6, g_2.Dose AS c_7, g_2.OrderNumber AS c_8, g_2.PatientID AS c_9, g_2.PharmaID AS c_10, g_2.PlannedTime AS c_11 FROM iziswh.wh_P_PharmaOrder AS g_0, iziswh.wh_P_Pharmas AS g_1, iziswh.wh_P_DailyOrderSchedule AS g_2 WHERE (g_2.PharmaID = g_1.PharmaID) AND (g_2.OrderNumber = g_0.OrderNumber) AND (g_1.OrderNumber = g_0.OrderNumber) AND (g_0.Status <> 2) AND (EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS g_3 WHERE (g_3.OrderNumber = g_1.OrderNumber) AND (g_3.PharmaID = g_1.PharmaID))) AND (g_1.PharmaID IN ()) AND (g_0.PatientID IN ()) ORDER BY c_0 ============================================================================