<Map Name="HEC List Upload" Source="Import">
  <Description>Data map created automatically using the map settings specified during an import.</Description>
  <EntitiesPerFile>Single</EntitiesPerFile>
  <EntityMaps>
    <EntityMap TargetEntityName="vhacrm_heclistitem" SourceEntityName="test data" Dedupe="Ignore" ProcessCode="Process">
      <AttributeMaps>
        <AttributeMap>
          <SourceAttributeName>SC_COMBINED_PERCENT</SourceAttributeName>
          <TargetAttributeName>vhacrm_sccombinedpercent_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>ICN</SourceAttributeName>
          <TargetAttributeName>vhacrm_icn_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>PHONE_NUMBER</SourceAttributeName>
          <TargetAttributeName>vhacrm_phonenumber_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>ADDRESS_LINE1</SourceAttributeName>
          <TargetAttributeName>vhacrm_addressline1_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>STATUS</SourceAttributeName>
          <TargetAttributeName>vhacrm_status_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>SUFFIX</SourceAttributeName>
          <TargetAttributeName>vhacrm_suffix_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>ADDRESS_LINE2</SourceAttributeName>
          <TargetAttributeName>vhacrm_addressline2_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>LAST_NAME</SourceAttributeName>
          <TargetAttributeName>vhacrm_lastname_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>SSN</SourceAttributeName>
          <TargetAttributeName>vhacrm_ssn_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>STATE_CODE</SourceAttributeName>
          <TargetAttributeName>vhacrm_stateid</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
          <LookupMaps>
            <LookupMap>
              <LookupType>System</LookupType>
              <LookupEntityName>vhacrm_state</LookupEntityName>
              <LookupAttributeName>vhacrm_abbreviation_text</LookupAttributeName>
              <ProcessCode>Process</ProcessCode>
            </LookupMap>
          </LookupMaps>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>APPT_REQUESTED</SourceAttributeName>
          <TargetAttributeName>vhacrm_apptrequested_bool</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
          <PicklistMaps>
            <PicklistMap>
              <SourceValue />
              <TargetValue />
              <ProcessCode>Ignore</ProcessCode>
            </PicklistMap>
            <PicklistMap>
              <SourceValue>Yes</SourceValue>
              <TargetValue>1</TargetValue>
              <ProcessCode>Process</ProcessCode>
            </PicklistMap>
            <PicklistMap>
              <SourceValue>No</SourceValue>
              <TargetValue>0</TargetValue>
              <ProcessCode>Process</ProcessCode>
            </PicklistMap>
          </PicklistMaps>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>APPLICATION_DATE</SourceAttributeName>
          <TargetAttributeName>vhacrm_applicationdate_date</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>ELIGIBILITY</SourceAttributeName>
          <TargetAttributeName>vhacrm_eligibility_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>PG</SourceAttributeName>
          <TargetAttributeName>vhacrm_pg_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>DATE_OF_BIRTH_FMT2</SourceAttributeName>
          <TargetAttributeName>vhacrm_dateofbirth_fmt2_date</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>FIRST_NAME</SourceAttributeName>
          <TargetAttributeName>vhacrm_firstname_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>ENROLLED</SourceAttributeName>
          <TargetAttributeName>vhacrm_enrolled_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>EDIPI</SourceAttributeName>
          <TargetAttributeName>vhacrm_edipi_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>MIDDLE_NAME</SourceAttributeName>
          <TargetAttributeName>vhacrm_middlename_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>PHONE_TYPE</SourceAttributeName>
          <TargetAttributeName>vhacrm_phonetype_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>ZIP</SourceAttributeName>
          <TargetAttributeName>vhacrm_zip_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>PREFERRED_FACILITY</SourceAttributeName>
          <TargetAttributeName>vhacrm_facility_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>VISN</SourceAttributeName>
          <TargetAttributeName>vhacrm_visnid</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
          <LookupMaps>
            <LookupMap>
              <LookupType>System</LookupType>
              <LookupEntityName>bah_visn</LookupEntityName>
              <LookupAttributeName>bah_visnid</LookupAttributeName>
              <ProcessCode>Process</ProcessCode>
            </LookupMap>
            <LookupMap>
              <LookupType>System</LookupType>
              <LookupEntityName>bah_visn</LookupEntityName>
              <LookupAttributeName>bah_name</LookupAttributeName>
              <ProcessCode>Process</ProcessCode>
            </LookupMap>
          </LookupMaps>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>CITY</SourceAttributeName>
          <TargetAttributeName>vhacrm_city_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>EMAIL_ADDRESS</SourceAttributeName>
          <TargetAttributeName>vhacrm_emailaddress_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>GENDER_CODE</SourceAttributeName>
          <TargetAttributeName>vhacrm_gender_code</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
          <PicklistMaps>
            <PicklistMap>
              <SourceValue>M</SourceValue>
              <TargetValue>1</TargetValue>
              <ProcessCode>Process</ProcessCode>
            </PicklistMap>
            <PicklistMap>
              <SourceValue>F</SourceValue>
              <TargetValue>2</TargetValue>
              <ProcessCode>Process</ProcessCode>
            </PicklistMap>
            <PicklistMap>
              <SourceValue />
              <TargetValue />
              <ProcessCode>Ignore</ProcessCode>
            </PicklistMap>
          </PicklistMaps>
        </AttributeMap>
        <AttributeMap>
          <SourceAttributeName>Marketing List</SourceAttributeName>
          <TargetAttributeName>vhacrm_marketinglist_text</TargetAttributeName>
          <ProcessCode>Process</ProcessCode>
        </AttributeMap>
      </AttributeMaps>
    </EntityMap>
  </EntityMaps>
</Map>