<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>N52 Formula Manager</Author>
  <LastAuthor>N52 Formula Manager</LastAuthor>
  <Created>6/13/2016 1:29:22 PM</Created>
  <LastSaved>6/13/2016 1:29:22 PM</LastSaved>
  <Company>N52 Formula Manager</Company>
  <Version>12.00</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>10005</WindowHeight>
  <WindowWidth>10005</WindowWidth>
  <WindowTopX>110</WindowTopX>
  <WindowTopY>125</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="10" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
 </Styles>
 <Worksheet ss:Name="Formula">
  <Table><Row>
<Cell><Data ss:Type="String">Name</Data></Cell>
<Cell><Data ss:Type="String">Formula Type</Data></Cell>
<Cell><Data ss:Type="String">Formula Description</Data></Cell>
<Cell><Data ss:Type="String">Status</Data></Cell>
<Cell><Data ss:Type="String">Status Reason</Data></Cell>
<Cell><Data ss:Type="String">Source Entity Name</Data></Cell>
<Cell><Data ss:Type="String">Source Entity Property</Data></Cell>
<Cell><Data ss:Type="String">Source Relationship</Data></Cell>
<Cell><Data ss:Type="String">Target Entity Name</Data></Cell>
<Cell><Data ss:Type="String">Target Entity Property</Data></Cell>
<Cell><Data ss:Type="String">Event</Data></Cell>
<Cell><Data ss:Type="String">Stage</Data></Cell>
<Cell><Data ss:Type="String">Display Format</Data></Cell>
<Cell><Data ss:Type="String">Auto Number Value</Data></Cell>
<Cell><Data ss:Type="String">Execution Order</Data></Cell>
<Cell><Data ss:Type="String">Message</Data></Cell>
<Cell><Data ss:Type="String">Enable PreValue Check</Data></Cell>
<Cell><Data ss:Type="String">Enable Find Function FetchXml Optimization</Data></Cell>
<Cell><Data ss:Type="String">Source Entity Property PreValue Check</Data></Cell>
<Cell><Data ss:Type="String">Category</Data></Cell>
<Cell><Data ss:Type="String">Sub Category</Data></Cell>
<Cell><Data ss:Type="String">Source Entity Property ClientSide</Data></Cell>
<Cell><Data ss:Type="String">Mode</Data></Cell>
<Cell><Data ss:Type="String">ShortCode</Data></Cell>
<Cell><Data ss:Type="String">Deployment Solution</Data></Cell>
<Cell><Data ss:Type="String">ClientSide Data Payload</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">HEC List Item - OnCreate</Data></Cell>
<Cell><Data ss:Type="String">217890013</Data></Cell>
<Cell><Data ss:Type="String">ForEachRecord(
  FindRecordsFetchXml(
    StringFormat(
      GetFetchXml(&#39;UpdateCreateVeteranBaseQuery&#39;),
      iftrue([vhacrm_heclistitem.vhacrm_firstname_text.X]!= &#39;X&#39;,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;firstname&#39;,
          [vhacrm_heclistitem.vhacrm_firstname_text]
        )
      ) +
      iftrue([vhacrm_heclistitem.vhacrm_middlename_text.X]!= &#39;X&#39;,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;middlename&#39;,
          [vhacrm_heclistitem.vhacrm_middlename_text]
        )
      ) +
      iftrue([vhacrm_heclistitem.vhacrm_lastname_text.X]!= &#39;X&#39;,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;lastname&#39;,
          [vhacrm_heclistitem.vhacrm_lastname_text]
        )
      ) +
      iftrue([vhacrm_heclistitem.vhacrm_ssn_text.X]!= &#39;X&#39;,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;bah_ssn_text&#39;,
          [vhacrm_heclistitem.vhacrm_ssn_text]
        )
      ) +
      iftrue([vhacrm_heclistitem.vhacrm_edipi_text.X]!= &#39;X&#39;,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;bah_edipi_text&#39;,
          [vhacrm_heclistitem.vhacrm_edipi_text]
        )
      ) +
      iftrue([vhacrm_heclistitem.vhacrm_addressline1_text.X]!= &#39;X&#39;,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;address1_line1&#39;,
          [vhacrm_heclistitem.vhacrm_addressline1_text]
        )
      ) +
      iftrue([vhacrm_heclistitem.vhacrm_addressline2_text.X]!= &#39;X&#39;,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;address1_line2&#39;,
          [vhacrm_heclistitem.vhacrm_addressline2_text]
        )
      ) +
      iftrue([vhacrm_heclistitem.vhacrm_city_text.X]!= &#39;X&#39;,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;address1_city&#39;,
          [vhacrm_heclistitem.vhacrm_city_text]
        )
      ) +
      iftrue(ContainsData([vhacrm_heclistitem.vhacrm_zip_text]),
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;address1_postalcode&#39;,
          [vhacrm_heclistitem.vhacrm_zip_text]
        )
      ) +
      iftrue(ContainsData([vhacrm_heclistitem.vhacrm_stateid]),
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; uitype=&quot;vhacrm_state&quot; /&gt;&#39;,
          &#39;vhacrm_address1_stateid&#39;,
          [vhacrm_heclistitem.vhacrm_stateid]
        )
      ) +
      iftrue(ContainsData([vhacrm_heclistitem.vhacrm_stateid]),
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;address1_stateorprovince&#39;,
          [vhacrm_heclistitem.vhacrm_stateidname]
        )
      ) +
      iftrue(DoesNotContainData([vhacrm_heclistitem.vhacrm_stateid]) and ContainsData([vhacrm_heclistitem.vhacrm_statecode_text]),
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;address1_stateorprovince&#39;,
          [vhacrm_heclistitem.vhacrm_statecode_text]
        )
      ) +
      iftrue([vhacrm_heclistitem.vhacrm_phonenumber_text.X]!= &#39;X&#39;,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;telephone1&#39;,
          [vhacrm_heclistitem.vhacrm_phonenumber_text]
        )
      ) +
      iftrue([vhacrm_heclistitem.vhacrm_emailaddress_text.X]!= &#39;X&#39;,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;emailaddress1&#39;,
          [vhacrm_heclistitem.vhacrm_emailaddress_text]
        )
      ) +
      iftrue(ContainsData([vhacrm_heclistitem.vhacrm_facility_text]),
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;eq&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;bah_preferredfacility_text&#39;,
          [vhacrm_heclistitem.vhacrm_facility_text]
        )
      ) +
      iftrue(datediff(&#39;1800-1-1&#39;,[vhacrm_heclistitem.vhacrm_dateofbirth_fmt2_date.1800-1-1],&#39;y&#39;)&gt;1,
        StringFormat(&#39;&lt;condition attribute=&quot;{0}&quot; operator=&quot;on&quot; value=&quot;{1}&quot; /&gt;&#39;,
          &#39;bah_dob_date&#39;,
          ToString([vhacrm_heclistitem.vhacrm_dateofbirth_fmt2_date],&#39;yyyy-MM-dd&#39;)
        )
      )
    )
  ),
  /*iftrue(RecordIndex() = 0
    ,AssociateEntities(
      &#39;list&#39;
      , FindValue(&#39;list&#39;,&#39;listname&#39;,[vhacrm_heclistitem.vhacrm_marketinglist_text],&#39;listid&#39;)
      ,&#39;contact&#39;
      ,CurrentRecord(&#39;contactid&#39;)
      , &#39;listcontact_association&#39;
    )
  ),*/

  iftrue(RecordIndex() = 0
    ,CreateRecord(
      &#39;phonecall&#39;
      ,SetAttribute(
        &#39;subject&#39;
        ,FindValue(&#39;list&#39;,&#39;listname&#39;,[vhacrm_heclistitem.vhacrm_marketinglist_text],&#39;listname&#39;)
      )
      ,SetAttribute(
        &#39;vhacrm_type_code&#39;
        ,713770000
      )
      ,SetAttribute(
        &#39;directioncode&#39;
        ,true
      )
      ,SetAttribute(
        &#39;vhacrm_attempt_number&#39;
        ,&#39;1&#39;
      )
      ,SetAttribute(
        &#39;phonenumber&#39;
        ,FindValue(&#39;contact&#39;,&#39;contactid&#39;,CurrentRecord(&#39;contactid&#39;),&#39;telephone1&#39;)
      )
      ,SetAttributePartyList(
        &#39;to&#39;
        ,&#39;contact&#39;
        ,CurrentRecord(&#39;contactid&#39;)
      )
      ,SetAttributeLookup(
        &#39;regardingobjectid&#39;
        ,&#39;campaignactivity&#39;
        ,FindValue(&#39;campaignactivity&#39;,&#39;subject&#39;,[vhacrm_heclistitem.vhacrm_marketinglist_text],&#39;activityid&#39;)
      )
    )
  ),
  
  iftrue(RecordIndex() = 0
    ,UpdateRecord(&#39;vhacrm_heclistitem&#39;, [vhacrm_heclistitem.vhacrm_heclistitemid], SetAttributeStatus(1,2))
  )
)</Data></Cell>
<Cell><Data ss:Type="String">0</Data></Cell>
<Cell><Data ss:Type="String">1</Data></Cell>
<Cell><Data ss:Type="String">vhacrm_heclistitem</Data></Cell>
<Cell><Data ss:Type="String">statuscode</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">217890000</Data></Cell>
<Cell><Data ss:Type="String">217890001</Data></Cell>
<Cell><Data ss:Type="String">217890000</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">False</Data></Cell>
<Cell><Data ss:Type="String">True</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">217890002</Data></Cell>
<Cell><Data ss:Type="String">Wrk</Data></Cell>
<Cell><Data ss:Type="String">North52FormulaManagerDeploymentSolution</Data></Cell>
<Cell><Data ss:Type="String">*:Create</Data></Cell>
</Row>

  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>6</ActiveRow>
     <ActiveCol>1</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>