<?xml version="1.0" encoding="utf-16"?>
<DTS xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <UserVariables>
    <UserVariable>
      <Name>line2</Name>
      <HelpText />
      <PromptText />
      <DataType>string</DataType>
      <Formula>IF( ISERROR( S8), " " , PROPER(S8))</Formula>
      <Prompted>false</Prompted>
    </UserVariable>
    <UserVariable>
      <Name>country</Name>
      <HelpText />
      <PromptText />
      <DataType>string</DataType>
      <Formula>FILELOOKUP( S12, "XREF.INI", "BAH_COUNTRY_CODE" )</Formula>
      <Prompted>false</Prompted>
    </UserVariable>
    <UserVariable>
      <Name>state</Name>
      <HelpText />
      <PromptText />
      <DataType>string</DataType>
      <Formula>FILELOOKUP( S10, "XREF.INI", "BAH_STATE_CODE" )</Formula>
      <Prompted>false</Prompted>
    </UserVariable>
  </UserVariables>
  <TargetVariables>
    <TargetVariable>
      <Name>enrollmentDate</Name>
      <HelpText />
      <Type>O</Type>
      <DataObject>contact</DataObject>
      <DataField>bah_enrollmentdate_date</DataField>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>currentState</Name>
      <HelpText />
      <Type>O</Type>
      <DataObject>contact</DataObject>
      <DataField>bah_address1_state_code</DataField>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>address1Field</Name>
      <HelpText />
      <Type>O</Type>
      <DataObject>contact</DataObject>
      <DataField>address1_line1</DataField>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>addresstypecode</Name>
      <HelpText />
      <Type>O</Type>
      <DataObject>customeraddress</DataObject>
      <DataField>addresstypecodename</DataField>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
    </TargetVariable>
  </TargetVariables>
  <JobInfo>
    <JobName />
    <JobDescription />
    <CreatedBy />
    <JobVersion />
    <HelpFile />
    <SourceDescription />
    <StepsDescription />
    <Version>26</Version>
    <VersionCompat>26</VersionCompat>
  </JobInfo>
  <KXRef>
    <Location>0</Location>
    <Database>0</Database>
    <Table />
    <SrcKey />
    <srcXRef />
    <TgtStep />
    <TgtKey />
    <TgtXref />
    <Label />
    <Variable />
    <SrcKeyDelimiter />
    <TgtKeyDelimiter />
    <SrcName />
    <SrcNameXRef />
    <TgtName />
    <TgtNameXref />
    <SrcNameDelimiter />
    <TgtNameDelimiter />
    <TgtDatabase />
  </KXRef>
  <UpdateStats>
    <Start>NO</Start>
    <End>NO</End>
    <State>AFTER % DEGRADE</State>
    <AfterNRows>1000</AfterNRows>
    <EveryNRows>1000</EveryNRows>
    <AfterDegradation>25</AfterDegradation>
  </UpdateStats>
  <Options>
    <GroupBy />
    <CommitEvery>NONE</CommitEvery>
    <NextJob>5. Service Request - Main.dts</NextJob>
    <ShowPercentComplete>NO</ShowPercentComplete>
    <TurboTextMode>YES</TurboTextMode>
    <AsyncOperations>NO</AsyncOperations>
    <CancelIfNoRows>NO</CancelIfNoRows>
    <CancelIfPercentSkip>NO</CancelIfPercentSkip>
    <PercentSkip>50</PercentSkip>
    <OutputSkipRows />
    <SkipRowServer />
    <SkipRowPrefix />
    <AllowMultiRecordUpdates>NO</AllowMultiRecordUpdates>
    <VariableInsert />
    <VariableUpdate />
    <VariableDelete />
    <CompareFieldsOnUpdates>NO</CompareFieldsOnUpdates>
    <SkipRowOwner />
    <OverrideSkipRowConnectionInfo>NO</OverrideSkipRowConnectionInfo>
    <CommitRowCount>0</CommitRowCount>
    <LogSuccessfulOperations />
    <LogOutcomes />
    <InternalDbUsage />
    <InternalDbLabel />
  </Options>
  <Source>
    <SourceQuery>SELECT VETADDR.[VET_ADDR_ID]
      , VETADDR.[VET_CREATED]
      , VETADDR.[VET_LST_UPD]
      , VETADDR.[VET_CREATED_BY]
      , VETADDR.[VET_LST_UPD_BY]
      , VETADDR.[VET_ID]
      , VETADDR.[VET_ADDR1]
      , VETADDR.[VET_ADDR2]
      , VETADDR.[VET_CITY]
      , VETADDR.[VET_STATE]
      , VETADDR.[VET_ZIP]
      , VETADDR.[VET_COUNTRY]
      , VETADDR.[VET_MAIL_TO]
      , VETADDR.[recordid]
      , VETADDR.[sequenceid]
      , VETADDR.[datecreated]
      , VETADDR.[errormessage]
      , VETADDR.[importstatus], VETDATA.VET_ID, STATENAME, COUNTRY.GUID AS COUNTRY_GUID, STATE.GUID AS STATE_GUID
