<?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>5/25/2016 12:14:19 PM</Created>
  <LastSaved>5/25/2016 12:14:19 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="FormulaDetail">
  <Table><Row>
<Cell><Data ss:Type="String">Name</Data></Cell>
<Cell><Data ss:Type="String">Formula</Data></Cell>
<Cell><Data ss:Type="String">Query Type</Data></Cell>
<Cell><Data ss:Type="String">Query</Data></Cell>
<Cell><Data ss:Type="String">Filter</Data></Cell>
<Cell><Data ss:Type="String">Filter Xml</Data></Cell>
<Cell><Data ss:Type="String">Layout</Data></Cell>
<Cell><Data ss:Type="String">Filter Attribute Name</Data></Cell>
<Cell><Data ss:Type="String">Filter Entity Name</Data></Cell>
<Cell><Data ss:Type="String">Query Primary Name Attribute</Data></Cell>
<Cell><Data ss:Type="String">Status</Data></Cell>
<Cell><Data ss:Type="String">Status Reason</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">UpdateCreateVeteran</Data></Cell>
<Cell><Data ss:Type="String">9f658aaf-041b-e611-811f-127b25dcbde7</Data></Cell>
<Cell><Data ss:Type="String">217890000</Data></Cell>
<Cell><Data ss:Type="String"><fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
<entity name="contact">
<attribute name="contactid" />
<filter type="and">
<condition attribute="bah_searchtype_text" operator="eq" value="{0}" />
<condition attribute="bah_source_text" operator="eq" value="{1}" />
<condition attribute="firstname" operator="eq" value="{2}" />
<condition attribute="middlename" operator="eq" value="{3}" />
<condition attribute="lastname" operator="eq" value="{4}" />
<condition attribute="bah_ssn_text" operator="eq" value="{5}" />
<condition attribute="bah_edipi_text" operator="eq" value="{6}" />
<condition attribute="address1_line1" operator="eq" value="{7}" />
<condition attribute="address1_line2" operator="eq" value="{8}" />
<condition attribute="address1_city" operator="eq" value="{9}" />
<condition attribute="address1_postalcode" operator="eq" value="{10}" />
<condition attribute="telephone1" operator="eq" value="{11}" />
<condition attribute="emailaddress1" operator="eq" value="{12}" />
</filter>
</entity>
</fetch></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"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">0</Data></Cell>
<Cell><Data ss:Type="String">1</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>