<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.0.1600.22" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="165.593" StatementText="SELECT&#xD;&#xA;  DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_TYPE&#xD;&#xA;,&#xD;&#xA;  CASE &#xD;&#xA;WHEN &#xD;&#xA;DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME= '' then null&#xD;&#xA;ELSE upper(DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME)&#xD;&#xA;END,&#xD;&#xA;  case&#xD;&#xA;when cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime) is null then cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;else cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime)&#xD;&#xA;end ,&#xD;&#xA;  CASE &#xD;&#xA;when DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE is null and DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_POLICY=POLICY.CD_POLICY then POLICY.CD_SCHEDULE &#xD;&#xA;else SCHEDULE.CD_SCHEDULE&#xD;&#xA;end &#xD;&#xA;,&#xD;&#xA;  sum(DTMPFO.dbo.DTMPFO_IMPRESSIONS.FG_RENEW),&#xD;&#xA;  PARTNER.CD_PARTNER&#xD;&#xA;,&#xD;&#xA;  PARTNER.LB_PARTNER&#xD;&#xA;FROM&#xD;&#xA;  CALENDAR RIGHT OUTER JOIN DTMPFO.dbo.DTMPFO_IMPRESSIONS ON (CALENDAR.LB_DAY=cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;)&#xD;&#xA;   LEFT OUTER JOIN ( SELECT [ITEMCODE]&#xD;&#xA;      ,[GROUPCODE]&#xD;&#xA;      ,[DESCRIPTION]&#xD;&#xA;FROM dbo03.[ODS].[dbo].[ODS_ENS_DECODE]&#xD;&#xA;WHERE [GROUPCODE]= 'reqstat') DECODE_REQSTAT ON (upper(DECODE_REQSTAT.ITEMCODE)=upper(DTMPFO.dbo.DTMPFO_IMPRESSIONS.STATUS)&#xD;&#xA;&#xD;&#xA;)&#xD;&#xA;   LEFT OUTER JOIN POLICY ON (DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_POLICY=POLICY.CD_POLICY)&#xD;&#xA;   LEFT OUTER JOIN PARTNER ON (POLICY.CD_PARTNER=PARTNER.CD_PARTNER)&#xD;&#xA;   LEFT OUTER JOIN POLICY_STATUS_ACTUAL ON (POLICY_STATUS_ACTUAL.CD_POLICY=POLICY.CD_POLICY)&#xD;&#xA;   LEFT OUTER JOIN POLICY_STATUS ON (POLICY_STATUS.CD_POLICY_STATUS=POLICY_STATUS_ACTUAL.CD_POLICY_STATUS)&#xD;&#xA;   LEFT OUTER JOIN SCHEDULE ON (SCHEDULE.CD_SCHEDULE=DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE)&#xD;&#xA;  &#xD;&#xA;WHERE&#xD;&#xA;  ( &#xD;&#xA;  DECODE_REQSTAT.DESCRIPTION  IN  ('Imprimé', 'Terminé')&#xD;&#xA;  AND  DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_TYPE&#xD;&#xA;  IN  ('CN1', 'RN1', 'RN2', 'RN3')&#xD;&#xA;  AND  CASE &#xD;&#xA;when DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE is null and DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_POLICY=POLICY.CD_POLICY then POLICY.CD_SCHEDULE &#xD;&#xA;else SCHEDULE.CD_SCHEDULE&#xD;&#xA;end &#xD;&#xA;  IN (SELECT&#xD;&#xA;  CASE &#xD;&#xA;when DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE is null and DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_POLICY=POLICY.CD_POLICY then POLICY.CD_SCHEDULE &#xD;&#xA;else SCHEDULE.CD_SCHEDULE&#xD;&#xA;end &#xD;&#xA;&#xD;&#xA;FROM&#xD;&#xA;  CALENDAR RIGHT OUTER JOIN DTMPFO.dbo.DTMPFO_IMPRESSIONS ON (CALENDAR.LB_DAY=cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;)&#xD;&#xA;   LEFT OUTER JOIN ( SELECT [ITEMCODE]&#xD;&#xA;      ,[GROUPCODE]&#xD;&#xA;      ,[DESCRIPTION]&#xD;&#xA;FROM dbo03.[ODS].[dbo].[ODS_ENS_DECODE]&#xD;&#xA;WHERE [GROUPCODE]= 'reqstat') DECODE_REQSTAT ON (upper(DECODE_REQSTAT.ITEMCODE)=upper(DTMPFO.dbo.DTMPFO_IMPRESSIONS.STATUS)&#xD;&#xA;&#xD;&#xA;)&#xD;&#xA;   LEFT OUTER JOIN POLICY ON (DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_POLICY=POLICY.CD_POLICY)&#xD;&#xA;   LEFT OUTER JOIN SCHEDULE ON (SCHEDULE.CD_SCHEDULE=DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE)&#xD;&#xA;  &#xD;&#xA;WHERE&#xD;&#xA;  ( &#xD;&#xA;  (CASE &#xD;&#xA;WHEN &#xD;&#xA;DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME= '' then null&#xD;&#xA;ELSE upper(DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME)&#xD;&#xA;END  IN  ('47_CNA_A4', '47_RNA_A4', '47_RNB_A4')&#xD;&#xA;  OR   CASE &#xD;&#xA;WHEN &#xD;&#xA;DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME= '' then null&#xD;&#xA;ELSE upper(DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME)&#xD;&#xA;END  IN  ('47D_CNA_A4', '47D_RNA_A4', '47D_RNB_A4', '47V_CNA_A4', '47V_RNA_A4', '47V_RNB_A4')&#xD;&#xA;  AND  case&#xD;&#xA;when cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime) is null then cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;else cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime)&#xD;&#xA;end   NOT BETWEEN  '04/01/2010 00:0:0' AND '04/13/2010 00:0:0')&#xD;&#xA;  AND  DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_RENEW_THEO  BETWEEN  '2011-07-01' AND '2011-07-31'&#xD;&#xA;  AND  DECODE_REQSTAT.DESCRIPTION  IN  ('Imprimé', 'Terminé')&#xD;&#xA;  )&#xD;&#xA;)&#xD;&#xA;  AND  POLICY_STATUS.CD_POLICY_STATUS  !=  'Z'&#xD;&#xA;  AND  case&#xD;&#xA;when cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime) is null then cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;else cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime)&#xD;&#xA;end   &gt;=  '2011-02-01'&#xD;&#xA;  )&#xD;&#xA;GROUP BY&#xD;&#xA;" StatementType="SELECT" QueryHash="0xF584E38AA82E37D7" QueryPlanHash="0xDD2DFBDB09A98F4E">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan CachedPlanSize="448" CompileTime="326" CompileCPU="325" CompileMemory="4840">
            <RelOp AvgRowSize="130" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="0" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="165.593">
              <OutputList>
                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                <ColumnReference Column="Expr1044" />
                <ColumnReference Column="Expr1045" />
                <ColumnReference Column="Expr1046" />
                <ColumnReference Column="Expr1047" />
              </OutputList>
              <Filter StartupExpression="false">
                <RelOp AvgRowSize="130" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="165.593">
                  <OutputList>
                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                    <ColumnReference Column="Expr1044" />
                    <ColumnReference Column="Expr1045" />
                    <ColumnReference Column="Expr1046" />
                    <ColumnReference Column="Expr1047" />
                  </OutputList>
                  <ComputeScalar>
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Column="Expr1047" />
                        <ScalarOperator ScalarString="CASE WHEN [Expr1161]=(0) THEN NULL ELSE [Expr1162] END">
                          <IF>
                            <Condition>
                              <ScalarOperator>
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="Expr1161" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="(0)" />
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </Condition>
                            <Then>
                              <ScalarOperator>
                                <Const ConstValue="NULL" />
                              </ScalarOperator>
                            </Then>
                            <Else>
                              <ScalarOperator>
                                <Identifier>
                                  <ColumnReference Column="Expr1162" />
                                </Identifier>
                              </ScalarOperator>
                            </Else>
                          </IF>
                        </ScalarOperator>
                      </DefinedValue>
                    </DefinedValues>
                    <RelOp AvgRowSize="130" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="2" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="165.593">
                      <OutputList>
                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                        <ColumnReference Column="Expr1044" />
                        <ColumnReference Column="Expr1045" />
                        <ColumnReference Column="Expr1046" />
                        <ColumnReference Column="Expr1161" />
                        <ColumnReference Column="Expr1162" />
                      </OutputList>
                      <StreamAggregate>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="Expr1161" />
                            <ScalarOperator ScalarString="COUNT_BIG([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[FG_RENEW])">
                              <Aggregate AggType="COUNT_BIG" Distinct="false">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                  </Identifier>
                                </ScalarOperator>
                              </Aggregate>
                            </ScalarOperator>
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Column="Expr1162" />
                            <ScalarOperator ScalarString="SUM([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[FG_RENEW])">
                              <Aggregate AggType="SUM" Distinct="false">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                  </Identifier>
                                </ScalarOperator>
                              </Aggregate>
                            </ScalarOperator>
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                            <ScalarOperator ScalarString="ANY([DWH].[dbo].[PARTNER].[LB_PARTNER])">
                              <Aggregate AggType="ANY" Distinct="false">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                  </Identifier>
                                </ScalarOperator>
                              </Aggregate>
                            </ScalarOperator>
                          </DefinedValue>
                        </DefinedValues>
                        <GroupBy>
                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                          <ColumnReference Column="Expr1044" />
                          <ColumnReference Column="Expr1045" />
                          <ColumnReference Column="Expr1046" />
                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                        </GroupBy>
                        <RelOp AvgRowSize="130" EstimateCPU="0.00010013" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Sort" NodeId="3" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="165.593">
                          <OutputList>
                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                            <ColumnReference Column="Expr1044" />
                            <ColumnReference Column="Expr1045" />
                            <ColumnReference Column="Expr1046" />
                          </OutputList>
                          <MemoryFractions Input="3.66388E-05" Output="1" />
                          <Sort Distinct="false">
                            <OrderBy>
                              <OrderByColumn Ascending="true">
                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                              </OrderByColumn>
                              <OrderByColumn Ascending="true">
                                <ColumnReference Column="Expr1044" />
                              </OrderByColumn>
                              <OrderByColumn Ascending="true">
                                <ColumnReference Column="Expr1045" />
                              </OrderByColumn>
                              <OrderByColumn Ascending="true">
                                <ColumnReference Column="Expr1046" />
                              </OrderByColumn>
                              <OrderByColumn Ascending="true">
                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                              </OrderByColumn>
                            </OrderBy>
                            <RelOp AvgRowSize="130" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="4" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="165.582">
                              <OutputList>
                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                <ColumnReference Column="Expr1044" />
                                <ColumnReference Column="Expr1045" />
                                <ColumnReference Column="Expr1046" />
                              </OutputList>
                              <ComputeScalar>
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Column="Expr1045" />
                                    <ScalarOperator ScalarString="CASE WHEN [Expr1074] IS NULL THEN CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0) ELSE CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0) END">
                                      <IF>
                                        <Condition>
                                          <ScalarOperator>
                                            <Compare CompareOp="IS">
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Column="Expr1074" />
                                                </Identifier>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Const ConstValue="NULL" />
                                              </ScalarOperator>
                                            </Compare>
                                          </ScalarOperator>
                                        </Condition>
                                        <Then>
                                          <ScalarOperator>
                                            <Convert DataType="datetime" Style="0" Implicit="false">
                                              <ScalarOperator>
                                                <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Convert>
                                              </ScalarOperator>
                                            </Convert>
                                          </ScalarOperator>
                                        </Then>
                                        <Else>
                                          <ScalarOperator>
                                            <Convert DataType="datetime" Style="0" Implicit="false">
                                              <ScalarOperator>
                                                <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Convert>
                                              </ScalarOperator>
                                            </Convert>
                                          </ScalarOperator>
                                        </Else>
                                      </IF>
                                    </ScalarOperator>
                                  </DefinedValue>
                                  <DefinedValue>
                                    <ColumnReference Column="Expr1046" />
                                    <ScalarOperator ScalarString="CASE WHEN [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_SCHEDULE] IS NULL AND [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY]=[DWH].[dbo].[POLICY].[CD_POLICY] THEN [DWH].[dbo].[POLICY].[CD_SCHEDULE] ELSE [DWH].[dbo].[SCHEDULE].[CD_SCHEDULE] END">
                                      <IF>
                                        <Condition>
                                          <ScalarOperator>
                                            <Logical Operation="AND">
                                              <ScalarOperator>
                                                <Compare CompareOp="IS">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Const ConstValue="NULL" />
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Compare CompareOp="EQ">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                            </Logical>
                                          </ScalarOperator>
                                        </Condition>
                                        <Then>
                                          <ScalarOperator>
                                            <Identifier>
                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                            </Identifier>
                                          </ScalarOperator>
                                        </Then>
                                        <Else>
                                          <ScalarOperator>
                                            <Identifier>
                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                            </Identifier>
                                          </ScalarOperator>
                                        </Else>
                                      </IF>
                                    </ScalarOperator>
                                  </DefinedValue>
                                </DefinedValues>
                                <RelOp AvgRowSize="163" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="165.582">
                                  <OutputList>
                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                    <ColumnReference Column="Expr1044" />
                                    <ColumnReference Column="Expr1074" />
                                  </OutputList>
                                  <NestedLoops Optimized="false">
                                    <OuterReferences>
                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                    </OuterReferences>
                                    <RelOp AvgRowSize="163" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Outer Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="158.871">
                                      <OutputList>
                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                        <ColumnReference Column="Expr1044" />
                                        <ColumnReference Column="Expr1074" />
                                      </OutputList>
                                      <NestedLoops Optimized="false">
                                        <OuterReferences>
                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                        </OuterReferences>
                                        <RelOp AvgRowSize="159" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Outer Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="158.868">
                                          <OutputList>
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                            <ColumnReference Column="Expr1044" />
                                            <ColumnReference Column="Expr1074" />
                                          </OutputList>
                                          <NestedLoops Optimized="false">
                                            <OuterReferences>
                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                            </OuterReferences>
                                            <RelOp AvgRowSize="93" EstimateCPU="0.857705" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="8" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="158.865">
                                              <OutputList>
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                <ColumnReference Column="Expr1044" />
                                                <ColumnReference Column="Expr1074" />
                                              </OutputList>
                                              <Filter StartupExpression="false">
                                                <RelOp AvgRowSize="93" EstimateCPU="0.0621525" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="621525" LogicalOp="Compute Scalar" NodeId="9" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="158.007">
                                                  <OutputList>
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                    <ColumnReference Column="Expr1044" />
                                                    <ColumnReference Column="Expr1074" />
                                                  </OutputList>
                                                  <ComputeScalar>
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Column="Expr1074" />
                                                        <ScalarOperator ScalarString="CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0)">
                                                          <Convert DataType="datetime" Style="0" Implicit="false">
                                                            <ScalarOperator>
                                                              <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                <ScalarOperator>
                                                                  <Identifier>
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                  </Identifier>
                                                                </ScalarOperator>
                                                              </Convert>
                                                            </ScalarOperator>
                                                          </Convert>
                                                        </ScalarOperator>
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <RelOp AvgRowSize="85" EstimateCPU="4.83281" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="621525" LogicalOp="Right Outer Join" NodeId="10" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="157.945">
                                                      <OutputList>
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                        <ColumnReference Column="Expr1044" />
                                                      </OutputList>
                                                      <MemoryFractions Input="0.00509335" Output="0.00509279" />
                                                      <Hash>
                                                        <DefinedValues />
                                                        <HashKeysBuild>
                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                        </HashKeysBuild>
                                                        <HashKeysProbe>
                                                          <ColumnReference Column="Expr1075" />
                                                        </HashKeysProbe>
                                                        <ProbeResidual>
                                                          <ScalarOperator ScalarString="[DWH].[dbo].[CALENDAR].[LB_DAY]=[Expr1075]">
                                                            <Compare CompareOp="EQ">
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Column="Expr1075" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                            </Compare>
                                                          </ScalarOperator>
                                                        </ProbeResidual>
                                                        <RelOp AvgRowSize="15" EstimateCPU="0.0049783" EstimateIO="0.0334954" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4383" LogicalOp="Clustered Index Scan" NodeId="11" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0384737" TableCardinality="4383">
                                                          <OutputList>
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                          </OutputList>
                                                          <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                            <DefinedValues>
                                                              <DefinedValue>
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                              </DefinedValue>
                                                            </DefinedValues>
                                                            <Object Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Index="[PK__CALENDAR__E8DA840F54E4CE25]" TableReferenceId="1" IndexKind="Clustered" />
                                                          </IndexScan>
                                                        </RelOp>
                                                        <RelOp AvgRowSize="85" EstimateCPU="4.35178" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="621525" LogicalOp="Inner Join" NodeId="12" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="153.073">
                                                          <OutputList>
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                            <ColumnReference Column="Expr1044" />
                                                            <ColumnReference Column="Expr1075" />
                                                          </OutputList>
                                                          <MemoryFractions Input="0" Output="0" />
                                                          <Hash>
                                                            <DefinedValues />
                                                            <HashKeysBuild>
                                                              <ColumnReference Column="Expr1101" />
                                                            </HashKeysBuild>
                                                            <HashKeysProbe>
                                                              <ColumnReference Column="Expr1076" />
                                                            </HashKeysProbe>
                                                            <ProbeResidual>
                                                              <ScalarOperator ScalarString="[Expr1101]=[Expr1076]">
                                                                <Compare CompareOp="EQ">
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Column="Expr1101" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Column="Expr1076" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                </Compare>
                                                              </ScalarOperator>
                                                            </ProbeResidual>
                                                            <RelOp AvgRowSize="48" EstimateCPU="0.0103333" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="13" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0103333">
                                                              <OutputList>
                                                                <ColumnReference Column="Expr1101" />
                                                              </OutputList>
                                                              <ComputeScalar>
                                                                <DefinedValues>
                                                                  <DefinedValue>
                                                                    <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="ITEMCODE" />
                                                                    <ScalarOperator ScalarString="[dbo03].[ODS].[dbo].[ODS_ENS_DECODE].[ITEMCODE]">
                                                                      <Identifier>
                                                                        <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="ITEMCODE" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                  </DefinedValue>
                                                                  <DefinedValue>
                                                                    <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="GROUPCODE" />
                                                                    <ScalarOperator ScalarString="[dbo03].[ODS].[dbo].[ODS_ENS_DECODE].[GROUPCODE]">
                                                                      <Identifier>
                                                                        <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="GROUPCODE" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                  </DefinedValue>
                                                                  <DefinedValue>
                                                                    <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="DESCRIPTION" />
                                                                    <ScalarOperator ScalarString="[dbo03].[ODS].[dbo].[ODS_ENS_DECODE].[DESCRIPTION]">
                                                                      <Identifier>
                                                                        <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="DESCRIPTION" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                  </DefinedValue>
                                                                  <DefinedValue>
                                                                    <ColumnReference Column="Expr1101" />
                                                                    <ScalarOperator ScalarString="[Expr1101]">
                                                                      <Identifier>
                                                                        <ColumnReference Column="Expr1101" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                  </DefinedValue>
                                                                </DefinedValues>
                                                                <RelOp AvgRowSize="48" EstimateCPU="0.0103333" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Remote Query" NodeId="14" Parallel="false" PhysicalOp="Remote Query" EstimatedTotalSubtreeCost="0.0103333">
                                                                  <OutputList>
                                                                    <ColumnReference Column="Expr1101" />
                                                                  </OutputList>
                                                                  <RemoteQuery RemoteSource="dbo03" RemoteQuery="SELECT &quot;Tbl1008&quot;.&quot;ITEMCODE&quot; &quot;Col1142&quot;,&quot;Tbl1008&quot;.&quot;GROUPCODE&quot; &quot;Col1143&quot;,&quot;Tbl1008&quot;.&quot;DESCRIPTION&quot; &quot;Col1144&quot;,upper(&quot;Tbl1008&quot;.&quot;ITEMCODE&quot;) &quot;Expr1101&quot; FROM &quot;ODS&quot;.&quot;dbo&quot;.&quot;ODS_ENS_DECODE&quot; &quot;Tbl1008&quot; WHERE (&quot;Tbl1008&quot;.&quot;DESCRIPTION&quot;='Imprimé' OR &quot;Tbl1008&quot;.&quot;DESCRIPTION&quot;='Terminé') AND &quot;Tbl1008&quot;.&quot;GROUPCODE&quot;='reqstat'" />
                                                                </RelOp>
                                                              </ComputeScalar>
                                                            </RelOp>
                                                            <RelOp AvgRowSize="88" EstimateCPU="14.7701" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="556578" LogicalOp="Inner Join" NodeId="24" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="147.011">
                                                              <OutputList>
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                <ColumnReference Column="Expr1044" />
                                                                <ColumnReference Column="Expr1075" />
                                                                <ColumnReference Column="Expr1076" />
                                                              </OutputList>
                                                              <MemoryFractions Input="0.613849" Output="0.613782" />
                                                              <Hash>
                                                                <DefinedValues />
                                                                <HashKeysBuild>
                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                </HashKeysBuild>
                                                                <HashKeysProbe>
                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                </HashKeysProbe>
                                                                <RelOp AvgRowSize="17" EstimateCPU="0.752932" EstimateIO="53.455" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2737790" LogicalOp="Clustered Index Scan" NodeId="25" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="54.2079" TableCardinality="2737790">
                                                                  <OutputList>
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                  </OutputList>
                                                                  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                    <DefinedValues>
                                                                      <DefinedValue>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                      </DefinedValue>
                                                                      <DefinedValue>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                      </DefinedValue>
                                                                      <DefinedValue>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                      </DefinedValue>
                                                                    </DefinedValues>
                                                                    <Object Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Index="[PK_POLICY]" TableReferenceId="1" IndexKind="Clustered" />
                                                                  </IndexScan>
                                                                </RelOp>
                                                                <RelOp AvgRowSize="82" EstimateCPU="18.7483" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5565780" LogicalOp="Inner Join" NodeId="26" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="75.4196">
                                                                  <OutputList>
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                    <ColumnReference Column="Expr1044" />
                                                                    <ColumnReference Column="Expr1075" />
                                                                    <ColumnReference Column="Expr1076" />
                                                                  </OutputList>
                                                                  <MemoryFractions Input="0.381058" Output="0.381016" />
                                                                  <Hash>
                                                                    <DefinedValues />
                                                                    <HashKeysBuild>
                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                    </HashKeysBuild>
                                                                    <HashKeysProbe>
                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                    </HashKeysProbe>
                                                                    <ProbeResidual>
                                                                      <ScalarOperator ScalarString="[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY]=[DWH].[dbo].[POLICY_STATUS_ACTUAL].[CD_POLICY]">
                                                                        <Compare CompareOp="EQ">
                                                                          <ScalarOperator>
                                                                            <Identifier>
                                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                            </Identifier>
                                                                          </ScalarOperator>
                                                                          <ScalarOperator>
                                                                            <Identifier>
                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                            </Identifier>
                                                                          </ScalarOperator>
                                                                        </Compare>
                                                                      </ScalarOperator>
                                                                    </ProbeResidual>
                                                                    <RelOp AvgRowSize="11" EstimateCPU="6.80448" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1834360" LogicalOp="Inner Join" NodeId="28" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="13.1161">
                                                                      <OutputList>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                      </OutputList>
                                                                      <MemoryFractions Input="0" Output="0" />
                                                                      <Hash>
                                                                        <DefinedValues />
                                                                        <HashKeysBuild>
                                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                        </HashKeysBuild>
                                                                        <HashKeysProbe>
                                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY_STATUS" />
                                                                        </HashKeysProbe>
                                                                        <ProbeResidual>
                                                                          <ScalarOperator ScalarString="[DWH].[dbo].[POLICY_STATUS].[CD_POLICY_STATUS]=[DWH].[dbo].[POLICY_STATUS_ACTUAL].[CD_POLICY_STATUS]">
                                                                            <Compare CompareOp="EQ">
                                                                              <ScalarOperator>
                                                                                <Identifier>
                                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                </Identifier>
                                                                              </ScalarOperator>
                                                                              <ScalarOperator>
                                                                                <Identifier>
                                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY_STATUS" />
                                                                                </Identifier>
                                                                              </ScalarOperator>
                                                                            </Compare>
                                                                          </ScalarOperator>
                                                                        </ProbeResidual>
                                                                        <RelOp AvgRowSize="9" EstimateCPU="0.0001713" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13" LogicalOp="Clustered Index Seek" NodeId="29" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032963" TableCardinality="14">
                                                                          <OutputList>
                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                          </OutputList>
                                                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                                                            <DefinedValues>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                              </DefinedValue>
                                                                            </DefinedValues>
                                                                            <Object Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Index="[PK_POLICY_STATUS]" IndexKind="Clustered" />
                                                                            <SeekPredicates>
                                                                              <SeekPredicateNew>
                                                                                <SeekKeys>
                                                                                  <EndRange ScanType="LT">
                                                                                    <RangeColumns>
                                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                    </RangeColumns>
                                                                                    <RangeExpressions>
                                                                                      <ScalarOperator ScalarString="'Z'">
                                                                                        <Const ConstValue="'Z'" />
                                                                                      </ScalarOperator>
                                                                                    </RangeExpressions>
                                                                                  </EndRange>
                                                                                </SeekKeys>
                                                                              </SeekPredicateNew>
                                                                              <SeekPredicateNew>
                                                                                <SeekKeys>
                                                                                  <StartRange ScanType="GT">
                                                                                    <RangeColumns>
                                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                    </RangeColumns>
                                                                                    <RangeExpressions>
                                                                                      <ScalarOperator ScalarString="'Z'">
                                                                                        <Const ConstValue="'Z'" />
                                                                                      </ScalarOperator>
                                                                                    </RangeExpressions>
                                                                                  </StartRange>
                                                                                </SeekKeys>
                                                                              </SeekPredicateNew>
                                                                            </SeekPredicates>
                                                                          </IndexScan>
                                                                        </RelOp>
                                                                        <RelOp AvgRowSize="12" EstimateCPU="0.752936" EstimateIO="5.52683" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2737810" LogicalOp="Clustered Index Scan" NodeId="30" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="6.27976" TableCardinality="2737810">
                                                                          <OutputList>
                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY_STATUS" />
                                                                          </OutputList>
                                                                          <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                            <DefinedValues>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                              </DefinedValue>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY_STATUS" />
                                                                              </DefinedValue>
                                                                            </DefinedValues>
                                                                            <Object Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Index="[PK__POLICY_STATUS_AC__43ECB87E]" IndexKind="Clustered" />
                                                                          </IndexScan>
                                                                        </RelOp>
                                                                      </Hash>
                                                                    </RelOp>
                                                                    <RelOp AvgRowSize="77" EstimateCPU="0.0932288" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3729150" LogicalOp="Compute Scalar" NodeId="32" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="40.6619">
                                                                      <OutputList>
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                        <ColumnReference Column="Expr1044" />
                                                                        <ColumnReference Column="Expr1075" />
                                                                        <ColumnReference Column="Expr1076" />
                                                                      </OutputList>
                                                                      <ComputeScalar>
                                                                        <DefinedValues>
                                                                          <DefinedValue>
                                                                            <ColumnReference Column="Expr1044" />
                                                                            <ScalarOperator ScalarString="CASE WHEN [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[LETTER_NAME]='' THEN NULL ELSE upper([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[LETTER_NAME]) END">
                                                                              <IF>
                                                                                <Condition>
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="EQ">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="''" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                </Condition>
                                                                                <Then>
                                                                                  <ScalarOperator>
                                                                                    <Const ConstValue="NULL" />
                                                                                  </ScalarOperator>
                                                                                </Then>
                                                                                <Else>
                                                                                  <ScalarOperator>
                                                                                    <Intrinsic FunctionName="upper">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                    </Intrinsic>
                                                                                  </ScalarOperator>
                                                                                </Else>
                                                                              </IF>
                                                                            </ScalarOperator>
                                                                          </DefinedValue>
                                                                          <DefinedValue>
                                                                            <ColumnReference Column="Expr1075" />
                                                                            <ScalarOperator ScalarString="CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0)">
                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                <ScalarOperator>
                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                    <ScalarOperator>
                                                                                      <Identifier>
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                  </Convert>
                                                                                </ScalarOperator>
                                                                              </Convert>
                                                                            </ScalarOperator>
                                                                          </DefinedValue>
                                                                          <DefinedValue>
                                                                            <ColumnReference Column="Expr1076" />
                                                                            <ScalarOperator ScalarString="upper([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[STATUS])">
                                                                              <Intrinsic FunctionName="upper">
                                                                                <ScalarOperator>
                                                                                  <Identifier>
                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                  </Identifier>
                                                                                </ScalarOperator>
                                                                              </Intrinsic>
                                                                            </ScalarOperator>
                                                                          </DefinedValue>
                                                                        </DefinedValues>
                                                                        <RelOp AvgRowSize="47" EstimateCPU="1.55352" EstimateIO="31.0572" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5649010" LogicalOp="Index Seek" NodeId="34" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="32.6107" TableCardinality="10400300">
                                                                          <OutputList>
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                          </OutputList>
                                                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                                                            <DefinedValues>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                              </DefinedValue>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                              </DefinedValue>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                              </DefinedValue>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                              </DefinedValue>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                              </DefinedValue>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                              </DefinedValue>
                                                                              <DefinedValue>
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                              </DefinedValue>
                                                                            </DefinedValues>
                                                                            <Object Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Index="[IDX_DTMPFO_IMPRESSIONS__LETTER_TYPE__STATUS]" TableReferenceId="1" IndexKind="NonClustered" />
                                                                            <SeekPredicates>
                                                                              <SeekPredicateNew>
                                                                                <SeekKeys>
                                                                                  <Prefix ScanType="EQ">
                                                                                    <RangeColumns>
                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                    </RangeColumns>
                                                                                    <RangeExpressions>
                                                                                      <ScalarOperator ScalarString="'CN1'">
                                                                                        <Const ConstValue="'CN1'" />
                                                                                      </ScalarOperator>
                                                                                    </RangeExpressions>
                                                                                  </Prefix>
                                                                                </SeekKeys>
                                                                              </SeekPredicateNew>
                                                                              <SeekPredicateNew>
                                                                                <SeekKeys>
                                                                                  <Prefix ScanType="EQ">
                                                                                    <RangeColumns>
                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                    </RangeColumns>
                                                                                    <RangeExpressions>
                                                                                      <ScalarOperator ScalarString="'RN1'">
                                                                                        <Const ConstValue="'RN1'" />
                                                                                      </ScalarOperator>
                                                                                    </RangeExpressions>
                                                                                  </Prefix>
                                                                                </SeekKeys>
                                                                              </SeekPredicateNew>
                                                                              <SeekPredicateNew>
                                                                                <SeekKeys>
                                                                                  <Prefix ScanType="EQ">
                                                                                    <RangeColumns>
                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                    </RangeColumns>
                                                                                    <RangeExpressions>
                                                                                      <ScalarOperator ScalarString="'RN2'">
                                                                                        <Const ConstValue="'RN2'" />
                                                                                      </ScalarOperator>
                                                                                    </RangeExpressions>
                                                                                  </Prefix>
                                                                                </SeekKeys>
                                                                              </SeekPredicateNew>
                                                                              <SeekPredicateNew>
                                                                                <SeekKeys>
                                                                                  <Prefix ScanType="EQ">
                                                                                    <RangeColumns>
                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                    </RangeColumns>
                                                                                    <RangeExpressions>
                                                                                      <ScalarOperator ScalarString="'RN3'">
                                                                                        <Const ConstValue="'RN3'" />
                                                                                      </ScalarOperator>
                                                                                    </RangeExpressions>
                                                                                  </Prefix>
                                                                                </SeekKeys>
                                                                              </SeekPredicateNew>
                                                                            </SeekPredicates>
                                                                          </IndexScan>
                                                                        </RelOp>
                                                                      </ComputeScalar>
                                                                    </RelOp>
                                                                  </Hash>
                                                                </RelOp>
                                                              </Hash>
                                                            </RelOp>
                                                          </Hash>
                                                        </RelOp>
                                                      </Hash>
                                                    </RelOp>
                                                  </ComputeScalar>
                                                </RelOp>
                                                <Predicate>
                                                  <ScalarOperator ScalarString="CASE WHEN [Expr1074] IS NULL THEN CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0) ELSE CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0) END&gt;='2011-02-01 00:00:00.000'">
                                                    <Compare CompareOp="GE">
                                                      <ScalarOperator>
                                                        <IF>
                                                          <Condition>
                                                            <ScalarOperator>
                                                              <Compare CompareOp="IS">
                                                                <ScalarOperator>
                                                                  <Identifier>
                                                                    <ColumnReference Column="Expr1074" />
                                                                  </Identifier>
                                                                </ScalarOperator>
                                                                <ScalarOperator>
                                                                  <Const ConstValue="NULL" />
                                                                </ScalarOperator>
                                                              </Compare>
                                                            </ScalarOperator>
                                                          </Condition>
                                                          <Then>
                                                            <ScalarOperator>
                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                <ScalarOperator>
                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                    <ScalarOperator>
                                                                      <Identifier>
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                  </Convert>
                                                                </ScalarOperator>
                                                              </Convert>
                                                            </ScalarOperator>
                                                          </Then>
                                                          <Else>
                                                            <ScalarOperator>
                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                <ScalarOperator>
                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                    <ScalarOperator>
                                                                      <Identifier>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                  </Convert>
                                                                </ScalarOperator>
                                                              </Convert>
                                                            </ScalarOperator>
                                                          </Else>
                                                        </IF>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="'2011-02-01 00:00:00.000'" />
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                </Predicate>
                                              </Filter>
                                            </RelOp>
                                            <RelOp AvgRowSize="77" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="51" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="30">
                                              <OutputList>
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                              </OutputList>
                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                  </DefinedValue>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <Object Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Index="[PK_PARTNER]" IndexKind="Clustered" />
                                                <SeekPredicates>
                                                  <SeekPredicateNew>
                                                    <SeekKeys>
                                                      <Prefix ScanType="EQ">
                                                        <RangeColumns>
                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                        </RangeColumns>
                                                        <RangeExpressions>
                                                          <ScalarOperator ScalarString="[DWH].[dbo].[POLICY].[CD_PARTNER]">
                                                            <Identifier>
                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                        </RangeExpressions>
                                                      </Prefix>
                                                    </SeekKeys>
                                                  </SeekPredicateNew>
                                                </SeekPredicates>
                                              </IndexScan>
                                            </RelOp>
                                          </NestedLoops>
                                        </RelOp>
                                        <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="52" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2749690">
                                          <OutputList>
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                          </OutputList>
                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                              </DefinedValue>
                                            </DefinedValues>
                                            <Object Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Index="[PK_SCHEDULE]" TableReferenceId="1" IndexKind="Clustered" />
                                            <SeekPredicates>
                                              <SeekPredicateNew>
                                                <SeekKeys>
                                                  <Prefix ScanType="EQ">
                                                    <RangeColumns>
                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                    </RangeColumns>
                                                    <RangeExpressions>
                                                      <ScalarOperator ScalarString="[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_SCHEDULE]">
                                                        <Identifier>
                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </RangeExpressions>
                                                  </Prefix>
                                                </SeekKeys>
                                              </SeekPredicateNew>
                                            </SeekPredicates>
                                          </IndexScan>
                                        </RelOp>
                                      </NestedLoops>
                                    </RelOp>
                                    <RelOp AvgRowSize="9" EstimateCPU="0.00069163" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="53" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="6.7105">
                                      <OutputList />
                                      <Filter StartupExpression="false">
                                        <RelOp AvgRowSize="27" EstimateCPU="0.00126799" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="10.1469" LogicalOp="Left Outer Join" NodeId="54" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.71048">
                                          <OutputList>
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                          </OutputList>
                                          <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
                                            <OuterReferences>
                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                              <ColumnReference Column="Expr1160" />
                                            </OuterReferences>
                                            <RelOp AvgRowSize="23" EstimateCPU="0.00126799" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="10.1469" LogicalOp="Left Outer Join" NodeId="56" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.67453">
                                              <OutputList>
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                              </OutputList>
                                              <NestedLoops Optimized="true" WithUnorderedPrefetch="true">
                                                <OuterReferences>
                                                  <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                  <ColumnReference Column="Expr1159" />
                                                </OuterReferences>
                                                <RelOp AvgRowSize="15" EstimateCPU="0.0670228" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="10.1469" LogicalOp="Filter" NodeId="59" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="6.63858">
                                                  <OutputList>
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                  </OutputList>
                                                  <Filter StartupExpression="false">
                                                    <RelOp AvgRowSize="73" EstimateCPU="0.00117998" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="394.702" LogicalOp="Compute Scalar" NodeId="60" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="6.63634">
                                                      <OutputList>
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                        <ColumnReference Column="Expr1078" />
                                                        <ColumnReference Column="Expr1079" />
                                                      </OutputList>
                                                      <ComputeScalar>
                                                        <DefinedValues>
                                                          <DefinedValue>
                                                            <ColumnReference Column="Expr1079" />
                                                            <ScalarOperator ScalarString="CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0)">
                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                <ScalarOperator>
                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                    <ScalarOperator>
                                                                      <Identifier>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                  </Convert>
                                                                </ScalarOperator>
                                                              </Convert>
                                                            </ScalarOperator>
                                                          </DefinedValue>
                                                        </DefinedValues>
                                                        <RelOp AvgRowSize="65" EstimateCPU="0.180603" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="394.702" LogicalOp="Right Outer Join" NodeId="61" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="6.6363">
                                                          <OutputList>
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                            <ColumnReference Column="Expr1078" />
                                                          </OutputList>
                                                          <MemoryFractions Input="7.32775E-05" Output="1.83194E-05" />
                                                          <Hash>
                                                            <DefinedValues />
                                                            <HashKeysBuild>
                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                            </HashKeysBuild>
                                                            <HashKeysProbe>
                                                              <ColumnReference Column="Expr1080" />
                                                            </HashKeysProbe>
                                                            <ProbeResidual>
                                                              <ScalarOperator ScalarString="[DWH].[dbo].[CALENDAR].[LB_DAY]=[Expr1080]">
                                                                <Compare CompareOp="EQ">
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Column="Expr1080" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                </Compare>
                                                              </ScalarOperator>
                                                            </ProbeResidual>
                                                            <RelOp AvgRowSize="15" EstimateCPU="0.0049783" EstimateIO="0.0334954" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4383" LogicalOp="Clustered Index Scan" NodeId="62" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0384737" TableCardinality="4383">
                                                              <OutputList>
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                              </OutputList>
                                                              <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                <DefinedValues>
                                                                  <DefinedValue>
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                  </DefinedValue>
                                                                </DefinedValues>
                                                                <Object Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Index="[PK__CALENDAR__E8DA840F54E4CE25]" TableReferenceId="2" IndexKind="Clustered" />
                                                              </IndexScan>
                                                            </RelOp>
                                                            <RelOp AvgRowSize="65" EstimateCPU="0.295939" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="394.702" LogicalOp="Inner Join" NodeId="63" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.50424">
                                                              <OutputList>
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                <ColumnReference Column="Expr1078" />
                                                                <ColumnReference Column="Expr1080" />
                                                              </OutputList>
                                                              <NestedLoops Optimized="false">
                                                                <Predicate>
                                                                  <ScalarOperator ScalarString="upper([dbo03].[ODS].[dbo].[ODS_ENS_DECODE].[ITEMCODE])=[Expr1081]">
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Intrinsic FunctionName="upper">
                                                                          <ScalarOperator>
                                                                            <Identifier>
                                                                              <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="ITEMCODE" />
                                                                            </Identifier>
                                                                          </ScalarOperator>
                                                                        </Intrinsic>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Column="Expr1081" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                </Predicate>
                                                                <RelOp AvgRowSize="48" EstimateCPU="0.0103333" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="64" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0103333">
                                                                  <OutputList>
                                                                    <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="ITEMCODE" />
                                                                  </OutputList>
                                                                  <ComputeScalar>
                                                                    <DefinedValues>
                                                                      <DefinedValue>
                                                                        <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="ITEMCODE" />
                                                                        <ScalarOperator ScalarString="[dbo03].[ODS].[dbo].[ODS_ENS_DECODE].[ITEMCODE]">
                                                                          <Identifier>
                                                                            <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="ITEMCODE" />
                                                                          </Identifier>
                                                                        </ScalarOperator>
                                                                      </DefinedValue>
                                                                    </DefinedValues>
                                                                    <RelOp AvgRowSize="48" EstimateCPU="0.0103333" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Remote Query" NodeId="65" Parallel="false" PhysicalOp="Remote Query" EstimatedTotalSubtreeCost="0.0103333">
                                                                      <OutputList>
                                                                        <ColumnReference Server="[dbo03]" Database="[ODS]" Schema="[dbo]" Table="[ODS_ENS_DECODE]" Column="ITEMCODE" />
                                                                      </OutputList>
                                                                      <RemoteQuery RemoteSource="dbo03" RemoteQuery="SELECT &quot;Tbl1034&quot;.&quot;ITEMCODE&quot; &quot;Col1098&quot; FROM &quot;ODS&quot;.&quot;dbo&quot;.&quot;ODS_ENS_DECODE&quot; &quot;Tbl1034&quot; WHERE (&quot;Tbl1034&quot;.&quot;DESCRIPTION&quot;='Imprimé' OR &quot;Tbl1034&quot;.&quot;DESCRIPTION&quot;='Terminé') AND &quot;Tbl1034&quot;.&quot;GROUPCODE&quot;='reqstat'" />
                                                                    </RelOp>
                                                                  </ComputeScalar>
                                                                </RelOp>
                                                                <RelOp AvgRowSize="76" EstimateCPU="1.04003" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2368.21" LogicalOp="Compute Scalar" NodeId="69" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="6.17694">
                                                                  <OutputList>
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                    <ColumnReference Column="Expr1078" />
                                                                    <ColumnReference Column="Expr1080" />
                                                                    <ColumnReference Column="Expr1081" />
                                                                  </OutputList>
                                                                  <ComputeScalar>
                                                                    <DefinedValues>
                                                                      <DefinedValue>
                                                                        <ColumnReference Column="Expr1078" />
                                                                        <ScalarOperator ScalarString="CASE WHEN [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[LETTER_NAME]='' THEN NULL ELSE upper([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[LETTER_NAME]) END">
                                                                          <IF>
                                                                            <Condition>
                                                                              <ScalarOperator>
                                                                                <Compare CompareOp="EQ">
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Const ConstValue="''" />
                                                                                  </ScalarOperator>
                                                                                </Compare>
                                                                              </ScalarOperator>
                                                                            </Condition>
                                                                            <Then>
                                                                              <ScalarOperator>
                                                                                <Const ConstValue="NULL" />
                                                                              </ScalarOperator>
                                                                            </Then>
                                                                            <Else>
                                                                              <ScalarOperator>
                                                                                <Intrinsic FunctionName="upper">
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                </Intrinsic>
                                                                              </ScalarOperator>
                                                                            </Else>
                                                                          </IF>
                                                                        </ScalarOperator>
                                                                      </DefinedValue>
                                                                      <DefinedValue>
                                                                        <ColumnReference Column="Expr1080" />
                                                                        <ScalarOperator ScalarString="CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0)">
                                                                          <Convert DataType="datetime" Style="0" Implicit="false">
                                                                            <ScalarOperator>
                                                                              <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                <ScalarOperator>
                                                                                  <Identifier>
                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                  </Identifier>
                                                                                </ScalarOperator>
                                                                              </Convert>
                                                                            </ScalarOperator>
                                                                          </Convert>
                                                                        </ScalarOperator>
                                                                      </DefinedValue>
                                                                      <DefinedValue>
                                                                        <ColumnReference Column="Expr1081" />
                                                                        <ScalarOperator ScalarString="upper([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[STATUS])">
                                                                          <Intrinsic FunctionName="upper">
                                                                            <ScalarOperator>
                                                                              <Identifier>
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                              </Identifier>
                                                                            </ScalarOperator>
                                                                          </Intrinsic>
                                                                        </ScalarOperator>
                                                                      </DefinedValue>
                                                                    </DefinedValues>
                                                                    <RelOp AvgRowSize="46" EstimateCPU="11.4404" EstimateIO="172.088" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2368.21" LogicalOp="Clustered Index Scan" NodeId="70" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="6.14215" TableCardinality="10400300">
                                                                      <OutputList>
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                      </OutputList>
                                                                      <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                        <DefinedValues>
                                                                          <DefinedValue>
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                          </DefinedValue>
                                                                          <DefinedValue>
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                          </DefinedValue>
                                                                          <DefinedValue>
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                          </DefinedValue>
                                                                          <DefinedValue>
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                          </DefinedValue>
                                                                          <DefinedValue>
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                          </DefinedValue>
                                                                        </DefinedValues>
                                                                        <Object Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Index="[PK__DTMPFO_I__191914166C858514]" TableReferenceId="2" IndexKind="Clustered" />
                                                                        <Predicate>
                                                                          <ScalarOperator ScalarString="[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_RENEW_THEO]&gt;='2011-07-01 00:00:00.000' AND [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_RENEW_THEO]&lt;='2011-07-31 00:00:00.000'">
                                                                            <Logical Operation="AND">
                                                                              <ScalarOperator>
                                                                                <Compare CompareOp="GE">
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_RENEW_THEO" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Const ConstValue="'2011-07-01 00:00:00.000'" />
                                                                                  </ScalarOperator>
                                                                                </Compare>
                                                                              </ScalarOperator>
                                                                              <ScalarOperator>
                                                                                <Compare CompareOp="LE">
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_RENEW_THEO" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Const ConstValue="'2011-07-31 00:00:00.000'" />
                                                                                  </ScalarOperator>
                                                                                </Compare>
                                                                              </ScalarOperator>
                                                                            </Logical>
                                                                          </ScalarOperator>
                                                                        </Predicate>
                                                                      </IndexScan>
                                                                    </RelOp>
                                                                  </ComputeScalar>
                                                                </RelOp>
                                                              </NestedLoops>
                                                            </RelOp>
                                                          </Hash>
                                                        </RelOp>
                                                      </ComputeScalar>
                                                    </RelOp>
                                                    <Predicate>
                                                      <ScalarOperator ScalarString="[Expr1078]='47_RNB_A4' OR [Expr1078]='47_RNA_A4' OR [Expr1078]='47_CNA_A4' OR ([Expr1078]='47V_RNB_A4' OR [Expr1078]='47V_RNA_A4' OR [Expr1078]='47V_CNA_A4' OR [Expr1078]='47D_RNB_A4' OR [Expr1078]='47D_RNA_A4' OR [Expr1078]='47D_CNA_A4') AND (CASE WHEN [Expr1079] IS NULL THEN CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0) ELSE CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0) END&lt;'2010-04-01 00:00:00.000' OR CASE WHEN [Expr1079] IS NULL THEN CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0) ELSE CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0) END&gt;'2010-04-13 00:00:00.000')">
                                                        <Logical Operation="OR">
                                                          <ScalarOperator>
                                                            <Compare CompareOp="EQ">
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Column="Expr1078" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Const ConstValue="'47_RNB_A4'" />
                                                              </ScalarOperator>
                                                            </Compare>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Compare CompareOp="EQ">
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Column="Expr1078" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Const ConstValue="'47_RNA_A4'" />
                                                              </ScalarOperator>
                                                            </Compare>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Compare CompareOp="EQ">
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Column="Expr1078" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Const ConstValue="'47_CNA_A4'" />
                                                              </ScalarOperator>
                                                            </Compare>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Logical Operation="AND">
                                                              <ScalarOperator>
                                                                <Logical Operation="OR">
                                                                  <ScalarOperator>
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Column="Expr1078" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="'47V_RNB_A4'" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Column="Expr1078" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="'47V_RNA_A4'" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Column="Expr1078" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="'47V_CNA_A4'" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Column="Expr1078" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="'47D_RNB_A4'" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Column="Expr1078" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="'47D_RNA_A4'" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Column="Expr1078" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="'47D_CNA_A4'" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                </Logical>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Logical Operation="OR">
                                                                  <ScalarOperator>
                                                                    <Compare CompareOp="LT">
                                                                      <ScalarOperator>
                                                                        <IF>
                                                                          <Condition>
                                                                            <ScalarOperator>
                                                                              <Compare CompareOp="IS">
                                                                                <ScalarOperator>
                                                                                  <Identifier>
                                                                                    <ColumnReference Column="Expr1079" />
                                                                                  </Identifier>
                                                                                </ScalarOperator>
                                                                                <ScalarOperator>
                                                                                  <Const ConstValue="NULL" />
                                                                                </ScalarOperator>
                                                                              </Compare>
                                                                            </ScalarOperator>
                                                                          </Condition>
                                                                          <Then>
                                                                            <ScalarOperator>
                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                <ScalarOperator>
                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                    <ScalarOperator>
                                                                                      <Identifier>
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                  </Convert>
                                                                                </ScalarOperator>
                                                                              </Convert>
                                                                            </ScalarOperator>
                                                                          </Then>
                                                                          <Else>
                                                                            <ScalarOperator>
                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                <ScalarOperator>
                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                    <ScalarOperator>
                                                                                      <Identifier>
                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                  </Convert>
                                                                                </ScalarOperator>
                                                                              </Convert>
                                                                            </ScalarOperator>
                                                                          </Else>
                                                                        </IF>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="'2010-04-01 00:00:00.000'" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Compare CompareOp="GT">
                                                                      <ScalarOperator>
                                                                        <IF>
                                                                          <Condition>
                                                                            <ScalarOperator>
                                                                              <Compare CompareOp="IS">
                                                                                <ScalarOperator>
                                                                                  <Identifier>
                                                                                    <ColumnReference Column="Expr1079" />
                                                                                  </Identifier>
                                                                                </ScalarOperator>
                                                                                <ScalarOperator>
                                                                                  <Const ConstValue="NULL" />
                                                                                </ScalarOperator>
                                                                              </Compare>
                                                                            </ScalarOperator>
                                                                          </Condition>
                                                                          <Then>
                                                                            <ScalarOperator>
                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                <ScalarOperator>
                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                    <ScalarOperator>
                                                                                      <Identifier>
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                  </Convert>
                                                                                </ScalarOperator>
                                                                              </Convert>
                                                                            </ScalarOperator>
                                                                          </Then>
                                                                          <Else>
                                                                            <ScalarOperator>
                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                <ScalarOperator>
                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                    <ScalarOperator>
                                                                                      <Identifier>
                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                  </Convert>
                                                                                </ScalarOperator>
                                                                              </Convert>
                                                                            </ScalarOperator>
                                                                          </Else>
                                                                        </IF>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="'2010-04-13 00:00:00.000'" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                </Logical>
                                                              </ScalarOperator>
                                                            </Logical>
                                                          </ScalarOperator>
                                                        </Logical>
                                                      </ScalarOperator>
                                                    </Predicate>
                                                  </Filter>
                                                </RelOp>
                                                <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="10.1353" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="84" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0359805" TableCardinality="2737790">
                                                  <OutputList>
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                  </OutputList>
                                                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                      </DefinedValue>
                                                      <DefinedValue>
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <Object Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Index="[PK_POLICY]" TableReferenceId="2" IndexKind="Clustered" />
                                                    <SeekPredicates>
                                                      <SeekPredicateNew>
                                                        <SeekKeys>
                                                          <Prefix ScanType="EQ">
                                                            <RangeColumns>
                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                            </RangeColumns>
                                                            <RangeExpressions>
                                                              <ScalarOperator ScalarString="[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY]">
                                                                <Identifier>
                                                                  <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                            </RangeExpressions>
                                                          </Prefix>
                                                        </SeekKeys>
                                                      </SeekPredicateNew>
                                                    </SeekPredicates>
                                                  </IndexScan>
                                                </RelOp>
                                              </NestedLoops>
                                            </RelOp>
                                            <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="10.1353" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="85" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0359694" TableCardinality="2749690">
                                              <OutputList>
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                              </OutputList>
                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <Object Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Index="[PK_SCHEDULE]" TableReferenceId="2" IndexKind="Clustered" />
                                                <SeekPredicates>
                                                  <SeekPredicateNew>
                                                    <SeekKeys>
                                                      <Prefix ScanType="EQ">
                                                        <RangeColumns>
                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                        </RangeColumns>
                                                        <RangeExpressions>
                                                          <ScalarOperator ScalarString="[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_SCHEDULE]">
                                                            <Identifier>
                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                        </RangeExpressions>
                                                      </Prefix>
                                                    </SeekKeys>
                                                  </SeekPredicateNew>
                                                </SeekPredicates>
                                              </IndexScan>
                                            </RelOp>
                                          </NestedLoops>
                                        </RelOp>
                                        <Predicate>
                                          <ScalarOperator ScalarString="CASE WHEN [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_SCHEDULE] IS NULL AND [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY]=[DWH].[dbo].[POLICY].[CD_POLICY] THEN [DWH].[dbo].[POLICY].[CD_SCHEDULE] ELSE [DWH].[dbo].[SCHEDULE].[CD_SCHEDULE] END=CASE WHEN [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_SCHEDULE] IS NULL AND [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY]=[DWH].[dbo].[POLICY].[CD_POLICY] THEN [DWH].[dbo].[POLICY].[CD_SCHEDULE] ELSE [DWH].[dbo].[SCHEDULE].[CD_SCHEDULE] END">
                                            <Compare CompareOp="EQ">
                                              <ScalarOperator>
                                                <IF>
                                                  <Condition>
                                                    <ScalarOperator>
                                                      <Logical Operation="AND">
                                                        <ScalarOperator>
                                                          <Compare CompareOp="IS">
                                                            <ScalarOperator>
                                                              <Identifier>
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                            <ScalarOperator>
                                                              <Const ConstValue="NULL" />
                                                            </ScalarOperator>
                                                          </Compare>
                                                        </ScalarOperator>
                                                        <ScalarOperator>
                                                          <Compare CompareOp="EQ">
                                                            <ScalarOperator>
                                                              <Identifier>
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                            <ScalarOperator>
                                                              <Identifier>
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                          </Compare>
                                                        </ScalarOperator>
                                                      </Logical>
                                                    </ScalarOperator>
                                                  </Condition>
                                                  <Then>
                                                    <ScalarOperator>
                                                      <Identifier>
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </Then>
                                                  <Else>
                                                    <ScalarOperator>
                                                      <Identifier>
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </Else>
                                                </IF>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <IF>
                                                  <Condition>
                                                    <ScalarOperator>
                                                      <Logical Operation="AND">
                                                        <ScalarOperator>
                                                          <Compare CompareOp="IS">
                                                            <ScalarOperator>
                                                              <Identifier>
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                            <ScalarOperator>
                                                              <Const ConstValue="NULL" />
                                                            </ScalarOperator>
                                                          </Compare>
                                                        </ScalarOperator>
                                                        <ScalarOperator>
                                                          <Compare CompareOp="EQ">
                                                            <ScalarOperator>
                                                              <Identifier>
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                            <ScalarOperator>
                                                              <Identifier>
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                          </Compare>
                                                        </ScalarOperator>
                                                      </Logical>
                                                    </ScalarOperator>
                                                  </Condition>
                                                  <Then>
                                                    <ScalarOperator>
                                                      <Identifier>
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </Then>
                                                  <Else>
                                                    <ScalarOperator>
                                                      <Identifier>
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </Else>
                                                </IF>
                                              </ScalarOperator>
                                            </Compare>
                                          </ScalarOperator>
                                        </Predicate>
                                      </Filter>
                                    </RelOp>
                                  </NestedLoops>
                                </RelOp>
                              </ComputeScalar>
                            </RelOp>
                          </Sort>
                        </RelOp>
                      </StreamAggregate>
                    </RelOp>
                  </ComputeScalar>
                </RelOp>
                <Predicate>
                  <ScalarOperator ScalarString="[Expr1047]=(1)">
                    <Compare CompareOp="EQ">
                      <ScalarOperator>
                        <Identifier>
                          <ColumnReference Column="Expr1047" />
                        </Identifier>
                      </ScalarOperator>
                      <ScalarOperator>
                        <Const ConstValue="(1)" />
                      </ScalarOperator>
                    </Compare>
                  </ScalarOperator>
                </Predicate>
              </Filter>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>