ProjectNode + Relational Node ID:1 + Output Columns:expr1 (integer) + Statistics: 0: Node Output Rows: 1 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 8450 3: Node Cumulative Process Time: 33596 4: Node Next Batch Calls: 392 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 1.0 + Child 0: GroupingNode + Relational Node ID:2 + Output Columns:agg0 (integer) + Statistics: 0: Node Output Rows: 1 1: Node Next Batch Process Time: 2 2: Node Cumulative Next Batch Process Time: 8450 3: Node Cumulative Process Time: 33596 4: Node Next Batch Calls: 392 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 1.0 + Child 0: JoinNode + Relational Node ID:3 + Output Columns + Statistics: 0: Node Output Rows: 11573 1: Node Next Batch Process Time: 1883 2: Node Cumulative Next Batch Process Time: 8448 3: Node Cumulative Process Time: 33596 4: Node Next Batch Calls: 397 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 23.470352 + Child 0: SelectNode + Relational Node ID:4 + Output Columns: 0: PatientID (integer) 1: expr (long) + Statistics: 0: Node Output Rows: 796805 1: Node Next Batch Process Time: 100 2: Node Cumulative Next Batch Process Time: 6564 3: Node Cumulative Process Time: 31727 4: Node Next Batch Calls: 1950 5: Node Blocks: 391 + Child 0: ProjectNode + Relational Node ID:5 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: stringvalue (string) 6: rang (integer) 7: expr (long) + Statistics: 0: Node Output Rows: 798906 1: Node Next Batch Process Time: 388 2: Node Cumulative Next Batch Process Time: 6464 3: Node Cumulative Process Time: 31727 4: Node Next Batch Calls: 1950 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 58892.992 + Child 0: UnionAllNode + Relational Node ID:6 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: stringvalue (string) 6: rang (integer) + Statistics: 0: Node Output Rows: 798906 1: Node Next Batch Process Time: 1 2: Node Cumulative Next Batch Process Time: 6076 3: Node Cumulative Process Time: 31727 4: Node Next Batch Calls: 1950 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 58892.992 + Child 0: ProjectNode + Relational Node ID:7 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: stringvalue (string) 6: rang (integer) + Statistics: 0: Node Output Rows: 2551 1: Node Next Batch Process Time: 1 2: Node Cumulative Next Batch Process Time: 12 3: Node Cumulative Process Time: 45 4: Node Next Batch Calls: 5 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: 492.5751 + Child 0: WindowFunctionProjectNode + Relational Node ID:8 + Output Columns: 0: expr (integer) 1: PatientID (integer) 2: VariableID (integer) 3: DateTime (timestamp) 4: EnterTime (timestamp) 5: Value (double) 6: expr (string) + Statistics: 0: Node Output Rows: 2551 1: Node Next Batch Process Time: 7 2: Node Cumulative Next Batch Process Time: 11 3: Node Cumulative Process Time: 44 4: Node Next Batch Calls: 5 5: Node Blocks: 2 + Child 0: SelectNode + Relational Node ID:9 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: expr (string) + Statistics: 0: Node Output Rows: 2551 1: Node Next Batch Process Time: 3 2: Node Cumulative Next Batch Process Time: 4 3: Node Cumulative Process Time: 36 4: Node Next Batch Calls: 5 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: 492.5751 + Child 0: AccessNode + Relational Node ID:10 + Output Columns: 0: Status (short) 1: PatientID (integer) 2: VariableID (integer) 3: DateTime (timestamp) 4: EnterTime (timestamp) 5: Value (double) 6: expr (string) + Statistics: 0: Node Output Rows: 2555 1: Node Next Batch Process Time: 1 2: Node Cumulative Next Batch Process Time: 1 3: Node Cumulative Process Time: 36 4: Node Next Batch Calls: 5 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: 17741.879 + Query:SELECT g_1.Status, g_1.PatientID, g_1.VariableID, g_1.DateTime, g_1.EnterTime, g_1."Value", CASE WHEN g_1.StringValue IS NULL THEN g_2.StringValue ELSE g_1.StringValue END FROM (izisprod.P_GeneralData AS g_0 INNER JOIN izisprod.P_ObservRec AS g_1 ON g_0.PatientID = g_1.PatientID) LEFT OUTER JOIN izisprod.S_OrdinalRef AS g_2 ON convert(g_2.Code, double) = g_1."Value" AND g_2.VariableID = g_1.VariableID WHERE ((g_0.Status = 1) OR ((g_0.Status >= 4) AND (g_0.Status <> 5))) AND (g_1.VariableID = 15001866) + Model Name:izisprod + Criteria:(bitand(convert(obr__1.Status, integer), 2) <> 2) AND (bitand(convert(obr__1.Status, integer), 8) = 8) + Window Functions:(PARTITION BY obr__1.PatientID, obr__1.VariableID, obr__1.DateTime ORDER BY obr__1.EnterTime DESC) + Select Columns: 0: obr__1.PatientID 1: obr__1.VariableID 2: obr__1.DateTime 3: obr__1.EnterTime 4: obr__1."Value" 5: CASE WHEN obr__1.StringValue IS NULL THEN ordr.StringValue ELSE obr__1.StringValue END AS stringvalue 6: ROW_NUMBER() OVER (PARTITION BY obr__1.PatientID, obr__1.VariableID, obr__1.DateTime ORDER BY obr__1.EnterTime DESC) AS rang + Child 1: ProjectNode + Relational Node ID:11 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: stringvalue (string) 6: rang (integer) + Statistics: 0: Node Output Rows: 796355 1: Node Next Batch Process Time: 195 2: Node Cumulative Next Batch Process Time: 6063 3: Node Cumulative Process Time: 31727 4: Node Next Batch Calls: 1947 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 117421.44 + Child 0: WindowFunctionProjectNode + Relational Node ID:12 + Output Columns: 0: expr (integer) 1: PatientID (integer) 2: VariableID (integer) 3: DateTime (timestamp) 4: EnterTime (timestamp) 5: Value (double) 6: StringValue (string) 7: StringValue (string) + Statistics: 0: Node Output Rows: 796355 1: Node Next Batch Process Time: 4750 2: Node Cumulative Next Batch Process Time: 5868 3: Node Cumulative Process Time: 31723 4: Node Next Batch Calls: 1947 5: Node Blocks: 391 + Child 0: JoinNode + Relational Node ID:13 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: StringValue (string) 6: StringValue (string) + Statistics: 0: Node Output Rows: 796355 1: Node Next Batch Process Time: 155 2: Node Cumulative Next Batch Process Time: 1118 3: Node Cumulative Process Time: 26375 4: Node Next Batch Calls: 1947 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 117421.44 + Child 0: SelectNode + Relational Node ID:14 + Output Columns: 0: Value (double) 1: PatientID (integer) 2: VariableID (integer) 3: DateTime (timestamp) 4: EnterTime (timestamp) 5: StringValue (string) + Statistics: 0: Node Output Rows: 796355 1: Node Next Batch Process Time: 917 2: Node Cumulative Next Batch Process Time: 963 3: Node Cumulative Process Time: 26375 4: Node Next Batch Calls: 1560 5: Node Blocks: 782 + Cost Estimates:Estimated Node Cardinality: 22991.773 + Child 0: AccessNode + Relational Node ID:15 + Output Columns: 0: Status (short) 1: Value (double) 2: PatientID (integer) 3: VariableID (integer) 4: DateTime (timestamp) 5: EnterTime (timestamp) 6: StringValue (string) + Statistics: 0: Node Output Rows: 796620 1: Node Next Batch Process Time: 46 2: Node Cumulative Next Batch Process Time: 46 3: Node Cumulative Process Time: 26374 4: Node Next Batch Calls: 1560 5: Node Blocks: 782 + Cost Estimates:Estimated Node Cardinality: 1347397.9 + Query:SELECT g_1.Status, g_1."Value", g_1.PatientID, g_1.VariableID, g_1.DateTime, g_1.EnterTime, g_1.StringValue FROM iziswh.P_GeneralData AS g_0, iziswh.P_ObservRec AS g_1 WHERE (g_0.PatientID = g_1.PatientID) AND (g_1.VariableID = 15001866) + Model Name:iziswh + Criteria:(bitand(convert(obr__2.Status, integer), 2) <> 2) AND (bitand(convert(obr__2.Status, integer), 8) = 8) + Child 1: ProjectNode + Relational Node ID:16 + Output Columns: 0: Code (integer) 1: StringValue (string) 2: expr (double) + Statistics: 0: Node Output Rows: 0 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 0 3: Node Cumulative Process Time: 0 4: Node Next Batch Calls: 1 5: Node Blocks: 0 + Cost Estimates:Estimated Node Cardinality: 131.15259 + Child 0: AccessNode + Relational Node ID:17 + Output Columns: 0: Code (integer) 1: StringValue (string) + Statistics: 0: Node Output Rows: 0 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 0 3: Node Cumulative Process Time: 0 4: Node Next Batch Calls: 1 5: Node Blocks: 0 + Cost Estimates:Estimated Node Cardinality: 131.15259 + Query:SELECT #MAT_IZISVIEWS.TV_S_ORDINALREF.Code, #MAT_IZISVIEWS.TV_S_ORDINALREF.StringValue FROM #MAT_IZISVIEWS.TV_S_ORDINALREF WHERE #MAT_IZISVIEWS.TV_S_ORDINALREF.VariableID = 15001866 + Model Name:__TEMP__ + Select Columns: 0: Code 1: StringValue 2: convert(Code, double) + Join Strategy:ENHANCED SORT JOIN (SORT/SORT) + Join Type:LEFT OUTER JOIN + Join Criteria:obr__2."Value"=convert(Code, double) + Window Functions:(PARTITION BY obr__2.PatientID, obr__2.VariableID, obr__2.DateTime ORDER BY obr__2.EnterTime DESC) + Select Columns: 0: obr__2.PatientID 1: obr__2.VariableID 2: obr__2.DateTime 3: obr__2.EnterTime 4: obr__2."Value" 5: CASE WHEN obr__2.StringValue IS NULL THEN StringValue ELSE obr__2.StringValue END AS stringvalue 6: ROW_NUMBER() OVER (PARTITION BY obr__2.PatientID, obr__2.VariableID, obr__2.DateTime ORDER BY obr__2.EnterTime DESC) AS rang + Select Columns: 0: v.PatientID 1: v.VariableID 2: v.DateTime 3: v.EnterTime 4: v."Value" 5: v.stringvalue 6: v.rang 7: convert(PatientID, long) + Criteria:v.rang = 1 + Child 1: DependentAccessNode + Relational Node ID:18 + Output Columns:PatientID (long) + Statistics: 0: Node Output Rows: 13632 1: Node Next Batch Process Time: 1 2: Node Cumulative Next Batch Process Time: 1 3: Node Cumulative Process Time: 85 4: Node Next Batch Calls: 7 5: Node Blocks: 0 + Cost Estimates:Estimated Node Cardinality: 6.8281264 + Query:SELECT g_0.PatientID FROM kd_matric.ExtrPatICUAdmissions AS g_0, kd_matric.PatICUAdmissions AS g_1 WHERE (g_1.ICUSessionID = g_0.ICUSessionID) AND (g_1.BatchID < 1152) AND (g_0.PatientID IN ()) + Model Name:kd_matric + Dependent Join:true + Join Strategy:ENHANCED SORT JOIN [SEMI] (SORT_DISTINCT/SORT) + Join Type:INNER JOIN + Join Criteria:convert(PatientID, long)=epa.PatientID + Grouping Mapping:anon_grp0.agg0=COUNT(*) + Sort Mode:false + Select Columns:anon_grp0.agg0 AS expr1 + Data Bytes Sent:17 + Planning Time:26