<?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>lobID</Name>
      <HelpText />
      <PromptText />
      <DataType>string</DataType>
      <Formula>"{6499EBC3-99D1-E511-9416-0050568DC724}"</Formula>
      <Prompted>false</Prompted>
    </UserVariable>
  </UserVariables>
  <TargetVariables>
    <TargetVariable>
      <Name>createdareaintersectionID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_areaintersection</DataObject>
      <DataField>vhacrm_areaintersectionid</DataField>
      <DataProvider>NEW_CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>createdtypeintersectionID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_typeintersection</DataObject>
      <DataField>vhacrm_typeintersectionid</DataField>
      <DataProvider>NEW_CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>createdsubareaintersectionID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_subareaintersection</DataObject>
      <DataField>vhacrm_subareaintersectionid</DataField>
      <DataProvider>NEW_CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>createdresolutionintersectionID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_resolutionintersection</DataObject>
      <DataField>vhacrm_resolutionintersectionid</DataField>
      <DataProvider>NEW_CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>createdareaID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_area</DataObject>
      <DataField>vhacrm_areaid</DataField>
      <DataProvider>NEW_CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>createdtypeID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_type</DataObject>
      <DataField>vhacrm_typeid</DataField>
      <DataProvider>NEW_CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>createdsubareaID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_subarea</DataObject>
      <DataField>vhacrm_subareaid</DataField>
      <DataProvider>NEW_CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>createdresolutionID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_resolution</DataObject>
      <DataField>vhacrm_resolutionid</DataField>
      <DataProvider>NEW_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.4 Service Request.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 REQ.[ROW ID]
      , REQ.[SR NUM]
      , REQ.[SR CREATED]
      , REQ.[SR LAST UPD]
      , REQ.[SR CREATED BY]
      , REQ.[SR LST UPD BY]
      , REQ.[SR DATE ASSIGN]
      , REQ.[SR OWNER ID]
      , REQ.[SR OWNER NAME]
      , REQ.[SR FIRST CLOSED]
      , REQ.[SR CLOSED DATE]
      , REQ.[SR TYPE]
      , REQ.[SR AREA]
      , REQ.[SR SUB AREA]
      , REQ.[SR STATUS]
      , REQ.[SR SUB STATUS]
      , REQ.[SR SUBTYPE]
      , REQ.[SR RESOLUTION]
      , REQ.[SR SUMMARY]
      , REQ.[SR PRIORITY]
      , REQ.[VET LN]
      , REQ.[VET FN]
      , REQ.[VET SSN]
      , REQ.[VET EDIPI]
      , REQ.[VET DOB]
      , REQ.[VET PHN]
      , REQ.[VET CALLBACK]
      , REQ.[VET SEX]
      , REQ.[VET EMAIL]
      , REQ.[VET ENROLL DT]
      , REQ.[VET ADDR1]
      , REQ.[VET ADDR2]
      , REQ.[VET CITY]
      , REQ.[VET STATE]
      , REQ.[VET ZIP]
      , REQ.[VET FLAG NOTE]
      , REQ.[SR FAC ORG TYPE]
      , REQ.[SR FAC NAME]
      , REQ.[SR FAC VISN]
      , REQ.[SR FAC STATION]
      , REQ.[SR FAC ADDR]
      , REQ.[SR FAC CITY]
      , REQ.[SR FAC STATE]
      , REQ.[SR FAC ZIP]
      , REQ.[SR FAC PHN]
      , REQ.[SR REWORK FLAG]
      , REQ.[SR CALLBACK FLAG]
      , REQ.[DIS EVAC]
      , REQ.[DIS EMP HLTH]
      , REQ.[DIS EMP FAM HLTH]
      , REQ.[DIS HOME DEST]
      , REQ.[SR MOD NUM]
      , REQ.[recordid]
      , REQ.[sequenceid]
      , REQ.[datecreated]
      , REQ.[errormessage]
      , REQ.[importstatus], TYPE.GUID AS TYPE, TYPEI.GUID AS TYPEINTERSECTION, AREA.[GUID] AS AREA, AREAI.GUID AS AREAINTERSECTION,