FROM VETADDR_DATA AS VETADDR
LEFT OUTER JOIN VET_DATA AS VETDATA ON VETDATA.VET_ID = VETADDR.VET_ID
LEFT OUTER JOIN HRCCountry AS COUNTRY ON COUNTRY.COUNTRY_NAME = VETADDR.VET_COUNTRY
LEFT OUTER JOIN HRCState AS STATE ON VETADDR.STATENAME = STATE.STATE_NAME</SourceQuery>
    <ModifySourceOperation>0</ModifySourceOperation>
    <ModifySourceField />
    <ModifySourceValue />
    <KeyFields />
    <KeyFieldsDelimiter />
    <NameFields />
    <NameFieldsDelimater />
    <UserVariables />
  </Source>
  <SourceFields>
    <SourceField>
      <Name>VET_ADDR_ID</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S1</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_CREATED</Name>
      <DataObject />
      <Type>char(25)</Type>
      <Reference>S2</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_LST_UPD</Name>
      <DataObject />
      <Type>char(25)</Type>
      <Reference>S3</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_CREATED_BY</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S4</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_LST_UPD_BY</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S5</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_ID</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S6</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_ADDR1</Name>
      <DataObject />
      <Type>char(200)</Type>
      <Reference>S7</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_ADDR2</Name>
      <DataObject />
      <Type>char(100)</Type>
      <Reference>S8</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_CITY</Name>
      <DataObject />
      <Type>char(50)</Type>
      <Reference>S9</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_STATE</Name>
      <DataObject />
      <Type>char(10)</Type>
      <Reference>S10</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_ZIP</Name>
      <DataObject />
      <Type>char(30)</Type>
      <Reference>S11</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_COUNTRY</Name>
      <DataObject />
      <Type>char(30)</Type>
      <Reference>S12</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_MAIL_TO</Name>
      <DataObject />
      <Type>char(1)</Type>
      <Reference>S13</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>recordid</Name>
      <DataObject />
      <Type>char(38)</Type>
      <Reference>S14</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>sequenceid</Name>
      <DataObject />
      <Type>decimal(8)</Type>
      <Reference>S15</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>datecreated</Name>
      <DataObject />
      <Type>datetime(16)</Type>
      <Reference>S16</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>errormessage</Name>
      <DataObject />
      <Type>char(250)</Type>
      <Reference>S17</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>importstatus</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S18</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET_ID</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S19</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>STATENAME</Name>
      <DataObject />
      <Type>char(50)</Type>
      <Reference>S20</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>COUNTRY_GUID</Name>
      <DataObject />
      <Type>char(38)</Type>
      <Reference>S21</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>STATE_GUID</Name>
      <DataObject />
      <Type>char(38)</Type>
      <Reference>S22</Reference>
      <IsLink>true</IsLink>
    </SourceField>
  </SourceFields>
  <DataProviders>
    <DataProvider>
      <Usage>ST</Usage>
      <Label>Scribe Internal Database</Label>
      <Type />
      <Vendor />
      <Name />
      <User />
      <Password />
      <Server />
      <ConnectParams />
      <AccessLibrary>0</AccessLibrary>
      <OverrideConnectInfo />
      <AdapterDbID />
      <Comment>This is the Scribe application database.  Use InternalDB.exe found in your Scribe install directory to make changes to this connection. WARNING: Changes to this database could result in application instability.  You should use this connection in your integration solutions if you are very familiar with the Scribe database schema.</Comment>
      <UseLabelAsNames />
      <IgnoreKSyncTables />
      <PromptForReconnect>NO</PromptForReconnect>
      <ReuseConnection>NO</ReuseConnection>
      <PreJobScript />
      <PostJobScript />
      <CanEditConnection>NO</CanEditConnection>
      <CanPromptForReconnect>NO</CanPromptForReconnect>
      <CanRename>NO</CanRename>
      <CanDelete>NO</CanDelete>
      <CanReuseConnection>NO</CanReuseConnection>
      <TextFile>NO</TextFile>
      <Unicodeconnection />
      <WinAuthImpersonate />
      <Properties />
    </DataProvider>
    <DataProvider>
      <Usage>T</Usage>
      <Label>Adapter for Dynamics CRM</Label>
      <Type>Db</Type>
      <Vendor />
      <Name>vrmcloud\</Name>
      <User>acollier</User>
      <Password>1853A1A216E999976C7A0F14C59B2DBE</Password>
      <Server>https://DNS        .hrc.dev.crm.vrm.vba.DNS   /DNS  M</Server>
      <ConnectParams />
      <AccessLibrary>0</AccessLibrary>
      <OverrideConnectInfo>NO</OverrideConnectInfo>
      <AdapterDbID>Scribe.DynamicsCrm5.Adapter.DynamicsCrmDatabase</AdapterDbID>
      <Comment />
      <UseLabelAsNames>NO</UseLabelAsNames>
      <IgnoreKSyncTables>NO</IgnoreKSyncTables>
      <PromptForReconnect>NO</PromptForReconnect>
      <ReuseConnection>YES</ReuseConnection>
      <PreJobScript />
      <PostJobScript />
      <CanEditConnection>YES</CanEditConnection>
      <CanPromptForReconnect>YES</CanPromptForReconnect>
      <CanRename>YES</CanRename>
      <CanDelete>YES</CanDelete>
      <CanReuseConnection>YES</CanReuseConnection>
      <TextFile>NO</TextFile>
      <Unicodeconnection>NO</Unicodeconnection>
      <WinAuthImpersonate>NO</WinAuthImpersonate>
      <Properties>
        <AdapterProperty>
          <Name>Organization</Name>
          <Value>DNS  M</Value>
          <IsConnectionProperty>Y</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>AuthType</Name>
          <Value>ActiveDirectory</Value>
          <IsConnectionProperty>Y</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>TrimStringData</Name>
          <Value>True</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>ValidateAgainstPickList</Name>
          <Value>True</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>UseRunAsUser</Name>
          <Value>false</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>RunAsUserName</Name>
          <Value />
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>RunAsUserID</Name>
          <Value>00000000-0000-0000-0000-000000000000</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>DefaultOwnerName</Name>
          <Value />
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>DefaultOwnerID</Name>
          <Value>00000000-0000-0000-0000-000000000000</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>DefaultOwnerType</Name>
          <Value />
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>QueryBatchSize</Name>
          <Value>100</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>TimeZoneOption</Name>
          <Value />
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>ThreadCount</Name>
          <Value>32</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>UseBulkApi</Name>
          <Value>True</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>SkipPreSeek</Name>
          <Value>False</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
      </Properties>
    </DataProvider>
  </DataProviders>
  <TargetTables>
    <TargetTable>
      <Name>contact(5)</Name>
      <Operation>U</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>4</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>G</Success0Action>
      <Success0Step>2</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>G</Success1Action>
      <Success1Step>3</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>C</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>N</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>2</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF ( ISERROR(address1Field), " ", SKIPSTEP())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Adapter for Dynamics CRM.contact Address Block 1</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>customeraddress(2)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>4</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>C</Success0Action>
      <Success0Step>0</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>C</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula />
      <PreOpValue />
      <StepName>Copy of Adapter for Dynamics CRM.customeraddress</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>VETADDR_DATA</Name>
      <Operation>U</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>S</FailureAction>
      <FailureStep>0</FailureStep>
      <FailureMessage />
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Scribe Internal Database</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>C</Success0Action>
      <Success0Step>0</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>C</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>0</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula />
      <PreOpValue />
      <StepName>Scribe Internal Database.VETADDR_DATA SUCCESS</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>VETADDR_DATA(2)</Name>
      <Operation>U</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>S</FailureAction>
      <FailureStep>0</FailureStep>
      <FailureMessage />
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Scribe Internal Database</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>C</Success0Action>
      <Success0Step>0</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>C</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>0</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula />
      <PreOpValue />
      <StepName>Scribe Internal Database.VETADDR_DATA FAILURE</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
  </TargetTables>
  <Keys>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S14</SourceField>
      <TargetDataObject>VETADDR_DATA</TargetDataObject>
      <TargetField>recordid</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>recordid</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S14</LookupExpression>
      <SourceFormula>S14</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S14</SourceField>
      <TargetDataObject>VETADDR_DATA(2)</TargetDataObject>
      <TargetField>recordid</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>recordid</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S14</LookupExpression>
      <SourceFormula>S14</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S6</SourceField>
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>vhacrm_siebelid_text</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>vhacrm_siebelid_text</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S6</LookupExpression>
      <SourceFormula>S6</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
  </Keys>
  <Links>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S2</SourceFields>
      <TargetDataObject>customeraddress(2)</TargetDataObject>
      <TargetField>overriddencreatedon</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S2</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S9</SourceFields>
      <TargetDataObject>customeraddress(2)</TargetDataObject>
      <TargetField>city</TargetField>
      <TargetValue />
      <Formula>PROPER( S9 )</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S11</SourceFields>
      <TargetDataObject>customeraddress(2)</TargetDataObject>
      <TargetField>postalcode</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S11</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S7</SourceFields>
      <TargetDataObject>customeraddress(2)</TargetDataObject>
      <TargetField>line1</TargetField>
      <TargetValue />
      <Formula>PROPER( S7 )</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>customeraddress(2)</TargetDataObject>
      <TargetField>line2</TargetField>
      <TargetValue />
      <Formula>line2</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>customeraddress(2)</TargetDataObject>
      <TargetField>name</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>addresstypecode</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>VETADDR_DATA</TargetDataObject>
      <TargetField>importstatus</TargetField>
      <TargetValue>Processed</TargetValue>
      <Formula>"Processed"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>VETADDR_DATA(2)</TargetDataObject>
      <TargetField>importstatus</TargetField>
      <TargetValue>Failure</TargetValue>
      <Formula>"Failure"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>VETADDR_DATA(2)</TargetDataObject>
      <TargetField>errormessage</TargetField>
      <TargetValue>Veteran Address failed to import</TargetValue>
      <Formula>"Veteran Address failed to import"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S13</SourceFields>
      <TargetDataObject>customeraddress(2)</TargetDataObject>
      <TargetField>vhacrm_ismailing_bool</TargetField>
      <TargetValue>#NULL!</TargetValue>
      <Formula>FILELOOKUP( S13, "XREF.INI", "ISMAILING_BOOL" )</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S1</SourceFields>
      <TargetDataObject>customeraddress(2)</TargetDataObject>
      <TargetField>vhacrm_siebelid_text</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S1</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S9</SourceFields>
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>address1_city</TargetField>
      <TargetValue />
      <Formula>PROPER(S9)</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S7</SourceFields>
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>address1_line1</TargetField>
      <TargetValue />
      <Formula>PROPER (S7)</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S8</SourceFields>
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>address1_line2</TargetField>
      <TargetValue />
      <Formula>PROPER (S8)</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S11</SourceFields>
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>address1_postalcode</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S11</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S13</SourceFields>
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>vhacrm_address1_ismailing_bool</TargetField>
      <TargetValue>#NULL!</TargetValue>
      <Formula>FILELOOKUP( S13, "XREF.INI", "ISMAILING_BOOL" )</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>address1_addresstypecode</TargetField>
      <TargetValue>4</TargetValue>
      <Formula>"4"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>address1_name</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>addresstypecode</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S12</SourceFields>
      <TargetDataObject>customeraddress(2)</TargetDataObject>
      <TargetField>country</TargetField>
      <TargetValue>#NULL!</TargetValue>
      <Formula>FILELOOKUP( S12, "XREF.INI", "BAH_COUNTRY_CODE" )</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S12</SourceFields>
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>address1_country</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S12</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S20</SourceFields>
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>address1_stateorprovince</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S20</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S21</SourceFields>
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>vhacrm_address1_countryid</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S21</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S22</SourceFields>
      <TargetDataObject>contact(5)</TargetDataObject>
      <TargetField>vhacrm_address1_stateid</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S22</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S20</SourceFields>
      <TargetDataObject>customeraddress(2)</TargetDataObject>
      <TargetField>stateorprovince</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S20</Formula>
      <Overwrite>true</Overwrite>
    </Link>
  </Links>
</DTS>