SUBAREA.GUID AS SUBAREA, SUBAREAI.GUID AS SUBAREAINTERSECTION, RESOLUTION.GUID AS RESOLUTION, 
RESOI.GUID AS RESOLUTIONINTERSECTION, CRMEMP.[CRM_GUID] AS OWNER_GUID, b.[CRM_GUID] AS CREATEDBY, c.[CRM_GUID] AS MODIFIEDBY
FROM SRREQ_DATA AS REQ
LEFT OUTER JOIN TYPE
ON TYPE.NAME = REQ.[SR TYPE]
LEFT OUTER JOIN TYPEINTERSECTION AS TYPEI
ON TYPEI.TYPE_INTERSECTION = REQ.[SR TYPE]
LEFT OUTER JOIN AREA
ON AREA.NAME = REQ.[SR AREA]
LEFT OUTER JOIN AREAINTERSECTION AS AREAI
ON AREAI.AREA_INTERSECTION = REQ.[SR AREA]
LEFT OUTER JOIN SUBAREA
ON SUBAREA.NAME = REQ.[SR SUB AREA]
LEFT OUTER JOIN SUBAREAINTERSECTION AS SUBAREAI
ON SUBAREAI.SUBAREA_INTERSECTION = REQ.[SR SUB AREA]
LEFT OUTER JOIN RESOLUTION 
ON RESOLUTION.NAME = REQ.[SR RESOLUTION]
LEFT OUTER JOIN RESOLUTIONSINTERSECTION AS RESOI
ON RESOI.RESOLUTION_INTERSECTION = REQ.[SR RESOLUTION]
LEFT OUTER JOIN CRMEMP_DATA AS CRMEMP
ON CRMEMP.[EMP_ID] = REQ.[SR OWNER ID]
LEFT OUTER JOIN CRMEMP_DATA AS b
ON b.[EMP_ID] = REQ.[SR CREATED BY]
LEFT OUTER JOIN CRMEMP_DATA AS c
ON c.[EMP_ID] = REQ.[SR LST UPD BY]
WHERE TYPE.GUID IS NULL OR TYPEI.GUID IS NULL OR AREA.GUID IS NULL OR  AREAI.GUID IS NULL OR SUBAREA.GUID IS NULL OR SUBAREAI.GUID IS NULL OR
RESOLUTION.GUID IS NULL OR  RESOI.GUID IS NULL</SourceQuery>
    <ModifySourceOperation>3</ModifySourceOperation>
    <ModifySourceField>importstatus</ModifySourceField>
    <ModifySourceValue>IF ( ISEMPTY (GETROWERROR()), "Processed", "Failure")</ModifySourceValue>
    <KeyFields />
    <KeyFieldsDelimiter />
    <NameFields />
    <NameFieldsDelimater />
    <UserVariables />
  </Source>
  <SourceFields>
    <SourceField>
      <Name>ROW ID</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S1</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR NUM</Name>
      <DataObject />
      <Type>char(64)</Type>
      <Reference>S2</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR CREATED</Name>
      <DataObject />
      <Type>char(25)</Type>
      <Reference>S3</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR LAST UPD</Name>
      <DataObject />
      <Type>char(25)</Type>
      <Reference>S4</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR CREATED BY</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S5</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR LST UPD BY</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S6</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR DATE ASSIGN</Name>
      <DataObject />
      <Type>char(25)</Type>
      <Reference>S7</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR OWNER ID</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S8</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR OWNER NAME</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S9</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR FIRST CLOSED</Name>
      <DataObject />
      <Type>char(25)</Type>
      <Reference>S10</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR CLOSED DATE</Name>
      <DataObject />
      <Type>char(25)</Type>
      <Reference>S11</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR TYPE</Name>
      <DataObject />
      <Type>char(50)</Type>
      <Reference>S12</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR AREA</Name>
      <DataObject />
      <Type>char(30)</Type>
      <Reference>S13</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR SUB AREA</Name>
      <DataObject />
      <Type>char(30)</Type>
      <Reference>S14</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR STATUS</Name>
      <DataObject />
      <Type>char(30)</Type>
      <Reference>S15</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR SUB STATUS</Name>
      <DataObject />
      <Type>char(30)</Type>
      <Reference>S16</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR SUBTYPE</Name>
      <DataObject />
      <Type>char(30)</Type>
      <Reference>S17</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR RESOLUTION</Name>
      <DataObject />
      <Type>char(30)</Type>
      <Reference>S18</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR SUMMARY</Name>
      <DataObject />
      <Type>char(2000)</Type>
      <Reference>S19</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR PRIORITY</Name>
      <DataObject />
      <Type>char(30)</Type>
      <Reference>S20</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET LN</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S21</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET FN</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S22</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET SSN</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S23</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET EDIPI</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S24</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET DOB</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S25</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET PHN</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S26</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET CALLBACK</Name>
      <DataObject />
      <Type>char(50)</Type>
      <Reference>S27</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET SEX</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S28</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET EMAIL</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S29</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET ENROLL DT</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S30</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET ADDR1</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S31</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET ADDR2</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S32</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET CITY</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S33</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET STATE</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S34</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET ZIP</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S35</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>VET FLAG NOTE</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S36</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR FAC ORG TYPE</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S37</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR FAC NAME</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S38</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR FAC VISN</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S39</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR FAC STATION</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S40</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR FAC ADDR</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S41</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR FAC CITY</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S42</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR FAC STATE</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S43</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR FAC ZIP</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S44</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR FAC PHN</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S45</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR REWORK FLAG</Name>
      <DataObject />
      <Type>char(1)</Type>
      <Reference>S46</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR CALLBACK FLAG</Name>
      <DataObject />
      <Type>char(1)</Type>
      <Reference>S47</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>DIS EVAC</Name>
      <DataObject />
      <Type>char(1)</Type>
      <Reference>S48</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>DIS EMP HLTH</Name>
      <DataObject />
      <Type>char(50)</Type>
      <Reference>S49</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>DIS EMP FAM HLTH</Name>
      <DataObject />
      <Type>char(50)</Type>
      <Reference>S50</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>DIS HOME DEST</Name>
      <DataObject />
      <Type>char(30)</Type>
      <Reference>S51</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>SR MOD NUM</Name>
      <DataObject />
      <Type>decimal(13)</Type>
      <Reference>S52</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>recordid</Name>
      <DataObject />
      <Type>char(38)</Type>
      <Reference>S53</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>sequenceid</Name>
      <DataObject />
      <Type>decimal(8)</Type>
      <Reference>S54</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>datecreated</Name>
      <DataObject />
      <Type>datetime(16)</Type>
      <Reference>S55</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>errormessage</Name>
      <DataObject />
      <Type>char(250)</Type>
      <Reference>S56</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>importstatus</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S57</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>TYPE</Name>
      <DataObject />
      <Type>nchar(38)</Type>
      <Reference>S58</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>TYPEINTERSECTION</Name>
      <DataObject />
      <Type>char(38)</Type>
      <Reference>S59</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>AREA</Name>
      <DataObject />
      <Type>nchar(38)</Type>
      <Reference>S60</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>AREAINTERSECTION</Name>
      <DataObject />
      <Type>char(38)</Type>
      <Reference>S61</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>SUBAREA</Name>
      <DataObject />
      <Type>nchar(38)</Type>
      <Reference>S62</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>SUBAREAINTERSECTION</Name>
      <DataObject />
      <Type>char(38)</Type>
      <Reference>S63</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>RESOLUTION</Name>
      <DataObject />
      <Type>nchar(38)</Type>
      <Reference>S64</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>RESOLUTIONINTERSECTION</Name>
      <DataObject />
      <Type>char(38)</Type>
      <Reference>S65</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>OWNER_GUID</Name>
      <DataObject />
      <Type>char(40)</Type>
      <Reference>S66</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>CREATEDBY</Name>
      <DataObject />
      <Type>char(40)</Type>
      <Reference>S67</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>MODIFIEDBY</Name>
      <DataObject />
      <Type>char(40)</Type>
      <Reference>S68</Reference>
      <IsLink>false</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>
    <DataProvider>
      <Usage>T</Usage>
      <Label>NEW_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>TYPE</Name>
      <Operation>S</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>G</Success1Action>
      <Success1Step>4</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>G</Success2Action>
      <Success2Step>4</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>N</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>2</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>2</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S58), IF( ISERROR(S12), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.TYPE</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>vhacrm_type</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>NEW_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>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S58), IF( ISERROR(S12), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>NEW_CRM.vhacrm_type</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>TYPE(2)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S58), IF( ISERROR(S12), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.TYPE(2)</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>TYPEINTERSECTION</Name>
      <Operation>S</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>G</Success1Action>
      <Success1Step>7</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>G</Success2Action>
      <Success2Step>7</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>N</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>2</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S59), IF( ISERROR(S12), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.TYPEINTERSECTION</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>vhacrm_typeintersection</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>NEW_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>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S59), IF( ISERROR(S12), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>NEW_CRM.vhacrm_typeintersection</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>TYPEINTERSECTION(2)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S59), IF( ISERROR(S12), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.TYPEINTERSECTION(2)</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>AREA</Name>
      <Operation>S</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>G</Success1Action>
      <Success1Step>10</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>G</Success2Action>
      <Success2Step>10</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>N</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>2</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S60), IF( ISERROR(S13), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.AREA</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>vhacrm_area</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>NEW_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>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S60), IF( ISERROR(S13), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>NEW_CRM.vhacrm_area</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>AREA(2)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S60), IF( ISERROR(S13), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.AREA(2)</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>AREAINTERSECTION(2)</Name>
      <Operation>S</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>G</Success1Action>
      <Success1Step>13</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>G</Success2Action>
      <Success2Step>13</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>N</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>2</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S61), IF( ISERROR(S13), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.AREAINTERSECTION(2)</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>vhacrm_areaintersection</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>NEW_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>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S61), IF( ISERROR(S13), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>NEW_CRM.vhacrm_areaintersection</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>AREAINTERSECTION</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S61), IF( ISERROR(S13), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.AREAINTERSECTION</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>SUBAREA</Name>
      <Operation>S</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>G</Success1Action>
      <Success1Step>16</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>G</Success2Action>
      <Success2Step>16</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>N</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>2</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S62), IF( ISERROR(S14), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.SUBAREA</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>vhacrm_subarea</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>NEW_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>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S62), IF( ISERROR(S14), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>NEW_CRM.vhacrm_subarea</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>SUBAREA(2)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S62), IF( ISERROR(S14), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.SUBAREA(2)</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>SUBAREAINTERSECTION</Name>
      <Operation>S</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>G</Success1Action>
      <Success1Step>19</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>G</Success2Action>
      <Success2Step>19</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>N</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>2</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S63), IF( ISERROR(S14), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.SUBAREAINTERSECTION</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>vhacrm_subareaintersection</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>NEW_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>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S63), IF( ISERROR(S14), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>NEW_CRM.vhacrm_subareaintersection</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>SUBAREAINTERSECTION(2)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S63), IF( ISERROR(S14), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.SUBAREAINTERSECTION(2)</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>RESOLUTION</Name>
      <Operation>S</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>G</Success1Action>
      <Success1Step>22</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>G</Success2Action>
      <Success2Step>22</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>N</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>2</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S64), IF( ISERROR(S18), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.RESOLUTION</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>vhacrm_resolution</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>NEW_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>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S64), IF( ISERROR(S18), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>NEW_CRM.vhacrm_resolution</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>RESOLUTION(2)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S64), IF( ISERROR(S18), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.RESOLUTION(2)</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>RESOLUTIONSINTERSECTION</Name>
      <Operation>S</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>G</Success1Action>
      <Success1Step>24</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>G</Success2Action>
      <Success2Step>26</Success2Step>
      <Success2Message>More than one Resolution Intersection Found</Success2Message>
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>2</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S65), IF( ISERROR(S18), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.RESOLUTIONSINTERSECTION</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>vhacrm_resolutionintersection</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>NEW_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>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S65), IF( ISERROR(S18), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>NEW_CRM.vhacrm_resolutionintersection</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>RESOLUTIONSINTERSECTION(2)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>26</FailureStep>
      <FailureMessage>Application defined error</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>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF (ISERROR (S65), IF( ISERROR(S18), SkipStep(), True()), SkipStep())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.RESOLUTIONSINTERSECTION(2</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>SRREQ_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>S</Success0Action>
      <Success0Step>0</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>S</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>2</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula />
      <PreOpValue />
      <StepName>Scribe Internal Database.SRREQ_DATA SUCESS</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>SRREQ_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.SRREQ_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>S53</SourceField>
      <TargetDataObject>SRREQ_DATA</TargetDataObject>
      <TargetField>recordid</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>recordid</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S53</LookupExpression>
      <SourceFormula>S53</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S53</SourceField>
      <TargetDataObject>SRREQ_DATA(2)</TargetDataObject>
      <TargetField>recordid</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>recordid</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S53</LookupExpression>
      <SourceFormula>S53</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S62</SourceField>
      <TargetDataObject>SUBAREA</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>GUID</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S62</LookupExpression>
      <SourceFormula>S62</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S63</SourceField>
      <TargetDataObject>SUBAREAINTERSECTION</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>GUID</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S63</LookupExpression>
      <SourceFormula>S63</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S64</SourceField>
      <TargetDataObject>RESOLUTION</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>GUID</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S64</LookupExpression>
      <SourceFormula>S64</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S65</SourceField>
      <TargetDataObject>RESOLUTIONSINTERSECTION</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>GUID</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S65</LookupExpression>
      <SourceFormula>S65</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S58</SourceField>
      <TargetDataObject>TYPE</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>GUID</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S58</LookupExpression>
      <SourceFormula>S58</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S59</SourceField>
      <TargetDataObject>TYPEINTERSECTION</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>GUID</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S59</LookupExpression>
      <SourceFormula>S59</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S61</SourceField>
      <TargetDataObject>AREAINTERSECTION(2)</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>GUID</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S61</LookupExpression>
      <SourceFormula>S61</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S60</SourceField>
      <TargetDataObject>AREA</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>GUID</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S60</LookupExpression>
      <SourceFormula>S60</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
  </Keys>
  <Links>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S13</SourceFields>
      <TargetDataObject>AREA(2)</TargetDataObject>
      <TargetField>NAME</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S13</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>AREA(2)</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>createdareaID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S13</SourceFields>
      <TargetDataObject>AREAINTERSECTION</TargetDataObject>
      <TargetField>AREA_INTERSECTION</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S13</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>AREAINTERSECTION</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>createdareaintersectionID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S12</SourceFields>
      <TargetDataObject>TYPE(2)</TargetDataObject>
      <TargetField>NAME</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S12</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>TYPE(2)</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>createdtypeID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S12</SourceFields>
      <TargetDataObject>TYPEINTERSECTION(2)</TargetDataObject>
      <TargetField>TYPE_INTERSECTION</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S12</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>TYPEINTERSECTION(2)</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>createdtypeintersectionID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S14</SourceFields>
      <TargetDataObject>SUBAREA(2)</TargetDataObject>
      <TargetField>NAME</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S14</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>SUBAREA(2)</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>createdsubareaID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S14</SourceFields>
      <TargetDataObject>SUBAREAINTERSECTION(2)</TargetDataObject>
      <TargetField>SUBAREA_INTERSECTION</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S14</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>SUBAREAINTERSECTION(2)</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>createdsubareaintersectionID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S18</SourceFields>
      <TargetDataObject>RESOLUTION(2)</TargetDataObject>
      <TargetField>NAME</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S18</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>RESOLUTION(2)</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>createdresolutionID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S18</SourceFields>
      <TargetDataObject>RESOLUTIONSINTERSECTION(2)</TargetDataObject>
      <TargetField>RESOLUTION_INTERSECTION</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S18</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>RESOLUTIONSINTERSECTION(2)</TargetDataObject>
      <TargetField>GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>createdresolutionintersectionID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>SRREQ_DATA</TargetDataObject>
      <TargetField>importstatus</TargetField>
      <TargetValue>Updated</TargetValue>
      <Formula>"Updated"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>SRREQ_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>SRREQ_DATA(2)</TargetDataObject>
      <TargetField>errormessage</TargetField>
      <TargetValue>Service Request Failure</TargetValue>
      <Formula>"Service Request Failure"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S12</SourceFields>
      <TargetDataObject>vhacrm_type</TargetDataObject>
      <TargetField>vhacrm_name</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S12</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_typeintersection</TargetDataObject>
      <TargetField>vhacrm_lobid</TargetField>
      <TargetValue>{6499EBC3-99D1-E511-9416-0050568DC724}</TargetValue>
      <Formula>lobID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S12</SourceFields>
      <TargetDataObject>vhacrm_typeintersection</TargetDataObject>
      <TargetField>vhacrm_name</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S12</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_typeintersection</TargetDataObject>
      <TargetField>vhacrm_typeid</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>createdtypeID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S13</SourceFields>
      <TargetDataObject>vhacrm_area</TargetDataObject>
      <TargetField>vhacrm_name</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S13</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S59</SourceFields>
      <TargetDataObject>vhacrm_areaintersection</TargetDataObject>
      <TargetField>vhacrm_typeintersectionid</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>IF(ISERROR(S59), createdtypeintersectionID, S59 )</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S60</SourceFields>
      <TargetDataObject>vhacrm_areaintersection</TargetDataObject>
      <TargetField>vhacrm_areaid</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>IF(ISERROR(S60), createdareaID, S60 )</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S13</SourceFields>
      <TargetDataObject>vhacrm_areaintersection</TargetDataObject>
      <TargetField>vhacrm_name</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S13</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_areaintersection</TargetDataObject>
      <TargetField>vhacrm_lobid</TargetField>
      <TargetValue>{6499EBC3-99D1-E511-9416-0050568DC724}</TargetValue>
      <Formula>lobID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S14</SourceFields>
      <TargetDataObject>vhacrm_subarea</TargetDataObject>
      <TargetField>vhacrm_name</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S14</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S62</SourceFields>
      <TargetDataObject>vhacrm_subareaintersection</TargetDataObject>
      <TargetField>vhacrm_subareaid</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>IF(ISERROR(S62), createdsubareaID, S62)</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S61</SourceFields>
      <TargetDataObject>vhacrm_subareaintersection</TargetDataObject>
      <TargetField>vhacrm_areaintersectionid</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>IF(ISERROR(S61), createdareaintersectionID, S61)</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_subareaintersection</TargetDataObject>
      <TargetField>vhacrm_lobid</TargetField>
      <TargetValue>{6499EBC3-99D1-E511-9416-0050568DC724}</TargetValue>
      <Formula>lobID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S14</SourceFields>
      <TargetDataObject>vhacrm_subareaintersection</TargetDataObject>
      <TargetField>vhacrm_name</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S14</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S18</SourceFields>
      <TargetDataObject>vhacrm_resolution</TargetDataObject>
      <TargetField>vhacrm_name</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S18</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S64</SourceFields>
      <TargetDataObject>vhacrm_resolutionintersection</TargetDataObject>
      <TargetField>vhacrm_resolutionid</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>IF(ISERROR(S64), createdresolutionID, S64)</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S59</SourceFields>
      <TargetDataObject>vhacrm_resolutionintersection</TargetDataObject>
      <TargetField>vhacrm_typeintersectionid</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>IF(ISERROR(S59), createdtypeintersectionID, S59)</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S18</SourceFields>
      <TargetDataObject>vhacrm_resolutionintersection</TargetDataObject>
      <TargetField>vhacrm_name</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S18</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>NEW_CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_resolutionintersection</TargetDataObject>
      <TargetField>vhacrm_lobid</TargetField>
      <TargetValue>{6499EBC3-99D1-E511-9416-0050568DC724}</TargetValue>
      <Formula>lobID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
  </Links>
</DTS>